• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
SQL Server Driver and Classpath problem
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

SQL Server Driver and Classpath problem


  • Subject: SQL Server Driver and Classpath problem
  • From: TW <email@hidden>
  • Date: Thu, 4 Sep 2008 23:34:41 -0700

All:

I'm stumped. I have a working model and app that accesses a remote db server running SQL Server 2000. This service is being upgraded to SQLServer 2005 so I have test server to, um, test against.

The drivers for the old server are embedded in my model and plist containing the data for the connection dictionary is in by the app Resources. This all works great for connecting to the old server.

Testing the new server: I am removing the old drivers from my model and embedding the new SQLServer 2005 driver in the model. To do this I'm dropping the jar into Libraries and then selecting "Add to Build Path." To remove the old one's I'm using "Remove from Build Path" and then deleting them from the project. Then, in my app, I change the url for my connection dictionary to the url to connect to the new server -- jdbc:sqlserver://server.ucla.edu:1433;DatabaseName=db

Running a query against the connection gives me this error:
"JDBC connection failed for driver :'com.microsoft.jdbc.sqlserver.SQLServerDriver'. Driver not found in Java Runtime!"


I've tried putting the driver everywhere including adding it to the app itself and also /Library/Java/Extensions and /Library/WebObjects/ Extensions -- just to be thorough. When I do make changes in Eclipse the .classpath file looks to be appropriately updated and sqljdbc.jar is always in the build path.

I just can't for the life of me figure out why I'm having so much difficulty with this. So, I need help to save my sanity.

Tim
_______________________________________________
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


  • Follow-Ups:
    • Re: SQL Server Driver and Classpath problem
      • From: Peter Vandoros <email@hidden>
  • Prev by Date: Re: History on WO query: Is there a special name for the design pattern describes EO itself?
  • Next by Date: Re: SQL Server Driver and Classpath problem
  • Previous by thread: Re: History on WO query: Is there a special name for the design pattern describes EO itself?
  • Next by thread: Re: SQL Server Driver and Classpath problem
  • Index(es):
    • Date
    • Thread