You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ojb-user@db.apache.org by Matthias Roth <ma...@impart.ch> on 2003/10/21 23:33:03 UTC
check Batchmode problem with DB2 on z/OS with ojb 1.0.rc4
Hi
does the SequenceManagerHighLowImpl check for batchmode by creating
a new broker instance in getSequence(...){
...
PersistenceBrokerFactory.createPersistenceBroker(brokerForSequence.getPBKey(
))
...
}
I get an db2 jdbc error (ONLY jdbc driver on z/OS) if the first getSequence
is called. The error
tells that batch mode is not suported. But in the repository.xml file I set
batch-mode="false".
Have had some body also this problem?
regards
Matthias Roth
Dipl. Ing. HTL
in Wirtschaftsinformatik
impart Software Engineering GmbH
Chasseralstrasse 13
Postfach
CH-3063 Ittigen
Phone +41 (0)31 922 39 25
Fax +41 (0)31 922 39 18
EMail mailto:matthias.roth@impart.ch
Homepage http://www.impart.ch
Re: check Batchmode problem with DB2 on z/OS with ojb 1.0.rc4
Posted by Gerhard Grosse <ge...@lex-com.net>.
Hi Armin,
Your suggestion sounds good to me...
Cheers,
Gerhard
On Wed, 22 Oct 2003 12:12:53 +0200, Armin Waibel
<ar...@code-au-lait.de> wrote:
>Hi,
>
>On Wed, 22 Oct 2003 09:29:09 +0200, Gerhard Grosse
><ge...@lex-com.net> wrote:
>
>> Hi Matthias,
>>
>> I am seeing an AbstractMethodError (partial stack trace below) in my
>> logs whenever OJB first initializes a JDBC connection from the DB2
>> JDBC driver. Obviously OJB is checking for batch support even if
>> batch-mode=false is set in repository.xml. However, in my case the
>> error is silently ignored and does not cause any further problems.
>>
>> I'm using CVS HEAD (almost), Windows XP, Websphere, DB2 and IBM's
>> category 2 JDBC driver.
>>
>You are right.
>The logged message can be ignored, it only suggest that
>the DB doesn't support batchUpdates.
>
>Maybe we should change the logging level from ERROR
>to INFO and prevent the 'checkForBatchSupport' method call
>when batch-mode 'false' is set in repository.
>What do you think?
>
>regards,
>Armin
>
>
>> Gerhard
>>
>>
>> ERROR ojb.broker.platforms.PlatformDefaultImpl - batch support check
>> failed
>> java.lang.AbstractMethodError:
>> COM/ibm/db2/jdbc/app/DB2DatabaseMetaData.supportsBatchUpdates
>> at
>> org.apache.ojb.broker.platforms.PlatformDefaultImpl.checkForBatchSupport(PlatformDefaultImpl.java:106)
>> at
>> org.apache.ojb.broker.platforms.PlatformDefaultImpl.initializeJdbcConnection(PlatformDefaultImpl.java:180)
>> at
>> org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.initializeJdbcConnection(ConnectionFactoryAbstractImpl.java:138)
>> at
>> org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.newConnectionFromDataSource(ConnectionFactoryAbstractImpl.java:210)
>> at
>> org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.lookupConnection(ConnectionFactoryAbstractImpl.java:97)
>> at
>> org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.getConnection(ConnectionManagerImpl.java:135)
>> at
>> org.apache.ojb.broker.accesslayer.StatementManager.getPreparedStatement(StatementManager.java:710)
>> at
>> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl.java:327)
>> ...
>>
>>
>> On Tue, 21 Oct 2003 23:33:03 +0200, "Matthias Roth"
>> <ma...@impart.ch> wrote:
>>
>>> Hi
>>>
>>> does the SequenceManagerHighLowImpl check for batchmode by creating
>>> a new broker instance in getSequence(...){
>>> ...
>>> PersistenceBrokerFactory.createPersistenceBroker(brokerForSequence.getPBKey(
>>> ))
>>> ...
>>> }
>>>
>>> I get an db2 jdbc error (ONLY jdbc driver on z/OS) if the first
>>> getSequence
>>> is called. The error
>>> tells that batch mode is not suported. But in the repository.xml file I
>>> set
>>> batch-mode="false".
>>>
>>> Have had some body also this problem?
>>>
>>>
>>>
>>> regards
>>> Matthias Roth
>>> Dipl. Ing. HTL
>>> in Wirtschaftsinformatik
>>>
>>> impart Software Engineering GmbH
>>> Chasseralstrasse 13
>>> Postfach
>>> CH-3063 Ittigen
>>>
>>> Phone +41 (0)31 922 39 25
>>> Fax +41 (0)31 922 39 18
>>> EMail mailto:matthias.roth@impart.ch
>>> Homepage http://www.impart.ch
>>
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
>> For additional commands, e-mail: ojb-user-help@db.apache.org
>>
>>
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org
Re: check Batchmode problem with DB2 on z/OS with ojb 1.0.rc4
Posted by Armin Waibel <ar...@code-au-lait.de>.
Hi,
On Wed, 22 Oct 2003 09:29:09 +0200, Gerhard Grosse
<ge...@lex-com.net> wrote:
> Hi Matthias,
>
> I am seeing an AbstractMethodError (partial stack trace below) in my
> logs whenever OJB first initializes a JDBC connection from the DB2
> JDBC driver. Obviously OJB is checking for batch support even if
> batch-mode=false is set in repository.xml. However, in my case the
> error is silently ignored and does not cause any further problems.
>
> I'm using CVS HEAD (almost), Windows XP, Websphere, DB2 and IBM's
> category 2 JDBC driver.
>
You are right.
The logged message can be ignored, it only suggest that
the DB doesn't support batchUpdates.
Maybe we should change the logging level from ERROR
to INFO and prevent the 'checkForBatchSupport' method call
when batch-mode 'false' is set in repository.
What do you think?
regards,
Armin
> Gerhard
>
>
> ERROR ojb.broker.platforms.PlatformDefaultImpl - batch support check
> failed
> java.lang.AbstractMethodError:
> COM/ibm/db2/jdbc/app/DB2DatabaseMetaData.supportsBatchUpdates
> at
> org.apache.ojb.broker.platforms.PlatformDefaultImpl.checkForBatchSupport(PlatformDefaultImpl.java:106)
> at
> org.apache.ojb.broker.platforms.PlatformDefaultImpl.initializeJdbcConnection(PlatformDefaultImpl.java:180)
> at
> org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.initializeJdbcConnection(ConnectionFactoryAbstractImpl.java:138)
> at
> org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.newConnectionFromDataSource(ConnectionFactoryAbstractImpl.java:210)
> at
> org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.lookupConnection(ConnectionFactoryAbstractImpl.java:97)
> at
> org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.getConnection(ConnectionManagerImpl.java:135)
> at
> org.apache.ojb.broker.accesslayer.StatementManager.getPreparedStatement(StatementManager.java:710)
> at
> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl.java:327)
> ...
>
>
> On Tue, 21 Oct 2003 23:33:03 +0200, "Matthias Roth"
> <ma...@impart.ch> wrote:
>
>> Hi
>>
>> does the SequenceManagerHighLowImpl check for batchmode by creating
>> a new broker instance in getSequence(...){
>> ...
>> PersistenceBrokerFactory.createPersistenceBroker(brokerForSequence.getPBKey(
>> ))
>> ...
>> }
>>
>> I get an db2 jdbc error (ONLY jdbc driver on z/OS) if the first
>> getSequence
>> is called. The error
>> tells that batch mode is not suported. But in the repository.xml file I
>> set
>> batch-mode="false".
>>
>> Have had some body also this problem?
>>
>>
>>
>> regards
>> Matthias Roth
>> Dipl. Ing. HTL
>> in Wirtschaftsinformatik
>>
>> impart Software Engineering GmbH
>> Chasseralstrasse 13
>> Postfach
>> CH-3063 Ittigen
>>
>> Phone +41 (0)31 922 39 25
>> Fax +41 (0)31 922 39 18
>> EMail mailto:matthias.roth@impart.ch
>> Homepage http://www.impart.ch
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-user-help@db.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org
Re: check Batchmode problem with DB2 on z/OS with ojb 1.0.rc4
Posted by Gerhard Grosse <ge...@lex-com.net>.
Hi Matthias,
I am seeing an AbstractMethodError (partial stack trace below) in my
logs whenever OJB first initializes a JDBC connection from the DB2
JDBC driver. Obviously OJB is checking for batch support even if
batch-mode=false is set in repository.xml. However, in my case the
error is silently ignored and does not cause any further problems.
I'm using CVS HEAD (almost), Windows XP, Websphere, DB2 and IBM's
category 2 JDBC driver.
Gerhard
ERROR ojb.broker.platforms.PlatformDefaultImpl - batch support check
failed
java.lang.AbstractMethodError:
COM/ibm/db2/jdbc/app/DB2DatabaseMetaData.supportsBatchUpdates
at
org.apache.ojb.broker.platforms.PlatformDefaultImpl.checkForBatchSupport(PlatformDefaultImpl.java:106)
at
org.apache.ojb.broker.platforms.PlatformDefaultImpl.initializeJdbcConnection(PlatformDefaultImpl.java:180)
at
org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.initializeJdbcConnection(ConnectionFactoryAbstractImpl.java:138)
at
org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.newConnectionFromDataSource(ConnectionFactoryAbstractImpl.java:210)
at
org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.lookupConnection(ConnectionFactoryAbstractImpl.java:97)
at
org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.getConnection(ConnectionManagerImpl.java:135)
at
org.apache.ojb.broker.accesslayer.StatementManager.getPreparedStatement(StatementManager.java:710)
at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl.java:327)
...
On Tue, 21 Oct 2003 23:33:03 +0200, "Matthias Roth"
<ma...@impart.ch> wrote:
>Hi
>
>does the SequenceManagerHighLowImpl check for batchmode by creating
>a new broker instance in getSequence(...){
>...
>PersistenceBrokerFactory.createPersistenceBroker(brokerForSequence.getPBKey(
>))
>...
>}
>
>I get an db2 jdbc error (ONLY jdbc driver on z/OS) if the first getSequence
>is called. The error
>tells that batch mode is not suported. But in the repository.xml file I set
>batch-mode="false".
>
>Have had some body also this problem?
>
>
>
>regards
>Matthias Roth
>Dipl. Ing. HTL
>in Wirtschaftsinformatik
>
>impart Software Engineering GmbH
>Chasseralstrasse 13
>Postfach
>CH-3063 Ittigen
>
>Phone +41 (0)31 922 39 25
>Fax +41 (0)31 922 39 18
>EMail mailto:matthias.roth@impart.ch
>Homepage http://www.impart.ch
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org
Re: check Batchmode problem with DB2 on z/OS with ojb 1.0.rc4
Posted by Armin Waibel <ar...@code-au-lait.de>.
Hi Matthias,
On Tue, 21 Oct 2003 23:33:03 +0200, Matthias Roth
<ma...@impart.ch> wrote:
> Hi
>
> does the SequenceManagerHighLowImpl check for batchmode by creating
> a new broker instance in getSequence(...){
> ...
> PersistenceBrokerFactory.createPersistenceBroker(brokerForSequence.getPBKey(
> ))
> ...
> }
>
> I get an db2 jdbc error (ONLY jdbc driver on z/OS) if the first
> getSequence
> is called. The error
> tells that batch mode is not suported. But in the repository.xml file I
> set
> batch-mode="false".
>
> Have had some body also this problem?
>
Which version do you use?
regards,
Armin
>
>
> regards
> Matthias Roth
> Dipl. Ing. HTL
> in Wirtschaftsinformatik
>
> impart Software Engineering GmbH
> Chasseralstrasse 13
> Postfach
> CH-3063 Ittigen
>
> Phone +41 (0)31 922 39 25
> Fax +41 (0)31 922 39 18
> EMail mailto:matthias.roth@impart.ch
> Homepage http://www.impart.ch
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org