tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Hugh Morgan <hughb...@gmail.com>
Subject Re: Newbie: Deploying .war file, getting it working with MySQL
Date Mon, 08 May 2006 15:40:47 GMT
David Smith wrote:
> Yes, authority in the url is the name of the database being accessed. 
> URL syntax looks something like this:
> 
> jdbc:mysql//[DNS_name|IP][:portNum]/database
> 
> portNum is 3306 if not specified and you can add a ? and connect options
> after the database name as needed.

I have made this change (to the server.xml file), still the same error 
[1].  I guess it is not getting to database, as it says "Cannot create 
JDBC driver of class '' for connect URL 'null'".

I am guessing there is somewere else I need to specify the class name 
and database URL?

[1]
<Context path="/minimal"
                docBase="minimal"
                debug="0"
                 reloadable="false"
                 crossContext="true">

<Resource name="jdbc/smsserver" auth="Container"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/smsserver">
     <parameter><name>username</name><value>root</value></parameter>
     <parameter><name>password</name><value>lock74numb</value></parameter>
 
<parameter><name>driverClassName</name><value>com.mysql.jdbc.Driver</value></parameter>
 
<parameter><name>url</name><value>jdbc:mysql://localhost/smsserver</value></parameter>
</ResourceParams>
</Context>

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message