Two problems: 1. In ResourceLink, the value for attribute "golbal" should be "jdbc/galleryDB" instead of "galleryDB".
2. The factory classname is wrong if you are using tomcat5's naming-factory-dbcp.jar. You can just remove that line and the default is used. -----Original Message----- From: lee hwaying [mailto:[EMAIL PROTECTED] Sent: Friday, February 24, 2006 3:22 PM To: [email protected] Subject: JNDI Datasource Problem ERROR JDBCExceptionReporter - Cannot create JDBC driver of class '' for connect URL 'null' I still get the above error in Tomcat 5.5.15 after doing the below. Please help web.xml : ... <resource-ref> <res-ref-name>jdbc/galleryDB</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> <res-sharing-scope>Shareable</res-sharing-scope> </resource-ref> ... C:\apache-tomcat-5.5.15\conf\server.xml : ... <!-- Global JNDI resources --> <GlobalNamingResources> <!-- Test entry for demonstration purposes --> <Environment name="simpleValue" type="java.lang.Integer" value="30"/> <!-- Editable user database that can also be used by UserDatabaseRealm to authenticate users --> <Resource name="UserDatabase" auth="Container" type="org.apache.catalina.UserDatabase" description="User database that can be updated and saved" factory="org.apache.catalina.users.MemoryUserDatabaseFactory" pathname="conf/tomcat-users.xml" /> <Resource auth="Container" name="jdbc/galleryDB" type=" javax.sql.DataSource" factory="org.apache.commons.dbcp.BasicDataSourceFactory" driverClassName="org.gjt.mm.mysql.Driver" url="jdbc:mysql://localhost/Gallery?autoReconnect=true" username="GalleryUser" password="hwaying" maxActive="50" maxIdle="10" maxWait="10000" removeAbandoned="true" removeAbandonedTimeout="60" logAbandoned="true"/> </GlobalNamingResources> ... C:\apache-tomcat-5.5.15\conf\Catalina\localhost\root.xml <Context debug="0" displayName="gallery" path="/gallery" docbase="C:\apache- tomcat-5.5.15\webapps\gallery" reloadable="true"> <!-- Link to the user database we will get roles from --> <ResourceLink name="jdbc/galleryDB" global="galleryDB" type="javax.sql.DataSource"/> </Context> Please help many thansk _________________________________________________________________ Find love online with MSN Personals. http://match.msn.com.my/match/mt.cfm?pg=channel --------------------------------------------------------------------- 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]
