Adding a JDBC driver in Sun Java System Web Server 7
I'm trying to configure JDBC database connection pooling for a Microsoft SQL Server 2005 Express Edition though the Sun Java System Web Server 7 administration console. I don't want to use the MSSQL JDBC driver that comes bundled with the SJSWS 7. So I've downloaded the lastest MSSQL JDBC driver from the Microsoft website and put in the "lib" subdirectory of the SJSWS installation directory. So when I go to add a new JDBC resource through the administration console, the newly added MSSQL database driver doesn't appear in the "Driver Vendor" drop-down box.
How do I add the downloaded JDBC driver to the server so that it appears in the "Driver Vendor" drop-down under "Create JDBC resource".
# 1
You can't modify the list of vendors that appear in the "Driver Vendor" drop-down box. You could either choose the "Other" list item from the drop-down box and fill in the classname, properties on the next screen or choose "MSSQL - MSSQL driver" and then modify the properties on the next screen.
See the following link for more information on adding JDBC resources.
http://docs.sun.com/app/docs/doc/819-2629/6n4tgd209?a=view
# 2
When I select "Other" from the drop down box, and select "Next", it asks for the Datasource Class Name but doesn't give any option to put the driver class name. Where do I specify the driver class name ?
# 3
Check this documentation from MS on using the JDBC driver with DataSource
http://msdn2.microsoft.com/en-us/library/ms379052.aspx
SJS Web Server 7.0 should work with any driver that has support for javax.sql.DataSource. The great majority of drivers do.
So instead of using the driver name, use the DataSource class name:
com.microsoft.sqlserver.jdbc.SQLServerDataSource
The properties to add should be:
user=username
password=password
servername=sql_server_hostname
portnumber=sql_server_port
databasename=databasename
In general, all the setters required to get the datasource configured can be set as properties.
