On Fri, 29 Sept 2023 at 14:22, Raivo Rebane <raivor...@gmail.com> wrote:
> Thanks, > > there was really JDK 17 in use. > I changed it to Java 1.8 > 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. Dave >