4 messages in com.mysql.lists.javaRe: mySQL and JDBC| From | Sent On | Attachments |
|---|---|---|
| Richard Thomas | 24 Jan 2001 11:34 | |
| Vinny | 24 Jan 2001 14:23 | |
| Richard Thomas | 24 Jan 2001 14:52 | |
| Vinny | 24 Jan 2001 15:22 |
| Subject: | Re: mySQL and JDBC |
|---|---|
| From: | Vinny (vin...@xaymaca.com) |
| Date: | 01/24/2001 02:23:13 PM |
| List: | com.mysql.lists.java |
are you able to connect to that host using the mysql command-line tool using by the same host , username, password, and database parameters?
Richard Thomas wrote:
HELP!
This is driving me nuts. I am trying to connect to mySQL from an XML file via
XSP.
I finally got the mm driver loaded but I cannot connect to the database. I get
the
following error:
java.lang.RuntimeException: Error opening connection to dburl:
jdbc:mysql://cs2734-4.austin.rr.com:3306/statements
at java.lang.Throwable.<init>(Throwable.java:96)
at java.lang.Exception.<init>(Exception.java:44)
at java.lang.RuntimeException.<init>(RuntimeException.java:49)
at
_opt._tomcat._webapps._cocoon._samples._sql._esql2.populateDocument(_esql2.java:162)
at org.apache.cocoon.processor.xsp.XSPPage.getDocument(XSPPage.java:97)
at org.apache.cocoon.processor.xsp.XSPProcessor.process(XSPProcessor.java:524)
at org.apache.cocoon.Engine.handle(Engine.java:383)
at org.apache.cocoon.Cocoon.service(Cocoon.java:183)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:404)
at org.apache.tomcat.core.Handler.service(Handler.java:286)
at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
at
org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:797)
at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
at
org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnection(Ajp12ConnectionHandler.java:166)
at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:498)
at java.lang.Thread.run(Thread.java:498)
I've tried using //localhost as well. The driver and dburl lines from the xml
file:
<esql:driver>org.gjt.mm.mysql.Driver</esql:driver> <esql:dburl>jdbc:mysql://cs2734-4.austin.rr.com:3306/statements</esql:dburl>
I'm using mySQL version 3.23.30-gamma The mm driver I'm using is 1.2c
Any ideas? Thanks.