2 Replies Latest reply on Aug 6, 2002 11:59 AM by kelvinchui

    Using JDBC in Entity Bean

    kelvinchui

      Hi all,

      I'm using JBoss3 to deploy a BMP Entity Bean, which uses JDBC to get data from an ACCESS DSN. The bean is deployed successfully as seen from the console. But when I use a client to test it, it throws "java.sql.SQLException: No suitable driver" in the line of a method inside the BMP bean:

      connection = DriverManager.getConnection(dbUrl, userName, password);

      I have placed the msaccess-service.xml file in the .../server/default/deploy folder. Is there anything more I need to do to access a DSN using JDBC-ODBC bridge?

      Thanks for help!