Win a copy of Rust Web Development this week in the Other Languages forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Tim Cooke
  • Campbell Ritchie
  • Ron McLeod
  • Liutauras Vilda
  • Jeanne Boyarsky
Sheriffs:
  • Junilu Lacar
  • Rob Spoor
  • Paul Clapham
Saloon Keepers:
  • Tim Holloway
  • Tim Moores
  • Jesse Silverman
  • Stephan van Hulst
  • Carey Brown
Bartenders:
  • Al Hobbs
  • Piet Souris
  • Frits Walraven

MySQL Datasource with WSAD 4.0.3

 
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Ranch Hand
Posts: 83
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Shanmugam,
I was missing the portNumber argument. Once I added that it worked. Many Thanks!
Ray
reply
    Bookmark Topic Watch Topic
  • New Topic