Re: Classpath for MSSQLServer JDBC Driver
Re: Classpath for MSSQLServer JDBC Driver
- Subject: Re: Classpath for MSSQLServer JDBC Driver
- From: "Jonathan Fleming" <email@hidden>
- Date: Fri, 23 May 2003 13:25:50 +0100
From: email@hidden
Reply-To: email@hidden
To: email@hidden
Subject: Re: Classpath for MSSQLServer JDBC Driver
Date: Thu, 22 May 2003 23:29:49 CDT
You are using WO 5.2, right?
Yeah, I am using 5.2
Weird. All I can say is it's worked for me.
When I'm back at
work (on Tuesday) I'll confirm that it really is working for me and make
sure I really am
doing exactly what I think I'm doing, but.... I'm not sure why it's not
working for you, sorry.
OK
The "current classpath for your application" you list seems awfully weird
too... It doesn't
seem to include the apple frameworks neccesary for a WO app, like
foundation, appserver,
etc., or the EOF frameworks.
I don't know if it makes a difference, but this errorr message was thrown up
by the EOModeler App when I tried to set the URL
Wait, that error message looks suspicious. You're not using WO 5.2, are
you?
Yes absolutly in fact WO5.2.1
Sorry, the
thing where you could just drop jars in that directory was new in 5.2.
I'm not sure what the
reccomended way to do it with other versions is; it was always confusing
to me too.
On Fri, 23 May 2003 00:28:30 +0100 "Jonathan Fleming" wrote:
> Ummm, Jonathan something hasn't worked...
> I'm getting the error below after using the given URL
> where Silver-Back is the local machine running SQLServer2000 and
> DevBoxSQLServer is the instance name...
>
> jdbc:microsoft:sqlserver://Silver-Back\\DevBoxSQLServer
>
> JDBC connection failed for driver
> :'com.microsoft.jdbc.sqlserver.SQLServerDriver'. Driver not found in
Java
> Runtime! Please verify your CLASSPATH environment variable. The current
> CLASSPATH for your application is :
>
C:\Apple\Library\Frameworks\JDBCEOAdaptor.framework\Resources\Java\.;c:\usr\FrontBas
e\Java\frontbasejdbc.jar;c:\usr\FrontBase\Java\FrontBasePlugIn.jar;/Library/Java;C:/Apple/
Local/Library/Java;C:/Apple/Library/Java;C:/Apple/Library/JDK/lib/classes.zip;C:/Apple/Libr
ary/Frameworks/JavaVM.framework/Classes/awt.jar;C:/Apple/Library/JDK/lib/swingall.jar
>
> I have tried the .jar files in --
> C:\Apple\Local\Library\WebObjects\Extensions
> and also in --
> C:\Apple\Library\Frameworks\JDBCEOAdaptor.framework\Resources\Java\
>
> but nothing... got any idea where or what I'm doing wrong?
>
> Jonathan
>
>
> >From: Jonathan Rochkind <email@hidden>
> >To: "Jonathan Fleming" <email@hidden>,
> >email@hidden, email@hidden
> >Subject: Re: Classpath for MSSQLServer JDBC Driver
> >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
> >
>
> _________________________________________________________________
> Stay in touch with absent friends - get MSN Messenger
> http://www.msn.co.uk/messenger
>
_________________________________________________________________
Stay in touch with absent friends - get MSN Messenger
http://www.msn.co.uk/messenger
_______________________________________________
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.