This week's giveaway is in the Spring forum.
We're giving away four copies of REST with Spring (video course) and have Eugen Paraschiv on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes No suitable driver error Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "No suitable driver error" Watch "No suitable driver error" New topic

No suitable driver error

Richard Mendoza
Ranch Hand

Joined: Feb 26, 2003
Posts: 48
I created a simple BMP Entity Bean that connects to MS Sql Server 2000. I use JBoss 3.2.5 as my Application Server. I always get this error,
"No suitable driver". I know that my jboss is not yet configured with ms sql server 2000. Can somebody provide me the steps in configure jboss 3.2.5 with ms sql server 2000?

Your help is very much appreciated. Thanks!

Paul Sturrock

Joined: Apr 14, 2004
Posts: 10336

  • Create a DataSource - this will be a file, something like mssql-ds.xml - and put it in your deploy directory. You should be able to find examples of *-ds.xml files in the examples that ship with JBoss.
  • Find a suitable driver for MSSQL. You could use Microsoft's own, but its not very good. Better is jTDS. Read the driver documentation, which will tell you where to put what.
  • Make sure you SQL server instance is configured correctly - SQL Server and Windows authentication etc. (you can find stuff on MSDN about this if you don't know)

  • And there you go. When you start JBos;s, assuming you have done everything correctly, there should be a DataSource avaliable through JNDI.

    JavaRanch FAQ HowToAskQuestionsOnJavaRanch
    wood burning stoves
    subject: No suitable driver error
    It's not a secret anymore!