PS C:\Program Files\Apache Software Foundation\Tomcat 9.0\bin> java -version java version "1.8.0_381" Java(TM) SE Runtime Environment (build 1.8.0_381-b09) Java HotSpot(TM) 64-Bit Server VM (build 25.381-b09, mixed mode)
but the same error occured :
java.sql.SQLException: No suitable driver found for jdbc:postgresql://localhost:5432/mushroom_database at java.sql.DriverManager.getConnection(DriverManager.java:689) at java.sql.DriverManager.getConnection(DriverManager.java:247) at MushroomAPIs.AddMushrooms.doGet(AddMushrooms.java:30)
why java.sql gives that error ?
for some reason the postgresql jar is not in the classpath.