From the debug statements below I can see that the SQL INSERT looks like:
[org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] SQL:INSERT INTO conferences (PK_ID,NAME,DESCRIPTION,STARTDATE,ENDDATE,ABSTRACTSUBMISSIONSTARTDATE,ABSTRACTSUBMISSIONENDDATE) VALUES (?,?,?,?,?,?,?)
Now if I issue that insert manually it works just fine. That's puzzling! Could be the date conversion from java.util.Data to SQL dates?
Thanks, Brian
2004-01-05 16:52:52,502 DEBUG [org.apache.ojb.broker.accesslayer.JdbcAccessImpl] executeUpdate : [EMAIL PROTECTED],fieldName=deprecatedColumn,grabSize=20,version=8,maxKey=180,currentKey=160]
2004-01-05 16:52:52,502 DEBUG [org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] SQL:UPDATE OJB_HL_SEQ SET MAX_KEY=?,GRAB_SIZE=?,VERSION=? WHERE TABLENAME = ? AND FIELDNAME = ? AND VERSION = ?
2004-01-05 16:52:52,502 DEBUG [org.apache.ojb.broker.accesslayer.JdbcAccessImpl] executeUpdate: [EMAIL PROTECTED]
2004-01-05 16:52:52,512 DEBUG [org.apache.ojb.broker.accesslayer.StatementManager] closeResources was called
2004-01-05 16:52:52,512 DEBUG [org.apache.ojb.broker.accesslayer.ConnectionManagerImpl] commit was called
2004-01-05 16:52:52,512 DEBUG [org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl] new sequence was [EMAIL PROTECTED],fieldName=deprecatedColumn,grabSize=20,version=9,maxKey=180,currentKey=160]
2004-01-05 16:52:52,512 DEBUG [org.apache.ojb.broker.core.PersistenceBrokerImpl] PB.close was called: [EMAIL PROTECTED]
2004-01-05 16:52:52,512 DEBUG [org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] SQL:SELECT PK_ID,ABSTRACTSUBMISSIONENDDATE,ABSTRACTSUBMISSIONSTARTDATE,NAME,DESCRIPTION,ENDDATE,STARTDATE FROM conferences WHERE PK_ID = ?
2004-01-05 16:52:52,512 DEBUG [org.apache.ojb.broker.accesslayer.StatementManager] closeResources was called
2004-01-05 16:52:52,512 DEBUG [org.apache.ojb.broker.accesslayer.JdbcAccessImpl] executeInsert : [Conference] id = 161, name = EJDOAB Conference, description = Brian's Conference
2004-01-05 16:52:52,512 DEBUG [org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl] do datasource lookup, name: java:tcmsDS, user: sa
2004-01-05 16:52:52,512 DEBUG [org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl] Create new connection using DataSource: [EMAIL PROTECTED]
2004-01-05 16:52:52,512 DEBUG [org.apache.ojb.broker.accesslayer.ConnectionManagerImpl] Request new connection from ConnectionFactory: [EMAIL PROTECTED]
2004-01-05 16:52:52,512 DEBUG [org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] SQL:INSERT INTO conferences (PK_ID,NAME,DESCRIPTION,STARTDATE,ENDDATE,ABSTRACTSUBMISSIONSTARTDATE,ABSTRACTSUBMISSIONENDDATE) VALUES (?,?,?,?,?,?,?)
2004-01-05 16:52:52,522 ERROR [org.apache.ojb.broker.accesslayer.JdbcAccessImpl] SQLException during the execution of the insert (for a com.ejdoab.pojos.Conference): This function is not supported
java.sql.SQLException: This function is not supported
at org.hsqldb.Trace.getError(Trace.java:180)
at org.hsqldb.Trace.getError(Trace.java:144)
at org.hsqldb.Trace.error(Trace.java:192)
at org.hsqldb.jdbcPreparedStatement.getNotSupported(jdbcPreparedStatement.java:1602)
at org.hsqldb.jdbcPreparedStatement.setCharacterStream(jdbcPreparedStatement.java:1375)
at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.setCharacterStream(WrappedPreparedStatement.java:644)
at org.apache.ojb.broker.platforms.PlatformDefaultImpl.setObjectForStatement(PlatformDefaultImpl.java:261)
at org.apache.ojb.broker.accesslayer.StatementManager.bindInsert(StatementManager.java:509)
at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(JdbcAccessImpl.java:232)
at org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(PersistenceBrokerImpl.java:1384)
at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImpl.java:1301)
at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImpl.java:688)
at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(DelegatingPersistenceBroker.java:165)
at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(DelegatingPersistenceBroker.java:165)
at com.ejdoab.beans.ConferenceFacadeBean.saveConference(ConferenceFacadeBean.java:93)
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.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:660)
at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:186)
at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:77)
at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:107)
at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:210)
at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:98)
at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:130)
at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:208)
at org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer.java:313)
at org.jboss.ejb.Container.invoke(Container.java:738)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
at org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:383)
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 sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
at sun.rmi.transport.Transport$1.run(Transport.java:148)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Transport.java:144)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701)
at java.lang.Thread.run(Thread.java:534)
2004-01-05 16:52:52,542 DEBUG [org.apache.ojb.broker.accesslayer.StatementManager] closeResources was called
2004-01-05 16:52:52,542 INFO [org.apache.ojb.broker.accesslayer.ConnectionManagerImpl] Rollback was called, do rollback on current connection null
2004-01-05 16:52:52,542 DEBUG [org.apache.ojb.broker.core.PersistenceBrokerImpl] PB.close was called: [EMAIL PROTECTED]
2004-01-05 16:52:57,489 DEBUG [org.jboss.ejb.plugins.LRUEnterpriseContextCachePolicy] Resized cache for bean ConferenceAbstractStatus: old capacity = 1000000, new capacity = 50
Brian Sam-Bodden wrote:
Coup, Robert Muir wrote:
If you use hsqldb in client-server mode you can set it up to log all the sql queries (see Advanced Topics in the HSQLDB docs). Or configure p6spy to do the same thing on the OJB side... This might give you some ideas about what it is trying to do...
I assume that your db connection in the repository is set to use the HSQLDB driver, etc?
Good luck,
Rob :)
Rob,
Thanks a bunch for responding. Here's some more info. I'm in the process of trying the P6SPY stuff right now.
here's my repository_database:
<jdbc-connection-descriptor
jcd-alias="tcms"
default-connection="true"
platform="Hsqldb"
driver="org.hsqldb.jdbcDriver"
jdbc-level="2.0"
jndi-datasource-name="java:tcmsDS"
username="sa"
password=""
eager-release="true"
batch-mode="false"
useAutoCommit="0"
ignoreAutoCommitExceptions="false">
<sequence-manager className="org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl"/>
</jdbc-connection-descriptor>
Thanks, Brian
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
