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 , 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.