• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Mysql and WSAD 5.1

 
Lu Battist
Ranch Hand
Posts: 104
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Has anyone successfully created a MySql DataSource and been able to use it in WSAD 5.1 with JSPs/Servlets with the Integrated Test Sever?
If so, please list the steps. I was able to make a regular jdbc connection through the Data Perpective, but when I try to create a JNDI DataSource on a WAS test server, it never works.
 
Martin Lira
Ranch Hand
Posts: 97
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Lu,
Looks like theres no entry for creating a MySQL Datasource in WSAD 5.1. When you try to "Add JDBC Provider" you dont find any for MySQL. But its surprising that when in Data perspective you can create a JDBC connection for MySQL. Try contacting IBM support.

Thanks,
Martin
 
Sudhir Meduri
Greenhorn
Posts: 22
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Yes you can access I got it working
kind of many steps involved

Im not putting the exact "name=values" since I dont have access right now

Here it is in Short:

JDBC provider select other for the driver,
provide the class path mysql..bin.jar,
for the connection use MysqlConnectionPool....

create Data Source,
provide Jndi..

create Jauthentication
provide the mysql user password

link the Jauth to the data source Component managed auth.

in custom properties
provide
serverName
databaseName
port

Hope this helps,

If you still have problem let me know I will type it in detail
latter this evening.

Thanks
Sudhir
 
Mohamed Farouk
Ranch Hand
Posts: 249
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello Friends
Please can you let us know in detail the exact procedure to add
a MYsql jdbc provider and create a data source in WSAD 5.1.1.
I have a mysql database running in localhost:3036 with a name sdk
I need values to put in each of the required boxes when trying to create
Provider and DS
Please help.

Thanks
Farouk
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic