🚀 go-pugleaf

Need help getting JNDI MySQL database source setup correctly within JBuilder
2006 to support a JSF application.   I am able to access the database using
a non-JNDI based approach, and, I was also able to get JNDI to work outside
of JBuilder 2006 using the configuration described below.

I am using the following tomcat documentation as a guide:
http://tomcat.apache.org/tomcat-5.5-doc/jndi-resources-howto.html

I have looked through a number of posts and examples, but at this point
(after many non-frutile hours) need someone with experience to help me to
get the configuration correct.

1.  Install JDBC Driver
    *  have 'mysql-connector-java-3.1.11-bin.jar' installed to
/myapp/webmodule/WEB-INF/lib
    * also have JDBC driver installed to
/JBuilder2006/thirdparty/jakarta-tomcat-5.5.9/common/lib (this was done as a
troubleshooting step though; prefer to only install this within the project
directory)

2.  Declare your Resource Requirements
  *  following code included in web.xml within project:
/myapp/webmodule/WEB-INF/web.xml
  <resource-ref>
    <description>MySQL DB Connection</description>
    <res-ref-name>jdbc/mysql</res-ref-name>
    <res-type>javax.sql.DataSource</res-type>
    <res-auth>Container</res-auth>
  </resource-ref>

3.  Code your Application's Use of this Resource
   *  project code from source.java file (note: try/catch blocks not
included)

           DataSource pool = null;
           Connection conn = null;
           PreparedStatement stmt = null;
           ResultSet rs = null;
           String sql = "select * from categories";

            ctx = new InitialContext();
            pool = (DataSource)ctx.lookup("java:comp/env/jdbc/mysql");
           conn = pool.getConnection();
            stmt = conn.prepareStatement(sql);
            rs = stmt.executeQuery();  (NOTE! this is statement that causes
the error)

4. Configure Tomcat's Resource Factory
   * context.xml contents located at:
/JBuilder2006/thirdparty/jakarta-tomcat-5.5.9/conf/context.xml

       <Context  debug="5" reloadable="true" crossContext="true">
       <WatchedResource>WEB-INF/web.xml</WatchedResource>
      <Resource name="jdbc/mysql" auth="Container"
type="javax.sql.DataSource"
           maxActive="10" maxIdle="30" maxWait="10000"
           username="root" password="pat"
           driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/test" />
        </Context>

    note: I also tried to add this same data to a context.xml file located
at /myapp/webmodule/META-INF/context.xml;  however, I could not get this
configuration to work, so I placed the context.xml back under the
jakarta-tomcat-5.5.9/conf folder.


ERRORS RECEIVED:
Receive an exception when try to execute the 'rs.=stmt.executeQuery()'
statement.  Following is initial start of stack trace:

Nov 27, 2005 7:10:29 PM com.sun.faces.lifecycle.InvokeApplicationPhase
execute
SEVERE: #{bn_searchproviders.search}: javax.faces.el.EvaluationException:
java.sql.SQLException
javax.faces.FacesException: #{bn_searchproviders.search}:
javax.faces.el.EvaluationException: java.sql.SQLException
 at
com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImp
l.java:78)

ALSO TRIED:
* Used Enterprise | Enterprise Setup to add mysql.config to point to mysql
jdbc driver (not sure if I needed this, but tried it as a troubleshooting
step.)
* If I do not attempt to do a JNDI lookup, and just load the database driver
directly (using  Class.forName("com.mysql.jdbc.Driver")), everything works
fine (but I don't have the DBCP pooling capability.)
*  Was able to get a similar configuration setup to work outside of the
JBuilder 2006 IDE environment

ANY SUGGESTIONS?
* Do I need anything specified in the server.xml file?

THANKS FOR ANY HELP!