• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

MySQL Datasource with WSAD 4.0.3

 
Ray H.
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello, I'm trying to setup a MySQL datasource using WSAD. I'm not sure how to go about doing this. Any info would be appreciated.
 
Shanmugam Muthukumarasamy
Ranch Hand
Posts: 83
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Ray,
Goto "Server Perspective" and create one server. Or Open the default "WbeSphere v4.0 Test Environment" server.
Now goto "DataSource" Tab.
Goto "JDBC driver list:"
Add your SQL Driver:
Here you have to define
Name(datasource name)
Implementaion class : Which is Driver specific.
Class path: Here mention your driver .jar file location.
and Next Goto
"Data Source defined in the JDBC driver selected above:"
Name : same one u have mentioned above.
JNDI name : jdbc/[datasource name]
User_id : Your DB user_id
Password : Your DB password
The other settings leave as it is.
Next goto "Resource Properties defined in the data source selected above:"
Click "Add"
Name : serverName
Type : java.lang.String
Value : < Your Server Name >
same way define "portNumber" and "URL"
I hope this will clear to you...
Goodluck,
Shanmugam.
 
Ray H.
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Shanmugam,
I was missing the portNumber argument. Once I added that it worked. Many Thanks!
Ray
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic