Hi,
Does anyone have the correct configuration for msaccess memo and ole object types?
The configuration listed here causes a hangup in the sun.jdbc.odbc classes.
The thread dump from a ctl-break is also listed below.
Thanks in advance,
Mark
___________________________________________________________________________
* configuration
* sql\base\msaccess\db.props in torque-3.0.jar
LONGVARCHAR = MEMO
* unchanged
BINARY = longbinary
VARBINARY = longbinary
LONGVARBINARY = longbinary
* changed as per the second table in
http://admin.nj.devry.edu/~kjudge/accessddl.htm
...
* for memo:
* example torque column declaration
* <column name="DESCRIPTION" type="LONGVARCHAR"/>
* example ojb field-descriptor
* <field-descriptor name="description" column="DESCRIPTION"
jdbc-type="VARCHAR"/>
* This works up to the 255 character length limit
* <field-descriptor name="description" column="DESCRIPTION"
jdbc-type="LONGVARCHAR"/>
* This hangs in
at
sun.jdbc.odbc.JdbcOdbcObject.CharsToBytes(JdbcOdbcObject.java:326)
at
sun.jdbc.odbc.JdbcOdbcPreparedStatement.setCharacterStream(JdbcOdbcPreparedStatement.java:2401)
at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at
java.lang.reflect.Method.invoke(Method.java:324)
at
org.apache.ojb.broker.util.batch.PreparedStatementInvocationHandler.doExecute(PreparedStatementInvocationHandler.java:173)
at
org.apache.ojb.broker.util.batch.PreparedStatementInvocationHandler.invoke(PreparedStatementInvocationHandler.java:140)
at $Proxy0.doExecute(Unknown Source)
at
org.apache.ojb.broker.util.batch.BatchConnection.executeBatch(BatchConnection.java:179)
at
org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.executeBatch(ConnectionManagerImpl.java:326)
at
org.apache.ojb.odmg.ObjectEnvelopeTable.commit(ObjectEnvelopeTable.java:188)
at
org.apache.ojb.odmg.TransactionImpl.doCommitOnObjects(TransactionImpl.java:326)
- locked <07BD5420> (a
org.apache.ojb.odmg.TransactionImpl)
at
org.apache.ojb.odmg.TransactionImpl.checkpoint(TransactionImpl.java:443)
* for ole object:
* example torque column declaration
* <column name="ICON_BLOB" type="LONGVARBINARY"/>
* example ojb field-descriptor
* <field-descriptor name="iconBlob" column="ICON_BLOB"
jdbc-type="VARBINARY"/>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
