RE: DB2 Error - Can Anybody Help?
it would be very helpful for you to write some straight JDBC using batch stuff and see why DB2 croaks. Then maybe we could make DB2 batching work for OJB. -Original Message- From: Shane Mingins [mailto:[EMAIL PROTECTED] Sent: Thursday, June 26, 2003 5:00 PM To: 'OJB Users List' Subject: RE: DB2 Error - Can Anybody Help? Matthew & Armin Thanks, I changed the code, and it all goes :-) Cheers Shane - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: DB2 Error - Can Anybody Help?
Matthew & Armin Thanks, I changed the code, and it all goes :-) Cheers Shane -Original Message- From: Armin Waibel [mailto:[EMAIL PROTECTED] Sent: Friday, 27 June 2003 10:43 a.m. To: OJB Users List Subject: Re: DB2 Error - Can Anybody Help? - Original Message - From: "Matthew Baird" <[EMAIL PROTECTED]> To: "OJB Users List" <[EMAIL PROTECTED]> Sent: Friday, June 27, 2003 12:32 AM Subject: RE: DB2 Error - Can Anybody Help? That's the "something happened that's so severe that you should call db2 service" error. it appears to be happening during the execution of a batch. You could try turning off batch, although I think you may have to do that in code and recompile. # when using CVS this could be done by set batch-mode=false then all setBatch(...) statements in code ignored. If using rc3, get latest ConnectionManagerImpl from CVS or patch setBatchMode-method to public void setBatchMode(boolean mode) { batchMode = mode && jcd.getBatchMode(); } regards, Armin m -Original Message- From: Shane Mingins [mailto:[EMAIL PROTECTED] Sent: Thursday, June 26, 2003 3:34 PM To: 'OJB Users List' Subject: DB2 Error - Can Anybody Help? Hi This is one of those "not sure how to describe the problem" problem *grin* I have a set of tests in a TestCase that were displaying unusual behaviour. One that failed when the entire case was run did not fail when executed solely on its own. So I changed the order and have found the following error: .[org.apache.ojb.odmg.ObjectEnvelopeTable] ERROR: Commit on object level failed for tx [EMAIL PROTECTED] [SQL0901] SQL system error. java.sql.BatchUpdateException: [SQL0901] SQL system error. at com.ibm.as400.access.AS400JDBCPreparedStatement.executeBatch(AS400JDBCPr epar edStatement.java:988) I have replicated the problem with other versions of OJB so no problem there. I then changed the database to MySQL and everything works fine. I have searched the IBM site and a SQL0901 error can be caused by a range of things, nothing I could see sparked any eureka moments. It is my "gut" feeling that it is not anything to do with the actual generated SQL but somehow the order in which they are being executed ... like something has a lock on a table still??? I am at a bit of a loss as to where to go to next. Has anybody come across this error with the AS400 and/or DB2? Or can anyone point me in some direction to help me find out more info about this? TIA Shane Shane Mingins Analyst Programmer Assure NZ Ltd Ph 644 494 2522 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: DB2 Error - Can Anybody Help?
unfortunately ODMG mode sets batch mode internally, that line of code needs to be changed. -Original Message- From: Armin Waibel [mailto:[EMAIL PROTECTED] Sent: Thursday, June 26, 2003 3:43 PM To: OJB Users List Subject: Re: DB2 Error - Can Anybody Help? - Original Message - From: "Matthew Baird" <[EMAIL PROTECTED]> To: "OJB Users List" <[EMAIL PROTECTED]> Sent: Friday, June 27, 2003 12:32 AM Subject: RE: DB2 Error - Can Anybody Help? That's the "something happened that's so severe that you should call db2 service" error. it appears to be happening during the execution of a batch. You could try turning off batch, although I think you may have to do that in code and recompile. # when using CVS this could be done by set batch-mode=false then all setBatch(...) statements in code ignored. If using rc3, get latest ConnectionManagerImpl from CVS or patch setBatchMode-method to public void setBatchMode(boolean mode) { batchMode = mode && jcd.getBatchMode(); } regards, Armin m -Original Message- From: Shane Mingins [mailto:[EMAIL PROTECTED] Sent: Thursday, June 26, 2003 3:34 PM To: 'OJB Users List' Subject: DB2 Error - Can Anybody Help? Hi This is one of those "not sure how to describe the problem" problem *grin* I have a set of tests in a TestCase that were displaying unusual behaviour. One that failed when the entire case was run did not fail when executed solely on its own. So I changed the order and have found the following error: .[org.apache.ojb.odmg.ObjectEnvelopeTable] ERROR: Commit on object level failed for tx [EMAIL PROTECTED] [SQL0901] SQL system error. java.sql.BatchUpdateException: [SQL0901] SQL system error. at com.ibm.as400.access.AS400JDBCPreparedStatement.executeBatch(AS400JDBCPr epar edStatement.java:988) I have replicated the problem with other versions of OJB so no problem there. I then changed the database to MySQL and everything works fine. I have searched the IBM site and a SQL0901 error can be caused by a range of things, nothing I could see sparked any eureka moments. It is my "gut" feeling that it is not anything to do with the actual generated SQL but somehow the order in which they are being executed ... like something has a lock on a table still??? I am at a bit of a loss as to where to go to next. Has anybody come across this error with the AS400 and/or DB2? Or can anyone point me in some direction to help me find out more info about this? TIA Shane Shane Mingins Analyst Programmer Assure NZ Ltd Ph 644 494 2522 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: DB2 Error - Can Anybody Help?
- Original Message - From: "Matthew Baird" <[EMAIL PROTECTED]> To: "OJB Users List" <[EMAIL PROTECTED]> Sent: Friday, June 27, 2003 12:32 AM Subject: RE: DB2 Error - Can Anybody Help? That's the "something happened that's so severe that you should call db2 service" error. it appears to be happening during the execution of a batch. You could try turning off batch, although I think you may have to do that in code and recompile. # when using CVS this could be done by set batch-mode=false then all setBatch(...) statements in code ignored. If using rc3, get latest ConnectionManagerImpl from CVS or patch setBatchMode-method to public void setBatchMode(boolean mode) { batchMode = mode && jcd.getBatchMode(); } regards, Armin m -Original Message- From: Shane Mingins [mailto:[EMAIL PROTECTED] Sent: Thursday, June 26, 2003 3:34 PM To: 'OJB Users List' Subject: DB2 Error - Can Anybody Help? Hi This is one of those "not sure how to describe the problem" problem *grin* I have a set of tests in a TestCase that were displaying unusual behaviour. One that failed when the entire case was run did not fail when executed solely on its own. So I changed the order and have found the following error: .[org.apache.ojb.odmg.ObjectEnvelopeTable] ERROR: Commit on object level failed for tx [EMAIL PROTECTED] [SQL0901] SQL system error. java.sql.BatchUpdateException: [SQL0901] SQL system error. at com.ibm.as400.access.AS400JDBCPreparedStatement.executeBatch(AS400JDBCPr epar edStatement.java:988) I have replicated the problem with other versions of OJB so no problem there. I then changed the database to MySQL and everything works fine. I have searched the IBM site and a SQL0901 error can be caused by a range of things, nothing I could see sparked any eureka moments. It is my "gut" feeling that it is not anything to do with the actual generated SQL but somehow the order in which they are being executed ... like something has a lock on a table still??? I am at a bit of a loss as to where to go to next. Has anybody come across this error with the AS400 and/or DB2? Or can anyone point me in some direction to help me find out more info about this? TIA Shane Shane Mingins Analyst Programmer Assure NZ Ltd Ph 644 494 2522 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: DB2 Error - Can Anybody Help?
Yes I have seen comments about it being a "call IBM message" :-) When referring to batch do you mean the batch-mode property in my JDBC connection descriptor for OJB? Thanks Shane -Original Message- From: Matthew Baird [mailto:[EMAIL PROTECTED] Sent: Friday, 27 June 2003 10:33 a.m. To: OJB Users List Subject: RE: DB2 Error - Can Anybody Help? That's the "something happened that's so severe that you should call db2 service" error. it appears to be happening during the execution of a batch. You could try turning off batch, although I think you may have to do that in code and recompile. m -Original Message- From: Shane Mingins [mailto:[EMAIL PROTECTED] Sent: Thursday, June 26, 2003 3:34 PM To: 'OJB Users List' Subject: DB2 Error - Can Anybody Help? Hi This is one of those "not sure how to describe the problem" problem *grin* I have a set of tests in a TestCase that were displaying unusual behaviour. One that failed when the entire case was run did not fail when executed solely on its own. So I changed the order and have found the following error: .[org.apache.ojb.odmg.ObjectEnvelopeTable] ERROR: Commit on object level failed for tx [EMAIL PROTECTED] [SQL0901] SQL system error. java.sql.BatchUpdateException: [SQL0901] SQL system error. at com.ibm.as400.access.AS400JDBCPreparedStatement.executeBatch(AS400JDBCPrepar edStatement.java:988) I have replicated the problem with other versions of OJB so no problem there. I then changed the database to MySQL and everything works fine. I have searched the IBM site and a SQL0901 error can be caused by a range of things, nothing I could see sparked any eureka moments. It is my "gut" feeling that it is not anything to do with the actual generated SQL but somehow the order in which they are being executed ... like something has a lock on a table still??? I am at a bit of a loss as to where to go to next. Has anybody come across this error with the AS400 and/or DB2? Or can anyone point me in some direction to help me find out more info about this? TIA Shane Shane Mingins Analyst Programmer Assure NZ Ltd Ph 644 494 2522 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: DB2 Error - Can Anybody Help?
That's the "something happened that's so severe that you should call db2 service" error. it appears to be happening during the execution of a batch. You could try turning off batch, although I think you may have to do that in code and recompile. m -Original Message- From: Shane Mingins [mailto:[EMAIL PROTECTED] Sent: Thursday, June 26, 2003 3:34 PM To: 'OJB Users List' Subject: DB2 Error - Can Anybody Help? Hi This is one of those "not sure how to describe the problem" problem *grin* I have a set of tests in a TestCase that were displaying unusual behaviour. One that failed when the entire case was run did not fail when executed solely on its own. So I changed the order and have found the following error: .[org.apache.ojb.odmg.ObjectEnvelopeTable] ERROR: Commit on object level failed for tx [EMAIL PROTECTED] [SQL0901] SQL system error. java.sql.BatchUpdateException: [SQL0901] SQL system error. at com.ibm.as400.access.AS400JDBCPreparedStatement.executeBatch(AS400JDBCPrepar edStatement.java:988) I have replicated the problem with other versions of OJB so no problem there. I then changed the database to MySQL and everything works fine. I have searched the IBM site and a SQL0901 error can be caused by a range of things, nothing I could see sparked any eureka moments. It is my "gut" feeling that it is not anything to do with the actual generated SQL but somehow the order in which they are being executed ... like something has a lock on a table still??? I am at a bit of a loss as to where to go to next. Has anybody come across this error with the AS400 and/or DB2? Or can anyone point me in some direction to help me find out more info about this? TIA Shane Shane Mingins Analyst Programmer Assure NZ Ltd Ph 644 494 2522 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
DB2 Error - Can Anybody Help?
Hi This is one of those "not sure how to describe the problem" problem *grin* I have a set of tests in a TestCase that were displaying unusual behaviour. One that failed when the entire case was run did not fail when executed solely on its own. So I changed the order and have found the following error: .[org.apache.ojb.odmg.ObjectEnvelopeTable] ERROR: Commit on object level failed for tx [EMAIL PROTECTED] [SQL0901] SQL system error. java.sql.BatchUpdateException: [SQL0901] SQL system error. at com.ibm.as400.access.AS400JDBCPreparedStatement.executeBatch(AS400JDBCPrepar edStatement.java:988) I have replicated the problem with other versions of OJB so no problem there. I then changed the database to MySQL and everything works fine. I have searched the IBM site and a SQL0901 error can be caused by a range of things, nothing I could see sparked any eureka moments. It is my "gut" feeling that it is not anything to do with the actual generated SQL but somehow the order in which they are being executed ... like something has a lock on a table still??? I am at a bit of a loss as to where to go to next. Has anybody come across this error with the AS400 and/or DB2? Or can anyone point me in some direction to help me find out more info about this? TIA Shane Shane Mingins Analyst Programmer Assure NZ Ltd Ph 644 494 2522 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]