The infamous java sql SQLException No suitable driver found

Question

I m trying to add a database-enabled JSP to an existing Tomcat 5 5 application  GeoServer 2 0 0  if that helps    The app itself talks to Postgres just fine  so I know that the database is up  user can access it  all that good stuff  What I m trying to do is a database query in a JSP that I ve added  I ve used the config example in the  Tomcat datasource example pretty much out of the box  The requisite taglibs are in the right place -- no errors occur if I just have the taglib refs  so it s finding those JARs  The postgres jdbc driver  postgresql-8 4 701 jdbc3 jar is in  CATALINA HOME common lib   Here s the top of the JSP    lt    taglib uri  http   java sun com jsp jstl sql  prefix  sql    gt   lt    taglib uri  http   java sun com jsp jstl core  prefix  c    gt    lt sql query var  rs  dataSource  jdbc mmas  gt    select current validstart as ValidTime from runoff forecast valid time  lt  sql query gt    The relevant section from  CATALINA HOME conf server xml  inside the  lt Host gt  which is in turn within  lt Engine gt     lt Context path   gs2  allowLinking  true  gt     lt Resource name  jdbc mmas  type  javax sql Datasource        auth  Container  driverClassName  org postgresql Driver        maxActive  100  maxIdle  30  maxWait  10000        username  mmas  password  very secure yess precious         url  jdbc postgresql  localhost 5432 mmas    gt   lt  Context gt    These lines are the last in the  tag in webapps gs2 WEB-INF web xml    lt resource-ref gt     lt description gt       The database resource for the MMAS PostGIS database    lt  description gt     lt res-ref-name gt       jdbc mmas    lt  res-ref-name gt     lt res-type gt       javax sql DataSource    lt  res-type gt     lt res-auth gt       Container    lt  res-auth gt   lt  resource-ref gt    Finally  the exception      exception     org apache jasper JasperException  Unable to get connection  DataSource invalid   java sql SQLException  No suitable driver          wads of ensuing goo elided

User · Answer

You will get this same error if there is not a Resource definition provided somewhere for your app -- most likely either in the central context xml  or individual context file in conf Catalina localhost  And if using individual context files  beware that Tomcat freely deletes them anytime you remove undeploy the corresponding  war file

User · Answer

I had this exact issue when developing a Spring Boot application in STS  but ultimately deploying the packaged war to WebSphere v 9   Based on previous answers my situation was unique  ojdbc8 jar was in my WEB-INF lib folder with Parent Last class loading set  but always it says it failed to find the suitable driver   My ultimate issue was that I was using the incorrect DataSource class because I was just following along with online tutorials examples  Found the hint thanks to David Dai comment on his own question here  Spring JDBC Could not load JDBC driver class  oracle jdbc driver OracleDriver   Also later found spring guru example with Oracle specific driver  https   springframework guru configuring-spring-boot-for-oracle   Example that throws error using org springframework jdbc datasource DriverManagerDataSource based on generic examples    Config  EnableTransactionManagement public class appDataConfig       Other Bean Defs         Bean     public DataSource dataSource                configure and return the necessary JDBC DataSource         DriverManagerDataSource dataSource   new DriverManagerDataSource  jdbc oracle thin    HOST PORT SID    user    password            dataSource setSchema  MY SCHEMA            return dataSource            And the corrected exapmle using a oracle jdbc pool OracleDataSource    Config  EnableTransactionManagement public class appDataConfig      Other Bean Defs     Bean     public DataSource dataSource                configure and return the necessary JDBC DataSource         OracleDataSource datasource   null          try               datasource   new OracleDataSource              catch  SQLException e                   TODO Auto-generated catch block             e printStackTrace                       datasource setURL  jdbc oracle thin    HOST PORT SID            datasource setUser  user            datasource setPassword  password             return datasource

User · Answer

