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.
>>
>>
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