I got MySQL working with WSAD 5 in a WebSphere 5 test environment. <\/P>
\n
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<\/A>. <\/P> It’s been working pretty well.<\/P><\/p>\n","protected":false},"excerpt":{"rendered":" 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 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-264","post","type-post","status-publish","format-standard","hentry","category-roller"],"_links":{"self":[{"href":"https:\/\/www.siwko.org\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/264"}],"collection":[{"href":"https:\/\/www.siwko.org\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.siwko.org\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.siwko.org\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.siwko.org\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=264"}],"version-history":[{"count":0,"href":"https:\/\/www.siwko.org\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/264\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.siwko.org\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=264"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.siwko.org\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=264"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.siwko.org\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=264"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n