No matter how old this thread becomes  people would continue to face this issue  My Case  I have the latest  at the time of posting  OpenJDK and maven setup  I had tried all methods given above  with out maven and even solutions on sister posts on StackOverflow  I am not using any IDE or anything else  running from bare CLI to demonstrate only the core logic  Here s what finally worked   Download the driver from the official site   for me it was MySQL https   www mysql com products connector    Use your flavour here  Unzip the given jar file in the same directory as your java project  You would get a directory structure like this  If you look carefully  this exactly relates to what we try to do using Class forName        The file that we want is the com mysql jdbc Driver class    Compile the java program containing the code   javac App java   Now load the director as a module by running  java --module-path com mysql jdbc -cp    App  This would load the  extracted  package manually  and your java program would find the required Driver class    Note that this was done for the mysql driver  other drivers might require minor changes  If your vendor provides a  deb image  you can get the jar from  usr share java your-vendor-file-here jar

User · Answer

I was having the same issue with mysql datasource using spring data that would work outside but gave me this error when deployed on tomcat    The error went away when I added the driver jar mysql-connector-java-8 0 16 jar to the jres lib ext folder  However I did not want to do this in production for fear of interfering with other applications  Explicity defining the driver class solved this issue for me      spring datasource driver-class-name  com mysql cj jdbc Driver

User · Answer

In my case I was working on a Java project with Maven and encountered this error  In your pom xml file make sure you have this dependencies   lt dependencies gt       lt dependency gt         lt groupId gt junit lt  groupId gt         lt artifactId gt junit lt  artifactId gt         lt version gt 4 11 lt  version gt         lt scope gt test lt  scope gt       lt  dependency gt       lt dependency gt         lt groupId gt mysql lt  groupId gt         lt artifactId gt mysql-connector-java lt  artifactId gt         lt version gt 8 0 11 lt  version gt       lt  dependency gt     lt  dependencies gt    and where you create connection have something like this  public Connection createConnection             try               String url    jdbc mysql   localhost 3306 yourDatabaseName               String username    root     your my sql username here             String password    1234     your mysql password here              Class forName  com mysql cj jdbc Driver                return DriverManager getConnection url  username  password             catch  SQLException   ClassNotFoundException e                e printStackTrace                       return null

User · Answer

A very silly mistake which could be possible resulting is adding of space at the start of the JDBC URL connection   What I mean is -  suppose u have bymistake given the jdbc url like  String jdbcUrl   jdbc mysql   localhost 3306 web customer tracker useSSL false amp serverTimeZone UTC      Notice there is a space in the staring of the url  this will make the error   the correct way should be   String jdbcUrl  jdbc mysql   localhost 3306 web customer tracker useSSL false amp serverTimeZone UTC      Notice no space in the staring  you may give space at the end of the url but it is safe not to

User · Answer

Run java with CLASSPATH environmental variable pointing to driver s JAR file  e g   CLASSPATH    drivers mssql-jdbc-6 2 1 jre8 jar  java ConnectURL   Where drivers mssql-jdbc-6 2 1 jre8 jar is the path to driver file  e g  JDBC for for SQL Server    The ConnectURL is the sample app from that driver  samples connections ConnectURL java   compiled via javac ConnectURL java

User · Answer

I was using jruby  in my case I created under config initializers  postgres driver rb   CLASSPATH  lt  lt      rbenv versions jruby-1 7 17 lib ruby gems shared gems jdbc-postgres-9 4 1200 lib postgresql-9 4-1200 jdbc4 jar    or wherever your driver is  and that s it

User · Answer

For me the same error occurred while connecting to postgres while creating a dataframe from table  It was caused  due to the missing dependency    jdbc dependency was not set  I was using maven  for the build  so added the required dependency to the pom file from maven dependency jdbc dependency

User · Answer

url  jdbc postgresql  localhost 5432 mmas    That URL looks wrong  do you need the following   url  jdbc postgresql   localhost 5432 mmas

User · Answer

