You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@metamodel.apache.org by "Hans Drexler (JIRA)" <ji...@apache.org> on 2015/06/12 14:18:00 UTC

[jira] [Created] (METAMODEL-151) Can't use type double on PostgreSQL

Hans Drexler created METAMODEL-151:
--------------------------------------

             Summary: Can't use type double on PostgreSQL
                 Key: METAMODEL-151
                 URL: https://issues.apache.org/jira/browse/METAMODEL-151
             Project: Apache MetaModel
          Issue Type: Bug
    Affects Versions: 4.3.2
            Reporter: Hans Drexler


{code}
Message:
    org.apache.metamodel.MetaModelException: Could not execute create table statement: CREATE TABLE public.pairs (group_id INTEGER, record_id_1 VARCHAR(500), record_id_2 VARCHAR(500), SimilarityScore DOUBLE): ERROR: type "double" does not exist
  Position: 114
Level:
    SEVERE
Stack Trace:
Could not execute create table statement: CREATE TABLE public.pairs (group_id INTEGER, record_id_1 VARCHAR(500), record_id_2 VARCHAR(500), SimilarityScore DOUBLE): ERROR: type "double" does not exist Position: 114
    org.apache.metamodel.jdbc.JdbcUtils.wrapException(JdbcUtils.java:68)
    org.apache.metamodel.jdbc.JdbcCreateTableBuilder.execute(JdbcCreateTableBuilder.java:62)
    com.hi.hiqmr.packaging.datacleaner.analyzerresult.export.DuplicateDetectionResultUpdateScript.writePairsTable(DuplicateDetectionResultUpdateScript.java:106)
    com.hi.hiqmr.packaging.datacleaner.analyzerresult.export.DuplicateDetectionResultUpdateScript.run(DuplicateDetectionResultUpdateScript.java:90)
    org.apache.metamodel.jdbc.JdbcDataContext.executeUpdate(JdbcDataContext.java:783)
    com.hi.hiqmr.packaging.datacleaner.analyzerresult.datacleaner.ui.ExportDuplicatesHelper$1.doInBackground(ExportDuplicatesHelper.java:78)
    com.hi.hiqmr.packaging.datacleaner.analyzerresult.datacleaner.ui.ExportDuplicatesHelper$1.doInBackground(ExportDuplicatesHelper.java:72)
    javax.swing.SwingWorker$1.call(SwingWorker.java:296)
    java.util.concurrent.FutureTask.run(FutureTask.java:262)
    javax.swing.SwingWorker.run(SwingWorker.java:335)
    java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    java.lang.Thread.run(Thread.java:745)
ERROR: type "double" does not exist Position: 114
    org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)
    org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)
    org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
    org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561)
    org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:405)
    org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:333)
    org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
    org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
    org.apache.metamodel.jdbc.JdbcCreateTableBuilder.execute(JdbcCreateTableBuilder.java:59)
    com.hi.hiqmr.packaging.datacleaner.analyzerresult.export.DuplicateDetectionResultUpdateScript.writePairsTable(DuplicateDetectionResultUpdateScript.java:106)
    com.hi.hiqmr.packaging.datacleaner.analyzerresult.export.DuplicateDetectionResultUpdateScript.run(DuplicateDetectionResultUpdateScript.java:90)
    org.apache.metamodel.jdbc.JdbcDataContext.executeUpdate(JdbcDataContext.java:783)
    com.hi.hiqmr.packaging.datacleaner.analyzerresult.datacleaner.ui.ExportDuplicatesHelper$1.doInBackground(ExportDuplicatesHelper.java:78)
    com.hi.hiqmr.packaging.datacleaner.analyzerresult.datacleaner.ui.ExportDuplicatesHelper$1.doInBackground(ExportDuplicatesHelper.java:72)
    javax.swing.SwingWorker$1.call(SwingWorker.java:296)
    java.util.concurrent.FutureTask.run(FutureTask.java:262)
    javax.swing.SwingWorker.run(SwingWorker.java:335)
    java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    java.lang.Thread.run(Thread.java:745)
{code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)