Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Unable to retrieve schema the altibase-DB
Hi~
so hot, too hot I am an ETL developer developing Altibase DB and interworking.
Altibase is a memory DB and I want to work with TOS DI 7.1 version.(http://altibase.com/)
Since there is no DBMS provided in TOS DI, connection is made with JDBC and basic CRUD is also successful.
However, when I create an Altibase meta DB (connection succeeded) and retrieve the schema, the following error occurs.
!ENTRY org.talend.platform.logging 4 0 2018-08-07 09:53:55.874 !MESSAGE 2018-08-07 09:53:55,873 ERROR org.talend.metadata.managment.model.DBConnectionFillerImpl - java.sql.SQLException: Invalid argument: Table type: <TABLE | SYSTEM TABLE | VIEW | SYSTEM VIEW | MATERIALIZED VIEW | QUEUE | SYNONYM | SEQUENCE> expected, but <EXTERNAL TABLE> !STACK 0 java.sql.SQLException: Invalid argument: Table type: <TABLE | SYSTEM TABLE | VIEW | SYSTEM VIEW | MATERIALIZED VIEW | QUEUE | SYNONYM | SEQUENCE> expected, but <EXTERNAL TABLE> at Altibase.jdbc.driver.ex.Error.throwSQLExceptionInternal(Error.java:187) at Altibase.jdbc.driver.ex.Error.throwSQLException(Error.java:181) at Altibase.jdbc.driver.AltibaseDatabaseMetaData.checkTableTypes(AltibaseDatabaseMetaData.java:789) <attach file >
I have confirmed that JDBC driver provided here (Alitabase) is good for various DBMS work tools.(DBeaver, etc.)
I would like to know if this error should be corrected in Talend or Altibase.Altibase supports the SQL / 92 standard.
thank you