I did not see your initial post, but to help clear this, let me say that, if you don't want to have to keep a connection to the database, then don't run "all-in-memory".

At 05:37 AM 7/12/2004, you wrote:
Is this the same post that was sent last week?  or week before?  I believe I
asked you a question that you never responded to.

What mode are you running in?
 http://hsqldb.sourceforge.net/web/hsqlModes.html


A few weeks ago, as I was finishing up several database implementations of commons-resources, I noticed that when I ran the tests with HSQLDB in "All-In-Memory" mode, you have to keep a connection to the database or you will lose everything, including your tables.

The only other suggestion I can make is to add  ';' to your statement.
> (queryStr = "INSERT INTO USERS (PASSWORD, EMAIL) VALUES ('?', '?');";)
                                                                    ^

You really should read the docs for HSQLDB.
 http://hsqldb.sourceforge.net/web/hsqlDocsFrame.html


-- James Mitchell Software Engineer / Open Source Evangelist EdgeTech, Inc. 678.910.8017 AIM: jmitchtx

----- Original Message -----
From: "Bussie, Andre D" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 12, 2004 8:09 AM
Subject: HSQLDV / STRUTS


> > > > > I'm using HSQLDB I have a Java Action Class that performs an INSERT > (queryStr = "INSERT INTO USERS (PASSWORD, EMAIL) VALUES ('?', '?')";) > query my code indicates that the INSERT is successful however when I > query the Database SELECT * <name of table> it doesn't show the current > INSERT that was made. Any suggestions on why the code is not being > reflected in the database? > > > >



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]



Reply via email to