It's not a secret anymore!*
The moose likes JDBC 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 Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "No suitable driver error" Watch "No suitable driver error" New topic
Author

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!


Richard
Paul Sturrock
Bartender

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
     
    It is sorta covered in the JavaRanch Style Guide.
     
    subject: No suitable driver error
     
    Similar Threads
    migration from MS sql 2000 to MS sql 2008
    Strange SQLException
    help in setting sql server 7.0 in jboss 3.2.5
    Any Idea about free Driver for MS SQL SERVER 2000
    The TDS prelogin response is incomplete