• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Paul Clapham
  • Devaka Cooray
  • Tim Cooke
Sheriffs:
  • Rob Spoor
  • Liutauras Vilda
  • paul wheaton
Saloon Keepers:
  • Tim Holloway
  • Tim Moores
  • Mikalai Zaikin
  • Carey Brown
  • Piet Souris
Bartenders:
  • Stephan van Hulst

JDBC & SQLServer

 
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi all,

I'm trying to connect to SQLServer, but I keep getting an exception on the following line:

Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");

I've downloaded and installed the JDBC driver from Microsoft, and set my classpath accordingly. Is there something else I'm missing?

Thanks,

Curtis
 
Ranch Hand
Posts: 1923
Scala Postgres Database Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Which exception? Out of memory?
 
Curtis Nelson
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I'm getting a ClassNotFoundException.

Thanks
 
Ranch Hand
Posts: 243
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Sounds like a classpath issue. Double-check that the JAR is part of the classpath.
 
Greenhorn
Posts: 28
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Originally posted by Curtis Nelson:
Hi all,

I'm trying to connect to SQLServer, but I keep getting an exception on the following line:

Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");

I've downloaded and installed the JDBC driver from Microsoft, and set my classpath accordingly. Is there something else I'm missing?

Thanks,

Curtis




please download JDBC driver from Microsoft.
under copy you-support(JDBC)/lib have msbase.jar mssqlserver.jar msutil.jar
copy three jar in you jdk/jre/lib/ext
that OK
 
Stefan Wagner
Ranch Hand
Posts: 1923
Scala Postgres Database Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
There are different MsSqlServer versions out, which need different jdbc-drivers.
For 7.0 you may use the OpenSource FreeTTS Driver i.e.
 
My first bit of advice is that if you are going to be a mime, you shouldn't talk. Even the tiny ad is nodding:
Gift giving made easy with the permaculture playing cards
https://coderanch.com/t/777758/Gift-giving-easy-permaculture-playing
reply
    Bookmark Topic Watch Topic
  • New Topic