RE: DB2 Error - Can Anybody Help?

2003-06-26 Thread Matthew Baird
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]



RE: DB2 Error - Can Anybody Help?

2003-06-26 Thread Shane Mingins
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?

2003-06-26 Thread Armin Waibel

- 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?

2003-06-26 Thread Shane Mingins
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]