problem with '/' in ejb-name
stundzig Apr 15, 2005 7:49 AMHi,
I'm currently migrating our EJB-apps from jboss 2.4.6 to 4.0.1RC2.
We have many entity beans. For better overview we packaged them not only in java packages but also in packages in the ejb-name. So we have e.g. an WorkItemEntityBean with ejb-name 'worklist/WorkItemBean'. In the older jboss all works good, but in the newer version I get an SQLException e.g. on the findByPrimaryKey.
13:31:26,059 DEBUG [worklist/WorkItemEntity#findByPrimaryKey] Executing SQL: SELECT t0_worklist/WorkItemEntity.id FROM WORKITEMENTITY t0_wor klist/WorkItemEntity WHERE t0_worklist/WorkItemEntity.id=? 13:31:26,069 ERROR [worklist/WorkItemEntity#findByPrimaryKey] Find failed java.sql.SQLException: ORA-00933: SQL-Befehl wurde nicht korrekt beendet at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891) at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:830) at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2391) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2672) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:589) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:527) at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:296) at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCommand.execute(JDBCAbstractQueryCommand.java:206)
Database is Oracle9i.
If I change the ejb-name to 'WorkItemEntity' only, then it works as expected.
13:35:04,002 DEBUG [WorkItemEntity#findByPrimaryKey] Executing SQL: SELECT t0_WorkItemEntity.id FROM WORKITEMENTITY t0_WorkItemEntity WHERE t0_WorkItemEntity.id=?
In the jbosscmp-jdbc.xml exists an entry tablename 'WorkItemEntity'. It's unchanged for each of the two alternatives of ejb-name.
What can I do? Is it possible to have '/' in ejb-names?
Regards
Steffen...