Bugs item #460607, was opened at 2001-09-11 00:42 You can respond by visiting: http://sourceforge.net/tracker/?func=detail&atid=376685&aid=460607&group_id=22866 Category: JBossServer Group: v2.4 (stable) Status: Open Resolution: None Priority: 5 Submitted By: Nobody/Anonymous (nobody) Assigned to: Nobody/Anonymous (nobody) Summary: Minerva & Oracle 8.1.6 drivers Initial Comment: Opertaion system: WinNT 4.0 SP 6 JDK: 1.3.0-C Sun Microsystems Problem is: While prepared statements cashing some of cashed statements (which are not actual 'prepared') doesn't execute repeatedly. For example, we work with table named 'SSQB_ESR.ESR_RESULT_2'; with one connection we trying to drop this table, then create table with the same name, fill it with data, and do some selects. This scenario is repeated several times. After server start the first execution of 'DROP' statement was successfull, but the following was failed without any exception or warnings (simple does nothing - table still exists). In case of statements usage (Statement java class instead of PreparedStatement) problem disappears. It's quite possible that problem described is not problem of JBOSS server or Minerva data pool but Oracle JDBC driver. We attached some parts of Oracle JDBC Driver log with two execution of 'DROP' statement, the first of them was successfull and the second was failed. JDBC Driver log was enabled with following part of java code on server starting: Class cls = Class.forName ( "oracle.jdbc.driver.OracleLog" ); oracle.jdbc.driver.OracleLog ol = (oracle.jdbc.driver.OracleLog)cls.newInstance(); ol.TRACE = true; ol.setLogWriter( new java.io.PrintWriter( new java.io.FileWriter( "C:\oracle.jdbc.log" ) ) ); Please respond in any case (even if this problem is related to Oracle drivers). With best regards, EPAm Systems OLAP and Reporting Group. ---------------------------------------------------------------------- You can respond by visiting: http://sourceforge.net/tracker/?func=detail&atid=376685&aid=460607&group_id=22866 _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
