File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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
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
    I agree. Here's the link:
    subject: No suitable driver error
    It's not a secret anymore!