Re: Classpath for MSSQLServer JDBC Driver
Re: Classpath for MSSQLServer JDBC Driver
- Subject: Re: Classpath for MSSQLServer JDBC Driver
- From: Jonathan Rochkind <email@hidden>
- Date: Thu, 22 May 2003 15:03:20 -0500
Yes, it has worked for me to just put my JDBC .jar files in that directory.
It was not neccesary to set my environmental CLASSPATH to anything at all.
You shouldn't have to, and probably should not. Instead, put all those JAR
files in that directory... and the WOBootstrap architecture will find them
there and make sure they are included in the CLASSPATH sent to the launched
Java app, even though they are not included in your environmental classpath.
--Jonathan
At 08:40 PM 5/22/2003 +0100, Jonathan Fleming wrote:
I've installed MS SQL Server 2000 and have the JDBC .jar files that need
to be used in classpath, since I am using WO5.2 can I simply copy these
into the C:\Apple\Local\Library\WebObjects\Extensions directory?
The documentation says: Set your system CLASSPATH to include the following
entries,
where install_dir is the path to your SQL Server 2000 Driver for
JDBC installation directory:
install_dir/lib/msbase.jar
install_dir/lib/msutil.jar
install_dir/lib/mssqlserver.jar
I'm using Windows 2000, this is the Windows Example
CLASSPATH=.;c:\Microsoft SQL Server 2000 Driver for
JDBC\lib\msbase.jar;c:\Microsoft SQL Server 2000 Driver for
JDBC\lib\msutil.jar;c:\Microsoft SQL Server 2000 Driver for JDBC
\lib\mssqlserver.jar
Just conforming. Once this is done I should be able to connect using my
EOModel with something like this:
jdbc:microsoft:sqlserver://server_name:1433
For example, to specify a connection URL that includes the user
ID "username" and the password "secret":
Connection conn = DriverManager.getConnection
("jdbc:microsoft:sqlserver://server1:1433","username","secret");
Thanks for any help
Jonathan
_________________________________________________________________
Express yourself with cool emoticons - download MSN Messenger today!
http://www.msn.co.uk/messenger
_______________________________________________
WebObjects-dev mailing list
email@hidden
http://www.omnigroup.com/mailman/listinfo/webobjects-dev
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.