>Try removing your username and password info from your connection string
>and using the 'connectionName' and 'connectionPassword'
_____________________________________________________________
Hi, I did that , this time I got following error, sorry this question is
off topic !!!!! but can you suggest a fix for that please?
Thanks
Khozaima.
Error Message:
Starting service Tomcat-Standalone
Apache Tomcat/4.0.4
Catalina.start: LifecycleException: Exception opening database connection:
jav
a.sql.SQLException: Cannot disable AUTO_COMMIT
LifecycleException: Exception opening database connection:
java.sql.SQLExcepti
on: Cannot disable AUTO_COMMIT
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:343
)
at
org.apache.catalina.core.StandardService.start(StandardService.java:3
88)
at
org.apache.catalina.core.StandardServer.start(StandardServer.java:506
)
at org.apache.catalina.startup.Catalina.start(Catalina.java:781)
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)>
>- Andrew
>
> > -----Original Message-----
> > From: khozaima shakir [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, August 12, 2002 10:42 AM
> > To: [EMAIL PROTECTED]
> > Subject: JDBC Realm Error --Can"t access database
> >
> >
> > Hi all, need help, please!
> > I am trying to set up JDBCRealm. I edit server.xml as:-
> > <Realm className="org.apache.catalina.realm.JDBCRealm" debug="99"
> > driverName="org.gjt.mm.mysql.Driver"
> >
> > connectionURL="jdbc:mysql://mysql.wpi.edu/EMSDATA?user=skhuzem
> > a;password=pPqrAb"
> > userTable="USERS" userNameCol="USER_NAME"
> > userCredCol="USER_PASS"
> > userRoleTable="USER_ROLES" roleNameCol="ROLE_NAME"
> > /> When i restart the tomcat after this, i get error message
> > as Starting service Tomcat-Standalone Apache Tomcat/4.0.4
> > Catalina.start: LifecycleException: Exception opening
> > database connection:
> > java.sql.SQLException: Invalid authorization specification:
> > Access denied
> > for user:'skhuzema;[EMAIL PROTECTED]' (Using password: NO)
> > LifecycleException: Exception opening database connection:
> > java.sql.SQLException: Invalid authorization specification:
> > Access denied
> > for user: 'skhuzema;[EMAIL PROTECTED]' (Using password: NO)
> > 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:343)
> > at
> > org.apache.catalina.core.StandardService.start(StandardService
> > .java:388)
> > at
> > org.apache.catalina.core.StandardServer.start(StandardServer.java:506)
> > at
> > org.apache.catalina.startup.Catalina.start(Catalina.java:781)
> > 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)
> >
> > The mysql database server is not on my local host (for
> > tomcat). Does it look
> > like the connection URL is not being parsed correctly? ( I
> > tried changing
> > the connectionURL string in server.xml and those were
> > reflected in the error
> > message and still got error as (Using Password: NO) Without
> > setting up
> > JDBCRealm, I can start the tomcat sucessfully and the servlet
> > also access
> > the database using the same url username and password....
> > can't figure out the fault... please help???!!!!!!!!!!!!
> > What other configs, do I need to do in addition to the one in
> > server.xml,
> > just to get tomcat started?
> > Khozaima
> >
> >
> >
> >
> >
> > _________________________________________________________________
> > Send and receive Hotmail on your mobile device: http://mobile.msn.com
> >
> >
> > --
> > To unsubscribe, e-mail:
> > <mailto:tomcat-user-> [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]>
_________________________________________________________________
MSN Photos is the easiest way to share and print your photos:
http://photos.msn.com/support/worldwide.aspx
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
