Return-Path: X-Original-To: apmail-metamodel-dev-archive@minotaur.apache.org Delivered-To: apmail-metamodel-dev-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 322CB18A98 for ; Wed, 17 Jun 2015 19:31:01 +0000 (UTC) Received: (qmail 59234 invoked by uid 500); 17 Jun 2015 19:31:01 -0000 Delivered-To: apmail-metamodel-dev-archive@metamodel.apache.org Received: (qmail 59205 invoked by uid 500); 17 Jun 2015 19:31:01 -0000 Mailing-List: contact dev-help@metamodel.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@metamodel.apache.org Delivered-To: mailing list dev@metamodel.apache.org Received: (qmail 59190 invoked by uid 99); 17 Jun 2015 19:31:01 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 17 Jun 2015 19:31:01 +0000 Date: Wed, 17 Jun 2015 19:31:00 +0000 (UTC) From: =?utf-8?Q?Kasper_S=C3=B8rensen_=28JIRA=29?= To: dev@metamodel.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Resolved] (METAMODEL-151) Can't use type double on PostgreSQL MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/METAMODEL-151?page=3Dcom.atlas= sian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kasper S=C3=B8rensen 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, Met= aModel throws an exception as below: > {code} > Message: > org.apache.metamodel.MetaModelException: Could not execute create tab= le statement: CREATE TABLE public.pairs (group_id INTEGER, record_id_1 VARC= HAR(500), record_id_2 VARCHAR(500), SimilarityScore DOUBLE): ERROR: type "d= ouble" does not exist > Position: 114 > Level: > SEVERE > Stack Trace: > Could not execute create table statement: CREATE TABLE public.pairs (grou= p_id INTEGER, record_id_1 VARCHAR(500), record_id_2 VARCHAR(500), Similarit= yScore DOUBLE): ERROR: type "double" does not exist Position: 114 > org.apache.metamodel.jdbc.JdbcUtils.wrapException(JdbcUtils.java:68) > org.apache.metamodel.jdbc.JdbcCreateTableBuilder.execute(JdbcCreateTa= bleBuilder.java:62) > com.hi.hiqmr.packaging.datacleaner.analyzerresult.export.DuplicateDet= ectionResultUpdateScript.writePairsTable(DuplicateDetectionResultUpdateScri= pt.java:106) > com.hi.hiqmr.packaging.datacleaner.analyzerresult.export.DuplicateDet= ectionResultUpdateScript.run(DuplicateDetectionResultUpdateScript.java:90) > org.apache.metamodel.jdbc.JdbcDataContext.executeUpdate(JdbcDataConte= xt.java:783) > com.hi.hiqmr.packaging.datacleaner.analyzerresult.datacleaner.ui.Expo= rtDuplicatesHelper$1.doInBackground(ExportDuplicatesHelper.java:78) > com.hi.hiqmr.packaging.datacleaner.analyzerresult.datacleaner.ui.Expo= rtDuplicatesHelper$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(QueryEx= ecutorImpl.java:2198) > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor= Impl.java:1927) > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja= va:255) > org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat= ement.java:561) > org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(Abstract= Jdbc2Statement.java:405) > org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdb= c2Statement.java:333) > org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingS= tatement.java:228) > org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingS= tatement.java:228) > org.apache.metamodel.jdbc.JdbcCreateTableBuilder.execute(JdbcCreateTa= bleBuilder.java:59) > com.hi.hiqmr.packaging.datacleaner.analyzerresult.export.DuplicateDet= ectionResultUpdateScript.writePairsTable(DuplicateDetectionResultUpdateScri= pt.java:106) > com.hi.hiqmr.packaging.datacleaner.analyzerresult.export.DuplicateDet= ectionResultUpdateScript.run(DuplicateDetectionResultUpdateScript.java:90) > org.apache.metamodel.jdbc.JdbcDataContext.executeUpdate(JdbcDataConte= xt.java:783) > com.hi.hiqmr.packaging.datacleaner.analyzerresult.datacleaner.ui.Expo= rtDuplicatesHelper$1.doInBackground(ExportDuplicatesHelper.java:78) > com.hi.hiqmr.packaging.datacleaner.analyzerresult.datacleaner.ui.Expo= rtDuplicatesHelper$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)