HyperSQL Database Engine (HSQLDB)

Latest snapshot jars have just been released and behave
identically in client-server and in-process modes.

http://hsqldb.org/support/

Please check and report any issues.

Fred
On Thu, 12 Aug 2010 16:47 -0400, "Vince Adamo"
<vadamo@...> wrote:

I am running HSQLDB 2.0.0 in a unit test environment and have
come across a situation where the exception
“java.sql.SQLException: invalid transaction state: read-only
SQL-transaction” is thrown while preparing a SQL update
statement, with the connection isolation level set to
Connection.TRANSACTION_SERIALIZABLE, when immediately preceded by
a SQL query with the connection isolation level set to
Connection.TRANSACTION_READ_UNCOMMITTED.  I have developed a test
case, which I have attached to this e-mail.


Please note that this test case will fail with the exception
mentioned above when HSQLDB is run “in memory” (i.e. Test class
member variable “serverMode” = false) but it will not fail when
HSQLDB is run remotely as a server (i.e. Test class member
variable “serverMode” = true).


I believe this issue is related to the fact that when running “in
memory”,
org.hsqldb.jdbc.JDBCConnection.setTransactionIsolation(int level)
is called directly when setting the connection isolation level,
but when running in “server mode” a remote call is made to
Session.setAttributes() to set the isolation level.  The call to
JDBCConnection.setTransactionIsolation(int level) results in a
call to Session.setIsolationDefault(), which sets
Session.isReadOnlyDefault to true when level is READ UNCOMITTED.
The call to Session.setAttributes(), instead, results in a call
to Session.setIsolation(), which does not set
Session.isReadOnlyDefault, it only changes the current
transactions isolation level.  And, Session.isReadOnlyDefault is
never reset to false when run “in memory” and the connection’s
isolation is set to SERIALIZABLE.


Is there something wrong with the sequence of events depicted by
the class Test, or is this a bug?  And if it’s a bug, can you
recommend a work around?


Thanks,

Vince Adamo



-------------------------------------------------------------------------
-----
This SF.net email is sponsored by

Make an app they can't live without
Enter the BlackBerry Developer Challenge
http://p.sf.net/sfu/RIM-dev2dev

_______________________________________________
Hsqldb-user mailing list
Hsqldb-user@...
https://lists.sourceforge.net/lists/listinfo/hsqldb-user

Latest 2.0.1 snapshot jars have just been uploade and support this
feature which was added to SVN a few days ago.

http://hsqldb.org/support/

Fred

On Thu, 19 Aug 2010 10:50 -0700, "Tmo_hsqldb_q" <tmoy@...>
wrote:
> 
> 
> 
> The error "user lacks privilege or object not found: PUSERNAME / Error
> Code:
> -5501 / State: 42501" is generated when trying to load the following
> procedure.
> 
> 
> 
> CREATE PROCEDURE USP_IPXML_GET_USERS (pUserName varchar(20))
> READS SQL DATA DYNAMIC RESULT SETS 1
> BEGIN ATOMIC
> 
>     DECLARE result CURSOR WITH RETURN FOR select * from User where
>     user_name
> = pUserName;
> 
>     OPEN result;
> 
> END   
> 
> 
> However when I replace pUserName with 'someuser' it loads with no errors.
> 
> 
> CREATE PROCEDURE USP_IPXML_GET_USERS (pUserName varchar(20))
> READS SQL DATA DYNAMIC RESULT SETS 1
> BEGIN ATOMIC
> 
>     DECLARE result CURSOR WITH RETURN FOR select * from User where
>     user_name
> = 'someuser';
> 
>     OPEN result;
> 
> END   
> 
> 
> 
> 
> thanks,
> Tony
> -- 
> View this message in context:
> http://old.nabble.com/DECLARE-result-CURSOR-WITH-RETURN---throws-error-when-accessing-parameter-tp29484720p29484720.html
> Sent from the HSQLDB - User mailing list archive at Nabble.com.
> 
> 
> ------------------------------------------------------------------------------
> This SF.net email is sponsored by 
> 
> Make an app they can't live without
> Enter the BlackBerry Developer Challenge
> http://p.sf.net/sfu/RIM-dev2dev 
> _______________________________________________
> Hsqldb-user mailing list
> Hsqldb-user@...
> https://lists.sourceforge.net/lists/listinfo/hsqldb-user
>