[castor-dev] Problem with Level IV Driver Microsoft SQL Server 2000

[Tino H�rning]

Hello there,

i have a problem with using the level 4 JDBC driver from Microsoft to
access a Microsoft SQL Server 2000 (i have also testet a Microsoft SQL
Server 7, but with the same result):

The exception:

java.sql.SQLException: [Microsoft][SQLServer JDBC Driver]Can't start a 
cloned connection while in manual transaction mode.
        at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
        at com.microsoft.jdbc.base.BaseConnection.getImplConnection(Unknown Source)
        at com.microsoft.jdbc.base.BaseStatement.getImplConnection(Unknown Source)
        at com.microsoft.jdbc.base.BaseStatement.getImplStatement(Unknown Source)
        at com.microsoft.jdbc.base.BaseStatement.preProcessSQL(Unknown Source)
        at com.microsoft.jdbc.base.BasePreparedStatement.<init>(Unknown Source)
        at com.microsoft.jdbc.base.BaseConnection.prepareStatement(Unknown Source)
        at org.exolab.castor.jdo.engine.SQLEngine.load(SQLEngine.java:984)
        at org.exolab.castor.persist.ClassMolder.load(ClassMolder.java:677)
        at org.exolab.castor.persist.LockEngine.load(LockEngine.java:359)
        at 
org.exolab.castor.persist.TransactionContext.load(TransactionContext.java:575)
        at 
org.exolab.castor.persist.TransactionContext.load(TransactionContext.java:486)
        at org.exolab.castor.persist.ClassMolder.load(ClassMolder.java:744)
        at org.exolab.castor.persist.LockEngine.load(LockEngine.java:359)
        at 
org.exolab.castor.persist.TransactionContext.load(TransactionContext.java:575)
        at org.exolab.castor.persist.QueryResults.fetch(QueryResults.java:229)
        at 
org.exolab.castor.jdo.engine.OQLQueryImpl$OQLEnumeration.hasMore(OQLQueryImpl.java:573)
        at 
org.exolab.castor.jdo.engine.OQLQueryImpl$OQLEnumeration.hasMore(OQLQueryImpl.java:556)

The error occurs on reading a object (class Object1) from database, which 
have a collection - reference to an other object (class Object2):

public class Object1 {

        protected Vector refToObject2;
        ....
}

public class Object2{

        ....
}


The mapping file:

<class name="Object1" identity="i_id" key-generator="UUID">
                
        <map-to table="tbl_01" />
                
        <field name="i_list" type="Object2" collection="vector">
                <sql many-key="ia_item_id" many-table="tbl_02"/>
        </field>

        .....
</class>

<class name="Object2" identity="c_id" key-generator="UUID">
                
        <map-to table="tbl_02" />
                
        <field name="ia_item_id" type="java.lang.String">
                <sql name="c_id" type="varchar" />
        </field>
</class>
        
I suppose, the JDBC Driver from Microsoft have a little problem ...

With regards
Tino

----------------------------------------------------------- 
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
        unsubscribe castor-dev