Thanks Troy, that seems to have solved the problem.
However, I now get :
Starting service Tomcat-Standalone
Apache Tomcat/4.0.1
Catalina.start: LifecycleException: Exception opening
database connection: java.sql.SQLException: Server
configuration denies access to data source
LifecycleException: Exception opening database
connection: java.sql.SQLException: Server
configuration denies access to data source
at
org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:615)
at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1108)
at
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:307)
at
org.apache.catalina.core.StandardService.start(StandardService.java:388)
at
org.apache.catalina.core.StandardServer.start(StandardServer.java:505)
at
org.apache.catalina.startup.Catalina.start(Catalina.java:776)
at
org.apache.catalina.startup.Catalina.execute(Catalina.java:681)
at
org.apache.catalina.startup.Catalina.process(Catalina.java:179)
at java.lang.reflect.Method.invoke(Native Method)
at
org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:243)
----- Root Cause -----
java.sql.SQLException: Server configuration denies
access to data source
at org.gjt.mm.mysql.MysqlIO.init(MysqlIO.java:144)
at
org.gjt.mm.mysql.Connection.<init>(Connection.java:230)
at org.gjt.mm.mysql.Driver.connect(Driver.java:126)
at
org.apache.catalina.realm.JDBCRealm.open(JDBCRealm.java:548)
at
org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:613)
at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1108)
at
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:307)
at
org.apache.catalina.core.StandardService.start(StandardService.java:388)
at
org.apache.catalina.core.StandardServer.start(StandardServer.java:505)
at
org.apache.catalina.startup.Catalina.start(Catalina.java:776)
at
org.apache.catalina.startup.Catalina.execute(Catalina.java:681)
at
org.apache.catalina.startup.Catalina.process(Catalina.java:179)
at java.lang.reflect.Method.invoke(Native Method)
at
org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:243)
Is this because of my Tomcat 4.0 configuration, or my
mySQL configuration. I am assuming that my connection
is now working, but not letting me read the database?
Thanks again,
Paul
--- Troy Campano <[EMAIL PROTECTED]>
wrote: > is the catalina.sh file in $TOMCAT_HOME/bin,
there
> is a the $CP variables
> that you need to add on to. For example I used this
> for a Oracle JDBC
> driver:
>
>
> CP=$CP:"$TOMCAT_HOME/lib/classes12.zip"
>
>
>
> hope that helps,
>
>
>
> Troy Campano
>
> -----Original Message-----
> From: Paul Davies [mailto:[EMAIL PROTECTED]]
> Sent: Monday, October 22, 2001 11:20 AM
> To: [EMAIL PROTECTED]
> Subject: Setting CLASSPATH in Linux
>
>
> Hello,
> Could you tell me how to set the CLASSPATH variable
> in
> Linux so that Tomcat 4.0 recognises my
> mm.mysql.jdbc-1.2c driver? I am trying to connect
> tomcat with mySQL, and I have the following in my
> server.xml file :
>
> <Realm
> className="org.apache.catalina.realm.JDBCRealm"
> debug="99"
> driverName="org.gjt.mm.mysql.Driver"
>
>
connectionURL="jdbc:mysql://localhost/authority?user=dba;password=dba"
> userTable="user" userNameCol="User"
> userCredCol="Password"
> userRoleTable="user_roles"
> roleNameCol="role_name" />
>
> Thanks,
> Paul
>
>
____________________________________________________________
> Nokia Game is on again.
> Go to http://uk.yahoo.com/nokiagame/ and join the
> new
> all media adventure before November 3rd.
>
>
===========================================================================
> To unsubscribe: mailto [EMAIL PROTECTED] with
> body: "signoff
> JSP-INTEREST".
> For digest: mailto [EMAIL PROTECTED] with body:
> "set JSP-INTEREST
> DIGEST".
> Some relevant FAQs on JSP/Servlets can be found at:
>
> http://archives.java.sun.com/jsp-interest.html
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.jsp
> http://www.jguru.com/faq/index.jsp
> http://www.jspinsider.com
>
>
===========================================================================
> To unsubscribe: mailto [EMAIL PROTECTED] with
> body: "signoff JSP-INTEREST".
> For digest: mailto [EMAIL PROTECTED] with body:
> "set JSP-INTEREST DIGEST".
> Some relevant FAQs on JSP/Servlets can be found at:
>
> http://archives.java.sun.com/jsp-interest.html
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.jsp
> http://www.jguru.com/faq/index.jsp
> http://www.jspinsider.com
____________________________________________________________
Nokia Game is on again.
Go to http://uk.yahoo.com/nokiagame/ and join the new
all media adventure before November 3rd.
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://archives.java.sun.com/jsp-interest.html
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.jsp
http://www.jguru.com/faq/index.jsp
http://www.jspinsider.com
