Hello, I have a problem when I want to access a database via my session bean
I use: - Jboss3.2.3 on Windows XP pro - postgresql 7.4 db on linux mandrake 9.1 - jdk1.4 I have got a MDB that listening on a topic, when it receives a message a session bean is instanciated and this one gets records from a database. But after deploying my beans and start my publisher I have got the following error display in Jboss console: 16:30:07,808 ERROR [STDERR] java.sql.SQLException: Table not found: IS_DBCLEANING in statement [select lastcleandate from is_dbcleaning] My xml files are: AdminDB-ds.xml <local-tx-datasource> <jndi-name>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>select * from is_protocol</new-connection-sql> <check-valid-connection-sql>select * from is_protocol</check-valid-connection-sql> </local-tx-datasource> 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> 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-name> <jndi-name>java:/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=3834097#3834097 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3834097 ------------------------------------------------------- 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
