GeeCON Prague 2014*
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


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
     
    I agree. Here's the link: http://aspose.com/file-tools
     
    subject: No suitable driver error