RE: Cocoon and hsqldb
It is started automatically when Cocoon is loaded. Usually, you can see a message like: Server started. Press Ctrl+C to shutdown in console window - it is the HSQLDB message. If don't get a similar message then check logs to see what's wrong. -- Konstantin Piroumian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, October 14, 2002 12:46 PM To: [EMAIL PROTECTED] Subject: Cocoon and hsqldb Hello everybody, I try to run a Cocoon example with the sql transformer and I use the hsqldb database included in Cocoon distribution for this. But how can I start this db? Thank you Sylvain - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faq/index.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faq/index.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Cocoon and hsqldb
Thank you Konstantin, I have this message: Server 1.6 is running. Is there a console where I can execute queries? Sylvain -Message d'origine- De: Piroumian Konstantin [mailto:[EMAIL PROTECTED]] Date: lundi, 14. octobre 2002 10:50 À: '[EMAIL PROTECTED]' Objet: RE: Cocoon and hsqldb It is started automatically when Cocoon is loaded. Usually, you can see a message like: Server started. Press Ctrl+C to shutdown in console window - it is the HSQLDB message. If don't get a similar message then check logs to see what's wrong. -- Konstantin Piroumian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, October 14, 2002 12:46 PM To: [EMAIL PROTECTED] Subject: Cocoon and hsqldb Hello everybody, I try to run a Cocoon example with the sql transformer and I use the hsqldb database included in Cocoon distribution for this. But how can I start this db? Thank you Sylvain - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faq/index.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faq/index.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faq/index.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Cocoon and hsqldb
From: [EMAIL PROTECTED] Thank you Konstantin, I have this message: Server 1.6 is running. Yes, it's the HSQLDB. Is there a console where I can execute queries? Have no idea here. Try to search for some tools for HSQLDB. I don't know if there is anything like that is bundled with Cocoon. KP Sylvain -Message d'origine- De: Piroumian Konstantin [mailto:[EMAIL PROTECTED]] Date: lundi, 14. octobre 2002 10:50 á: '[EMAIL PROTECTED]' Objet: RE: Cocoon and hsqldb It is started automatically when Cocoon is loaded. Usually, you can see a message like: Server started. Press Ctrl+C to shutdown in console window - it is the HSQLDB message. If don't get a similar message then check logs to see what's wrong. -- Konstantin Piroumian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, October 14, 2002 12:46 PM To: [EMAIL PROTECTED] Subject: Cocoon and hsqldb Hello everybody, I try to run a Cocoon example with the sql transformer and I use the hsqldb database included in Cocoon distribution for this. But how can I start this db? Thank you Sylvain - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faq/index.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faq/index.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faq/index.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faq/index.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Cocoon and hsqldb
I have found a script file that creates tables and entries in the default Cocoon example database, you can find this file here: \WEB-INF\db\cocoondb.script Now all work with HSQLDB! Has someone tried to connect Cocoon to a Microsoft SQL Server database? I'm looking for a database URL connection example. Thank you Sylvain -Message d'origine- De: Piroumian Konstantin [mailto:[EMAIL PROTECTED]] Date: lundi, 14. octobre 2002 11:02 á: '[EMAIL PROTECTED]' Objet: RE: Cocoon and hsqldb From: [EMAIL PROTECTED] Thank you Konstantin, I have this message: Server 1.6 is running. Yes, it's the HSQLDB. Is there a console where I can execute queries? Have no idea here. Try to search for some tools for HSQLDB. I don't know if there is anything like that is bundled with Cocoon. KP Sylvain -Message d'origine- De: Piroumian Konstantin [mailto:[EMAIL PROTECTED]] Date: lundi, 14. octobre 2002 10:50 á: '[EMAIL PROTECTED]' Objet: RE: Cocoon and hsqldb It is started automatically when Cocoon is loaded. Usually, you can see a message like: Server started. Press Ctrl+C to shutdown in console window - it is the HSQLDB message. If don't get a similar message then check logs to see what's wrong. -- Konstantin Piroumian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, October 14, 2002 12:46 PM To: [EMAIL PROTECTED] Subject: Cocoon and hsqldb Hello everybody, I try to run a Cocoon example with the sql transformer and I use the hsqldb database included in Cocoon distribution for this. But how can I start this db? Thank you Sylvain - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faq/index.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faq/index.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faq/index.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faq/index.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faq/index.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Cocoon and hsqldb
On Monday 14 October 2002 11:18, [EMAIL PROTECTED] wrote: . . . Has someone tried to connect Cocoon to a Microsoft SQL Server database? I'm looking for a database URL connection example. . . . If you're courageous you can use the JDBC-ODBC bridge for this, but last time I checked it was fairly limited and funky (or do they have native JDBC now?). I don't have an URL handy but you should find it in the JDBC-ODBC samples. I've also used www.inetsoftware.de's excellent (commercial) drivers for MS SQL, you'd then use a JDBC URL like: jdbc:inetdae:your_server:1433?database=your_db A nice utility to test these URLs and JDBC drivers is DBVisualizer, http://www.minq.se/products/dbvis/info.html Hope this helps. -Bertrand - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faq/index.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Cocoon and hsqldb
There is a JDBC driver for MS SQL Server, available at sourceforge.net: jtds. -Message d'origine- De: Bertrand Delacretaz [mailto:[EMAIL PROTECTED]] Date: lundi 14 octobre 2002 11:26 á: [EMAIL PROTECTED]; [EMAIL PROTECTED] Objet: Re: Cocoon and hsqldb On Monday 14 October 2002 11:18, [EMAIL PROTECTED] wrote: . . . Has someone tried to connect Cocoon to a Microsoft SQL Server database? I'm looking for a database URL connection example. . . . If you're courageous you can use the JDBC-ODBC bridge for this, but last time I checked it was fairly limited and funky (or do they have native JDBC now?). I don't have an URL handy but you should find it in the JDBC-ODBC samples. I've also used www.inetsoftware.de's excellent (commercial) drivers for MS SQL, you'd then use a JDBC URL like: jdbc:inetdae:your_server:1433?database=your_db A nice utility to test these URLs and JDBC drivers is DBVisualizer, http://www.minq.se/products/dbvis/info.html Hope this helps. -Bertrand - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faq/index.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faq/index.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Cocoon and hsqldb
Is there a console where I can execute queries? Yes, start: java org.hsqldb.util.DatabaseManager Ralph Henke - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faq/index.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]