My guess is that the mysql version you are using does not deal correctly
with case and/or quotes in database identifiers. Try turning the "create
tables" option off in (I think) jaws.xml, at least after you have deployed
your beans once to create the tables.
david jencks
On 2001.09.23 04:59:43 -0400 Imran Bohoran wrote:
>
> HI all
>
> I'm using
> JBoss 2.4.1 with tomcat integration.
> my entity beans are all cmps'.
> The db is mysql 3.23.41nt with the 'mm.mysql-2.0.4-bin.jar'
> driver.
>
> i'm having a problerm in a data retreival. the container throws this
> error.
>
> [JAWS] java.sql.SQLException: General error: Table 'test_table' already
> exists
> [JAWS] at org.gjt.mm.mysql.MysqlIO.sendCommand(MysqlIO.java:497)
> [JAWS] at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(MysqlIO.java:550)
> [JAWS] at org.gjt.mm.mysql.Connection.execSQL(Connection.java:885)
> [JAWS] at
> org.gjt.mm.mysql.PreparedStatement.executeUpdate(PreparedStatement.java:389)
> [JAWS] at
> org.jboss.pool.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementI
> nPool.java:82)
> [JAWS] at
> org.jboss.ejb.plugins.jaws.jdbc.JDBCUpdateCommand.executeStatementAndHandleR
> esult(JDBCUpdateCommand.java:49)
> [JAWS] at
> org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCCommand.java:160
> )
> [JAWS] at
> org.jboss.ejb.plugins.jaws.jdbc.JDBCInitCommand.execute(JDBCInitCommand.java
> :128)
> [JAWS] at
> org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.init(JAWSPersistenceManage
> r.java:103)
> [JAWS] at
> org.jboss.ejb.plugins.CMPPersistenceManager.init(CMPPersistenceManager.java:
> 110)
> [JAWS] at org.jboss.ejb.EntityContainer.init(EntityContainer.java:291)
> [JAWS] at org.jboss.ejb.Application.init(Application.java:202)
> [JAWS] at org.jboss.ejb.ContainerFactory.deploy(ContainerFactory.java:372)
> [JAWS] at org.jboss.ejb.ContainerFactory.deploy(ContainerFactory.java:304)
> [JAWS] at java.lang.reflect.Method.invoke(Native Method)
> [JAWS] at
> com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
> [JAWS] at
> com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
> [JAWS] at
> org.jboss.deployment.J2eeDeployer.startModules(J2eeDeployer.java:494)
> [JAWS] at
> org.jboss.deployment.J2eeDeployer.startApplication(J2eeDeployer.java:468)
> [JAWS] at org.jboss.deployment.J2eeDeployer.deploy(J2eeDeployer.java:208)
> [JAWS] at java.lang.reflect.Method.invoke(Native Method)
> [JAWS] at
> com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
> [JAWS] at
> com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
> [JAWS] at org.jboss.ejb.AutoDeployer.deploy(AutoDeployer.java:379)
> [JAWS] at org.jboss.ejb.AutoDeployer.run(AutoDeployer.java:217)
> [JAWS] at org.jboss.ejb.AutoDeployer.startService(AutoDeployer.java:353)
> [JAWS] at
> org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:107)
> [JAWS] at java.lang.reflect.Method.invoke(Native Method)
> [JAWS] at
> com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
> [JAWS] at
> com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
> [JAWS] at
> org.jboss.configuration.ConfigurationService$ServiceProxy.invoke(Configurati
> onService.java:836)
> [JAWS] at $Proxy0.start(Unknown Source)
> [JAWS] at org.jboss.util.ServiceControl.start(ServiceControl.java:81)
> [JAWS] at java.lang.reflect.Method.invoke(Native Method)
> [JAWS] at
> com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
> [JAWS] at
> com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
> [JAWS] at org.jboss.Main.<init>(Main.java:210)
> [JAWS] at org.jboss.Main$1.run(Main.java:116)
> [JAWS] at java.security.AccessController.doPrivileged(Native
> Method)
> [JAWS] at org.jboss.Main.main(Main.java:112)
> [JAWS] Could not create table TEST_TABLE: General error: Table
> 'test_table
> already exists
>
> appreciate a quick response
>
> TIA
>
> Imran
>
>
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> https://lists.sourceforge.net/lists/listinfo/jboss-user
>
>
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user