The correct syntax is "SELECT * FROM <name of table>
At 05:23 AM 7/12/2004, you wrote:
Andre
What type of commit are you using under JDBC, automatic or manual? Perhaps you should reply with the offending code so we can see what is happeneing. Also, what exception handling are you using around the INSERT code, as you may be handling an exception/error but not doing anything with it.
Regards
Christopher Marsh-Bourdon www.marsh-bourdon.com
"Bussie, Andre D" <[EMAIL PROTECTED]> 12/07/2004 13:09 Please respond to "Struts Users Mailing List"
To: [EMAIL PROTECTED] cc: 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?
-----------------------------------------
The information in this e-mail is confidential. It is intended solely for the addressee. If you are not the intended recipient please notify the sender immediately and delete this message. Any review, dissemination, distribution, copying or other use of this communication or the information in it is strictly prohibited.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
