Getting Error Message from Server

[Gregg Bolinger]

Ok, I am trying to work with Resin and I am using it's Connection Pool to connect to a database from a Servlet.
Below is the relevent information
resin.conf - <Database>

<database>
    <name>jdbc/anykey</name>
    <driver-class>com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource</driver-class>
    <driver-url>jdbc:mysql://10.2.8.152:3306/anykey</driver-url>
    <user>gdboling</user>
    <password>bolinger</password>
    <max-connections>20</max-connections>
    <max-idle-time>30s</max-idle-time>
</database>

Servlet - NewPostServlet

package com.embeddedthought.JBB.Servlets;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.naming.*;
import java.sql.*;
import javax.sql.*;
import java.io.*;
public class NewPostServlet extends HttpServlet
{
    DataSource source;
    public NewPostServlet()
    {
    }
    public void doGet(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException
    {
        try
        {
            Context env = (Context) new InitialContext().lookup("java:comp/env");
            source = (DataSource)env.lookup("jdbc/anykey");
        }
        catch(NamingException e)
        {
        
        }
        
        
        try
        {
            Connection conn = source.getConnection();
            Statement stmt = conn.createStatement();
            ResultSet rs = stmt.executeQuery("SELECT * FROM calldatainput_table");
            PrintWriter out = res.getWriter();
            while(rs.next())
            {
                
                out.println(rs.getString("ID"));
            }
            out.close();
            stmt.close();
            conn.close();
        }
        catch(SQLException e)
        {
            PrintWriter write = res.getWriter();
            write.println(e.getMessage());
            write.close();
        }
    }
}

web.xml

<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE web-app
    PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
    "http://java.sun.com/dtd/web-app_2_3.dtd">
<web-app>
  <display-name>JBB</display-name>
  <description>
     JBB
  </description>
  
  <taglib>
  <taglib-uri>http://java.sun.com/jstl/sql</taglib-uri>
  <taglib-location>/WEB-INF/sql.tld</taglib-location>
  </taglib>
  <taglib>
  <taglib-uri>http://java.sun.com/jstl/c</taglib-uri>
  <taglib-location>/WEB-INF/c.tld</taglib-location>
  </taglib>
  <servlet>
      <servlet-name>connection</servlet-name>
      <servlet-class>com.embeddedthought.JBB.Servlets.NewPostServlet</servlet-class>
  </servlet>
  <servlet-mapping>
      <SERVLET-NAME>connection</SERVLET-NAME>
      <URL-PATTERN>/Connection</URL-PATTERN>
  </servlet-mapping>
  
</web-app>

And when I run this using the following http
http : //localhost : 8081/JBB/Connection (space for smilies)
I get the following error:
General error, message from server: "No Database Selected"
I have used the same Connectin Pool and used JSP - sql syntax to do the exact same thing I am doing in my Servlet and it works just fine. So I am not sure if the problem is my Servlet or my resin.conf file or my web.xml file. It all seems fine to me.
Thanks for any help.
The reason this is in the Resin Forum is because I don't know if it is a Resin problem or not. Move it if it is a Servlet problem.
Thanks.

[Gregg Bolinger]

UPDATE
I have determined that the error message is coming from an SQLException so the Driver is returning that message to me. However, I still don't know why. I specified the database in the resin.conf file.
So again, if this needs to be moved....

[Gregg Bolinger]

UPDATE
If I execute a USE dbname command before the query, it works just fine. But I don't understand why I would have to do this. It doesn't seem like I should if the ConnectionPool has already connected to the database n number of times and the connections are just sitting there.

[Chad McGowan]

Here's how I have my data source configured in Resin:

<resource-ref>
  <res-ref-name>jdbc/test</res-ref-name>
  <res-type>javax.sql.DataSource</res-type>
  <init-param driver-name="com.mysql.jdbc.Driver"/>
  <init-param url="jdbc:mysql://localhost:3306/test"/>
  <init-param user="testuser"/>
  <init-param password="whatever"/>
</resource-ref>

I haven't had any problems with this.

[Matthew Phillips]

The sample resin.conf file has the following configuration.

 <resource-ref>
  <res-ref-name>jdbc/test</res-ref-name>
  <res-type>javax.sql.DataSource</res-type>
  <init-param driver-name="com.caucho.jdbc.mysql.Driver"/>
  <init-param url="jdbc:mysql_caucho://localhost:3306/test"/>
  <init-param user=""/>
  <init-param password=""/>
  <init-param max-connections="20"/>
  <init-param max-idle-time="30"/>
</resource-ref> 

[Gregg Bolinger]

I forgot to mention that I am using the new Resin Beta release. I am going to back off to the current release and see if that makes a difference. In the beta release they have changed their resin.conf a bit. My info reflects these changes.
Thanks for the help.

[Mariusz Olejnik]

Use org.gjt.mm.mysql.Driver instead of com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource