Re: JDBCRealm Question

[Alan Halley]

Hi Rick

I'm still getting the same eror. My context in server.xml is as follows

  <Context path="" docBase="D:\forteprojects\tomcat401_base\webapps\diamond"
debug="99">
       <Realm className="org.apache.catalina.realm.JDBCRealm" debug="99"
          driverName="org.gjt.mm.mysql.Driver"
        connectionURL="jdbc:mysql://localhost/diamond"
           connectionName="alan"
          connectionPassword="xxxxxxx"

       userTable="users" userNameCol="user_name" userCredCol="user_pass"
        userRoleTable="user_roles" roleNameCol="role_name"/>


          <Valve
className="org.netbeans.modules.web.monitor.catalina.MonitorValve" />

<InstanceListener>org.netbeans.modules.web.monitor.catalina.DispatchListener
</InstanceListener>
          <Logger className="org.apache.catalina.logger.FileLogger"
prefix="localhost__log." suffix=".txt" timestamp="true" />
        </Context>

Alan
----- Original Message -----
From: "Rick Fincher" <[EMAIL PROTECTED]>
To: "Tomcat Users List" <[EMAIL PROTECTED]>
Sent: Tuesday, October 08, 2002 3:32 PM
Subject: Re: JDBCRealm Question


> Hi Alan,
>
> Try using "connectionName" and  "connectionPassword" rather than passing
> that info in the URL.  Tomcat is probably sticking a user="" and
password=""
> onto the end of your url resulting in:
>
>
jdbc:mysql://localhost:3306/diamond?user=alan;password=xxxxxxx?user="";passw
> ord=""
> which blows up when it tries to get a connection.
>
> The realm tag should look like:
>
>     <Realm className="org.apache.catalina.realm.JDBCRealm" debug="99"
>           driverName="org.gjt.mm.mysql.Driver"
>           connectionURL="jdbc:mysql://localhost:3306/diamond"
>           connectionName="alan"
>           connectionPassword="xxxxxxx"
>           userTable="users"
>           userNameCol="user_name"
>           userCredCol="user_pass"
>           userRoleTable="user_roles"
>           roleNameCol="role_name"/>
>
> Hope that helps,
>
> Rick
>
> ----- Original Message -----
> From: "Alan Halley" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, October 08, 2002 9:55 AM
> Subject: JDBCRealm Question
>
>
>
> Hi
>
> I am getting strange error when I try to use JDCRealm. I running Tomcat 4
> from within Forte.
> The error is
>
> Catalina.start: LifecycleException:  Exception opening database
connection:
> java.sql.SQLException: org.gjt.mm.mysql.Driver
> LifecycleException:  Exception opening database connection:
> java.sql.SQLException: org.gjt.mm.mysql.Driver
>         at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:615)
> I'm sure that my JDBCrealm is configured correctly. Here is the relevant
> section of the server.xml
>
>       <Realm className="org.apache.catalina.realm.JDBCRealm" debug="99"
>           driverName="org.gjt.mm.mysql.Driver"
>
>
connectionURL="jdbc:mysql://localhost:3306/diamond?user=alan;password=xxxxxx
> x;"
>        userTable="users" userNameCol="user_name" userCredCol="user_pass"
>         userRoleTable="user_roles" roleNameCol="role_name"/>
>
> Any help would be gratefully appreciated.
> Alan Halley
>
>
>
> --
> To unsubscribe, e-mail:
<mailto:[EMAIL PROTECTED]>
> For additional commands, e-mail:
<mailto:[EMAIL PROTECTED]>
>


--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>