Hi Phil, strange!? The hsql version shipped with jboss is different from the version shipped with OJB. So handle carefully with hsql jar files in your classpath. Only use hsql.jar's shipped with jboss.
regards, Armin ----- Original Message ----- From: "Phil Warrick" <[EMAIL PROTECTED]> To: "OJB Users List" <[EMAIL PROTECTED]> Sent: Wednesday, October 30, 2002 12:28 AM Subject: Re: how to deploy the test hsqldb > Hi Armin, > > Got a bit further this time, any idea about the hsqldb Trace problem? > (console output below). > > Thanks, > > Phil > > 16:24:44,118 INFO [Server] JBoss (MX MicroKernel) [3.0.3 > Date:200209301503] Started in 0m:18s:146ms > 16:24:56,957 INFO [STDOUT] [BOOT] WARN: > 16:24:56,967 INFO [STDOUT] Value > "org.apache.ojb.broker.metadata.PersistentFieldPropertyImpl" is illegal > for key "PersistentFieldClass" (should be a class, using default value > org.apache.ojb.broker.metadata.fieldaccess.PersistentFieldDefaultImpl) > 16:24:57,057 INFO [STDOUT] [org.apache.ojb.ejb.PBSessionBean] INFO: > 16:24:57,057 INFO [STDOUT] ojbPrepare was called > 16:24:57,057 INFO [STDOUT] [org.apache.ojb.ejb.PBSessionBean] INFO: > 16:24:57,057 INFO [STDOUT] Use OJB repository file: repository.xml > 16:24:57,097 INFO [STDOUT] [org.apache.ojb.ejb.PBSessionBean] INFO: > 16:24:57,097 INFO [STDOUT] getArticleCount was called > 16:24:57,097 INFO [STDOUT] [org.apache.ojb.ejb.PBSessionBean] INFO: > 16:24:57,097 INFO [STDOUT] getBroker was called > 16:24:57,097 INFO [STDOUT] > [org.apache.ojb.broker.ta.PersistenceBrokerFactoryDefaultImpl] INFO: > 16:24:57,097 INFO [STDOUT] Already created persistence broker instances: 0 > 16:24:57,447 INFO [STDOUT] > [org.apache.ojb.broker.util.sequence.SequenceManagerFactory] INFO: > 16:24:57,447 INFO [STDOUT] Use sequence manager class: class > org.apache.ojb.broker.util.sequence.SequenceManagerHiLoImpl > 16:24:57,527 ERROR [LogInterceptor] Unexpected Error: > java.lang.IllegalAccessError: tried to access class org.hsqldb.Trace > from class org.hsqldb.jdbcDriver > at org.hsqldb.jdbcDriver.<clinit>(Unknown Source) > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) > at > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorA ccessorImpl.java:39) > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingCons tructorAccessorImpl.java:27) > at java.lang.reflect.Constructor.newInstance(Constructor.java:274) > at java.lang.Class.newInstance0(Class.java:306) > at java.lang.Class.newInstance(Class.java:259) > at > org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.chec kDriver(LocalManagedConnectionFactory.java:438) > at > org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.crea teManagedConnection(LocalManagedConnectionFactory.java:130) > at > org.jboss.resource.connectionmanager.InternalManagedConnectionPool.creat eConnection(InternalManagedConnectionPool.java:259) > at > org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getCo nnection(InternalManagedConnectionPool.java:106) > at > org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool .getConnection(JBossManagedConnectionPool.java:323) > at > org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedCo nnection(BaseConnectionManager2.java:467) > at > org.jboss.resource.connectionmanager.LocalTxConnectionManager.getManaged Connection(LocalTxConnectionManager.java:221) > at > org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConn ection(BaseConnectionManager2.java:532) > at > org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionMa nagerProxy.allocateConnection(BaseConnectionManager2.java:812) > at > org.jboss.resource.adapter.jdbc.local.LocalDataSource.getConnection(Loca lDataSource.java:122) > at > org.apache.ojb.broker.accesslayer.AbstractConnectionFactory.getConnectio nFromDataSource(Unknown > Source) > at > org.apache.ojb.broker.accesslayer.AbstractConnectionFactory.getConnectio n(Unknown > Source) > at > org.apache.ojb.broker.accesslayer.ConnectionFactoryDefaultImpl.lookupCon nection(Unknown > Source) > at > org.apache.ojb.broker.accesslayer.ConnectionManager.getConnection(Unknow n > Source) > at > org.apache.ojb.broker.accesslayer.StatementsForClassImpl.createStatement (Unknown > Source) > at > org.apache.ojb.broker.accesslayer.StatementsForClassImpl.getGenericStmt( Unknown > Source) > at > org.apache.ojb.broker.accesslayer.StatementManager.getGenericStatement(U nknown > Source) > at org.apache.ojb.broker.accesslayer.JdbcAccess.executeQuery(Unknown > Source) > at org.apache.ojb.broker.accesslayer.RsIterator.<init>(Unknown Source) > at > org.apache.ojb.broker.accesslayer.ReportQueryRsIterator.<init>(Unknown > Source) > at > org.apache.ojb.broker.singlevm.ReportRsIteratorFactoryImpl.createRsItera tor(Unknown > Source) > at > org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getRsIteratorFromQu ery(Unknown > Source) > at > org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getReportQueryItera torFromQuery(Unknown > Source) > at > org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getReportQueryItera torByQuery(Unknown > Source) > at > org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCount(Unknown > Source) > at org.apache.ojb.ejb.PBSessionBean.getCount(Unknown Source) > at org.apache.ojb.ejb.PBSessionBean.getArticleCount(Unknown Source) > 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:178) > at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:60) > at > org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.jav a:130) > at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:203) > at > org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer .java:313) > at org.jboss.ejb.Container.invoke(Container.java:712) > at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517) > at > org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:381 ) > 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:536) > 16:24:57,648 INFO [STDOUT] [org.apache.ojb.ejb.PBSessionBean] INFO: > 16:24:57,648 INFO [STDOUT] ojbPrepare was called > 16:24:57,648 INFO [STDOUT] [org.apache.ojb.ejb.PBSessionBean] INFO: > 16:24:57,648 INFO [STDOUT] Use OJB repository file: repository.xml > 16:24:57,648 INFO [STDOUT] [org.apache.ojb.ejb.PBSessionBean] INFO: > 16:24:57,648 INFO [STDOUT] getPersonCount was called > 16:24:57,648 INFO [STDOUT] [org.apache.ojb.ejb.PBSessionBean] INFO: > 16:24:57,648 INFO [STDOUT] getBroker was called > 16:24:57,648 INFO [STDOUT] > [org.apache.ojb.broker.ta.PersistenceBrokerFactoryDefaultImpl] INFO: > > > Armin Waibel wrote: > > Hi Phil, > > > > ----- Original Message ----- > > From: "Phil Warrick" <[EMAIL PROTECTED]> > > To: "OJB Users List" <[EMAIL PROTECTED]> > > Sent: Tuesday, October 29, 2002 8:33 PM > > Subject: j2EE: how to deploy the test hsqldb > > > > > > > >>Hi, > >> > >>I'm getting close to finally getting the cvs head ejb examples to work > >>with a remote client (more on the pain involved with the > >>build-xdoclet.xml file and creating a client perhaps later). My > > > > problem > > > >>is that I don't know how to deploy the hsqldb with the test tables > >>(table "Artikle", etc.) to jboss. > >> > > > > > > Do a > > bin\build.bat prepare-testdb > > on OJB to generate hsql test tables. > > Take the generated OJB.script file from .../target/test > > and rename the file to default.script. > > Replace the in > > JBoss\server\default\db\hypersonic > > default.script with the new file. > > > > In your repository file define > > > > <jdbc-connection-descriptor > > platform="Hsqldb" > > jdbc-level="2.0" > > jndi-datasource-name="java:DefaultDS" > > username="sa" > > password="" > > eager-release="true" > > /> > > > > That's it. > > > > HTH > > regards, > > Armin > > > > > >>1) If I use the default hsqldb location java:DefaultDS, I get a file > > > > i/o > > > >>error, and I can't see that the correct table definitions would exist > > > > by > > > >>default: > >> > >>14:24:11,490 INFO [Server] JBoss (MX MicroKernel) [3.0.3 > >>Date:200209301503] Started in 0m:20s:379ms > >>14:24:22,466 INFO [STDOUT] [org.apache.ojb.ejb.PBSessionBean] INFO: > >>14:24:22,466 INFO [STDOUT] ojbPrepare was called > >>14:24:22,476 INFO [STDOUT] [org.apache.ojb.ejb.PBSessionBean] INFO: > >>14:24:22,476 INFO [STDOUT] Use OJB repository file: repository.xml > >>14:24:22,526 INFO [STDOUT] [org.apache.ojb.ejb.PBSessionBean] INFO: > >>14:24:22,526 INFO [STDOUT] getArticleCount was called > >>14:24:22,526 INFO [STDOUT] [org.apache.ojb.ejb.PBSessionBean] INFO: > >>14:24:22,526 INFO [STDOUT] getBroker was called > >>14:24:22,536 INFO [STDOUT] > >>[org.apache.ojb.broker.ta.PersistenceBrokerFactoryDe > >>faultImpl] INFO: > >>14:24:22,536 INFO [STDOUT] Already created persistence broker > > > > instances: 0 > > > >>14:24:22,636 INFO [STDOUT] settign eager: false > >>14:24:22,827 INFO [STDOUT] > >>[org.apache.ojb.broker.util.sequence.SequenceManager > >>Factory] INFO: > >>14:24:22,837 INFO [STDOUT] Use sequence manager class: class > >>org.apache.ojb.bro > >>ker.util.sequence.SequenceManagerHiLoImpl > >>14:24:22,907 INFO [STDOUT] > >>[org.apache.ojb.broker.accesslayer.AbstractConnectio > >>nFactory] ERROR: > >>14:24:22,907 INFO [STDOUT] Error getting Connection from > > > > DriverManager > > > >>with url > >> (jdbc:hsqldb:java:/DefaultDS) and driver (org.hsqldb.jdbcDriver) > >>14:24:22,917 INFO [STDOUT] File input/output error: > >>java:/DefaultDS.properties > >>14:24:22,917 ERROR [STDERR] java.sql.SQLException: File input/output > >>error: java:/DefaultDS.properties > >>14:24:22,927 ERROR [STDERR] at > > > > org.hsqldb.Trace.getError(Trace.java:180) > > > >>14:24:22,927 ERROR [STDERR] at > > > > org.hsqldb.Trace.getError(Trace.java:144) > > > >>14:24:22,937 ERROR [STDERR] at > > > > org.hsqldb.Trace.error(Trace.java:205) > > > >>14:24:22,937 ERROR [STDERR] at > >>org.hsqldb.Log.saveProperties(Log.java:630) > >>14:24:22,937 ERROR [STDERR] at org.hsqldb.Log.create(Log.java:521) > >>14:24:22,947 ERROR [STDERR] at org.hsqldb.Log.open(Log.java:159) > >>14:24:22,947 ERROR [STDERR] at > >>org.hsqldb.Database.<init>(Database.java:96) > >>14:24:22,947 ERROR [STDERR] at > >>org.hsqldb.jdbcConnection.openStandalone(jdbc > >>Connection.java:926) > >> > >> > >>2) If I put the hsqldb files OJB.script and OJB.properties in the .sar > >>file (say in target\test\OJB), there is a complaint about writing to > >>that file. > >> > >>3) If I put them in the jboss\bin directory, I get a "wrong database > >>version" problem: > >> > >>14:18:35,440 INFO [MainDeployer] Deployed package: > >>file:/C:/jboss/jboss-3.0.3/s > >>erver/default/conf/jboss-service.xml > >>14:18:35,450 INFO [Server] JBoss (MX MicroKernel) [3.0.3 > >>Date:200209301503] Started in 0m:20s:28ms > >>14:18:50,772 INFO [STDOUT] [org.apache.ojb.ejb.PBSessionBean] > >>14:18:50,772 INFO [STDOUT] [org.apache.ojb.ejb.PBSessionBean] INFO: > >>14:18:50,772 INFO [STDOUT] ojbPrepare was called > >>14:18:50,772 INFO [STDOUT] [org.apache.ojb.ejb.PBSessionBean] INFO: > >>14:18:50,772 INFO [STDOUT] Use OJB repository file: repository.xml > >>14:18:50,822 INFO [STDOUT] [org.apache.ojb.ejb.PBSessionBean] INFO: > >>14:18:50,822 INFO [STDOUT] getArticleCount was called > >>14:18:50,832 INFO [STDOUT] [org.apache.ojb.ejb.PBSessionBean] INFO: > >>14:18:50,832 INFO [STDOUT] getBroker was called > >>14:18:50,832 INFO [STDOUT] > >>[org.apache.ojb.broker.ta.PersistenceBrokerFactoryDe > >>faultImpl] INFO: > >>14:18:50,842 INFO [STDOUT] Already created persistence broker > > > > instances: 0 > > > >>14:18:50,943 INFO [STDOUT] settign eager: false > >>14:18:51,143 INFO [STDOUT] > >>[org.apache.ojb.broker.util.sequence.SequenceManager > >>Factory] INFO: > >>14:18:51,153 INFO [STDOUT] Use sequence manager class: class > >>org.apache.ojb.bro > >>ker.util.sequence.SequenceManagerHiLoImpl > >>14:18:51,223 INFO [STDOUT] > >>[org.apache.ojb.broker.accesslayer.AbstractConnectio > >>nFactory] ERROR: > >>14:18:51,233 INFO [STDOUT] Error getting Connection from > > > > DriverManager > > > >>with url > >> (jdbc:hsqldb:target/test/OJB) and driver (org.hsqldb.jdbcDriver) > >>14:18:51,243 INFO [STDOUT] Wrong database file version > >>14:18:51,243 ERROR [STDERR] java.sql.SQLException: Wrong database file > >>version > >>14:18:51,243 ERROR [STDERR] at > > > > org.hsqldb.Trace.getError(Trace.java:180) > > > >>14:18:51,253 ERROR [STDERR] at > > > > org.hsqldb.Trace.getError(Trace.java:144) > > > >>14:18:51,253 ERROR [STDERR] at > > > > org.hsqldb.Trace.check(Trace.java:276) > > > >>14:18:51,253 ERROR [STDERR] at > > > > org.hsqldb.Trace.check(Trace.java:260) > > > >>14:18:51,263 ERROR [STDERR] at org.hsqldb.Log.open(Log.java:185) > >>14:18:51,263 ERROR [STDERR] at > >>org.hsqldb.Database.<init>(Database.java:96) > >>14:18:51,263 ERROR [STDERR] at > >>org.hsqldb.jdbcConnection.openStandalone(jdbc > >>Connection.java:926) > >> > >>Any help would be most appreciated. > >> > >>Thanks, > >> > >>Phil > >> > >> > >>-- > >>To unsubscribe, e-mail: > > > > <mailto:ojb-user-unsubscribe@;jakarta.apache.org> > > > >>For additional commands, e-mail: > > > > <mailto:ojb-user-help@;jakarta.apache.org> > > > >> > >> > > > > > > -- > > To unsubscribe, e-mail: <mailto:ojb-user-unsubscribe@;jakarta.apache.org> > > For additional commands, e-mail: <mailto:ojb-user-help@;jakarta.apache.org> > > > > -- > To unsubscribe, e-mail: <mailto:ojb-user-unsubscribe@;jakarta.apache.org> > For additional commands, e-mail: <mailto:ojb-user-help@;jakarta.apache.org> > > > -- To unsubscribe, e-mail: <mailto:ojb-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:ojb-user-help@;jakarta.apache.org>
