[
https://issues.apache.org/jira/browse/OPENJPA-303?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Michael Dick closed OPENJPA-303.
--------------------------------
> MappingTools not honoring @Temporal for Date & Calender entity attributes
> -------------------------------------------------------------------------
>
> Key: OPENJPA-303
> URL: https://issues.apache.org/jira/browse/OPENJPA-303
> Project: OpenJPA
> Issue Type: Bug
> Components: jdbc
> Affects Versions: 0.9.7, 1.0.0
> Environment: All OS & platforms
> Reporter: Albert Lee
> Assignee: Michael Dick
> Attachments: OPENJPA-303.patch
>
>
> I have a simple entity:
> @Entity
> @Table(name = "JSEEmployee")
> public class Employee {
> @Id
> private int id;
> ......
> @Temporal(TemporalType.DATE)
> private java.util.Date date;
> .....
> }
> When I run the mapping tool to generated the sql as in below, the "date"
> column is still a TIMESTAMP type. Would it be of DATE type due to the
> @Temporal annotation ?
> ------------------------------------------------
> C:\a.workspace\eclipse.workspace\wasx.jpa.jse.test\JPA.JSE>java
> org.apache.openjpa.jdbc.meta.MappingTool -sa build -sql create.sql
> 16 Employee TRACE [main] openjpa.Runtime - Setting the following
> properties from
> "file:/C:/a.workspace/eclipse.workspace/wasx.jpa.jse.test/JPA.JSE/META-INF/persistence.xml"
> into configuration: { openjpa.ConnectionURL=jdbc:db2:WSTest,
> openjpa.Id=Employee, openjpa.ConnectionUserName=leealber,
> openjpa.Log=DefaultLevel=TRACE, MetaData=TRACE, Runtime=TRACE, Enhance=TRACE,
> SQL=TRACE, openjpa.jdbc.DBDictionary=db2, openjpa.MetaDataFactory=jpa
> (Types=suite.r70.jse.Employee),
> javax.persistence.provider=com.ibm.websphere.persistence.PersistenceProviderImpl,
>
> openjpa.ConnectionDriverName=COM.ibm.db2.jdbc.app.DB2Driver,openjpa.ConnectionPassword=fth616dy,
> openjpa.jdbc.SynchronizeMappings=buildSchema }
> 63 Employee INFO [main] openjpa.jdbc.JDBC - Using dictionary class
> "org.apache.openjpa.jdbc.sql.DB2Dictionary".
> 78 Employee INFO [main] openjpa.Tool - No targets were given. Running on
> all classes listed in your configuration,or all persistent classes in the
> classpath if no classes are configured. Use -help to display tool usage
> information.
> 125 Employee TRACE [main] openjpa.MetaData - Using metadata factory
> "[EMAIL PROTECTED]".
> 125 Employee TRACE [main] openjpa.MetaData - Scanning resource
> "META-INF/orm.xml" for persistent types.
> 141 Employee TRACE [main] openjpa.MetaData - parsePersistentTypeNames()
> found [suite.r70.jse.Employee].
> 141 Employee TRACE [main] openjpa.MetaData - Found 1 classes with metadata
> in 16 milliseconds.
> 141 Employee INFO [main] openjpa.Tool - Mapping tool running on type
> "class suite.r70.jse.Employee" with action "buildSchema".
> 141 Employee TRACE [main] openjpa.MetaData - Using metadata factory
> "[EMAIL PROTECTED] ".
> 141 Employee TRACE [main] openjpa.MetaData - Loading metadata for "class
> suite.r70.jse.Employee" under mode "[META][QUERY]".
> 141 Employee TRACE [main] openjpa.MetaData - Scanning resource
> "META-INF/orm.xml" for persistent types.
> 141 Employee TRACE [main] openjpa.MetaData - parsePersistentTypeNames()
> found [suite.r70.jse.Employee].
> 141 Employee TRACE [main] openjpa.MetaData - Found 1 classes with metadata
> in 0 milliseconds.
> 172 Employee TRACE [main] openjpa.MetaData - Parsing class
> "suite.r70.jse.Employee".
> 172 Employee TRACE [main] openjpa.MetaData - Parsing package
> "suite.r70.jse.Employee".
> 203 Employee TRACE [main] openjpa.MetaData - Generating default metadata
> for type " suite.r70.jse.Employee".
> 234 Employee TRACE [main] openjpa.MetaData - Set persistence-capable
> superclass of "suite.r70.jse.Employee" to "null".
> 234 Employee TRACE [main] openjpa.MetaData - Resolving metadata for
> "[EMAIL PROTECTED]".
> 234 Employee TRACE [main] openjpa.MetaData - Resolving field
> "[EMAIL PROTECTED] ".
> 250 Employee TRACE [main] openjpa.MetaData - Resolving field
> "[EMAIL PROTECTED]".
> 250 Employee TRACE [main] openjpa.MetaData - Resolving field
> "[EMAIL PROTECTED]".
> 250 Employee TRACE [main] openjpa.MetaData - Resolving field "
> [EMAIL PROTECTED]".
> 250 Employee TRACE [main] openjpa.MetaData - Preparing mapping for
> "suite.r70.jse.Employee".
> 250 Employee TRACE [main] openjpa.MetaData - Resolving field
> "[EMAIL PROTECTED]".
> 266 Employee TRACE [main] openjpa.MetaData - "id" has mapping
> strategy "org.apache.openjpa.jdbc.meta.strats.PrimitiveFieldStrategy".
> 266 Employee TRACE [main] openjpa.MetaData - Resolving field "
> [EMAIL PROTECTED]".
> 266 Employee TRACE [main] openjpa.MetaData - "date" has mapping
> strategy "org.apache.openjpa.jdbc.meta.strats.HandlerFieldStrategy".
> 266 Employee TRACE [main] openjpa.MetaData - Resolving field
> "[EMAIL PROTECTED]".
> 266 Employee TRACE [main] openjpa.MetaData - "name" has mapping
> strategy " org.apache.openjpa.jdbc.meta.strats.StringFieldStrategy".
> 266 Employee TRACE [main] openjpa.MetaData - Resolving field
> "[EMAIL PROTECTED] ".
> 266 Employee TRACE [main] openjpa.MetaData - "salary" has mapping
> strategy "org.apache.openjpa.jdbc.meta.strats.PrimitiveFieldStrategy".
> 266 Employee TRACE [main] openjpa.MetaData -
> "suite.r70.jse.Employee<discriminator>" has mapping strategy "none".
> 266 Employee TRACE [main] openjpa.MetaData -
> "suite.r70.jse.Employee<version>" has mapping strategy "none".
> 266 Employee TRACE [main] openjpa.MetaData - Resolving mapping for "[EMAIL
> PROTECTED]".
> 266 Employee TRACE [main] openjpa.MetaData - "suite.r70.jse.Employee" has
> mapping strategy "full".
> 266 Employee INFO [main] openjpa.Tool - Recording mapping and schema
> changes.
> 391 Employee TRACE [main] openjpa.MetaData - Clearing metadata repository
> "[EMAIL PROTECTED] ".
> C:\a.workspace\eclipse.workspace\wasx.jpa.jse.test\JPA.JSE>type create.sql
> CREATE TABLE JSEEmployee (id INTEGER NOT NULL, date TIMESTAMP, name
> VARCHAR(254), salary BIGINT, PRIMARY KEY (id));
> ------------------------------------------------
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
