Subject Error while checking if table aleady exists;
Author Stephen Thompson

Hello all,

I am having an issue with JBoss and the firebird driver. I am getting the following error whilst deploying some beans. Has anyone encountered this, does anyone have any suggestions. I am using JBoss3.2.0RC3 and jaybird 1.0.0RC2.

 

 

14:32:55,437 INFO [EntityContainer] Starting

14:32:57,531 INFO [ProfileBean] Table 'CASSPROFILE' already exists

14:32:57,609 INFO [PermissionBean] Table 'CASSPERMISSION' already exists

14:32:57,640 ERROR [EntityContainer] Starting failed

org.jboss.deployment.DeploymentException: Error while checking if table aleady exists; - nested throwable: (java.sql.DataTruncatio

n: Data truncation)

at org.jboss.ejb.plugins.cmp.jdbc.SQLUtil.tableExists(SQLUtil.java:731)

at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand.java:143)

at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.execute(JDBCStartCommand.java:114)

at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.startStoreManager(JDBCStoreManager.java:563)

at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:471)

at org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:170)

at org.jboss.ejb.EntityContainer.startService(EntityContainer.java:339)

at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:192)

at sun.reflect.GeneratedMethodAccessor82.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:324)

at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)

at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)

at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:966)

at $Proxy11.start(Unknown Source)

at org.jboss.system.ServiceController.start(ServiceController.java:392)

at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:324)

at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)

at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)

at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)

at $Proxy32.start(Unknown Source)

at org.jboss.ejb.EjbModule.startService(EjbModule.java:370)

at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:192)

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.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)

at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)

at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:966)

at $Proxy11.start(Unknown Source)

at org.jboss.system.ServiceController.start(ServiceController.java:392)

at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:324)

at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)

at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)

at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)

at $Proxy19.start(Unknown Source)

at org.jboss.ejb.EJBDeployer.start(EJBDeployer.java:451)

at org.jboss.deployment.MainDeployer.start(MainDeployer.java:827)

at org.jboss.deployment.MainDeployer.start(MainDeployer.java:819)

at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:639)

at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:612)

at sun.reflect.GeneratedMethodAccessor24.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:324)

at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)

at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)

at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)

at $Proxy7.deploy(Unknown Source)

at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:404)

at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:531)

at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:195)

at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.loop(AbstractDeploymentScanner.java:206)

at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.run(AbstractDeploymentScanner.java:185)

Caused by: java.sql.DataTruncation: Data truncation

at org.firebirdsql.jdbc.FBStringField.setString(FBStringField.java:291)

at org.firebirdsql.jdbc.FBPreparedStatement.setString(FBPreparedStatement.java:205)

at org.firebirdsql.jdbc.FBConnection.doQuery(FBConnection.java:1181)

at org.firebirdsql.jdbc.FBDatabaseMetaData.getTables(FBDatabaseMetaData.java:2342)

at org.jboss.ejb.plugins.cmp.jdbc.SQLUtil.tableExists(SQLUtil.java:726)

... 57 more

14:32:57,843 WARN [ServiceController] Problem starting service jboss.j2ee:jndiName=ejb/cass/security/GroupLocal,service=EJB

org.jboss.deployment.DeploymentException: Error while checking if table aleady exists; - nested throwable: (java.sql.DataTruncatio

n: Data truncation)

at org.jboss.ejb.plugins.cmp.jdbc.SQLUtil.tableExists(SQLUtil.java:731)

at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand.java:143)

at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.execute(JDBCStartCommand.java:114)

at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.startStoreManager(JDBCStoreManager.java:563)

at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:471)

at org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:170)

at org.jboss.ejb.EntityContainer.startService(EntityContainer.java:339)

at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:192)

at sun.reflect.GeneratedMethodAccessor82.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:324)

at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)

at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)

at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:966)

at $Proxy11.start(Unknown Source)

at org.jboss.system.ServiceController.start(ServiceController.java:392)

at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:324)

at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)

at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)

at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)

at $Proxy32.start(Unknown Source)

at org.jboss.ejb.EjbModule.startService(EjbModule.java:370)

at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:192)

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.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)

at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)

at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:966)

at $Proxy11.start(Unknown Source)

at org.jboss.system.ServiceController.start(ServiceController.java:392)

at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:324)

at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)

at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)

at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)

at $Proxy19.start(Unknown Source)

at org.jboss.ejb.EJBDeployer.start(EJBDeployer.java:451)

at org.jboss.deployment.MainDeployer.start(MainDeployer.java:827)

at org.jboss.deployment.MainDeployer.start(MainDeployer.java:819)

at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:639)

at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:612)

at sun.reflect.GeneratedMethodAccessor24.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:324)

at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)

at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)

at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)

at $Proxy7.deploy(Unknown Source)

at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:404)

at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:531)

at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:195)

at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.loop(AbstractDeploymentScanner.java:206)

at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.run(AbstractDeploymentScanner.java:185)

Caused by: java.sql.DataTruncation: Data truncation

at org.firebirdsql.jdbc.FBStringField.setString(FBStringField.java:291)

at org.firebirdsql.jdbc.FBPreparedStatement.setString(FBPreparedStatement.java:205)

at org.firebirdsql.jdbc.FBConnection.doQuery(FBConnection.java:1181)

at org.firebirdsql.jdbc.FBDatabaseMetaData.getTables(FBDatabaseMetaData.java:2342)

at org.jboss.ejb.plugins.cmp.jdbc.SQLUtil.tableExists(SQLUtil.java:726)

... 57 more

 

 

 

Regards,

 

Stephen.



With Yahoo! Mail you can get a bigger mailbox -- choose a size that fits your needs