Re: Session question

2022-06-23 Thread Bayless Kirtley
My apologies. I did post the question to the HSQL user list. I am also a Netbeans user (exclusively) and may have posted it here accidently. Bayless On 6/22/22 20:50, Guy Daniel wrote: Hi Bayless, HSQL is probably just storing everything in RAM, so unless you hand the same connection to the

RE: Session question

2022-06-22 Thread Greenberg, Gary
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

Re: Session question

2022-06-22 Thread Guy Daniel
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

Re: Session question

2022-06-22 Thread Bayless Kirtley
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

Re: Session question

2022-06-22 Thread Bayless Kirtley
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

RE: Session question

2022-06-22 Thread Greenberg, Gary
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

Re: Session question

2022-06-22 Thread Amn
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