Re: [JBoss-user] CMP problerm in JAWS

2001-09-23 Thread Rosalie Lepretre 

Hi,

I got the same error message copying data from SQL Server 7.0 to MySQL.
I have a shareware copying data.
The Program could not delete the already present table in MySQL and the same 
message as you did, was sent.
I expected a bad status of MYSQL and after a restart of the computer hosting 
MySQL the copy was processed ok.

I hope it helps.

Franck

_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp


___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Re: [JBoss-user] CMP problerm in JAWS

2001-09-23 Thread David Jencks 

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.(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

[JBoss-user] CMP problerm in JAWS

2001-09-23 Thread Imran Bohoran 


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.(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