Hi,
I put a hack in the code for the name of the driver to be changed to
com.microsoft.sqlserver.jdbc.SQLServerDriver but I don't know how to go to the connection dictionary and change it.
The hack in the code works, but I'd like to do this the right way.
Please let me know how to change the name of the driver in the connection dictionary.
Thank you,
Mersida
p.s: I had the jar file in /Library/Java/Extensions and then removed it from there because it was not doing anything. I just included it as resource.
--- On Wed, 8/6/08, Chuck Hill <email@hidden> wrote:
From: Chuck Hill <email@hidden>
Subject: Re: Microsoft SQL Helpppp!
To: "Greg Bartnick"
<email@hidden>
Cc: "Mersida Kurti" <email@hidden>, "WebObjects Dev" <email@hidden>
Date: Wednesday, August 6, 2008, 4:31 PM
Also check the connection dictionary, the driver should be
com.microsoft.sqlserver.jdbc.SQLServerDriver
And the URL like
jdbc:sqlserver://host:1433;databaseName=Database
Chuck
On Aug 6, 2008, at 1:29 PM, Greg Bartnick wrote:
> Hi Mersida,
>
> Where did you place the sqljdbc.jar file? I don't see it being
> included in the classpath that was printed out. If you put it in
> /Library/WebObjects/Extensions/ or /Library/Java/Extensions/ it should
> get added to the classpage automatically.
>
> Regards,
> Greg
>
> On Wed, Aug 6, 2008 at 1:14 PM, Mersida Kurti <email@hidden>
> wrote:
>> Hi everyone,
>>
>> Seems like our
sql database that one of our apps connects to has
>> changed
>> from sql 2000 to 2005 (yay!) Well not good news for us, because
>> apparently
>> it won't connect anymore. I added the new jar file in there
>> sqljdbc.jar and
>> changed the url to reflect the change; therefore from
>> jdbc:microsoft:sqlserver I changed it to jdbc:sqlserver. However,
>> I'm still
>> getting an error that says:
>>
>> Could not connect to a database DBname because 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 forDriver not found in Java Runtime! Please verify your
>> CLASSPATH
>> environment variable. The current CLASSPATH for
your application is :
>> /Users/muc154/Projects/V5/SOARData/dist/SOARData.woa/Contents/
>> Resources/Java/soardata.jar:/System/Library/Frameworks/
>> JavaWOExtensions.framework/Resources/Java/JavaWOExtensions.jar:/
>> Library/Frameworks/CipherUtility.framework/Resources/Java/
>> cipherutility.jar:/Library/Frameworks/ISSOFramework.framework/
>> Resources/Java/issoframework.jar:/Library/Frameworks/
>> ISSOFramework.framework/Resources/Java/xmlrpc-1.2-b1.jar:/System/
>> Library/Frameworks/JavaEOAccess.framework/Resources/Java/
>> javaeoaccess.jar:/System/Library/Frameworks/JavaEOControl.framework/
>> Resources/Java/javaeocontrol.jar:/System/Library/Frameworks/
>> JavaFoundation.framework/Resources/Java/javafoundation.jar:/System/
>> Library/Frameworks/JavaJDBCAdaptor.framework/Resources/Java/
>>
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden
|