Just a note on the URL after you get the driver working: > connectionURL="jdbc:mysql://localhost/authority?user=test;password=test"
The connection URL should have an amperstand encoded instead of a semicolon before password. It's unique to MySQL's JDBC driver and isn't done with any others that I know of. Here's the correct URL string: jdbc:mysql://localhost/authority?user=test&password=test The & has to be encoded as & per XML spec, but is decoded to & when TC contacts the MySQL database. --David On Monday 03 December 2001 02:08 am, you wrote: > hi! > i am using mysql database > can the reply given by u solve my problem, > i aleady placed mysql.jar under > catalinahome/lib > if u can pass me the server.xml, web.xml and the changes to be made in > httpd.conf for creation of new application i will be very thank ful to u, > before that i want to say what i had done > 1.i lept my myapplication.war under webapps, > 2.i restarted tomcat > 3.then a directory myapplication is creating under webapps > 4.if i want to create the Context in server.xml > then the tomcat not starting, > if i comment the Conttext and restarting it's starting and the error i said > before is occuring, i changed in httpd.conf also as required. > One more case : > if i am uncommenting the Realm for org.gjt.mm.mysql.Driver, > > <Realm className="org.apache.catalina.realm.JDBCRealm" debug="99" > driverName="org.gjt.mm.mysql.Driver" > > connectionURL="jdbc:mysql://localhost/authority?user=test;password=test" > userTable="users" userNameCol="user_name" userCredCol="user_pass" > userRoleTable="user_roles" roleNameCol="role_name" /> > the server is not restarting, > so i think my changes are not proper in server.xml, > so please guide me in this > jagan > > > -----Original Message----- > From: Nikola Milutinovic [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 03, 2001 2:59 PM > To: Tomcat Users List > Subject: Re: tomcat 4.0 > > > i am getting the below error > > can anybody help me > > > > The error starts here: > > > > type Exception report > > > > message Internal Server Error > > > > description The server encountered an internal error (Internal Server > > Error) that prevented it from fulfilling this request. > > > > exception > > > > javax.servlet.ServletException: No suitable driver > > JDBC error indicating that a driver class for your desired JDBC connection > has not been registered. For PostgreSQL the process is relatively simple: > > - add postgres-jdbc.jar to a classpath (in Tomcat, place it under > $CATALINA_HOME/common/lib - load the driver with: "Class.forName( > "org.postgresql.Driver" ) > > I'd expct other dirvers to be similar. > > Nix. > > > -- > To unsubscribe: <mailto:[EMAIL PROTECTED]> > For additional commands: <mailto:[EMAIL PROTECTED]> > Troubles with the list: <mailto:[EMAIL PROTECTED]> -- To unsubscribe: <mailto:[EMAIL PROTECTED]> For additional commands: <mailto:[EMAIL PROTECTED]> Troubles with the list: <mailto:[EMAIL PROTECTED]>
