MySql And WSAD 5 in A J2EE 1.3 Project
I got MySQL working with WSAD 5 in a WebSphere 5 test environment.
First I added mysql-connector-java-3.0.9-stable.bin.jar to the ws.ext.dirs section of the Paths section of the server config. Then I added a JDBC provider to the Data source section. I used the implementation class name: com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource. I added the mysql-connector-java-3.0.9-stable.bin.jar to the class path here again out of paranoia. It didn’t work with the jar just here until I added the ws.ext.dirs entry. I’ll clean this up later. I had luck with the v4 datasources before, but in this case I wanted to do a WAS5 project and use J2EE 1.3. An exception is thrown when I try to get a V4 DataSource in this case. So, I added a V5 DataSource. The non-obvious thing was to set the helper class name to: com.ibm.websphere.rsadapter.GenericDataStoreHelper. It’s not in the drop down list in my copy of WSAD. After a bit of searching, I found this: http://publib7b.boulder.ibm.com/wasinfo1/en/info/ee/javadoc/ee/com/ibm/websphere/rsadapter/GenericDataStoreHelper.html.
It’s been working pretty well.