I ran into this a long time ago and never found a solution except not to
use isql. I have no idea what is causing this. As you say, sticking
entirely to the java drivers seems to work ok. I think closing isql may
also make the changes visible??

david jencks

On 2002.04.12 19:22:35 -0400 Marczisovszky Daniel wrote:
> Hi,
>
> Well, hm... I have serious problem again. The happens only on Linux. I
> have tested with both Classic and Superserver on a Debian Potato and
> on a Suse 7.2 with same results. The same is happening with both
> Interclient and the latest type4 driver.
>
> I get a connection and starts reading a record from it, periodically,
> but always on the same connection. If I change that record from isql,
> nothing happens, I still get the previous value for that record. I've
> also tried IBConsole but that did not help either. The interesting
> thing I tried QuickDesk and If I change the record with that, then I
> get the new value in the java program. I tried also with FIBPlus in
> Delphi (QuickDesk also uses FIBPlus) but the java still shows the
> previous value.
>
> I have attached a little example application. It reads the first
> record from test table in every 3 seconds always with the same
> connection. (I have tried both autocommit and non-autocommit, but none
> of them worked).
>
> It runs an infinite loop. While it prints it the first record, try to
> change that in isql or with IBConsole, and check if you see the new
> value or not. I don't see the change.
>
> I know that probably this is not a bug a driver, but I'm not sure,
> although I can't reproduce it on Windows. Does the driver contains any
> platform-specific part?
>
> If I change the value from java (e.g. I start a separate java program)
> then it works, it shows the new value.
>
> Is there any special isolation level for isql and IBConsole I missed?
>
> Please help, if you can! I really don't know how to cope with this.
>
> Best wishes,
> Daniel
>
> // same database as last time, so only it has an id, username and
> // passwd field
>
> import java.sql.*;
> import java.util.*;
>
> public class conn {
> public static void main( String[] args ) {
> try {
> Class.forName("org.firebirdsql.jdbc.FBDriver");
> String url = "jdbc:firebirdsql:localhost/3050://opt/interbase/test.gdb";
> //String url = "jdbc:firebirdsql:localhost/3050:/programs/develop/firebird/test.gdb";
>
> // we a get a connection
> Connection conn = DriverManager.getConnection(url, "sysdba",
> "masterkey");
> while (true) {
> Statement st = conn.createStatement();
> ResultSet rs = st.executeQuery("select username from
> test");
> rs.next();
> System.out.println(rs.getString(1));
> // wait 3 seconds and try again
> try {
> Thread.sleep(3000);
> }
> catch (Exception ee) {}
> }
> }
> catch(ClassNotFoundException e) {
> System.err.println("Couldn't load the driver: " +
> e.getMessage());
> }
> catch(SQLException e) {
> System.err.println("SQLException caught: " + e.getMessage());
> }
> finally {
> }
> }
> }
>
>
>
> To unsubscribe from this group, send an email to:
> Firebird-Java-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>