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
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.
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