On 13.10.13 20:39, Bob M wrote:
Hi
I am getting the following two errors................
(1)
---- SQL Exception --------
SQL State: 42X01
Error Code: 20000
Message: Syntax error: Encountered"\', 0, 2, \" at line 1, column 43
Now this refers to data in the first record I am trying to add to my table
the record starts like this-
('06-01-2009', 0, 2, 'Tuesday',...............)
where the fields are
VARCHR, INT, INT, VARCHR,.......
(2)
---- SQL Exception --------
SQL State: 25001
Error Code: 20000
Message: Cannot close a connection while a transaction is still active
Hi Bob,
The second error means that you have neither committed nor rolled back
the transaction on the connection before you attempt to close it. I
presume you are running with auto-commit off?
Maybe you have a place in the code where you're not committing/aborting
in certain cases? Remember that this applies to read-transactions too.
Regarding the first error, can you include more of the query? Also, are
you running it in ij, through JDBC, or with some other tool?
Regards,
--
Kristian
Any help in understanding either of these errors - much appreciated
Bob M
--
View this message in context:
http://apache-database.10148.n7.nabble.com/explanation-of-errors-please-tp134695.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.
