tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Matt Fury <mattfur...@yahoo.com>
Subject Help: Cannot create resource instance
Date Wed, 23 Oct 2002 15:53:45 GMT
Hello all:

I am having trouble trying to set up mySQL connection
pooling. I am using the example straight from the Wrox
"Professional Apache Tomcat" book, which is excellent
I might add.

Unfortunately I am running into an error:

org.apache.jasper.JasperException: Cannot create
resource instance

I can't quite figure this one out. 
Here is my server.xml code:
 <!-- Database connection pooling -->
         <ResourceParams name="jdbc/HomeLand">
            <parameter>
                <name>driverClassName</name>
                <value>org.gjt.mm.mysql.Driver</value>
            </parameter>
            <parameter>
                <name>url</name>
               
<value>jdbc:mysql://localhost/homeland</value>
            </parameter>
            <parameter>
                <name>username</name>
                <value>username</value>
            </parameter>
            <parameter>
                <name>password</name>
                <value>password</value>
            </parameter>
            <parameter>
                <name>maxActive</name>
                <value>20</value>
            </parameter>
            <parameter>
                <name>maxIdle</name>
                <value>30000</value>
            </parameter>
            <parameter>
                <name>maxWait</name>
                <value>100</value>
            </parameter>
       </ResourceParams>
       <!-- end Database connection pooling -->

and web.xml:
<resource-ref>
        <res-ref-name>jdbc/HomeLand</res-ref-name>
        <res-type>javax.sql.Datasource</res-type>
        <res-auth>Container</res-auth>
</resource-ref>

and jsp db code:
<%
InitialContext initCtx = new InitialContext();
DataSource ds = (DataSource)
initCtx.lookup("java:comp/env/jdbc/HomeLand");
con = ds.getConnection();
%>

Any ideas why this would happen?

=====
------------------------
int myName() {
  cout << "-Matt Fury \n";
  return 0;
}
------------------------

__________________________________________________
Do you Yahoo!?
Y! Web Hosting - Let the expert host your web site
http://webhosting.yahoo.com/

--
To unsubscribe, e-mail:   <mailto:tomcat-user-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:tomcat-user-help@jakarta.apache.org>


Mime
View raw message