Hi!
I'm fighting with a problem, that I didn't had in an older jboss version
(maybe 1 month older); deploying and running worked fine there.
Right now I downloaded the newest binary version, and deploying works fine
:-) , but when I let JAWS CMP access a table, it says "table not found" (see
below) and the stacktrace shows "org.hsql.jdbcConnection.executeHSQL..." So
it's trying to access a HyperSonic table; it should use "oracle.jdbc...."
My question: How can I tell JAWS to use one DataSource for one CMP
EntitityBean, and another DataSource for another CMP EntitityBean?
I tried to play around with the settings in these files but I got always the
same or similar errors:
in jboss.xml:
<entity>
... here comes the definition of CategoryEntity
<resource-ref>
<res-ref-name>OracleDB</res-ref-name>
<resource-name>Oracle</resource-name>
</resource-ref>
</entity>
in ejb-jar.xml:
<resource-ref>
<res-ref-name>OracleDB</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
in jaws.xml:
<datasource>OracleDB</datasource>
<type-mapping>Oracle</type-mapping>
in jboss.conf:
<MLET CODE = "org.jboss.jdbc.DataSourceImpl"
ARCHIVE="jboss.jar,classes12.zip" CODEBASE="../lib/ext/">
<ARG TYPE="java.lang.String" VALUE="jdbc:oracle:thin:@myhost:1521:prod">
<ARG TYPE="java.lang.String" VALUE="OracleDB">
<ARG TYPE="java.lang.String" VALUE="oracle.jdbc.driver.OracleDriver">
<ARG TYPE="java.lang.String" VALUE="user">
<ARG TYPE="java.lang.String" VALUE="password">
</MLET>
And this is the output:
[Container factory] Deployed application: file:/D:/j/jboss/deploy/mywork/
[CategoryEntity] -------------------------------------
[CategoryEntity] -- CategoryEntityBean 0
[CategoryEntity] ---- setEntityContext
[CategoryEntity] ------
org.jboss.ejb.EntityEnterpriseContext$EntityContextImpl@
6d27e4
[CategoryEntity] ---- null
[CategoryEntity] -------------------------------------
[JAWS] java.sql.SQLException: Table not found: CATEGORY in statement [SELECT
id FROM category]
[JAWS] at org.hsql.Trace.getError(Trace.java:124)
[JAWS] at org.hsql.Result.<init>(Result.java:70)
[JAWS] at org.hsql.jdbcConnection.executeHSQL(jdbcConnection.java:638)
[JAWS] at org.hsql.jdbcConnection.execute(jdbcConnection.java:538)
[JAWS] at org.hsql.jdbcStatement.fetchResult(jdbcStatement.java:499)
[JAWS] at org.hsql.jdbcStatement.executeQuery(jdbcStatement.java:37)
[JAWS] at
org.hsql.jdbcPreparedStatement.executeQuery(jdbcPreparedStatement.java:99)
[JAWS] at
org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.findEntities(JAWSPersisten
ceManager.java:532)
[JAWS] at org.jboss.ejb.EntityContainer.find(EntityContainer.java:258)
[JAWS] at java.lang.reflect.Method.invoke(Native Method)
[JAWS] at
org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContaine
r.java:377)
[JAWS] at
org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySync
hronizationInterceptor.java:133)
[JAWS] at
org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.jav
a:64)
[JAWS] at
org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInt
erceptor.java:65)
[JAWS] at
org.jboss.ejb.plugins.TxInterceptor.invokeHome(TxInterceptor.java:71)
[JAWS] at
org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:8
thanks, Heiko Seebach
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
