Hi Edward
As far as I can see, I can't find the solution in the "advanced" section. I've
scrolled this doc up and down many times now and i haven't been able to come up with a
solution. Are there any particular places in this doc, you would recommend, or was it
just a generel suggestion. In the latter case, I've been there as you can see.
Thank's anyway.
Cheers
Kris Kristensen
-----Oprindelig meddelelse-----
Fra: Edward J Becker <[EMAIL PROTECTED]>
Til: jBoss <[EMAIL PROTECTED]>
Dato: 18. december 2000 23:27
Emne: RE: [jBoss-User] problems with JNDI/Datasource
>Not sure if this well help, but you might want to check (if you havent
>already):
>
>http://www.ejboss.org/manual/adv_config.html
>
>-----Original Message-----
>From: [EMAIL PROTECTED]
>[mailto:[EMAIL PROTECTED]]On Behalf Of Kris Kristensen
>Sent: Monday, December 18, 2000 5:06 PM
>To: [EMAIL PROTECTED]
>Subject: [jBoss-User] problems with JNDI/Datasource
>
>
>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]
>
>
>
>--
>--------------------------------------------------------------
>To subscribe: [EMAIL PROTECTED]
>To unsubscribe: [EMAIL PROTECTED]
>Problems?: [EMAIL PROTECTED]
>
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
List Help?: [EMAIL PROTECTED]
