View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0002295SymmetricDSBugpublic2015-05-12 08:492019-04-26 22:07
Reportermsc Assigned To 
Prioritynormal 
Status newResolutionopen 
Product Version3.7.16 
Summary0002295: SYM tables won't create on Interbase with SQL-Dialect 1 bec "token unknown" error
Descriptioni've tried a first setup with postgres and interbase.
Postgres works fine but the DDL for interbase was rejected:


[WebIB] - InterbaseSymmetricDialect - There are SymmetricDS tables that needed altered
[WebIB] - InterbaseSymmetricDialect - DDL failed: CREATE TABLE "SYM_CHANNEL"(
    "CHANNEL_ID" VARCHAR(128) NOT NULL,
    "PROCESSING_ORDER" INTEGER DEFAULT 1 NOT NULL,
    "MAX_BATCH_SIZE" INTEGER DEFAULT 1000 NOT NULL,
    "MAX_BATCH_TO_SEND" INTEGER DEFAULT 60 NOT NULL,
    "MAX_DATA_TO_ROUTE" INTEGER DEFAULT 100000 NOT NULL,
    "EXTRACT_PERIOD_MILLIS" INTEGER DEFAULT 0 NOT NULL,
    "ENABLED" SMALLINT DEFAULT 1 NOT NULL,
    "USE_OLD_DATA_TO_ROUTE" SMALLINT DEFAULT 1 NOT NULL,
    "USE_ROW_DATA_TO_ROUTE" SMALLINT DEFAULT 1 NOT NULL,
    "USE_PK_DATA_TO_ROUTE" SMALLINT DEFAULT 1 NOT NULL,
    "RELOAD_FLAG" SMALLINT DEFAULT 0 NOT NULL,
    "FILE_SYNC_FLAG" SMALLINT DEFAULT 0 NOT NULL,
    "CONTAINS_BIG_LOB" SMALLINT DEFAULT 0 NOT NULL,
    "BATCH_ALGORITHM" VARCHAR(50) DEFAULT 'default' NOT NULL,
    "DATA_LOADER_TYPE" VARCHAR(50) DEFAULT 'default' NOT NULL,
    "DESCRIPTION" VARCHAR(255),
    "CREATE_TIME" TIMESTAMP,
    "LAST_UPDATE_BY" VARCHAR(50),
    "LAST_UPDATE_TIME" TIMESTAMP,
    PRIMARY KEY ("CHANNEL_ID")
)
[WebIB] - JdbcSqlTemplate - [interclient][interbase]Dynamic SQL Error
[interclient][interbase]SQL error code = -104
[interclient][interbase]Token unknown - line 1, char 13
[interclient][interbase]"SYM_CHANNEL". Failed to execute: CREATE TABLE "SYM_CHANNEL"(
    "CHANNEL_ID" VARCHAR(128) NOT NULL,
    "PROCESSING_ORDER" INTEGER DEFAULT 1 NOT NULL,
    "MAX_BATCH_SIZE" INTEGER DEFAULT 1000 NOT NULL,
    "MAX_BATCH_TO_SEND" INTEGER DEFAULT 60 NOT NULL,
    "MAX_DATA_TO_ROUTE" INTEGER DEFAULT 100000 NOT NULL,
    "EXTRACT_PERIOD_MILLIS" INTEGER DEFAULT 0 NOT NULL,
    "ENABLED" SMALLINT DEFAULT 1 NOT NULL,
    "USE_OLD_DATA_TO_ROUTE" SMALLINT DEFAULT 1 NOT NULL,
    "USE_ROW_DATA_TO_ROUTE" SMALLINT DEFAULT 1 NOT NULL,
    "USE_PK_DATA_TO_ROUTE" SMALLINT DEFAULT 1 NOT NULL,
    "RELOAD_FLAG" SMALLINT DEFAULT 0 NOT NULL,
    "FILE_SYNC_FLAG" SMALLINT DEFAULT 0 NOT NULL,
    "CONTAINS_BIG_LOB" SMALLINT DEFAULT 0 NOT NULL,
    "BATCH_ALGORITHM" VARCHAR(50) DEFAULT 'default' NOT NULL,
    "DATA_LOADER_TYPE" VARCHAR(50) DEFAULT 'default' NOT NULL,
    "DESCRIPTION" VARCHAR(255),
    "CREATE_TIME" TIMESTAMP,
    "LAST_UPDATE_BY" VARCHAR(50),
    "LAST_UPDATE_TIME" TIMESTAMP,
    PRIMARY KEY ("CHANNEL_ID")
)
[WebIB] - AbstractSymmetricEngine - An error occurred while starting SymmetricDS
org.jumpmind.db.sql.SqlException: [interclient][interbase]Dynamic SQL Error
[interclient][interbase]SQL error code = -104
[interclient][interbase]Token unknown - line 1, char 13
[interclient][interbase]"SYM_CHANNEL"
        at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:288)
        at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:279)
        at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:434)
        at org.jumpmind.db.sql.JdbcSqlTemplate.update(JdbcSqlTemplate.java:344)
        at org.jumpmind.db.sql.SqlScript.execute(SqlScript.java:107)
        at org.jumpmind.symmetric.db.AbstractSymmetricDialect.createOrAlterTablesIfNecessary(AbstractSymmetricDialect.java:432)
        at org.jumpmind.symmetric.db.AbstractSymmetricDialect.initTablesAndDatabaseObjects(AbstractSymmetricDialect.java:149)
        at org.jumpmind.symmetric.AbstractSymmetricEngine.setupDatabase(AbstractSymmetricEngine.java:388)
        at org.jumpmind.symmetric.AbstractSymmetricEngine.setup(AbstractSymmetricEngine.java:379)
        at org.jumpmind.symmetric.AbstractSymmetricEngine.start(AbstractSymmetricEngine.java:518)
        at org.jumpmind.symmetric.AbstractSymmetricEngine.start(AbstractSymmetricEngine.java:510)
        at org.jumpmind.symmetric.ClientSymmetricEngine.start(ClientSymmetricEngine.java:237)
        at org.jumpmind.symmetric.web.SymmetricEngineHolder$EngineStarter.run(SymmetricEngineHolder.java:445)
