Bugs item #577857, was opened at 2002-07-05 17:29
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=376685&aid=577857&group_id=22866
Category: JBossCMP
Group: v3.0 Rabbit Hole
Status: Open
Resolution: None
Priority: 5
Submitted By: CaoNi Ma (a13519)
Assigned to: Nobody/Anonymous (nobody)
Summary: Can't find table by findByPrimaryKey
Initial Comment:
My problem is same as ukkm.
Everything is ok during the hot deployment. After I
inovate findByPrimaryKey of remote home, I get
FinderException from client console and get the
following from JBoss server console:
-----------------------------------
13:01:33,343 ERROR [JDBCCommand] Exception
caught executing SQL
java.sql.SQLException: General error:
Table 'wp.idpool' doesn't exist
at org.gjt.mm.mysql.MysqlIO.sendCommand
(Unknown Source)
at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect
(Unknown Source)
at org.gjt.mm.mysql.Connection.execSQL
(Unknown Source)
at
org.gjt.mm.mysql.PreparedStatement.executeQuery
(Unknown Source)
at
org.jboss.resource.adapter.jdbc.local.LocalPrepared
Statement.executeQ
uery(LocalPreparedStatement.java:289)
at
org.jboss.ejb.plugins.jaws.jdbc.JDBCQueryCommand.
executeStatementAndH
andleResult(JDBCQueryCommand.java:62)
at
org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcE
xecute(JDBCCommand.j
ava:175)
at
org.jboss.ejb.plugins.jaws.jdbc.JDBCBeanExistsCom
mand.execute(JDBCBea
nExistsCommand.java:58)
at
org.jboss.ejb.plugins.jaws.jdbc.JDBCFindEntityComm
and.execute(JDBCFin
dEntityCommand.java:79)
at
org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.f
indEntity(JAWSPers
istenceManager.java:263)
at
org.jboss.ejb.plugins.CMPPersistenceManager.findEn
tity(CMPPersistence
Manager.java:336)
... ...
-----------------------------------
I do specify the proper table name in jbosscmp-
jdbc.xml, shows following:
-----------------------------------
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE jbosscmp-jdbc SYSTEM "E:\jboss-3.0.0
\docs\dtd\jbosscmp-jdbc_3_0.dtd">
<jbosscmp-jdbc>
<enterprise-beans>
<entity>
<ejb-
name>IdPool</ejb-name>
<create-
table>false</create-table>
<row-
locking>true</row-locking>
<table-
name>idtable</table-name>
<cmp-field>
<field-
name>idName</field-name>
<column-
name>idname</column-name>
</cmp-field>
<cmp-field>
<field-
name>idType</field-name>
<column-
name>idtype</column-name>
</cmp-field>
<cmp-field>
<field-
name>idI</field-name>
<column-
name>idi</column-name>
</cmp-field>
<cmp-field>
<field-
name>idC</field-name>
<column-
name>idc</column-name>
</cmp-field>
</entity>
</enterprise-beans>
</jbosscmp-jdbc>
-----------------------------------
Please help me!
Thanks,
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=376685&aid=577857&group_id=22866
-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Bringing you mounds of caffeinated joy.
http://thinkgeek.com/sf
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development
