Does anyone have experience/info on setting up a JDBC Datasource in WSAD for MySQL. I am trying to set up a datasource (with a JNDI name - ie: jdbc/cdcatalog) for a WAS 5.1 test server (just a basic server configuration) running inside WSAD 5.1.1. I am using the MySQL jarfile: mysql-connector-java-3.0.9-stable-bin.jar. I have MySQL running OK on localhost:3306 (default). I am adding information to the Data source tab of the server configuration editor. In addition, I tried to add a resource reference to the web.xml: <resource-ref id="ResourceRef_1083720835000"> <description>MySQL4 connection</description> <res-ref-name>jdbc/cdcatalog</res-ref-name> <res-type>java.lang.Object</res-type> <res-auth>Container</res-auth> <res-sharing-scope>Shareable</res-sharing-scope> </resource-ref> However, when I run a test app that attempts to connect to the database, I get all manner of exceptions related to errors with the lookup and methods not found. A sample of just ONE of the exceptions is: Unable to find constructor for DataStoreHelper: com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource. Perhaps I am using the wrong implementation class name...any help would be appreciated. Thanks
Hi Mark, Welcome to JavaRanch, the absolute best site on the www for Java information. We don't have many rules around here, but we do have one. Please change your display name to a first and last name to comply with the JavaRanch Naming Policy. You can change it here. Thank you for your cooperation.
Any intelligent fool can make things bigger, more complex, and more violent. It takes a touch of genius - and a lot of courage - to move in the opposite direction. - Ernst F. Schumacher
Thanks Robert Eanes for the links just an observation: You can configure the datasource in WSAD Also, you can use the directives from the second article (like implementation, helper class names) to configure the datasource in WSAD without going to administrative console.