API tools faq
paste
timh52280

Untitled

timh52280
May 6th, 2020
503
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 7.81 KB | None | 0 0
raw download clone embed print report
  1. 2020-05-05 23:09:59,740 INFO [client] [DefaultDatabaseWriter] [client-dataloader-3] About to create table using the following definition: <?xml version="1.0"?>
  2. <!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
  3. <database name="dataextractor">
  4.     <table name="REGISTRY">
  5.         <column name="ELEMENTO_ID" primaryKey="true" required="true" type="INTEGER" size="10">
  6.             <platform-column name="firebird" type="INTEGER" size="10"/>
  7.         </column>
  8.         <column name="NOMBRE" required="true" type="VARCHAR" size="50">
  9.             <platform-column name="firebird" type="VARCHAR" size="50"/>
  10.         </column>
  11.         <column name="TIPO" required="true" type="CHAR" size="1">
  12.             <platform-column name="firebird" type="CHAR" size="1"/>
  13.         </column>
  14.         <column name="PADRE_ID" required="true" type="INTEGER" size="10">
  15.             <platform-column name="firebird" type="INTEGER" size="10"/>
  16.         </column>
  17.         <column name="VALOR" type="VARCHAR" size="100">
  18.             <platform-column name="firebird" type="VARCHAR" size="100"/>
  19.         </column>
  20.         <column name="VALOR_BLOB" type="BLOB">
  21.             <platform-column name="firebird" type="BLOB SUB_TYPE <0"/>
  22.         </column>
  23.         <column name="VALOR_MEMO" type="LONGVARCHAR" size="254">
  24.             <platform-column name="firebird" type="BLOB SUB_TYPE 1"/>
  25.         </column>
  26.     </table>
  27. </database>
  28. 2020-05-05 23:09:59,752 INFO [client] [FirebirdDatabasePlatform] [client-dataloader-3] Running alter sql:
  29. CREATE TABLE "REGISTRY"(
  30.     "ELEMENTO_ID" INTEGER NOT NULL,
  31.     "NOMBRE" VARCHAR(50) NOT NULL,
  32.     "TIPO" CHAR(1) NOT NULL,
  33.     "PADRE_ID" INTEGER NOT NULL,
  34.     "VALOR" VARCHAR(100),
  35.     "VALOR_BLOB" BLOB SUB_TYPE <0,
  36.     "VALOR_MEMO" BLOB SUB_TYPE 1,
  37.     PRIMARY KEY ("ELEMENTO_ID")
  38. );
  39.  
  40. 2020-05-05 23:09:59,758 WARN [client] [JdbcSqlTemplate] [client-dataloader-3] Dynamic SQL Error; SQL error code = -104; Token unknown - line 7, column 32; < [SQLState:42000, ISC error code:335544634].  Failed to execute: CREATE TABLE "REGISTRY"(
  41.     "ELEMENTO_ID" INTEGER NOT NULL,
  42.     "NOMBRE" VARCHAR(50) NOT NULL,
  43.     "TIPO" CHAR(1) NOT NULL,
  44.     "PADRE_ID" INTEGER NOT NULL,
  45.     "VALOR" VARCHAR(100),
  46.     "VALOR_BLOB" BLOB SUB_TYPE <0,
  47.     "VALOR_MEMO" BLOB SUB_TYPE 1,
  48.     PRIMARY KEY ("ELEMENTO_ID")
  49. )
  50. 2020-05-05 23:09:59,759 ERROR [client] [DefaultDatabaseWriter] [client-dataloader-3] Failed to alter table using the following xml: <?xml version="1.0"?>
  51. <!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
  52. <database name="dataextractor">
  53.     <table name="REGISTRY">
  54.         <column name="ELEMENTO_ID" primaryKey="true" required="true" type="INTEGER" size="10">
  55.             <platform-column name="firebird" type="INTEGER" size="10"/>
  56.         </column>
  57.         <column name="NOMBRE" required="true" type="VARCHAR" size="50">
  58.             <platform-column name="firebird" type="VARCHAR" size="50"/>
  59.         </column>
  60.         <column name="TIPO" required="true" type="CHAR" size="1">
  61.             <platform-column name="firebird" type="CHAR" size="1"/>
  62.         </column>
  63.         <column name="PADRE_ID" required="true" type="INTEGER" size="10">
  64.             <platform-column name="firebird" type="INTEGER" size="10"/>
  65.         </column>
  66.         <column name="VALOR" type="VARCHAR" size="100">
  67.             <platform-column name="firebird" type="VARCHAR" size="100"/>
  68.         </column>
  69.         <column name="VALOR_BLOB" type="BLOB">
  70.             <platform-column name="firebird" type="BLOB SUB_TYPE <0"/>
  71.         </column>
  72.         <column name="VALOR_MEMO" type="LONGVARCHAR" size="254">
  73.             <platform-column name="firebird" type="BLOB SUB_TYPE 1"/>
  74.         </column>
  75.     </table>
  76. </database> StackTraceKey.init [SqlException:1319906164]
  77. org.jumpmind.db.sql.SqlException: Dynamic SQL Error; SQL error code = -104; Token unknown - line 7, column 32; < [SQLState:42000, ISC error code:335544634]
  78.     at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:305)
  79.     at org.jumpmind.db.platform.firebird.FirebirdJdbcSqlTemplate.translate(FirebirdJdbcSqlTemplate.java:62)
  80.     at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:294)
  81.     at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:519)
  82.     at org.jumpmind.db.sql.JdbcSqlTemplate.update(JdbcSqlTemplate.java:427)
  83.     at org.jumpmind.db.sql.SqlScript.execute(SqlScript.java:114)
  84.     at org.jumpmind.db.platform.AbstractDatabasePlatform.alterTables(AbstractDatabasePlatform.java:241)
  85.     at org.jumpmind.db.platform.AbstractDatabasePlatform.alterDatabase(AbstractDatabasePlatform.java:214)
  86.     at org.jumpmind.symmetric.io.data.writer.DefaultDatabaseWriter.create(DefaultDatabaseWriter.java:571)
  87.     at org.jumpmind.symmetric.io.data.writer.AbstractDatabaseWriter.write(AbstractDatabaseWriter.java:204)
  88.     at org.jumpmind.symmetric.io.data.writer.NestedDataWriter.write(NestedDataWriter.java:64)
  89.     at org.jumpmind.symmetric.model.ProcessInfoDataWriter.write(ProcessInfoDataWriter.java:84)
  90.     at org.jumpmind.symmetric.io.data.writer.NestedDataWriter.write(NestedDataWriter.java:64)
  91.     at org.jumpmind.symmetric.io.data.writer.TransformWriter.write(TransformWriter.java:201)
  92.     at org.jumpmind.symmetric.io.data.DataProcessor.forEachDataInTable(DataProcessor.java:212)
  93.     at org.jumpmind.symmetric.io.data.DataProcessor.forEachTableInBatch(DataProcessor.java:178)
  94.     at org.jumpmind.symmetric.io.data.DataProcessor.process(DataProcessor.java:124)
  95.     at org.jumpmind.symmetric.service.impl.DataLoaderService$LoadIntoDatabaseOnArrivalListener$2.call(DataLoaderService.java:1080)
  96.     at org.jumpmind.symmetric.service.impl.DataLoaderService$LoadIntoDatabaseOnArrivalListener$2.call(DataLoaderService.java:1057)
  97.     at java.util.concurrent.FutureTask.run(FutureTask.java:266)
  98.     at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  99.     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  100.     at java.lang.Thread.run(Thread.java:748)
  101. Caused by: java.sql.SQLSyntaxErrorException: Dynamic SQL Error; SQL error code = -104; Token unknown - line 7, column 32; < [SQLState:42000, ISC error code:335544634]
  102.     at org.firebirdsql.gds.ng.FbExceptionBuilder$Type$1.createSQLException(FbExceptionBuilder.java:527)
  103.     at org.firebirdsql.gds.ng.FbExceptionBuilder.toFlatSQLException(FbExceptionBuilder.java:302)
  104.     at org.firebirdsql.gds.ng.wire.AbstractWireOperations.readStatusVector(AbstractWireOperations.java:138)
  105.     at org.firebirdsql.gds.ng.wire.AbstractWireOperations.processOperation(AbstractWireOperations.java:202)
  106.     at org.firebirdsql.gds.ng.wire.AbstractWireOperations.readSingleResponse(AbstractWireOperations.java:169)
  107.     at org.firebirdsql.gds.ng.wire.AbstractWireOperations.readResponse(AbstractWireOperations.java:153)
  108.     at org.firebirdsql.gds.ng.wire.AbstractWireOperations.readGenericResponse(AbstractWireOperations.java:255)
  109.     at org.firebirdsql.gds.ng.wire.AbstractFbWireDatabase.readGenericResponse(AbstractFbWireDatabase.java:173)
  110.     at org.firebirdsql.gds.ng.wire.version11.V11Statement.prepare(V11Statement.java:89)
  111.     at org.firebirdsql.jdbc.FBStatement.prepareFixedStatement(FBStatement.java:1368)
  112.     at org.firebirdsql.jdbc.FBStatement.internalExecute(FBStatement.java:1354)
  113.     at org.firebirdsql.jdbc.FBStatement.executeImpl(FBStatement.java:840)
  114.     at org.firebirdsql.jdbc.FBStatement.execute(FBStatement.java:826)
  115.     at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
  116.     at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
  117.     at org.jumpmind.db.sql.JdbcSqlTemplate$6.execute(JdbcSqlTemplate.java:442)
  118.     at org.jumpmind.db.sql.JdbcSqlTemplate$6.execute(JdbcSqlTemplate.java:427)
  119.     at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:517)
  120.     ... 19 more
  121. Caused by: org.firebirdsql.jdbc.FBSQLExceptionInfo: Dynamic SQL Error
  122. 2020-05-05 23:09:59,775 ERROR [client] [ManageIncomingBatchListener] [client-dataloader-3] Failed to load batch server-4699 StackTraceKey [SqlException:1319906164]
  123. 2020-05-05 23:09:59,891 INFO [client] [ConfigurationChangedDataRouter] [client-job-16] About to refresh the cache of node security because new configuration came through the data router
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!