OK, there are two things going on here. The first is that the table names supplied in jaws.xml are lower case and do not match the all upper case ones returned by hsqldb 1.7.1. This is the cause of the error below. I will make a change so that we do a case-insensitive compare when checking if the table exists.
However, if I make the table name all upper case to avoid this problem bankiiop fails for me with 'Exception in thread "main"' on the test console an nothing logged elsewhere. This leaves the bank bean deployed and then everything is messed up. Anyone have any ideas, before I dig in? Thanks Jeremy > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of > Jeremy Boynes > Sent: Saturday, February 08, 2003 8:23 PM > To: [EMAIL PROTECTED] > Subject: RE: [JBoss-dev] Why is JDBCCommand dumping out these errors now > > > This seems to be a reoccurance of the case-sensitive meta-data > problem that > happened with the upgrade to hsqldb 1.7.1 back in December. It's not all > tests that fail, the cmp2 ones seem to work fine but bankiiop is broken. > > I'll look into it. > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED]]On Behalf Of Scott > > M Stark > > Sent: Saturday, February 08, 2003 7:35 PM > > To: [EMAIL PROTECTED] > > Subject: [JBoss-dev] Why is JDBCCommand dumping out these errors now > > > > > > The JDBCCommand layer is dumping out errors due to some recent > change. Run > > any cmp test more than once that attempts to create a table and > > the following > > type of error occurs. It does not prevent the test from running > > but it should > > not be showing up as an error. > > > > 19:30:12,198 ERROR [JDBCCommand] Exception caught executing SQL > > java.sql.SQLException: Table already exists: CUSTOMER in > > statement [CREATE TABLE > > Customer (name VARCHAR(256),accounts OBJECT,id VARCHAR(256))] > > at org.hsqldb.Trace.getError(Unknown Source) > > at org.hsqldb.Result.<init>(Unknown Source) > > at org.hsqldb.jdbcConnection.executeHSQL(Unknown Source) > > at org.hsqldb.jdbcConnection.execute(Unknown Source) > > at org.hsqldb.jdbcStatement.fetchResult(Unknown Source) > > at org.hsqldb.jdbcStatement.executeUpdate(Unknown Source) > > at > org.hsqldb.jdbcPreparedStatement.executeUpdate(Unknown Source) > > at > > org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUp > > date(WrappedPreparedStatement.java:308) > > at > > org.jboss.ejb.plugins.jaws.jdbc.JDBCUpdateCommand.executeStatement > > AndHandleResult(JDBCUpdateCommand.java:61) > > at > > org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCComman > > d.java:176) > > at > > org.jboss.ejb.plugins.jaws.jdbc.JDBCInitCommand.execute(JDBCInitCo > > mmand.java:149) > > at > > org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.create(JAWSPersi > > stenceManager.java:131) > > at > > org.jboss.ejb.plugins.CMPPersistenceManager.create(CMPPersistenceM > > anager.java:127) > > at > > org.jboss.ejb.EntityContainer.createService(EntityContainer.java:277) > > at > > > org.jboss.system.ServiceMBeanSupport.create(ServiceMBeanSupport.java:158) > > at sun.reflect.GeneratedMethodAccessor33.invoke(Unknown Source) > > at > > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAc > > cessorImpl.java:25) > > at java.lang.reflect.Method.invoke(Method.java:324) > > at > > org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedM > > BeanDispatcher.java:284) > > at > > org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549) > > at > > org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceCont > > roller.java:966) > > at $Proxy11.create(Unknown Source) > > at > > org.jboss.system.ServiceController.create(ServiceController.java:310) > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > > at > > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorIm > > pl.java:39) > > at > > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAc > > cessorImpl.java:25) > > at java.lang.reflect.Method.invoke(Method.java:324) > > at > > org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedM > > BeanDispatcher.java:284) > > at > > org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549) > > at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174) > > at $Proxy32.create(Unknown Source) > > at org.jboss.ejb.EjbModule.createService(EjbModule.java:347) > > at > > > org.jboss.system.ServiceMBeanSupport.create(ServiceMBeanSupport.java:158) > > at sun.reflect.GeneratedMethodAccessor33.invoke(Unknown Source) > > at > > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAc > > cessorImpl.java:25) > > at java.lang.reflect.Method.invoke(Method.java:324) > > at > > org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedM > > BeanDispatcher.java:284) > > at > > org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549) > > at > > org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceCont > > roller.java:966) > > at $Proxy11.create(Unknown Source) > > at > > org.jboss.system.ServiceController.create(ServiceController.java:310) > > at > > org.jboss.system.ServiceController.create(ServiceController.java:243) > > at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source) > > at > > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAc > > cessorImpl.java:25) > > at java.lang.reflect.Method.invoke(Method.java:324) > > at > > org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedM > > BeanDispatcher.java:284) > > at > > org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549) > > at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174) > > at $Proxy20.create(Unknown Source) > > at org.jboss.ejb.EJBDeployer.create(EJBDeployer.java:430) > > at > org.jboss.deployment.MainDeployer.create(MainDeployer.java:779) > > at > org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:638) > > at > org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:612) > > at > org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:596) > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > > at > > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorIm > > pljava:39) > > at > > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAc > > cessorImpl.java:25) > > at java.lang.reflect.Method.invoke(Method.java:324) > > at > > org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedM > > BeanDispatcher.java:284) > > at > > org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549) > > at > > org.jboss.jmx.adaptor.rmi.RMIAdaptorImpl.invoke(RMIAdaptorImpl.java:269) > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > > at > > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorIm > > pl.java:39) > > at > > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAc > > cessorImpl.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(TCPTransp > > ort.java:701) > > at java.lang.Thread.run(Thread.java:536) > > 19:30:12,248 INFO [EntityContainer] Created > > > > xxxxxxxxxxxxxxxxxxxxxxxx > > Scott Stark > > Chief Technology Officer > > JBoss Group, LLC > > xxxxxxxxxxxxxxxxxxxxxxxx > > > > > > ------------------------------------------------------- > > This SF.NET email is sponsored by: > > SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See! > > http://www.vasoftware.com > > _______________________________________________ > > Jboss-development mailing list > > [EMAIL PROTECTED] > > https://lists.sourceforge.net/lists/listinfo/jboss-development > > > > ------------------------------------------------------- > This SF.NET email is sponsored by: > SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See! > http://www.vasoftware.com > _______________________________________________ > Jboss-development mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-development ------------------------------------------------------- This SF.NET email is sponsored by: SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See! http://www.vasoftware.com _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
