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: Mon, 21 Aug 2023 19:41:34 -0400
Message-ID: <fd9dd478-36c3-bf64-d501-b1159c4ed877@gmail.com> (raw)
In-Reply-To: <CADK3HHLVsMqkp7sVD5+U-z2tx72QLPv8KBRhW3XRBgozYymQwg@mail.gmail.com>
References: <d26a0727-3595-c25b-a6e5-4401d672d93b@gmail.com>
	<CADK3HHLVsMqkp7sVD5+U-z2tx72QLPv8KBRhW3XRBgozYymQwg@mail.gmail.com>

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)  latest in thread

Message-ID: <fd9dd478-36c3-bf64-d501-b1159c4ed877@gmail.com>
Permalink:  ../fd9dd478-36c3-bf64-d501-b1159c4ed877@gmail.com/
Also on:    postgresql.org/message-id/fd9dd478-36c3-bf64-d501-b1159c4ed877@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: <fd9dd478-36c3-bf64-d501-b1159c4ed877@gmail.com>
  References: <d26a0727-3595-c25b-a6e5-4401d672d93b@gmail.com> <CADK3HHLVsMqkp7sVD5+U-z2tx72QLPv8KBRhW3XRBgozYymQwg@mail.gmail.com> <fd9dd478-36c3-bf64-d501-b1159c4ed877@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