I ve forgot to add the PostgreSQL JDBC Driver into my project  Mvnrepository    Gradle      http   mvnrepository com artifact postgresql postgresql compile group   postgresql   name   postgresql   version   9 0-801 jdbc4    Maven      lt dependency gt       lt groupId gt postgresql lt  groupId gt       lt artifactId gt postgresql lt  artifactId gt       lt version gt 9 0-801 jdbc4 lt  version gt   lt  dependency gt    You can also download the JAR and import to your project manually

User · Answer

As well as adding the MySQL JDBC connector ensure the context xml  if not unpacked in the Tomcat webapps folder  with your DB connection definitions are included within Tomcats conf directory

User · Answer

I faced the similar issue   My Project in context is Dynamic Web Project Java 8   Tomcat 8  and error is for PostgreSQL Driver exception  No suitable driver found  It got resolved by adding Class forName  org postgresql Driver   before calling getConnection   method  Here is my Sample Code   try               Connection conn   null              Class forName  org postgresql Driver                conn   DriverManager getConnection  jdbc postgresql       host         port      preferQueryMode                         sql auth sql user   sql password             catch  Exception e                System out println  Failed to create JDBC db connection     e toString     e getMessage

User · Answer

I found the followig tip helpful  to eliminate this issue in Tomcat -  be sure to load the driver first doing a Class forName   org postgresql Driver    in your code   This is from the post - https   www postgresql org message-id e13c14ec050510103846db6b0e mail gmail com  The jdbc code worked fine as a standalone program but  in TOMCAT it gave the error - No suitable driver found

User · Answer

The infamous java sql SQLException  No suitable driver found   This exception can have basically two causes   1  JDBC driver is not loaded  You need to ensure that the JDBC driver is placed in server s own  lib folder      Or  when you re actually not using a server-managed connection pool data source  but are manually fiddling around with DriverManager getConnection   in WAR  then you need to place the JDBC driver in WAR s  WEB-INF lib and perform      Class forName  com example jdbc Driver         in your code before the first DriverManager getConnection   call whereby you make sure that you do not swallow ignore any ClassNotFoundException which can be thrown by it and continue the code flow as if nothing exceptional happened  See also Where do I have to place the JDBC driver for Tomcat  39 s connection pool   2  Or  JDBC URL is in wrong syntax  You need to ensure that the JDBC URL is conform the JDBC driver documentation and keep in mind that it s usually case sensitive  When the JDBC URL does not return true for Driver acceptsURL   for any of the loaded drivers  then you will also get exactly this exception   In case of PostgreSQL it is documented here      With JDBC  a database is represented by a URL  Uniform Resource Locator   With PostgreSQL     this takes one of the following forms          jdbc postgresql database   jdbc postgresql   host database   jdbc postgresql   host port database      In case of MySQL it is documented here      The general format for a JDBC URL for connecting to a MySQL server is as follows  with items in square brackets       being optional       jdbc mysql    host1   port1    host2   port2        database          propertyName1 propertyValue1  amp propertyName2 propertyValue2        In case of Oracle it is documented here      There are 2 URL syntax  old syntax which will only work with SID and the new one with Oracle service name       Old syntax jdbc oracle thin   HOST   PORT  SID      New syntax jdbc oracle thin     HOST   PORT  SERVICE     See also    Where do I have to place the JDBC driver for Tomcat  39 s connection pool  How to install JDBC driver in Eclipse web project without facing java lang ClassNotFoundexception How should I connect to JDBC database   datasource in a servlet based application  What is the difference between  quot Class forName   quot  and  quot Class forName   newInstance   quot   Connect Java to a MySQL database

User · Answer

I encountered this issue by putting a XML file into the src main resources wrongly  I deleted it and then all back to normal

User · Answer

It might be worth noting that this can also occur when Windows blocks downloads that it considers to be unsafe  This can be addressed by right-clicking the jar file  such as ojdbc7 jar   and checking the  Unblock  box at the bottom   Windows JAR File Properties Dialog

[postgresql] The infamous java.sql.SQLException: No suitable driver found

Examples related to postgresql

Examples related to tomcat

Examples related to jdbc

Examples related to geoserver