wood burning stoves 2.0*
The moose likes Websphere and the fly likes Mysql and WSAD 5.1 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Websphere
Bookmark "Mysql and WSAD 5.1" Watch "Mysql and WSAD 5.1" New topic
Author

Mysql and WSAD 5.1

Lu Battist
Ranch Hand

Joined: Feb 17, 2003
Posts: 104
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

Joined: May 26, 2004
Posts: 97
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

Joined: May 28, 2003
Posts: 22
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


Thanks,<br />Sudhir <br />SCJP1.4
Mohamed Farouk
Ranch Hand

Joined: Jun 08, 2005
Posts: 249
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


SCJP, SCWCD, SCBCD, SCEA 5
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Mysql and WSAD 5.1