Re: tomcat 6 database pooling, DataSource returning NULL connection

[Lucas Vickers]

woops, email was sent prematurely

anyway, the full email:

META-INF/context.xml :

  <Resource
     name="jdbc/tabscorp_tabsdb"
     auth="Container"
     type="javax.sql.DataSource"
         maxActive="100" maxIdle="30" maxWait="10000"
         username="mylogin" password="mypass"
     driverClassName="com.mysql.jdbc.Driver"
     logAbandoned="true" removeAbandoned="true"
     removeAbandonedTimeout="60"
         url="jdbc:mysql://localhost:3306/mydb?autoReconnect=true"/>

WEB-INF/web.xml :

    <resource-ref>
      <description>TABS DB Connection</description>
      <res-ref-name>jdbc/tabscorp_tabsdb</res-ref-name>
      <res-type>javax.sql.DataSource</res-type>
      <res-auth>Container</res-auth>
    </resource-ref>


Java Code:

                    InitialContext cxt = new InitialContext();
                    if ( cxt == null ) {
                        throw new Exception("InitialContext is NULL");
                    }

                    DataSource ds = (DataSource) cxt.lookup(
"java:/comp/env/jdbc/tabscorp_tabsdb" );
                    if ( ds == null ) {
                        throw new Exception("Data source not found");
                    }

                    Connection conn = ds.getConnection();
                    if ( conn == null) {
                        throw new Exception("Connection is null");
                    }

                    stmt = connection.createStatement();


I am getting a conn == null , but no other information, so I am having
trouble debugging.
suggestions?

thanks