I seem to solve my own problems frequently after posting to this list... I moved the Sybase jar file from $CATALINA_HOME/lib to $CATALINA_HOME/common/lib and it worked. It seems that Cocoon's connection pools can function with the jar in the root lib, but realms can not. Moving the jar to common/lib allows both realms and the connection pool to work.
However now I have a new question. I really want to password protect cocoon URLs. I added a <security-constraint> to webapps/cocoon/web.xml, but this breaks cocoon. Anyone know the correct way to use realms for cocoon? On Fri, 3 Jan 2003, Jeff Sexton wrote: > > Today I wanted to try a Tomcat security setup. I created and populated > tables in a (Sybase) database and edited server.xml per examples in the > Goodwill Apress book. > > I get an exception on startup, Tomcat fails to initialize. I didn't > expect this because I am also running Cocoon with a connection pool, so I > know that it can find the Sybase JDBC jar. I also know that the host, > socket and login are correct. > > I hope someone can give me a tip on the exception. Is the jar not found > until later in the startup process? > > Here is the server.xml entry: > > <Realm className="org.apache.catalina.realm.JDBCRealm" debug="99" > driverName="com.sybase.jdbc2.jdbc.SybDriver" > > connectionURL="jdbc:sybase:Tds:ods6:4100?user=username;password=mypassword" > userTable="users" userNameCol="user_name" > userCredCol="user_pass" > userRoleTable="user_roles" roleNameCol="role_name" /> > > I also added entries to web.xml for my apps, but it doesn't seem to be > getting there? > > Here is the exception from catalina.out: > > Starting service Tomcat-Standalone > Apache Tomcat/4.0.4 > Catalina.start: LifecycleException: Exception opening database > connection: java.sql.SQLException: com.sybase.jdbc2.jdbc.SybDriver > LifecycleException: Exception opening database connection: > java.sql.SQLException: com.sybase.jdbc2.jdbc.SybDriver > 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) > ----- Root Cause ----- > java.sql.SQLException: com.sybase.jdbc2.jdbc.SybDriver > at org.apache.catalina.realm.JDBCRealm.open(JDBCRealm.java:538) > at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:613) > 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) > > > > --------------------------------------------------------------------- > Please check that your question has not already been answered in the > FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html> > > To unsubscribe, e-mail: <[EMAIL PROTECTED]> > For additional commands, e-mail: <[EMAIL PROTECTED]> > --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html> To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>
