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
  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]
  2. 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]
  3. 0

    MappingTool error with Mysql and class with member field called "database".

    Oracle Community | 1 decade ago | 3004
    kodo.util.GeneralException: com.solarmetric.jdbc.ReportingSQLException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DATABASE VARCHAR(255), JDOCLASS VARCHAR(255), JDOID BIGINT NOT NULL, JDOVERSION ' at line 1 {stmnt 2566497 CREATE TABLE EXTERNALREFERENCE (AC VARCHAR(255), DATABASE VARCHAR(255), JDOCLASS VARCHAR(255), JDOID BIGINT NOT NULL, JDOVERSION INTEGER, PRIMARY KEY P_EXTERNALREFERENCE (JDOID)) TYPE = innodb} [code=1064, state=42000]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Query: Missing tablename in generated SQL for vertical mapped classes

    Oracle Community | 1 decade ago | 3004
    com.solarmetric.jdbc.ReportingSQLException: ERROR: syntax error at or near "WHERE" {prepstmnt 16398807 SELECT AVG(t0.lengthinminutes) FROM WHERE t1.jdoclass = ? [reused=0]} [code=0, state=42601]
  6. 0

    Query under Transaction Exception....

    Oracle Community | 1 decade ago | 3004
    com.solarmetric.jdbc.ReportingSQLException: DB2 SQL error: SQLCODE: -511, SQLSTATE: 42829, SQLERRMC: null {prepstmnt 107840951 SELECT t0.GROUPSETTINGID, t0.ALLOWDRAW, t0.ALLOWSTRIKE, t0.ALLOWTRANSFER, t0.ASCENDONLY, t0.AUTOAPPROVE, t0.BARVISIBLE, t0.DEFAULTLEVELNAME, t0.LASTMODIFY, t0.MAXDRAW, t0.MAXRECHARGE, t0.MAXROWS, t0.MAXSTRIKE, t0.MAXTRANSFER, t0.MINDRAW, t0.MINRECHARGE, t0.MINSTRIKE, t0.MINTRANSFER, t0.GROUPID, t0.RECHARGEABLE, t0.USERTYPEMODIFICATION FROM OLTP.GROUPSETTING t0 INNER JOIN OLTP.ORGANGROUP t1 ON t0.GROUPID = t1.GROUPID WHERE (t1.GROUPID = ?) FOR UPDATE [reused=0]} [code=-511, state=42829]

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    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