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
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards 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