2 Replies Latest reply on Nov 2, 2011 7:28 PM by 897369

    Is Oracle 11g client compatible with oracle 9i server ?

    897369
      Hi

      In our application we are using oracle 11g client to connect to oracle 9i server on linux 32 bit machine with glassfish v3.0.1 with jdk 1.6. As such there are no issue is getting connections etc.

      The issue seen here is that whenever we do insert to database table and then doing select on same table to fetch the row inserted sporadically it sometimes give 0 results and if i check manually using sqlplus i can see same row in db table.

      Some additional info:
      1) The insert and then select is happening in same thread.
      2) This issue is happening whether i am getting connection manually using DriverManager.getConnection(...) or even if i am using oracle glassfish v3.0.1 connection poolings.
      3) Oracle driver used is oracle.jdbc.driver.OracleDriver (jdbc:oracle:oci:@<SID>)
      4) Also in case if i am using connection-pooling of oracle glassfish v3.0.1 and using connection-pool option "associate-with=thread="true", then this issue is not happening.
      5) Proper code is in place to commit the row inserted and close connections properly once insertion/selection is done

      Any idea if anyone has seen this issue in past. Any help on this will be highly appreciated.

      Thanks.

      Amit Nanda