Hello,
I have implemented a MDB and a sessin bean that get a record from a database after
received a jms message.
But I have got an SQLException Table not found when I start the test, but I can see my
table in the jmx console.
Here are my conf files:
the AdminDB-ds.xml:
<local-tx-datasource>
<jndi-name>jdbc/AdminDB</jndi-name>
<connection-url>jdbc:postgresql://svt-lmk91:5432/AdminDB</connection-url>
<driver-class>org.postgresql.Driver</driver-class>
<user-name>postgres</user-name>
<!-- <new-connection-sql></new-connection-sql> -->
<check-valid-connection-sql>select * from
is_copyprotocol</check-valid-connection-sql>
</local-tx-datasource>
my ejb-jar.xml:
<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE ejb-jar PUBLIC "-//Sun Microsystems, Inc.//DTD Enterprise JavaBeans 2.0//EN"
"http://java.sun.com/dtd/ejb-jar_2_0.dtd";>
<ejb-jar>
Deployment descriptor for the MDBTest
<display-name>XferAgent</display-name>
<enterprise-beans>
<message-driven>
Mdb for messages recieved about the test
<display-name>Message Driven Bean MdbTest</display-name>
<ejb-name>MdbTest2</ejb-name>
<ejb-class>com.iratensolutions.mdbDB.MdbTest2</ejb-class>
<transaction-type>Bean</transaction-type>
<acknowledge-mode>Auto-acknowledge</acknowledge-mode>
<message-driven-destination>
<destination-type>javax.jms.Topic</destination-type>
<subscription-durability>NotDurable</subscription-durability>
</message-driven-destination>
<ejb-local-ref>
<ejb-ref-name>ejb/SessionTestLocalHome</ejb-ref-name>
<ejb-ref-type>Session</ejb-ref-type>
<local-home>com.iratensolutions.mdbDB.SessionTestLocalHome</local-home>
com.iratensolutions.mdbDB.SessionTestLocal
<ejb-link>SessionTestBean</ejb-link>
</ejb-local-ref>
</message-driven>
<ejb-name>SessionTestBean</ejb-name>
<local-home>com.iratensolutions.mdbDB.SessionTestLocalHome</local-home>
com.iratensolutions.mdbDB.SessionTestLocal
<ejb-class>com.iratensolutions.mdbDB.SessionTestBean</ejb-class>
<session-type>Stateless</session-type>
<transaction-type>Bean</transaction-type>
<resource-ref>
<res-ref-name>jdbc/AdminDB</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
</enterprise-beans>
</ejb-jar>
my jboss.xml:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE jboss PUBLIC
"-//JBoss//DTD JBOSS 3.2//EN"
"http://www.jboss.org/j2ee/dtd/jboss_3_2.dtd";>
<enterprise-beans>
<message-driven>
<ejb-name>MdbTest2</ejb-name>
<destination-jndi-name>topic/testTopic</destination-jndi-name>
</message-driven>
<ejb-name>SessionTestBean</ejb-name>
<local-jndi-name>SessionLocalHome</local-jndi-name>
<jndi-name>SessionLocalHome</jndi-name>
<resource-ref>
<res-ref-name>jdbc/AdminDB</res-ref-name>
<resource-name>AdminDB</resource-ref-name>
<jndi-name>java:jdbc/AdminDB</jndi-name>
</resource-ref>
</enterprise-beans>
Thanks for any help.
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3833922#3833922
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3833922
-------------------------------------------------------
This SF.Net email is sponsored by Sleepycat Software
Learn developer strategies Cisco, Motorola, Ericsson & Lucent use to
deliver higher performing products faster, at low TCO.
http://www.sleepycat.com/telcomwpreg.php?From=osdnemail3
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
