Return-Path: Delivered-To: apmail-openjpa-dev-archive@www.apache.org Received: (qmail 93058 invoked from network); 30 Jul 2007 20:52:15 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 30 Jul 2007 20:52:15 -0000 Received: (qmail 93766 invoked by uid 500); 30 Jul 2007 20:52:14 -0000 Delivered-To: apmail-openjpa-dev-archive@openjpa.apache.org Received: (qmail 93744 invoked by uid 500); 30 Jul 2007 20:52:14 -0000 Mailing-List: contact dev-help@openjpa.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@openjpa.apache.org Delivered-To: mailing list dev@openjpa.apache.org Received: (qmail 93734 invoked by uid 99); 30 Jul 2007 20:52:14 -0000 Received: from Unknown (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 30 Jul 2007 13:52:14 -0700 X-ASF-Spam-Status: No, hits=-100.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.4] (HELO brutus.apache.org) (140.211.11.4) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 30 Jul 2007 20:52:13 +0000 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id 2BF3C7141FD for ; Mon, 30 Jul 2007 13:51:53 -0700 (PDT) Message-ID: <15390108.1185828713176.JavaMail.jira@brutus> Date: Mon, 30 Jul 2007 13:51:53 -0700 (PDT) From: "Albert Lee (JIRA)" To: dev@openjpa.apache.org Subject: [jira] Created: (OPENJPA-303) MappingTools not honoring @Temporal for Date & Calender entity attributes MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org 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, 0.9.8, 1.0.0 Environment: All OS & platforms Reporter: Albert Lee 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 "org.apache.openjpa.persistence.jdbc.PersistenceMappingFactory@2ea82ea8". 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 "org.apache.openjpa.persistence.jdbc.PersistenceMappingFactory@19621962 ". 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 "suite.r70.jse.Employee@1018576054". 234 Employee TRACE [main] openjpa.MetaData - Resolving field "suite.r70.jse.Employee@1018576054.date ". 250 Employee TRACE [main] openjpa.MetaData - Resolving field "suite.r70.jse.Employee@1018576054.id". 250 Employee TRACE [main] openjpa.MetaData - Resolving field "suite.r70.jse.Employee@1018576054.name". 250 Employee TRACE [main] openjpa.MetaData - Resolving field " suite.r70.jse.Employee@1018576054.salary". 250 Employee TRACE [main] openjpa.MetaData - Preparing mapping for "suite.r70.jse.Employee". 250 Employee TRACE [main] openjpa.MetaData - Resolving field "suite.r70.jse.Employee@1018576054.id". 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 " suite.r70.jse.Employee@1018576054.date". 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 "suite.r70.jse.Employee@1018576054.name". 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 "suite.r70.jse.Employee@1018576054.salary ". 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" has mapping strategy "none". 266 Employee TRACE [main] openjpa.MetaData - "suite.r70.jse.Employee" has mapping strategy "none". 266 Employee TRACE [main] openjpa.MetaData - Resolving mapping for "suite.r70.jse.Employee@1018576054". 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 "org.apache.openjpa.jdbc.meta.MappingRepository@54685468 ". 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.