topic Re: Use HSQL Databases in Installing and Upgrading

Use HSQL Databases

_AnonymousUser — Sat, 16 Nov 2024 14:36:14 GMT

Hi,
Has anyone been able to get talend to work with HSQL Databases?
If so, which module did you use?
Thanks!

Re: Use HSQL Databases

Anonymous — Thu, 02 Aug 2007 21:10:02 GMT

I'm using Talend 2.1 and I'd like to use HSQL too. What does tHSQLDBInput expect to connect to--a standalone HSQL server? And how do I define a repository database connection to my HSQL database? I don't see it in the DB Type dropdown list.
Thanks much,
Jason

Re: Use HSQL Databases

Anonymous — Thu, 02 Aug 2007 22:13:38 GMT

Hello Jason,
HSQL Wizard is not yet available.
It will be done soon.
I think you have to specify HSQL Server to connect to a standalone server.
Regards,
Michaël.

Re: Use HSQL Databases

Anonymous — Fri, 03 Aug 2007 00:53:20 GMT

Ok, I have "HSQLDB Server" as the running mode for my tHSQLDBInput. How do I specify the JDBC string to connect to it? Is that what the Database Alias field is for? I'm running HSQL in standalone server mode, but it's (naturally) not able to connect.

Re: Use HSQL Databases

Anonymous — Fri, 03 Aug 2007 11:45:28 GMT

The jdbc String is generated automatically by the component using the properties in the component : jdbc:hsqldb:hsql://host ort/dbalias
Hope it helps
Michaël.

Re: Use HSQL Databases

Anonymous — Wed, 08 Aug 2007 22:09:24 GMT

Ok, the JDBC string produced by the HSQL Database Manager is of the form "jdbc:hsqldb:file:C:\Documents\User\blah". I have the component's properties set as follows:
Host name: "localhost"
Port: "9001"
Database Alias: "file:C:\Documents\User\blah"
When I run the job, I get this exception:
Exception in thread "main" java.lang.Error: Unresolved compilation problem:
Invalid escape sequence (valid ones are \b \t \n \f \r \" \' \\ )
at tripletsphere.loadtripletsphere.LoadTripletSphere.tHSQLDbInput_2Process(LoadTripletSphere.java:146)
at tripletsphere.loadtripletsphere.LoadTripletSphere.main(LoadTripletSphere.java:317)
Jason

Re: Use HSQL Databases

Anonymous — Wed, 08 Aug 2007 22:45:56 GMT

Replace "file:C:\Documents\User\blah" by "file:C:\\Documents\\User\\blah" or "file:C:/Documents/User/blah"
Michaël.