Re: change collation for order

In the current version you cannot do either. The next major version supports 
SQL triggers, allowing you to use similar syntax as other databases. We have 
currently no plans for ("jdbc:default:connection") but may implement it for 
the next version.

Fred

----- Original Message ----- 
From: "Stephen Ince" <since@xxxxxxxxxxxxxx>
To: "HSQLdb user discussions" <hsqldb-user@xxxxxxxxxxxxxxxxxxxxx>
Sent: 04 July 2007 17:16
Subject: Re: [Hsqldb-user] change collation for order


Hi,
    I am trying to port over a schema from postgres to hsqldb. I have a few
questions regarding triggers.

1) How can you determine what the column name is for the "or" and "nr" rows.
    public void fire(int typ, String trn, String tn, Object[] or,
                     Object[] nr) {

2) Are they any plans to support
"DriverManager.getConnection("jdbc:default:connection") function call for
getting a connection in a stored procudure?

Steve


-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Hsqldb-user mailing list
Hsqldb-user@xxxxxxxxxxxxxxxxxxxxx
https://lists.sourceforge.net/lists/listinfo/hsqldb-user 


-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/