You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@metamodel.apache.org by "Kasper Sørensen (JIRA)" <ji...@apache.org> on 2015/06/17 21:31:00 UTC
[jira] [Resolved] (METAMODEL-151) Can't use type double on
PostgreSQL
[ 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)