![]() The easiest way to create it is go to Data Sources section, click on New and then click on the link create a new J2C authentication alias. J2C is a way to create an authentication for our DataSource. The first screen will come up and then you must click on Save link to commit the information to Websphere. In my case, I copied the file mysql-connector-java-5.1.6-bin.jar to the /lib directory.Ĭlick on Next and on the next screen click on Finish. On next screen, you must inform the ClassPath of the JARs files. On the new screen, select User-Defined in Database type field (because WAS doesn’t have MySQL pre-defined), 2.optional.MysqlConnectionPoolDataSource in Implementation Class Name field and MySQL JDBC Provider in Name field.Īfter that, click on Next button. We are going to create a new one for MySQL. By default, WAS 6.1 brings only Derby JDBC Provider already setup. Setting up a DataSourceīasically, there are 3 steps to create a DataSource on Websphere:įirst of all, you must start the Websphere server and open its admin console: On Admin Console, expand the Resources -> JDBC section.Ĭlick on JDBC Provider link and a list of current JDBC providers will appears for you. Also, this article can be useful if you want to use another database, such as DB2, Oracle and so on. ![]() After you read this article, you will be capable to create a DataSource on Websphere 6.1 using MySQL database.
0 Comments
Leave a Reply. |