aspose file tools*
The moose likes Websphere and the fly likes JDBC drivers Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Websphere
Bookmark "JDBC drivers" Watch "JDBC drivers" New topic
Author

JDBC drivers

Jayadev Pulaparty
Ranch Hand

Joined: Mar 25, 2002
Posts: 662
I have SQL 2000 running on my machine. I need JDBC drivers for that to access from my entity EJB. How can i know where the driver classes reside on my machine so as to supply that information to the WSAD workbench for creating the entity beans bottom-up from the db tables.
I downloaded Microsoft SQL Server 2000 Driver for JDBC and gave the WSAD inputs as the following for EJB to RDB mapping -
JDBC driver class - as com.microsoft.jdbc.sqlserver.SQLServerDriver
Class location - C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\mssqlserver.jar
Its says "no suitable driver" when i apply the above settings.
Can anyone please help.
[ October 10, 2003: Message edited by: Jayadev Pulaparty ]
Jayadev Pulaparty
Ranch Hand

Joined: Mar 25, 2002
Posts: 662
I found a very similar thread, but that was for DB2. Mine is SQL2000 server.
http://www.coderanch.com/t/70786/Websphere/WebSphere-Studio-JDBC-Connection
Can anyone please help.
[ October 10, 2003: Message edited by: Jayadev Pulaparty ]
Jayadev Pulaparty
Ranch Hand

Joined: Mar 25, 2002
Posts: 662
Can anyone help me on this one. I'm badly stuck up on this one.
Nikhil Pendharkar
Ranch Hand

Joined: Sep 01, 2003
Posts: 44
Jayadev ,
I think you need to configure a 'Datasource' for SQL server 2000 , so that you can use that for your entity bean's data access purpose .
If you are using Websphere 5.0 and WSAD 5.0 , there is no need to download any JDBC driver for that, the support is built in .

You can create the datasource by following steps :
1) If you are using WSAD , Open your server configuration .
2) Go to the "Data source" page.
3) You should see a section for "Server Settings", under that there is a section for "JDBC provider list" .
You need to add a JDBC provider for MS SQL server 2000, if you don't see one present already in the list .
Step 1) Create JDBC provider for SQL server 2000
Click "Add" button next to the JDBC provider list ,it should pop up a Create JDBC provider page .For Data base type select "MS SQL Server"
for JDBC Driver type select "Microsoft JDBC driver for MS SQLServer 2000" .
Click Next , enter any name for JDBC provider "Sqlserver2000" and click finish .
Step 2) Create SQL server Data source using above JDBC provider :
Select the JDBC provider you have just selected in above step .
Click "Add" button next to the Data source list." Create Data source" pop up should appear .
In the Create a Data Source window, select Version 5.0 data source for the
type of data source and click Next.
Complete the Modify Data Source window :
Enter valid values for Name and JNDI name columns (JNDI name will specify in theEJB deployment descriptor to access the database).
Make sure that Datasource helper class name has value selected as "com.ibm.websphere.rsadapter.ConnectJDBCDataStoreHelper"
Click Check box that Use this data source in container-managed persistence (CMP)is selected. This is required for EJB access to the database.

Click Next.
Step III )
In the Modify Resource Properties window, select the databaseName
property and change the value to your Database Name
Click Finish.
The data source is added to the list and displayed in the server configuration
Save the server configuration and close the editor
You can then use the datasource created in EJB's .
I hope this helps ,
Thanks ,
Nikhil
P.S: I haven't used MS - SQL 2000 with Websphere yet ,above setps are listed based on the my experience on configuring datasources for other databases.
 
Consider Paul's rocket mass heater.
 
subject: JDBC drivers