You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@empire-db.apache.org by "Andreas Fink (JIRA)" <em...@incubator.apache.org> on 2010/04/12 21:41:48 UTC
[jira] Updated: (EMPIREDB-76) erroneous translation of
DataType.DOUBLE for postgres
[ https://issues.apache.org/jira/browse/EMPIREDB-76?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Andreas Fink updated EMPIREDB-76:
---------------------------------
Attachment: patch.txt
you are too quick for me, just saw that in the documentation about "double precision" ;-)
attached my patch that also takes care of getConvertPhrase(..).
thanks for fixing this.
> erroneous translation of DataType.DOUBLE for postgres
> -----------------------------------------------------
>
> Key: EMPIREDB-76
> URL: https://issues.apache.org/jira/browse/EMPIREDB-76
> Project: Empire-DB
> Issue Type: Bug
> Components: Core
> Affects Versions: empire-db-2.0.7-incubating
> Environment: java 1.6.0_17, OSX 10.5.8, postgresql 8.3
> Reporter: Andreas Fink
> Assignee: Francis De Brabandere
> Attachments: patch.txt
>
>
> following statement:
> CREATE TABLE TREND_PERFORMANCE_INDEX (
> INDEX_ID INT NOT NULL,
> TREND_ID INT NOT NULL,
> PERFORMANCE DOUBLE NOT NULL,
> TIMESTAMP DATE NOT NULL, PRIMARY KEY (INDEX_ID))
> produces following exception:
> 2010-04-12 19:38:05.729 org.postgresql.util.PSQLException: ERROR: type "double" does not exist
> org.postgresql.util.PSQLException: ERROR: type "double" does not exist
> at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
> at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
> at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
> at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
> at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:336)
> at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:282)
> at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
> at org.apache.empire.db.DBDatabaseDriver.executeSQL(DBDatabaseDriver.java:485)
> at org.apache.empire.db.DBSQLScript.run(DBSQLScript.java:115)
> at de.trendlink.backend.stk.persistence.empiredb.HiKuDao.setupDatabase(HiKuDao.java:61)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
> at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
> at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
> at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
> at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
> at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
> at $Proxy6.setupDatabase(Unknown Source)
> at de.trendlink.backend.stk.HiKuSpringApp.main(HiKuSpringApp.java:24)
> in trunk/empire-db/src/main/java/org/apache/empire/db/postgresql/DBDatabaseDriverPostgreSQL.java:704 Double gets "converted" to Double but should be "float8" instead ( http://www.postgresql.org/docs/8.3/static/datatype.html )
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira