• 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:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Mysql and WSAD 5.1

 
Ranch Hand
Posts: 104
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Ranch Hand
Posts: 97
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Greenhorn
Posts: 22
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Ranch Hand
Posts: 249
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
reply
    Bookmark Topic Watch Topic
  • New Topic