Re: Subject: RE: Classpath for MSSQLServer JDBC Driver[SOLVED]
Re: Subject: RE: Classpath for MSSQLServer JDBC Driver[SOLVED]
- Subject: Re: Subject: RE: Classpath for MSSQLServer JDBC Driver[SOLVED]
- From: "Jonathan Fleming" <email@hidden>
- Date: Sat, 24 May 2003 02:16:52 +0100
From: Brian McDerment <email@hidden>
To: Jonathan Fleming <email@hidden>
Subject: Re: Subject: RE: Classpath for MSSQLServer JDBC Driver
Date: Fri, 23 May 2003 16:59:11 -0400
I know well your woes. I just started working with MS SQL 2000 this week. I
was working with a pure java swing database benchmarking application I am
writing and forgot to factor in WebObjects development tools.
I just tried it with EO Modeler and here is how I got it to work.
1. copied all MS .jar files into standard JRE ext folder
2. put path to all jar files in Classpath environment variable
3. changed WEBOBJECTS_JAVA_EXTENSIONS environment variable to point to this
folder.
That was all it took, didn't have to change anything else.
Hope this helps,
Yes Brian it helped a lot... you prompted a thought that WebObjects does not
like spaces in paths that its applications uses, so I changedthe the
directory and classpath I was using to:
c:\MSSQLServer2000JDBCDriver\lib\msbase.jar;c:\MSSQLServer2000JDBCDriver\lib\msutil.jar;c:\MSSQLServer2000JDBCDriver\lib\mssqlserver.jar
instaed of what i had before and now it works beautifully.
Thank you very much for your help and everyone else who took time out on
this one
Thanks guys
Jonathan :^)
smiling again
> From: "Jonathan Fleming" <email@hidden>
> Date: Fri, 23 May 2003 21:23:21 +0100
> To: email@hidden
> Cc: email@hidden, email@hidden
> Subject: Re: Subject: RE: Classpath for MSSQLServer JDBC Driver
>
>
>
>
>> From: Brian McDerment <email@hidden>
>> To: <email@hidden>
>> Subject: Subject: RE: Classpath for MSSQLServer JDBC Driver Date: Fri,
23
>> May 2003 15:15:04 -0400
>>
>>
>> Have you tried just throwing the .jar files into the folder
>> C:\Program Files\JavaSoft\JRE\1.3.1_02\lib\ext
>
> Yep, done this and still no joy.
> So, now I've copied the .jar files into all these areas as well:
>
> C:\jdk1.3.1_01\jre\lib\ext
> C:\Apple\Local\Library\WebObjects\Extensions
> This is the original location of the files C:\Program Files\Microsoft
SQL
> Server 2000 Driver for JDBC\lib
>
> and still get this error form EOModeller even though the classpath
> Environment variable on the system has been populated with this:
>
> 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
>
> EOModeller URL:
>
jdbc:microsoft:sqlserver://10.0.0.1:1433;DatabaseName=JandM;SelectMethod=curso>
r
>
> EOModeller Error Message:
> 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:\Micros
> oft
> 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;c:\usr\FrontBase\Java\frontbasejdbc.jar;c:\usr\FrontB
>
ase\Java\FrontBasePlugIn.jar;/Library/Java;C:/Apple/Local/Library/Java;C:/Appl
>
e/Library/Java;C:/Apple/Library/JDK/lib/classes.zip;C:/Apple/Library/Framework
> s/JavaVM.framework/Classes/awt.jar;C:/Apple/Library/JDK/lib/swingall.jar
>
> further more I have used the command line tool to run this script that
Pete
> Fournier posted:
> Javap com.microsoft.jdbc.sqlserver.SQLServerDriver
>
> I was told it would It should respond with the class definition, if not,
I
> have files in the
> wrong place. This was the returned message. What does it mean exactly?:
>
> C:\Documents and Settings\Jonathan>Javap
> com.microsoft.jdbc.sqlserver.SQLServerD
> river
> No sourcepublic class com.microsoft.jdbc.sqlserver.SQLServerDriver
extends
> com.microsoft.jdbc.base.BaseDriver {
> static {};
> public com.microsoft.jdbc.sqlserver.SQLServerDriver();
> public static void main(java.lang.String[]);
> }
>
> What on earth have I got left to do now.... COMPUTERS ah.
>
> Jonathan :^]
>
>
>>
>> Cheers,
>> Brian
>>
>> =================================
>> Brian McDerment
>> email@hidden
>> Asst. Circulation Product Manager
>> Harris & Baseview
>> http://www.baseview.com
>> http://www.jazbox.com
>>
>>
>
> _________________________________________________________________
> Get Hotmail on your mobile phone http://www.msn.co.uk/msnmobile
>
_________________________________________________________________
Sign-up for a FREE BT Broadband connection today!
http://www.msn.co.uk/specials/btbroadband
_______________________________________________
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.