[
https://issues.apache.org/jira/browse/OPENJPA-460?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Catalina Wei resolved OPENJPA-460.
----------------------------------
Resolution: Fixed
fixed under svn r601576
> Can't convert to: Time, InformixDictionary needs timeTypeName set to
> "DATETIME HOUR TO SECOND"
> ----------------------------------------------------------------------------------------------
>
> Key: OPENJPA-460
> URL: https://issues.apache.org/jira/browse/OPENJPA-460
> Project: OpenJPA
> Issue Type: Bug
> Components: sql
> Affects Versions: 1.1.0
> Reporter: Catalina Wei
> Assignee: Catalina Wei
> Fix For: 1.1.0
>
>
> The default timeTypeName -- "Time" cause InformixDB reporting SQLException:
> 32747 mdd TRACE [main] openjpa.jdbc.SQL - <t 1090273532, conn 1260145436>
> executing stmnt 2021947524 CREATE TABLE EmpBean (empid INTEGER NOT NULL,
> bonus DOUBLE PRECISION, execLevel INTEGER, hireDate DATE, hireTime TIME,
> hireTimestamp DATE, isManager BOOLEAN, name VARCHAR(40), salary DOUBLE
> PRECISION, dept_deptno INTEGER, home_street VARCHAR(40), work_street
> VARCHAR(40), PRIMARY KEY (empid)) LOCK MODE ROW
> 32827 mdd TRACE [main] openjpa.jdbc.SQL - <t 1090273532, conn 1260145436>
> [80 ms] spent
> Exception in thread "main" <openjpa-1.0.1-SNAPSHOT-runknown nonfatal general
> error> org.apache.openjpa.util.GeneralException: Type (time) not found.
> {stmnt 2021947524 CREATE TABLE EmpBean (empid INTEGER NOT NULL, bonus DOUBLE
> PRECISION, execLevel INTEGER, hireDate DATE, hireTime TIME, hireTimestamp
> DATE, isManager BOOLEAN, name VARCHAR(40), salary DOUBLE PRECISION,
> dept_deptno INTEGER, home_street VARCHAR(40), work_street VARCHAR(40),
> PRIMARY KEY (empid)) LOCK MODE ROW} [code=-9628, state=IX000]
> at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:549)
> at org.apache.openjpa.jdbc.meta.MappingTool.run(MappingTool.java:1069)
> at org.apache.openjpa.jdbc.meta.MappingTool.run(MappingTool.java:980)
> at org.apache.openjpa.jdbc.meta.MappingTool.main(MappingTool.java:921)
> Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Type (time) not
> found. {stmnt 2021947524 CREATE TABLE EmpBean (empid INTEGER NOT NULL, bonus
> DOUBLE PRECISION, execLevel INTEGER, hireDate DATE, hireTime TIME,
> hireTimestamp DATE, isManager BOOLEAN, name VARCHAR(40), salary DOUBLE
> PRECISION, dept_deptno INTEGER, home_street VARCHAR(40), work_street
> VARCHAR(40), PRIMARY KEY (empid)) LOCK MODE ROW} [code=-9628, state=IX000]
> at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:192)
> at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$800(LoggingConnectionDecorator.java:57)
> at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingStatement.executeUpdate(LoggingConnectionDecorator.java:754)
> at
> org.apache.openjpa.lib.jdbc.DelegatingStatement.executeUpdate(DelegatingStatement.java:114)
> at
> org.apache.openjpa.jdbc.schema.SchemaTool.executeSQL(SchemaTool.java:1185)
> at
> org.apache.openjpa.jdbc.schema.SchemaTool.createTable(SchemaTool.java:949)
> at org.apache.openjpa.jdbc.schema.SchemaTool.add(SchemaTool.java:526)
> at org.apache.openjpa.jdbc.schema.SchemaTool.add(SchemaTool.java:344)
> at org.apache.openjpa.jdbc.schema.SchemaTool.run(SchemaTool.java:321)
> at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:497)
> ... 3 more
> when time has been created using a date type, at runtime we get time exception
> <openjpa-1.0.1-SNAPSHOT-runknown nonfatal general error>
> org.apache.openjpa.persistence.PersistenceException: Can't convert to: Time
> at
> org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:3851)
> at
> org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:97)
> at
> org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:83)
> at
> org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:59)
> at
> org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initialize(JDBCStoreManager.java:260)
> ...
> Caused by: java.sql.SQLException: Can't convert to: Time
> at com.informix.util.IfxErrMsg.getSQLMinorException(IfxErrMsg.java:511)
> at com.informix.jdbc.IfxObject.toTime(IfxObject.java:590)
> at com.informix.jdbc.IfxResultSet.getTime(IfxResultSet.java:1281)
> at
> org.apache.commons.dbcp.DelegatingResultSet.getTime(DelegatingResultSet.java:208)
> ...
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
