Bugs item #568501, was opened at 2002-06-13 08:00
You can respond by visiting:
http://sourceforge.net/tracker/?func=detail&atid=376685&aid=568501&group_id=22866
Category: JBossCMP
Group: v3.0 Rabbit Hole
>Status: Closed
>Resolution: Duplicate
Priority: 5
Submitted By: Darryl Thompson (eusdart)
>Assigned to: Dain Sundstrom (dsundstrom)
>Summary: JBoss does not work with schema.table syntax
Initial Comment:
Hello,
I am running the production version of JBoss 3.0.0
using EJB 2.0 CMP (Local home, etc) on Oracle 8i. I
have 1 table out of 28 that fails to update when an
ejbCreate is issued so I turned on the log4j debug
category and discovered that a jboss class is failing to
find the table because somehow it is corrupting the table
name, I have included relevant stanza from jbosscmp-
jdbc.xml identifying the table name and also the run-
time error message produced by log4j debugger. We
hope to use JBoss 3 in our production environment so
hopefullyl some one can helpme resolve this issue
quickly.
Thanks
<enterprise-beans>
<entity>
<ejb-name>OrderProductUsageplan</ejb-name>
<table-
name>COEADMIN.ORDER_PRODUCT_USAGEPLAN</
table-name>
<data-source-name>dsCOE</data-source-
name>
<datasource>java:/dsCOE</datasource>
<create-table>false</create-table>
<remove-table>false</remove-table>
<read-only>false</read-only>
<cmp-field>
<field-name>orderid</field-name>
<column-name>ORDERID</column-name>
</cmp-field>
<cmp-field>
<field-name>usageplanid</field-name>
<column-name>USAGEPLANID</column-
name>
</cmp-field>
<cmp-field>
<field-name>currentcarrier</field-name>
<column-
name>CURRENTCARRIER</column-name>
</cmp-field>
<cmp-field>
<field-name>accountnumber</field-name>
<column-
name>ACCOUNTNUMBER</column-name>
</cmp-field>
<cmp-field>
<field-name>newcarrier</field-name>
<column-name>NEWCARRIER</column-
name>
</cmp-field>
</entity>
// LOG4J DEBUGGER ***********************
07:44:59,312 DEBUG [OrderIntralataInfo] Executing
SQL: SELECT COUNT(*) FROM
COEADMIN.ORDER_INTRALATA_INFO WHERE
ORDERID=?
07:44:59,328 DEBUG [OrderIntralataInfo] Executing
SQL: INSERT INTO
COEADMIN.ORDER_INTRALATA_INFO (ORDERID,
INTRALATAPROVIDER, ACCOUNTNUMBER,
INTRALATAID) VALUES (?, ?, ?, ?)
07:44:59,390 DEBUG [OrderIntralataInfo] Rows affected
= 1
07:44:59,531 INFO [STDOUT]
Classname:
com.algx.coe.bean.sales.SalesOrderProductUsageValue
Object
Simple Properties: [accountNumber, orderId,
currentCarrier, newCarrier, usagePlanId]
List Properties: []
accountNumber: 44556
orderId: 1372700
currentCarrier: JUNIT Test Carrier
newCarrier: CACTUS Test Carrier
usagePlanId: 9
07:44:59,593 DEBUG [OrderProductUsageplan] Create:
pk=com.algx.coe.ejb.entity.sales.OrderProductUsagepla
nPK@ccac409f
07:44:59,593 DEBUG [OrderProductUsageplan]
Executing SQL: SELECT COUNT(*) FROM
COEADMIN.ORDER_PRODUC_1UOZE1C WHERE
ORDERID=? AND USAGEPLANID=?
07:44:59,671 ERROR [OrderProductUsageplan] Error
checking if entity exists
java.sql.SQLException: ORA-00942: table or view does
not exist
at
oracle.jdbc.dbaccess.DBError.throwSqlException
(DBError.java:168)
at oracle.jdbc.ttc7.TTIoer.processError
(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7
(TTC7Protocol.java:1405)
at
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe
(TTC7Protocol.java:643)
at
oracle.jdbc.driver.OracleStatement.doExecuteQuery
(OracleStatement.java:1674)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeo
ut(OracleStatement.java:1870)
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpd
ate(OraclePreparedStatement.java:363)
at
oracle.jdbc.driver.OraclePreparedStatement.executeQuer
y(OraclePreparedStatement.java:314)
at
org.jboss.resource.adapter.jdbc.local.LocalPreparedStat
ement.executeQuery(LocalPreparedStatement.java:289)
at
org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityComma
nd.entityExists(JDBCCreateEntityCommand.java:154)
at
org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityComma
nd.execute(JDBCCreateEntityCommand.java:127)
at
org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.creat
eEntity(JDBCStoreManager.java:450)
at
org.jboss.ejb.plugins.CMPPersistenceManager.createEn
tity(CMPPersistenceManager.java:253)
at
org.jboss.resource.connectionmanager.CachedConnectio
nInterceptor.createEntity
(CachedConnectionInterceptor.java:270)
at org.jboss.ejb.EntityContainer.createLocalHome
(EntityContainer.java:579)
at java.lang.reflect.Method.invoke(Native Method)
at
org.jboss.ejb.EntityContainer$ContainerInterceptor.invoke
Home(EntityContainer.java:1116)
at
org.jboss.ejb.plugins.AbstractInterceptor.invokeHome
(AbstractInterceptor.java:73)
at
org.jboss.ejb.plugins.EntitySynchronizationInterceptor.inv
okeHome(EntitySynchronizationInterceptor.java:257)
at
org.jboss.resource.connectionmanager.CachedConnectio
nInterceptor.invokeHome
(CachedConnectionInterceptor.java:215)
at
org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHo
me(EntityInstanceInterceptor.java:134)
at
org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome
(EntityLockInterceptor.java:79)
at
org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHo
me(EntityCreationInterceptor.java:44)
at
org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext
(AbstractTxInterceptor.java:98)
at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransacti
ons(TxInterceptorCMT.java:167)
at
org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome
(TxInterceptorCMT.java:52)
at
org.jboss.ejb.plugins.SecurityInterceptor.invokeHome
(SecurityInterceptor.java:104)
at org.jboss.ejb.plugins.LogInterceptor.invokeHome
(LogInterceptor.java:109)
at org.jboss.ejb.EntityContainer.invokeHome
(EntityContainer.java:487)
at
org.jboss.ejb.plugins.local.BaseLocalContainerInvoker.inv
okeHome(BaseLocalContainerInvoker.java:227)
at
org.jboss.ejb.plugins.local.LocalHomeProxy.invoke
(LocalHomeProxy.java:110)
at $Proxy102.create(Unknown Source)
at
com.algx.coe.ejb.entity.sales.SalesorderBean.createOrd
erProductUsage(Unknown Source)
at
com.algx.coe.ejb.entity.sales.SalesorderBean.ejbPostCr
eate(Unknown Source)
at java.lang.reflect.Method.invoke(Native Method)
at
org.jboss.ejb.plugins.CMPPersistenceManager.postCrea
teEntity(CMPPersistenceManager.java:284)
at
org.jboss.resource.connectionmanager.CachedConnectio
nInterceptor.postCreateEntity
(CachedConnectionInterceptor.java:278)
at
org.jboss.ejb.EntityContainer.postCreateLocalHome
(EntityContainer.java:593)
at java.lang.reflect.Method.invoke(Native Method)
at
org.jboss.ejb.EntityContainer$ContainerInterceptor.invoke
(EntityContainer.java:1174)
at
org.jboss.ejb.plugins.cmp.jdbc.JDBCRelationInterceptor.i
nvoke(JDBCRelationInterceptor.java:190)
at
org.jboss.ejb.plugins.EntitySynchronizationInterceptor.inv
oke(EntitySynchronizationInterceptor.java:340)
at
org.jboss.resource.connectionmanager.CachedConnectio
nInterceptor.invoke
(CachedConnectionInterceptor.java:186)
at
org.jboss.ejb.plugins.EntityInstanceInterceptor.invoke
(EntityInstanceInterceptor.java:193)
at
org.jboss.ejb.plugins.EntityLockInterceptor.invoke
(EntityLockInterceptor.java:107)
at
org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHo
me(EntityCreationInterceptor.java:59)
at
org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext
(AbstractTxInterceptor.java:98)
at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransacti
ons(TxInterceptorCMT.java:167)
at
org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome
(TxInterceptorCMT.java:52)
at
org.jboss.ejb.plugins.SecurityInterceptor.invokeHome
(SecurityInterceptor.java:104)
at org.jboss.ejb.plugins.LogInterceptor.invokeHome
(LogInterceptor.java:109)
at org.jboss.ejb.EntityContainer.invokeHome
(EntityContainer.java:487)
at
org.jboss.ejb.plugins.local.BaseLocalContainerInvoker.inv
okeHome(BaseLocalContainerInvoker.java:227)
at
org.jboss.ejb.plugins.local.LocalHomeProxy.invoke
(LocalHomeProxy.java:110)
at $Proxy108.create(Unknown Source)
at
com.algx.coe.ejb.session.sales.SOPersistenceServiceB
ean.addOrder(Unknown Source)
at
com.algx.coe.ejb.session.sales.SOPersistenceServiceB
ean.recordSalesOrder(Unknown Source)
at java.lang.reflect.Method.invoke(Native Method)
at
org.jboss.ejb.StatelessSessionContainer$ContainerInterc
eptor.invoke(StatelessSessionContainer.java:664)
at
org.jboss.resource.connectionmanager.CachedConnectio
nInterceptor.invoke
(CachedConnectionInterceptor.java:186)
at
org.jboss.ejb.plugins.StatelessSessionInstanceIntercept
or.invoke(StatelessSessionInstanceInterceptor.java:77)
at
org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext
(AbstractTxInterceptor.java:96)
at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransacti
ons(TxInterceptorCMT.java:167)
at org.jboss.ejb.plugins.TxInterceptorCMT.invoke
(TxInterceptorCMT.java:61)
at org.jboss.ejb.plugins.SecurityInterceptor.invoke
(SecurityInterceptor.java:129)
----------------------------------------------------------------------
>Comment By: Dain Sundstrom (dsundstrom)
Date: 2002-06-13 16:00
Message:
Logged In: YES
user_id=251431
This is a duplicate of feature request [ 545051 ] Add optional
<schema> tag
----------------------------------------------------------------------
You can respond by visiting:
http://sourceforge.net/tracker/?func=detail&atid=376685&aid=568501&group_id=22866
_______________________________________________________________
Don't miss the 2002 Sprint PCS Application Developer's Conference
August 25-28 in Las Vegas -
http://devcon.sprintpcs.com/adp/index.cfm?source=osdntextlink
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development
