Your database does not support the disabling of AutoCommit, which probably means it doesn't support transactions.
Your Choices: 1) You might see if you can find a MySQL driver that doesn't throw an exception when you try to disable AutoCommit 2) Change rdbms's 3) Alter the Realm source code and compile without the AutoCommit line 4) Report it as a bug and see what happens. Since the call is compliant with JDBC and your DB obviously isn't, I don't think they will do much. But it can't hurt to ask. - Andrew > -----Original Message----- > From: khozaima shakir [mailto:[EMAIL PROTECTED]] > Sent: Monday, August 12, 2002 6:29 PM > To: [EMAIL PROTECTED] > Subject: RE: JDBC Realm Error --Can"t access database > > > >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: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]>
