Re: Right version of jdbc

Hi,
sometimes I am lucky and don't get the old error, but sometime not.

I tried to use PreparedStatement, but I got error -
org.postgresql.util.PSQLException: Can't use query methods that take a
query string on a PreparedStatement.
at
org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:145)
at MushroomAPIs.Clean.deleteAllRecordsFromTable(Clean.java:34)
and java code is -

String deleteQuery = "DELETE FROM " + tableNam

System.out.println(deleteQuery);

PreparedStatement statement = connection.prepareStatement(deleteQuery);

May be it's easy for me to use normal statement ?

Raivo

On Sat, Sep 30, 2023 at 8:27 AM Raivo Rebane <raivore55(at)gmail(dot)com> wrote:

> Sorry. I accidentally usin postgres 16, which was empty
> Many thanks for advise !!!
>
> Raivo
>
> On Sat, Sep 30, 2023 at 8:18 AM Raivo Rebane <raivore55(at)gmail(dot)com> wrote:
>
>> May be I have to copy PostGis draiver also to tomcat/lib ?
>>
>> Raivo
>>
>> On Sat, Sep 30, 2023 at 8:01 AM Raivo Rebane <raivore55(at)gmail(dot)com> wrote:
>>
>>> Hi,
>>> I copied the postgres driver to Tomcat/lib.
>>> PS C:\Program Files\Apache Software Foundation\Tomcat 9.0\lib> dir post*
>>> Directory: C:\Program Files\Apache Software Foundation\Tomcat 9.0\lib
>>> Mode LastWriteTime Length Name
>>> ---- ------------- ------ ----
>>> -a---- 28.09.2023 14:40 1081604 postgresql-42.6.0.jar
>>> but Tomcat remains to give error -
>>> java.sql.SQLException: No suitable driver found for
>>> jdbc:postgresql://localhost:5432/mushroom_database
>>> I am using Postgres 15. May be I have to use more older one ?
>>>
>>>
>>> Raivo
>>>
>>> On Sat, Sep 30, 2023 at 6:32 AM Craig McIlwee <craigm(at)vt(dot)edu> wrote:
>>>
>>>> > for some reason the postgresql jar is not in the classpath.
>>>>
>>>> This is due to the way that Tomcat loads drivers, which is documented
>>>> at [1]. In short, the JDBC driver should be placed in the tomcat/lib
>>>> directory and removed from the application's WEB-INF/lib directory. After
>>>> doing that, I was able to get past the "No suitable driver" exception.
>>>>
>>>> OP, you should read that entire page, and in particular the portion at
>>>> [2]. By registering a "Resource" with Tomcat, you can let it manage a
>>>> connection pool for you (if you aren't already using something like
>>>> PgBouncer or pgpool) and, if registered at the container level, in the
>>>> future you can share that pool across all of your web applications in the
>>>> container.
>>>>
>>>> [1]
>>>> https://tomcat.apache.org/tomcat-9.0-doc/jndi-datasource-examples-howto.html#DriverManager,_the_service_provider_mechanism_and_memory_leaks
>>>> [2]
>>>> https://tomcat.apache.org/tomcat-9.0-doc/jndi-datasource-examples-howto.html#PostgreSQL
>>>>
>>>> Craig
>>>>
>>>>>