Hi,
I'm trying to connect TOS 5.6.1 with Interbase 5.6 (locally installed) by diferent ways with no luck:
1st method -> Repository/Metadata DB connection:
- dbtype: Interbase
- login: SYSDBA
- pass: masterkey
- server: localhost
- database: C:/my_database.gdb
- ERROR:
Connection failure. You must change the Database Settings.
java.lang.RuntimeException: java.sql.SQLException: interbase.interclient.IBException: connection rejected by remote interface
at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:164)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1054)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:311)
at org.talend.repository.ui.utils.ManagerConnection.check(ManagerConnection.java:272)
at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$26.runWithCancel(DatabaseForm.java:2335)
at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$26.runWithCancel(DatabaseForm.java:1)
at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$1.runnableWithCancel(AProgressMonitorDialogWithCancel.java:77)
at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$ARunnableWithProgressCancel$1.call(AProgressMonitorDialogWithCancel.java:161)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: interbase.interclient.IBException: connection rejected by remote interface
at interbase.interclient.Connection.remote_ATTACH_DATABASE(Unknown Source)
at interbase.interclient.Connection.connect(Unknown Source)
at interbase.interclient.Connection.<init>(Unknown Source)
at interbase.interclient.Driver.connect(Unknown Source)
at org.talend.core.model.metadata.builder.database.DriverShim.connect(DriverShim.java:41)
at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:155)
... 9 more
2nd method -> tJDBCConnection + interclient.jar -> tJDBCInput
- JDBCURL: "jdbc:interbase://localhost//C:/iofwin.gdb"
- Driver JAR: interclient.jar
- Driver Class: "interbase.interclient.Driver"
- User: "SYSDBA"
- pass: "masterkey"
- ERROR: tJDBCInput -> Database connection is failed. Set parameters and continue -> None connection parameter is in red
3rd method -> tInterbaseConnection -> tInterbaseInput
- host: "localhost"
- database: "C:/my_database.gdb"
- User: "SYSDBA"
- pass: "masterkey"
- ERROR: tInterbaseInput-> Database connection is failed. Set parameters and continue -> "database" connection parameter is in red
An ideas?
Regards
Hi Sabrina,
solution found work for Connect and Select. No luck for Insert or Update statements.
I made a simple Workflow to insert in a simple table called "NEW_TABLE" with one string field. No FKs, etc
tFixedFlowInput (Assigning the String vaslue) -> tMap -> tInterBaseOutput
This is the error:
Exception in component tInterbaseOutput_1
interbase.interclient.SQLException: Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 12
"NEW_TABLE"
I think this error means the SLQStatement has syntax errors... line 1, char 12 ->
INSERT INTO NEW_TABLE(...
It seems the name of the table is wrong. It is picked from "NEW_TABLE" Table Name window.
Any ideas?
Regards
