no change - same situation.
Mike Sabroff <[EMAIL PROTECTED]> wrote: When I do this from a program or bean
or servlet, i make the connection
a true url:
url="jdbc:mysql://localhost:3306/everycitizen?username=everyuser&password=%%%%%"
I dont know if it is different in the server.xml as I have never tried this,
but why should it be?
I have been fooled by thinking logically b4 and I know that things are
different in different setups, but it's worth a try, huh?
Mike
David McMinn wrote:
> I'm running Tomcat 5.5 and trying to do a very simple jdbc connection a
> single table. I have set up tomcat to run on port 8070 and the mysql database
> on the default 3306 port. It's the connection statement in the jsp that is
> blowing up - If I take that out, it works fine.
>
> I'm getting page not found or
> ...."Cannot create JDBC driver of class '' for connect URL 'null' ".
>
>
>
>> Steps I have done
>>
>> 1) Created a DB called everycitizen and a table called test with a
>> column called pk. Created user everyuser w/ a password and granted Select
>> privileges to that user.
>> 2) Copied the mysql-connector-java-3.1.12-bin.jar into
>> $CATALINA_HOME/common/lib.
>> 3)Added the following to the $CATALINA_HOME/conf/server.xml
>>
>
>
>>> javax.sql.Datasource" name="jdbc/WroxTC5"
>>>
>> driverClassName="com.mysql.jdbc.Driver"
>> url="jdbc:mysql://localhost:3306/everycitizen" username="everyuser"
>> password="%%%%%" maxActive="20" maxIdle="30000"
>> maxWait="100"/>
>>
>> 4) Added the following to the
>> $CATALINA_HOME/webapps/jsp-examples/WEB-INF web.xml file at the bottom
>> just before the entry after the last env-entry.
>>
>>
>> jdbc/WroxTC5
>> javax.sql.DataSource
>> Container
>>
>>
>> 5) Added the JDBCTest.jsp file and the errorpg.jsp file to
>> $CATALINA_HOME/webapps/jsp-examples/wroxjdbc directory. I created the
>> wroxjdbc folder. The JDBC Test is:
>>
>>
>>
>>
>>> import="java.sql.*,
>>>
>> javax.sql.*,
>> java.io.*,
>> javax.naming.InitialContext,
>> javax.naming.Context" %>
>>
>> JDBC JNDI Resource Test
>>
>>> InitialContext initCtx = new InitialContext();
>>>
>> DataSource ds =
>> (DataSource)initCtx.lookup("java:comp/env/jdbc/WroxTC5");
>> Connection conn = ds.getConnection();
>> Statement stmt = conn.createStatement();
>> ResultSet rset = stmt.executeQuery("select * from test;");
>> %>
>>
>>
>> XXXX
>>
>>
>>> while (rset.next())
>>>
>> {
>> %>
>>
>>
>>> rset.close();
>>>
>> stmt.close();
>> conn.close();
>> initCtx.close();
>> %>
>>
>
>
--
Mike Sabroff
Web Services
Developer
[EMAIL PROTECTED]
920-568-8379
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
