when does SET INITIAL SCHEMA come?

Thread: when does SET INITIAL SCHEMA come?

Search this list only Search all lists
when does SET INITIAL SCHEMA come?
Germany	2007-08-21 11:09:55
Hi, I have read in the archive where Fred named the SET INITIAL SCHEMA. My question about this: Does the 1.8.0.8 release include the "SET INITIAL SCHEMA <schema name>"? I was wondering about behaviour after SET DEFAULT SCHEMA. The default schema after connection is by no means the expected one. What does the SET DEFAULT SCHEMA set? The actual schema if you do not set one via SET SCHEMA? But if you have to always set the default schema why do not set it at all? Or am I wrong? Related to my first question, I read latest news: "28 July 2007 - Version 1.8.0.8 bug-fix release will be released soon." My question to this: What does this soon exactly mean? I can give also a hint for the page content admin (I could not find the one responsible for, maybe he/she is reading here): http://hsqldb. org/web/hsqlSupport.html links to http://sourceforge.net/mailarchive/forum.php?forum_id= 2231 which is "thephpbible-support" and not http://sourceforge.net/mailarchive/forum.php? forum_name=hsqldb-user ... Greets, Christoph -- GMX FreeMail: 1 GB Postfach, 5 E-Mail-Adressen, 10 Free SMS. Alle Infos und kostenlose Anmeldung: http://www.gmx.net/ de/go/freemail ------------------------------------------------------------ ------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Hsqldb-user mailing list Hsqldb-userlists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hsqldb-user

Re: when does SET INITIAL SCHEMA come?
United Kingdom	2007-08-21 12:26:40
SET INITIAL SCHEMA is supported in the next major version, not 1.8.0.x. The usage of this command is per user and determines which schema is current when the user is connected. SET SCHEMA is supported in 1.8.0 and switches the current schema for the current user. There is no SET DEFAULT SCHEMA command The bug fix release should come out by the end of the month. Thanks for the bad link report. I have fixed it. Fred ----- Original Message ----- From: <chw-legmx.de> To: <hsqldb-userlists.sourceforge.net> Sent: 21 August 2007 17:09 Subject: [Hsqldb-user] when does SET INITIAL SCHEMA come? Hi, I have read in the archive where Fred named the SET INITIAL SCHEMA. My question about this: Does the 1.8.0.8 release include the "SET INITIAL SCHEMA <schema name>"? I was wondering about behaviour after SET DEFAULT SCHEMA. The default schema after connection is by no means the expected one. What does the SET DEFAULT SCHEMA set? The actual schema if you do not set one via SET SCHEMA? But if you have to always set the default schema why do not set it at all? Or am I wrong? Related to my first question, I read latest news: "28 July 2007 - Version 1.8.0.8 bug-fix release will be released soon." My question to this: What does this soon exactly mean? I can give also a hint for the page content admin (I could not find the one responsible for, maybe he/she is reading here): http://hsqldb. org/web/hsqlSupport.html links to http://sourceforge.net/mailarchive/forum.php?forum_id= 2231 which is "thephpbible-support" and not http://sourceforge.net/mailarchive/forum.php? forum_name=hsqldb-user ... Greets, Christoph -- GMX FreeMail: 1 GB Postfach, 5 E-Mail-Adressen, 10 Free SMS. Alle Infos und kostenlose Anmeldung: http://www.gmx.net/ de/go/freemail ------------------------------------------------------------ ------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Hsqldb-user mailing list Hsqldb-userlists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hsqldb-user ------------------------------------------------------------ ------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Hsqldb-user mailing list Hsqldb-userlists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hsqldb-user

Re: when does SET INITIAL SCHEMA come?
Germany	2007-08-21 13:00:37
Hello Fred, Thank you for your fast response! Ok, I have understood. I/we use hsql via JDO/Spring/JDBC-Pooling. I think the SET SCHEMA has to apply only to the current connection. Otherwise a multi user mode is not possible. But connecting via a pool (and one user) we have to set the schema every time because the connection can be a newly created one... Or we have to wait for the new release. Greets, Christoph -- Der GMX SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen! Ideal für Modem und ISDN: http://www.gmx.n et/de/go/smartsurfer ------------------------------------------------------------ ------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Hsqldb-user mailing list Hsqldb-userlists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hsqldb-user

[1-3]

about | contact Other archives ( Real Estate discussion Medical topics )