There was some trick I remember about that - try using java.sql.Date ... Rob :)
-----Original Message----- From: Brian Sam-Bodden [mailto:[EMAIL PROTECTED] Sent: Tuesday, 6 January 2004 11:04 a.m. To: [EMAIL PROTECTED] Subject: Re: HSQLDB + JBoss Help (Function is Not Supported SQL Exception) Rob, 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,AB STRACTSUBMISSIONENDDATE) 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] _conferences,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] _conferences,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,DESCRIP TION,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,AB STRACTSUBMISSIONENDDATE) 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.j ava:1602) at org.hsqldb.jdbcPreparedStatement.setCharacterStream(jdbcPreparedStatemen t.java:1375) at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.setCharacterStr eam(WrappedPreparedStatement.java:644) at org.apache.ojb.broker.platforms.PlatformDefaultImpl.setObjectForStatemen t(PlatformDefaultImpl.java:261) at org.apache.ojb.broker.accesslayer.StatementManager.bindInsert(StatementM anager.java:509) at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(JdbcAcces sImpl.java:232) at org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(PersistenceBr okerImpl.java:1384) at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBroker Impl.java:1301) at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBroker Impl.java:688) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(DelegatingP ersistenceBroker.java:165) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(DelegatingP ersistenceBroker.java:165) at com.ejdoab.beans.ConferenceFacadeBean.saveConference(ConferenceFacadeBea n.java:93) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav a:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor Impl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(Stat elessSessionContainer.java:660) at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke( CachedConnectionInterceptor.java:186) at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(Statele ssSessionInstanceInterceptor.java:77) at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterce ptor.java:107) at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptor CMT.java:210) at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:98) at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.jav a: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.jav a:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor Impl.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.ja va: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.SequenceManagerHighLowImp l"/> > > </jdbc-connection-descriptor> > > Thanks, > Brian --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
