Ingo,
Hmmmmm...
This seems to be the first problem with the changed
look_if_table_already_exists code in the JDBCInitCommand.
The InitCommand askes the driver (DatabaseMetaData) if the table it
wants to create exists or not. The driver says not but obviously it
_does_ exist.
Which driver do you use?
Aaron, if you read that - is the driver Ingo uses a one we have to take
care of?
Fast work around: change the jaws.xml so that you dont create tables on
deploy:
<enterprise-beans>
<entity>
...
<create-table>false</create-table>
...
HTH
\Daniel
Ingo Bruell wrote:
>
> Hi,
>
> the following error happens always, if i deploy my beans and the table
> already exists:
>
> --- snip ---
> [JAWS] java.sql.SQLException: ORA-00955: Es gibt bereits ein Objekt mit
> diesem N
> amen
> [JAWS]
> [JAWS] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
> [JAWS] at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
> [JAWS] at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:542)
> [JAWS] at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1311)
> [JAWS] at
> oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:738
> )
> [JAWS] at
> oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.ja
> va:1313)
> [JAWS] at
> oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.jav
> a:1232)
> [JAWS] at
> oracle.jdbc.driver.OracleStatement.doExecuteWithBatch(OracleStatement
> .java:1353)
> [JAWS] at
> oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.java:176
> 0)
> [JAWS] at
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
> nt.java:1807)
> [JAWS] at
> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePrepar
> edStatement.java:332)
> [JAWS] at
> org.jboss.minerva.jdbc.PreparedStatementInPool.executeUpdate(Prepared
> StatementInPool.java:81)
> [JAWS] at
> org.jboss.ejb.plugins.jaws.jdbc.JDBCUpdateCommand.executeStatementAnd
> HandleResult(JDBCUpdateCommand.java:49)
> [JAWS] at
> org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCCommand.j
> ava:158)
> [JAWS] at
> org.jboss.ejb.plugins.jaws.jdbc.JDBCInitCommand.execute(JDBCInitComma
> nd.java:105)
> [JAWS] at
> org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.init(JAWSPersistenc
> eManager.java:97)
> [JAWS] at
> org.jboss.ejb.plugins.CMPPersistenceManager.init(CMPPersistenceManage
> r.java:103)
> [JAWS] at org.jboss.ejb.EntityContainer.init(EntityContainer.java:198)
> [JAWS] at org.jboss.ejb.Application.init(Application.java:158)
> [JAWS] at org.jboss.ejb.ContainerFactory.deploy(ContainerFactory.java:733)
> [JAWS] at org.jboss.ejb.ContainerFactory.deploy(ContainerFactory.java:272)
> [JAWS] at java.lang.reflect.Method.invoke(Native Method)
> [JAWS] at
> com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:16
> 28)
> [JAWS] at
> com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:15
> 23)
> [JAWS] at
> org.jboss.deployment.J2eeDeployer.startApplication(J2eeDeployer.java:
> 645)
> [JAWS] at org.jboss.deployment.J2eeDeployer.deploy(J2eeDeployer.java:137)
> [JAWS] at java.lang.reflect.Method.invoke(Native Method)
> [JAWS] at
> com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:16
> 28)
> [JAWS] at
> com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:15
> 23)
> [JAWS] at org.jboss.ejb.AutoDeployer.deploy(AutoDeployer.java:332)
> [JAWS] at org.jboss.ejb.AutoDeployer.run(AutoDeployer.java:268)
> [JAWS] at org.jboss.ejb.AutoDeployer.startService(AutoDeployer.java:311)
> [JAWS] at
> org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:92)
>
> [JAWS] at java.lang.reflect.Method.invoke(Native Method)
> [JAWS] at
> com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:16
> 28)
> [JAWS] at
> com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:15
> 23)
> [JAWS] at
> org.jboss.dependencies.DependencyManager.startMBean(DependencyManager
> .java:284)
> [JAWS] at
> org.jboss.dependencies.DependencyManager.loadService(DependencyManage
> r.java:261)
> [JAWS] at
> org.jboss.dependencies.DependencyManager.processService(DependencyMan
> ager.java:243)
> [JAWS] at
> org.jboss.dependencies.DependencyManager.startMBeans(DependencyManage
> r.java:117)
> [JAWS] at org.jboss.Main.<init>(Main.java:162)
> [JAWS] at org.jboss.Main$1.run(Main.java:87)
> [JAWS] at java.security.AccessController.doPrivileged(Native Method)
> [JAWS] at org.jboss.Main.main(Main.java:83)
> [JAWS] Could not create table wbuser: ORA-00955: Es gibt bereits ein Objekt
> mit
> diesem Namen
>
> [OraclePool] Pool OraclePool [0/1/Unlimited] returned object
> org.jboss.minerva.x
> a.XAConnectionImpl@409554 to the pool.
> [Container factory] javax.naming.NameNotFoundException:
> TopicConnectionFactory n
> ot bound
> --- snap ---
>
> And if i restart jboss, the deploy is still confused. If i clear the
> jboss/tmp directory it works ...
>
> CU
>
> ---
> Ingo Bruell
> OBL GmbH ([EMAIL PROTECTED])
> Hude (Oldenburg)
> Germany
