metamodel-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kasper Sørensen (JIRA) <j...@apache.org>
Subject [jira] [Resolved] (METAMODEL-151) Can't use type double on PostgreSQL
Date Wed, 17 Jun 2015 19:31:00 GMT

     [ https://issues.apache.org/jira/browse/METAMODEL-151?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Kasper Sørensen resolved METAMODEL-151.
---------------------------------------
    Resolution: Fixed
      Assignee: Hans Drexler

> 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
>            Assignee: Hans Drexler
>
> When I try to create a table with a column of type ColumnType.double, MetaModel throws
an exception as below:
> {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)

Mime
View raw message