[ https://issues.apache.org/jira/browse/METAMODEL-151?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14589651#comment-14589651 ]
ASF GitHub Bot commented on METAMODEL-151:
------------------------------------------
GitHub user drexler42 opened a pull request:
https://github.com/apache/metamodel/pull/28
Translate type DOUBLE to postgresql type "double precision". Jira 151
Fix for METAMODEL-151
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/drexler42/metamodel master
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/metamodel/pull/28.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #28
----
commit 2b16674c9bae4176889b2f1f55e9c346a3e9b528
Author: hdrexler <gi...@klaan.nl>
Date: 2015-06-17T10:59:29Z
Translate type DOUBLE to postgresql type "double precision". (Fixes JIRA
METAMODEL-151)
----
> 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
>
> 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)