com.solarmetric.jdbc.ReportingSQLException: ERROR: syntax error at or near "(" {stmnt 16398807 CREATE TABLE public.WFMSGCONTAINER (jdoid int8(8) NOT NULL, PRIMARY KEY (jdoid))} [code=0, state=42601] [refresh] at com.solarmetric.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:124) [refresh] at com.solarmetric.jdbc.LoggingConnectionDecorator.access$600(LoggingConnectionDecorator.java:19) [refresh] at com.solarmetric.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingStatement.executeUpdate(LoggingConnectionDecorator.java:586) [refresh] at com.solarmetric.jdbc.DelegatingStatement.executeUpdate(DelegatingStatement.java:125) [refresh]

Oracle Community | 3004 | 1 decade ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    Parameters for POSTGRESQL kodo.jdbc.DBDictionary

    Oracle Community | 1 decade ago | 3004
    com.solarmetric.jdbc.ReportingSQLException: ERROR: syntax error at or near "(" {stmnt 16398807 CREATE TABLE public.WFMSGCONTAINER (jdoid int8(8) NOT NULL, PRIMARY KEY (jdoid))} [code=0, state=42601] [refresh] at com.solarmetric.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:124) [refresh] at com.solarmetric.jdbc.LoggingConnectionDecorator.access$600(LoggingConnectionDecorator.java:19) [refresh] at com.solarmetric.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingStatement.executeUpdate(LoggingConnectionDecorator.java:586) [refresh] at com.solarmetric.jdbc.DelegatingStatement.executeUpdate(DelegatingStatement.java:125) [refresh]

    Root Cause Analysis

    1. com.solarmetric.jdbc.ReportingSQLException

      ERROR: syntax error at or near "(" {stmnt 16398807 CREATE TABLE public.WFMSGCONTAINER (jdoid int8(8) NOT NULL, PRIMARY KEY (jdoid))} [code=0, state=42601] [refresh] at com.solarmetric.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:124) [refresh] at com.solarmetric.jdbc.LoggingConnectionDecorator.access$600(LoggingConnectionDecorator.java:19) [refresh] at com.solarmetric.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingStatement.executeUpdate(LoggingConnectionDecorator.java:586) [refresh] at com.solarmetric.jdbc.DelegatingStatement.executeUpdate(DelegatingStatement.java:125) [refresh]

      at kodo.jdbc.schema.SchemaTool.executeSQL()
    2. kodo.jdbc.schema
      SchemaTool.add
      1. kodo.jdbc.schema.SchemaTool.executeSQL(SchemaTool.java:1179)[refresh]
      2. kodo.jdbc.schema.SchemaTool.createTable(SchemaTool.java:926)[refresh]
      3. kodo.jdbc.schema.SchemaTool.add(SchemaTool.java:425)[refresh]
      4. kodo.jdbc.schema.SchemaTool.add(SchemaTool.java:256)[refresh]
      4 frames
    3. kodo.jdbc.meta
      MappingTool.main
      1. kodo.jdbc.meta.MappingTool.record(MappingTool.java:458)[refresh]
      2. kodo.jdbc.meta.MappingTool.run(MappingTool.java:944)[refresh]
      3. kodo.jdbc.meta.MappingTool.run(MappingTool.java:879)[refresh]
      4. kodo.jdbc.meta.MappingTool.main(MappingTool.java:802)
      4 frames