hi there
I have hazzled through all your examples, both in the manual, and in the mailing list,
but somehow it refuses to work. I have one stateless session bean that is going to
handle all communikation to and from various databases. Just as a test I've setup one
DataSource in the jboss.conf and jboss.jcml files. during startup JBoss logs the
following:
XA Connection pool jdbc/newsDB bound to java:/jdbc/newsDB
In my ejb-jar.xml:
<?xml version="1.0" encoding="Cp1252"?>
<ejb-jar>
<enterprise-beans>
<session>
<ejb-name>DogNewsBean</ejb-name>
<home>dk.redballtech.dogs.beans.ejb.sessionbeans.DogNewsHome</home>
<remote>dk.redballtech.dogs.beans.ejb.sessionbeans.DogNews</remote>
<ejb-class>dk.redballtech.dogs.beans.ejb.sessionbeans.DogNewsBean</ejb-class>
<session-type>Stateless</session-type>
<transaction-type>Container</transaction-type>
<resource-ref>
<description>A link to newsDB</description>
<res-ref-name>jdbc/newsDB</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
</session>
</enterprise-beans>
<assembly-descriptor>
<container-transaction>
<method>
<ejb-name>DogNewsBean</ejb-name>
<method-name>*</method-name>
</method>
<trans-attribute>Required</trans-attribute>
</container-transaction>
</assembly-descriptor>
</ejb-jar>
In my jboss.xml:
<?xml version="1.0" encoding="Cp1252"?>
<jboss>
<secure>false</secure>
<container-configurations>
<resource-managers>
<resource-manager>
<res-name>NewsForDogs</res-name>
<res-jndi-name>jdbc/newsDB</res-jndi-name>
</resource-manager>
</resource-managers>
</container-configurations>
<enterprise-beans>
<session>
<ejb-name>DogNewsBean</ejb-name>
<jndi-name>DogNews</jndi-name>
<configuration-name></configuration-name>
<resource-ref>
<res-ref-name>jdbc/newsDB</res-ref-name>
<resource-name>NewsForDogs</resource-name>
</resource-ref>
</session>
</enterprise-beans>
</jboss>
In my java code I would call this by the JNDI:
java:comp/env/jdbc/newsDB
But jboss doesn't resolve the right JNDI name. Result from JBoss log:
[Hypersonic] 0:SELECT * FROM newsTB ORDER BY newsID DESC
[Hypersonic] java.sql.SQLException: Table not found: NEWSTB
[Hypersonic] at org.hsql.Trace.getError(Trace.java:124)
[Hypersonic] at org.hsql.Trace.getError(Trace.java:115)
[Hypersonic] at org.hsql.Trace.error(Trace.java:130)
[Hypersonic] at org.hsql.Database.getTable(Database.java:216)
[Hypersonic] at org.hsql.Parser.parseTableFilter(Parser.java:456)
[Hypersonic] at org.hsql.Parser.parseSelect(Parser.java:305)
[Hypersonic] at org.hsql.Parser.processSelect(Parser.java:25)
[Hypersonic] at org.hsql.Database.execute(Database.java:120)
[Hypersonic] at org.hsql.ServerConnection.run(ServerConnection.java:58)
...
what is missing (or incorrect) since JBoss "think's" it's a Hypersonic DS ?
-thanks is advance
Kris Kristensen
Btw: I'm using JBoss-final-2.0 edition
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
