empire-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Francis De Brabandere (JIRA)" <empire-db-...@incubator.apache.org>
Subject [jira] Commented: (EMPIREDB-76) erroneous translation of DataType.DOUBLE for postgres
Date Mon, 12 Apr 2010 20:35:48 GMT

    [ https://issues.apache.org/jira/browse/EMPIREDB-76?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12856154#action_12856154
] 

Francis De Brabandere commented on EMPIREDB-76:
-----------------------------------------------

No problem, we love users who contribute/fix bugs :-)

> 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.6-incubating
>         Environment: java 1.6.0_17, OSX 10.5.8, postgresql 8.3
>            Reporter: Andreas Fink
>            Assignee: Francis De Brabandere
>             Fix For: empire-db-2.0.6-incubating
>
>         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

        

Mime
View raw message