pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Amn Ojee Uw <amnojeeuw@gmail.com>
To: pgsql-general@lists.postgresql.org
Subject: Re: JDBC + PG-15 but not psql
Date: Tue, 22 Aug 2023 13:47:59 -0400
Message-ID: <a1f30b02-574c-0884-45a0-50d3769c6098@gmail.com> (raw)
In-Reply-To: <CADK3HH+aG2Hac-4cMsN6Jpo+T7BkfR6AOt6mp0Brn594QJyFDQ@mail.gmail.com>
References: <d26a0727-3595-c25b-a6e5-4401d672d93b@gmail.com>
	<CADK3HHLVsMqkp7sVD5+U-z2tx72QLPv8KBRhW3XRBgozYymQwg@mail.gmail.com>
	<fd9dd478-36c3-bf64-d501-b1159c4ed877@gmail.com>
	<CADK3HH+aG2Hac-4cMsN6Jpo+T7BkfR6AOt6mp0Brn594QJyFDQ@mail.gmail.com>

Yes your are right! I don't know why it was part of the requirement to 
add a JDBC line to explicitly set the behaviour of autocommint to 
*true*, when it was the default value. Perhaps it has to do with "just 
making sure it is" sort of thing.
Thanks Dave, I'll let the my group know.

On 8/22/23 8:31 a.m., Dave Cramer wrote:
> Hi Amn,
>
> What I don't understand is the requirement to set autocommit to true 
> since this is the default ?
>
> Either way this is expected behaviour as psql also has autocommit true 
> by default.
>
> Thanks,
>
> Dave Cramer
>
>
>
> On Mon, 21 Aug 2023 at 20:57, Amn Ojee Uw <amnojeeuw@gmail.com> wrote:
>
>     Thanks Dave for your interest.
>
>     In  the OP I started by explaining the difficulties when trying to
>     create a tabelspace using JDBC; please note that when using the
>     PG-15 prompt I did not have the problem. Well, it turns out that
>     while developing the request for help (writing the email), I
>     realize that my code had the following line :
>     *this.conn.setAutoCommit(false);*/*
>     */However, in my research, I had read a post mentioning that by
>     setting /auto commit/ to *true* the issue was solved. So, I
>     changed that line of code in my algorithm to :
>     *this.conn.setAutoCommit(true);*/*
>     */Which also resulted in my app working without any errors./**/
>
>     Please read the code-snip I submitted; there you can see that line
>     of code I edited; which I commented with "/*//*//*game changer!!".*/
>
>     Thanks again Dave, have great week.
>
>     /*
>     */
>
>     On 8/21/23 2:51 p.m., Dave Cramer wrote:
>>     Hi Amn,
>>
>>     Can you help me understand this issue better?
>>
>>     I don't see anywhere in the code where you are attempting to
>>     create a tablespace ?
>>
>>
>>     Dave Cramer
>>
>>
>>
>>     On Sun, 20 Aug 2023 at 11:17, Amn Ojee Uw <amnojeeuw@gmail.com>
>>     wrote:
>>
>>         Hello.
>>
>>         I have searched the net in an attempt to find if others have
>>         had and resolved this challenge, but most of the sites talk
>>         about how, when using the psql, this error arises. In my
>>         case, the error arises only when access PG-15 using JDBC.
>>         JDBC connects to the database, but when trying to execute a
>>         schema, it be to create a database or to create a tabelspace
>>         I get this error :
>>
>>         *StackTrace : [Ljava.lang.StackTraceElement;@7a69b07**
>>         **Message : ERROR: CREATE TABLESPACE cannot run inside a
>>         transaction block*
>>
>>         I have used the same algorithm, but now modify to accommodate
>>         PG-15, when using SQLite. So the JDBC code might not be the
>>         problem, but the requirements needed from PG-15.
>>
>>         Change of perspective, I resolved the concern!
>>
>>         Here is what changed the outcome :
>>         --- snip ---
>>
>>         public void connectToDatabase() throws
>>         ClassNotFoundException, SQLException {
>>             try {
>>         Class.forName(this.getDatabaseClass().toString());
>>                 this.conn =
>>         DriverManager.getConnection(this.getDatabaseUrl().toString(),
>>                         this.getUserID().toString(),
>>         this.getUserPassword().toString());
>>
>>         *this.conn.setAutoCommit(true);*/*//*//*game changer!!*/
>>
>>                 this.pout("Connected to the PostgreSQL server,
>>         success!!!");
>>
>>                 this.stmt = this.conn.createStatement();
>>             } catch (final SQLException | ClassNotFoundException e) {
>>                 throw e;
>>             }
>>         }
>>
>>         --
>>
>>         All I had to do was to setAutoCommit to true, PG-15 set this
>>         value to false by default.
>>
>>
>>         I hope my experience can help others.
>>
>>

view thread (5+ messages)

Message-ID: <a1f30b02-574c-0884-45a0-50d3769c6098@gmail.com>
Permalink:  ../a1f30b02-574c-0884-45a0-50d3769c6098@gmail.com/
Also on:    postgresql.org/message-id/a1f30b02-574c-0884-45a0-50d3769c6098@gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-general@postgresql.org
  Cc: amnojeeuw@gmail.com
  Subject: Re: JDBC + PG-15 but not psql
  In-Reply-To: <a1f30b02-574c-0884-45a0-50d3769c6098@gmail.com>
  References: <d26a0727-3595-c25b-a6e5-4401d672d93b@gmail.com> <CADK3HHLVsMqkp7sVD5+U-z2tx72QLPv8KBRhW3XRBgozYymQwg@mail.gmail.com> <fd9dd478-36c3-bf64-d501-b1159c4ed877@gmail.com> <CADK3HH+aG2Hac-4cMsN6Jpo+T7BkfR6AOt6mp0Brn594QJyFDQ@mail.gmail.com> <a1f30b02-574c-0884-45a0-50d3769c6098@gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox