No Suitable Driver Found For Jdbc Jtds Sqlserver

 admin
  • I have explored similar questions, but none of them seem to be the same situation. I have a REST application deployed to the JBOSS 7.1.1 server. I am using JPA.
  • Anonymous said. I use h2database,and this problem occured. My database bean defination is but when I replace org.springframework.jdbc.datasource.DriverManagerDataSource with org.apache.commons.dbcp.BasicDataSource, the problem will fix up.
  • 'The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing.
  • Visit the appropriate sqlserver web site (google) and download the JDBC driver jar and put it in your build path if executing in an IDE, or in the same directory as your program jar if executing from the command line.
Ranch Hand
posted 6 years ago
Hi Friends,
I am new to sql. I am using SQL server 5.5 db.
I would like to establish JDBC connection for a helloworld web application.
I have downloaded jar(mysql-connector-java-5.1.22-bin.jar) for jdbc connection.
When I excecute the code,exception is thrown 'java.sql.SQLException: No suitable driver found'
java.sql.SQLException: No suitable driver found for jdbc://localhost:3306/shop
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.user.auth.HelloWorldServlet.doGet(HelloWorldServlet.java:23)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:240)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:164)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:462)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:563)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:403)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:301)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:162)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:140)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:309)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Please suggest me a valid solution.
Regards,
Anand
Bartender
posted 6 years ago
can you post us the connection code as well please.
It looks like your connection URL may be a problem, but that is just a guess.
Sheriff
posted 6 years ago

Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site. JTDS - SQL Server and Sybase JDBC driver Brought to you by: ickzon. Summary Files Reviews Support Donate Code Tickets Bugs; Patches; Feature Requests. JTDS - No Suitable Driver Exception Forum: Open Discussion. Creator: Ashwani handa. I have explored similar questions, but none of them seem to be the same situation. I have a REST application deployed to the JBOSS 7.1.1 server. I am using JPA. Whenever I make a call in the.

Anand Sivathanu wrote:I am new to sql. I am using SQL server 5.5 db.


This is Microsoft's SQL Server? Or did you just use 'SQL server' as a general description and you're actually using some other database? (If so, which one?)

I have downloaded jar(mysql-connector-java-5.1.22-bin.jar) for jdbc connection.

The downloaded file will be saved in the specified place in the self-extracting form (.exe format ). Double-click the downloaded EXE file to decompress it, then installation will start automatically. Memo: If you select [ Run ] ( or [ Open ] ) instead of [ Save ], the file will be automatically installed after it is saved. Click the link, select [ Save ], specify “Save As”, then click [ Save ] to download the file. Canon PIXMA MG5220 Windows Driver – 18.30Mb Canon PIXMA MG5220 Mac Driver & Software Package This file is a printer driver for Canon IJ printers. Canon mg2520 driver windows 10.


That suggests you're using MySQL as your database. That JDBC driver will only work with MySQL, so if you are using some other database, you should start by getting the JDBC driver which goes with it.
Ranch Hand
posted 6 years ago

This is the connection code..
Class.forName('com.mysql.jdbc.Driver');
Connection con = DriverManager.getConnection('jdbc://localhost:3306/shop','root','root');
Database is MySQL server 5.0. previously i tried in MySQL Server 5.5
Getting same error for both the versions
Ranch Hand
posted 6 years ago
In what folder did you placed the 'mysql-connector-java-5.1.22-bin.jar' ?

Thanks & Regards, Sumeet
SCJP 1.4, SCWCD 5, LinkedIn Profile

I have a HP Probook 6560b. Formatted hardrive, fresh install of Windows 7 Professional, SP1. After installation, couldn't make network connection. Pci simple communications controller hp.

Bartender
posted 6 years ago
  • 1
just done a quick search for mysql connection urls and all the examples followed this pattern:

they include jdbc:mysql
infact this looks goos oracle docs
Ranch Hand
posted 6 years ago

No Suitable Driver Found For Jdbc Sqlserver

Wendy Gibbons,
As you said,
Connection con = DriverManager.getConnection('jdbc:mysql://localhost:3306/shop','root','root');(right)
will work.I will try this in my machine and let you know
Connection con = DriverManager.getConnection('jdbc://localhost:3306/shop','root','root'); (wrong)
Sumit Patil,
'mysql-connector-java-5.1.22-bin.jar' placed in WEB-INFlib.
Ranch Hand

Java.sql.sqlexception: No Suitable Driver Found For

posted 6 years ago

No Suitable Driver Found For Jdbc:postgresql

Hi friends,
Now I can able to access the table.
Connection con = DriverManager.getConnection('jdbc:mysql://localhost:3306/shop','root','root');(right code)
Previously it was
Connection con = DriverManager.getConnection('jdbc://localhost:3306/shop','root','root');(wrong code).missing 'mysql' near jdbc caused the problem(As Wendy Gibbons said)
Regards,
Anand