Bugs item #460605, was opened at 2001-09-11 00:41 You can respond by visiting: http://sourceforge.net/tracker/?func=detail&atid=376685&aid=460605&group_id=22866
Category: JBossServer Group: v2.4 (stable) Status: Closed Resolution: Rejected Priority: 5 Submitted By: Nobody/Anonymous (nobody) Assigned to: Andreas Schaefer (schaefera) 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. ---------------------------------------------------------------------- >Comment By: Andreas Schaefer (schaefera) Date: 2001-11-10 09:17 Message: Logged In: YES user_id=70434 To go on further I need more information about the problem. The mentioned log file is not attached nore the code causing the problem. Andy ---------------------------------------------------------------------- Comment By: Andreas Schaefer (schaefera) Date: 2001-11-10 09:17 Message: Logged In: YES user_id=70434 To go on further I need more information about the problem. The mentioned log file is not attached nore the code causing the problem. Andy ---------------------------------------------------------------------- Comment By: Andreas Schaefer (schaefera) Date: 2001-10-29 21:44 Message: Logged In: YES user_id=70434 My initial guess is that I see problem coming when you try to create a prepared statement mixing DDL and DML commands. I am not 100% sure but I would suggest that you use regular statements for DDL and prepared statements only for DML. I will investigate to find the source or at least a better explanation. ---------------------------------------------------------------------- You can respond by visiting: http://sourceforge.net/tracker/?func=detail&atid=376685&aid=460605&group_id=22866 _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
