Hi (Armin and others),

using the RC4, PB api and MySql, with the following settings in
ojb.properties and database repository:

ConnectionFactoryClass=org.apache.ojb.broker.accesslayer.ConnectionFactoryNo
tPooledImpl

    
    <jdbc-connection-descriptor
      jcd-alias="default"
      default-connection="true"
      batch-mode="false"
      useAutoCommit="1"
      ignoreAutoCommitExceptions="false"
      eager-release="true"
      platform="MySQL"
      jdbc-level="2.0"
      driver="org.gjt.mm.mysql.Driver"
      protocol="jdbc"
      subprotocol="mysql"
      dbalias="//localhost:3306/metanumber"
      username="sa"
      password="kulikoma"
    >
        <connection-pool
            maxActive="21"
            validationQuery="SELECT * FROM IBANX_USER" />

        <sequence-manager
className="org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl">
            <attribute attribute-name="grabSize" attribute-value="50"/>
            <attribute attribute-name="autoNaming" attribute-value="false"/>
            <attribute attribute-name="globalSequenceId"
attribute-value="false"/>
            <attribute attribute-name="globalSequenceStart"
attribute-value="10000"/>
        </sequence-manager>
    
    </jdbc-connection-descriptor>


whenever i have code like this:

        broker.beginTransaction();
      broker.store(obj);
      broker.commitTransaction();

on issueing the commit, the underlying ConnectionManagerImpl has no
connection.

tracing (with loads of added system.out statements in OJB code) revealed
that upon the call of broker.store(obj), the connection within the
connectionmanager gets released and set to null, so when later calling a
commit, there is no connection to commit on, hence we also get the error
logged from PlatformDefaultImpl [ Given connection was null, cannot prepare
autoCommit state].

hope this gives you the info so you can reproduce it.

Roger Janssen
iBanx


*************************************************************************
The information contained in this communication is confidential and is
intended solely for the use of the individual or entity to  whom it is
addressed.You should not copy, disclose or distribute this communication 
without the authority of iBanx bv. iBanx bv is neither liable for 
the proper and complete transmission of the information has been maintained
nor that the communication is free of viruses, interceptions or interference.

If you are not the intended recipient of this communication please return
the communication to the sender and delete and destroy all copies.

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to