Caused by: java.sql.SQLException: [interclient][interbase]Dynamic SQL Error
[interclient][interbase]SQL error code = -104
[interclient][interbase]Token unknown - line 1, char 13
[interclient][interbase]"SYM_CHANNEL"
        at interbase.interclient.Statement.remote_EXECUTE_STATEMENT(Unknown Source)
        at interbase.interclient.Statement.execute(Unknown Source)
        at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
        at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
        at org.jumpmind.db.sql.JdbcSqlTemplate$6.execute(JdbcSqlTemplate.java:358)
        at org.jumpmind.db.sql.JdbcSqlTemplate$6.execute(JdbcSqlTemplate.java:344)
        at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:432)
        ... 10 more
[WebIB] - AbstractSymmetricEngine - SymmetricDS: type=server, name=WebIB, version=3.7.16, groupId=master, externalId=002, databaseName=InterBase, databaseVersion=10.0, driverName=InterClient, driverVersion=10.0.7 for Java 1.6 with InterBase XE, 2009 and 2007
[SymmetricMaster] - PostgreSqlSymmetricDialect - Please add "custom_variable_classes = 'symmetric'" to your postgresql.conf file
[SymmetricMaster] - AbstractSymmetricEngine - Please add "custom_variable_classes = 'symmetric'" to your postgresql.conf file
[SymmetricMaster] - AbstractSymmetricEngine - SymmetricDS: type=server, name=SymmetricMaster, version=3.7.16, groupId=AFA, externalId=000, databaseName=PostgreSQL, databaseVersion=9.1, driverName=PostgreSQL Native Driver, driverVersion=PostgreSQL 9.2 JDBC4 (build 1002)
Steps To Reproducesetup a node with interbase-jdbc

Additional Informationinterbase-node.properties

db.driver=interbase.interclient.Driver
db.url=jdbc:interbase://seat:3050//opt/interbase/afa2web.ib?charSet=8859_1


interclient.jar
InterClientVersion=10.0.7

Interbase-Server: (tried two different version)

InterBase/x86/linux Intel (remote server), version "LI-V10.0.4.590/tcp (seat)/P15"
InterBase/x86/Windows NT (remote server), version "WI-V8.1.0.257/tcp (srvtransfer)/P15"


Tagsdialect: interbase, install

Activities

msc

2015-05-15 08:43

reporter   ~0000690

the error comes from the always enabled double-quoting of table/column names.

if i modify the database and change from interbase SQL-Dialect 1 to 3 it works.

that's still a problem, because changing the sql dialect will change the client behavior (quoting, date-behavior, ...).
It would be nice if the sql dialect will be determined from server and therefore ident-quoting will be enabled or not.

Issue History

Date Modified Username Field Change
2015-05-12 08:49 msc New Issue
2015-05-15 08:43 msc Note Added: 0000690
2019-04-23 17:13 elong Tag Attached: install
2019-04-23 17:13 elong Tag Attached: interbase
2019-04-23 20:49 admin Tag Renamed interbase => dialect: interbase
2019-04-26 22:07 elong Summary symmetricDS node-DDL for Interbase is not working => SYM tables won't create on Interbase with SQL-Dialect 1 bec "token unknown" error