JDBC does not commit by default. You can specify auto-commit upon establishing
connection, though.
-Original Message-
From: Bayless Kirtley
Sent: Wednesday, June 22, 2022 5:42 PM
To: users@netbeans.apache.org
Subject: Re: Session question
thanks for the suggestion, Gary. I was not comm
Hi Bayless,
HSQL is probably just storing everything in RAM, so unless you hand the
same connection to the second class you may not see the data.
Just to test, try using a connection to a MariaDB instance or some SQL
that stores onto the disk by default?
You could post code, but I think the
It is a fairly complex application but I will try to produce a smaller
example to show some code. Of course, my luck is that the smaller set
will probably work as expected. More tomorrow. Thanks for the suggestion.
Bayless
On 6/22/22 08:10, Amn wrote:
A little bit of code and a larger descr
thanks for the suggestion, Gary. I was not committing. My understanding
is that JDBC commits everything by default unless set otherwise. Anyway,
I added a commit and still no success.
Bayless
On 6/22/22 12:12, Greenberg, Gary wrote:
Are you committing your changes?
-Original Message
Are you committing your changes?
-Original Message-
From: Bayless Kirtley
Sent: Wednesday, June 22, 2022 5:19 AM
To: List, Netbeans
Subject: Session question
I have an application that could really use a local temporary table but I can't
seem to make it work. One class creates and pop
A little bit of code and a larger description of your solution would go
a long way. Please try again 😁
On 2022-06-22 8:19 a.m., Bayless Kirtley wrote:
I have an application that could really use a local temporary table
but I can't seem to make it work. One class creates and populates the
table
I have an application that could really use a local temporary table but
I can't seem to make it work. One class creates and populates the table
then passes the Connection to another class that wants to use it. The
second class sees the table but finds it empty. What am I doing wrong? I
am usin