I do get a slightly different error:
SEVERE: Parse Fatal Error at line 199 column 69: The entity name must immediatel
y follow the '&' in the entity reference.
org.xml.sax.SAXParseException: The entity name must immediately follow the '&' i
n the entity reference.
at org.apache.xerces.util.ErrorHandlerWrapper.createSAXParseException(Er
rorHandlerWrapper.java:232)
However moving the & and ; around in every possible different spot does not seem to
make a difference......
-----Original Message-----
From: Raible, Matt [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 31, 2003 2:21 PM
To: 'Tomcat Users List'
Subject: RE: MySQL/Tomcat startup problem
Try using an & in place of the ; in your connectionURL:
connectionURL="jdbc:mysql://javadev.logic.bm/steve?user=user&password=pa
ssword"
> -----Original Message-----
> From: Geoff Peters [mailto:[EMAIL PROTECTED]]
> Sent: Friday, January 31, 2003 11:08 AM
> To: [EMAIL PROTECTED]
> Subject: MySQL/Tomcat startup problem
>
>
> Hello again - I have spent most of the day on this and don't
> seem to be getting anywhere, searched the archives here and
> the java.sun.com forums to no avail. Running Tomcat 4.1.18 on
> my dev box Win2K Server, running MySQL 3.23.49 on the same
> network on a Redhat 7.3 install. I am simply trying to make
> a database connection, have 2 tables created with usernames
> and roles, usernames and passwords, and set the mysqladmin
> password to connect through the string. The systems guy sees
> my packets hitting the box, so it doesn't seem to be a
> network / firewall problem.
>
> Here is the realm tag (commented out the memory realm):
>
> <Realm className="org.apache.catalina.realm.JDBCRealm" debug="99"
> driverName="org.gjt.mm.mysql.Driver"
>
> connectionURL="jdbc:mysql://javadev.logic.bm/steve?user=user;p
> assword=password"
>
> userTable="tblUsers" userNameCol="user_name"
> userCredCol="user_pass"
> userRoleTable="tblUser_Role" roleNameCol="role_name" />
>
> Here is the output (no matter what I change the username /
> password to):
>
>
>
> Catalina.start: LifecycleException: Exception opening
> database connection: jav
> a.sql.SQLException: Communication link failure: java.io.IOException
> LifecycleException: Exception opening database connection:
> java.sql.SQLExcepti
> on: Communication link failure: java.io.IOException
> at
> org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:681)
> at
> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1173)
>
> at
> org.apache.catalina.core.StandardEngine.start(StandardEngine.java:347
> )
> at
> org.apache.catalina.core.StandardService.start(StandardService.java:4
> 97)
> at
> org.apache.catalina.core.StandardServer.start(StandardServer.java:218
> 9)
> at
> org.apache.catalina.startup.Catalina.start(Catalina.java:512)
> at
> org.apache.catalina.startup.Catalina.execute(Catalina.java:400)
> at
> org.apache.catalina.startup.Catalina.process(Catalina.java:180)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> at java.lang.reflect.Method.invoke(Unknown Source)
> at
> org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:203)
> ----- Root Cause -----
> java.sql.SQLException: Communication link failure: java.io.IOException
> at com.mysql.jdbc.MysqlIO.init(Unknown Source)
> at com.mysql.jdbc.Connection.connectionInit(Unknown Source)
> at
> com.mysql.jdbc.jdbc2.Connection.connectionInit(Unknown Source)
> at com.mysql.jdbc.Driver.connect(Unknown Source)
> at
> org.apache.catalina.realm.JDBCRealm.open(JDBCRealm.java:616)
> at
> org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:679)
> at
> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1173)
>
> at
> org.apache.catalina.core.StandardEngine.start(StandardEngine.java:347
> )
> at
> org.apache.catalina.core.StandardService.start(StandardService.java:4
> 97)
> at
> org.apache.catalina.core.StandardServer.start(StandardServer.java:218
> 9)
> at
> org.apache.catalina.startup.Catalina.start(Catalina.java:512)
> at
> org.apache.catalina.startup.Catalina.execute(Catalina.java:400)
> at
> org.apache.catalina.startup.Catalina.process(Catalina.java:180)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> at java.lang.reflect.Method.invoke(Unknown Source)
> at
> org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:203)
> Stopping service Tomcat-Standalone
> Catalina.stop: LifecycleException: Coyote connector has not
> been started
> LifecycleException: Coyote connector has not been started
> at
> org.apache.coyote.tomcat4.CoyoteConnector.stop(CoyoteConnector.java:1
> 075)
> at
> org.apache.catalina.core.StandardService.stop(StandardService.java:54
> 6)
> at
> org.apache.catalina.core.StandardServer.stop(StandardServer.java:2224
> )
> at
> org.apache.catalina.startup.Catalina.start(Catalina.java:543)
> at
> org.apache.catalina.startup.Catalina.execute(Catalina.java:400)
> at
> org.apache.catalina.startup.Catalina.process(Catalina.java:180)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> at java.lang.reflect.Method.invoke(Unknown Source)
> at
> org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:203)
>
>
> Communication link failure seems a little vague, anyone point
> me in the right direction?
>
> Thanks!!!
>
> Geoff
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
