- #CONNECTING RATIONAL APPLICATION DEVELOPER TO WEBSPHRE PLUS#
- #CONNECTING RATIONAL APPLICATION DEVELOPER TO WEBSPHRE FREE#
Back to the Data sources section, check the datasource you want and click on Test connection button.
#CONNECTING RATIONAL APPLICATION DEVELOPER TO WEBSPHRE FREE#
(there are also other properties that you are free to change them if you want).Īfter the changes are done, it is time to test the DataSource. On Custom properties, you must change the value to databaseName and serverName. To do that, click on your Data Source and onto the new screen, click on Custom properties link. We need now to setup a couple of parameters. To commit the changes, click on Save link. On the next two screens, just click on Next and then Finish. On the next screen, select the JDBC Provider previously created.
#CONNECTING RATIONAL APPLICATION DEVELOPER TO WEBSPHRE PLUS#
Note: The JNDI name default is jdbc/ plus JNDI name. On the new screen, insert the Data source name, JNDI name and select the J2C. Go to Data Sources section and click on New. On the new screen, click on New button and fill up the fields:Ĭlick on OK and then Save link. 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 kommentar(er)
