[ http://issues.apache.org/jira/browse/OPENJPA-13?page=comments#action_12428249 ] Megan commented on OPENJPA-13: ------------------------------
I tried to change the type of the "id" field from Integer to BigDecimal (and Number) but openjpac fails. enhance: [openjpac] 80 INFO [main] openjpa.Tool - No targets were given. Running on all classes listed in org.apache.openjpa.PersistentClasses, or all metadata files in classpath directories if the property is not specified. [openjpac] 1261 INFO [main] openjpa.Tool - Enhancer running on type "class mytest.domain.model.JpaType". [openjpac] <4|true|0.9.0> org.apache.openjpa.util.MetaDataException: Type "class mytest.domain.model.JpaType" declares field "id" as a primary key, but keys of type "java.math.BigDecimal" are not supported. [openjpac] at org.apache.openjpa.meta.ClassMetaData.validateAppIdClass(ClassMetaData.java:1676) [openjpac] at org.apache.openjpa.meta.ClassMetaData.validateIdentity(ClassMetaData.java:1655) [openjpac] at org.apache.openjpa.meta.ClassMetaData.validateMeta(ClassMetaData.java:1572) [openjpac] at org.apache.openjpa.meta.ClassMetaData.resolve(ClassMetaData.java:1462) [openjpac] at org.apache.openjpa.meta.MetaDataRepository.processBuffer(MetaDataRepository.java:641) [openjpac] at org.apache.openjpa.meta.MetaDataRepository.resolveMeta(MetaDataRepository.java:548) [openjpac] at org.apache.openjpa.meta.MetaDataRepository.resolve(MetaDataRepository.java:493) [openjpac] at org.apache.openjpa.meta.MetaDataRepository.getMetaData(MetaDataRepository.java:294) [openjpac] at org.apache.openjpa.enhance.PCEnhancer.<init>(PCEnhancer.java:163) [openjpac] at org.apache.openjpa.enhance.PCEnhancer.run(PCEnhancer.java:3473) [openjpac] at org.apache.openjpa.ant.PCEnhancerTask.executeOn(PCEnhancerTask.java:86) [openjpac] at org.apache.openjpa.lib.ant.AbstractTask.execute(AbstractTask.java:166) [openjpac] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275) [openjpac] at org.apache.tools.ant.Task.perform(Task.java:364) [openjpac] at org.apache.tools.ant.Target.execute(Target.java:341) [openjpac] at org.apache.tools.ant.Target.performTasks(Target.java:369) [openjpac] at org.apache.tools.ant.Project.executeTarget(Project.java:1214) [openjpac] at org.apache.tools.ant.Project.executeTargets(Project.java:1062) [openjpac] at org.apache.tools.ant.Main.runBuild(Main.java:673) [openjpac] at org.apache.tools.ant.Main.startAnt(Main.java:188) [openjpac] at org.apache.tools.ant.launch.Launcher.run(Launcher.java:196) [openjpac] at org.apache.tools.ant.launch.Launcher.main(Launcher.java:55) BUILD FAILED C:\appd\renux\mytest.domain\build.xml:31: <4|true|0.9.0> org.apache.openjpa.util.MetaDataException: Type "class mytest.domain.model.JpaType" declares field "id" as a primary key, but keys of type "java.math.BigDecimal" are not supported. > GenerationType.IDENTITY problem with MS SQL Server > -------------------------------------------------- > > Key: OPENJPA-13 > URL: http://issues.apache.org/jira/browse/OPENJPA-13 > Project: OpenJPA > Issue Type: Bug > Components: jpa > Environment: Microsoft SQL Server 2000 > Windows XP > Java SE 1.5 > OpenJPA - source downloaded today (Aug 14, 2006) > Reporter: Megan > Priority: Critical > > Cannot persist entity with identity column. To reproduce, create a simple > object with identity column > @Entity > @Table(name="JpaType") > public class JpaType implements Serializable > { > @Id > @GeneratedValue(strategy=GenerationType.IDENTITY) > @Column(name="Id") > private Integer id = null; > > @Column(name="Name") > private String name = null; > > public Integer getId() { return id; } > public String getName() { return name; } > public void setName(String name) { this.name = name; } > } > create table JpaType ( > Id int identity(1, 1) not null > , Name varchar(50) null > , constraint JpaType_PK primary key (Id) > ) > JpaType jpa = new JpaType(); > jpa.setName("Test 1"); > em.persist(jpa); > em.flush(); > It works OK if I remove identity column (and set ID myself). > Stack trace > <0|true|0.9.0> org.apache.openjpa.persistence.PersistenceException: > java.math.BigDecimal > at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:1576) > at > org.apache.openjpa.kernel.DelegatingBroker.flush(DelegatingBroker.java:927) > at > org.apache.openjpa.persistence.EntityManagerImpl.flush(EntityManagerImpl.java:421) > at mytest.domain.JpaTest.testJpa(JpaTest.java:30) > 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:585) > at > org.junit.internal.runners.TestMethodRunner.executeMethodBody(TestMethodRunner.java:99) > at > org.junit.internal.runners.TestMethodRunner.runUnprotected(TestMethodRunner.java:81) > at > org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java:34) > at > org.junit.internal.runners.TestMethodRunner.runMethod(TestMethodRunner.java:75) > at > org.junit.internal.runners.TestMethodRunner.run(TestMethodRunner.java:45) > at > org.junit.internal.runners.TestClassMethodsRunner.invokeTestMethod(TestClassMethodsRunner.java:71) > at > org.junit.internal.runners.TestClassMethodsRunner.run(TestClassMethodsRunner.java:35) > at > org.junit.internal.runners.TestClassRunner$1.runUnprotected(TestClassRunner.java:42) > at > org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java:34) > at > org.junit.internal.runners.TestClassRunner.run(TestClassRunner.java:52) > at > org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:38) > at > org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38) > at > org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460) > at > org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673) > at > org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386) > at > org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196) > Caused by: java.lang.ClassCastException: java.math.BigDecimal > at mytest.domain.model.JpaType.pcReplaceField(JpaType.java) > at > org.apache.openjpa.kernel.StateManagerImpl.replaceField(StateManagerImpl.java:2824) > at > org.apache.openjpa.kernel.StateManagerImpl.storeObjectField(StateManagerImpl.java:2284) > at > org.apache.openjpa.kernel.StateManagerImpl.storeField(StateManagerImpl.java:2380) > at > org.apache.openjpa.kernel.StateManagerImpl.storeField(StateManagerImpl.java:723) > at > org.apache.openjpa.kernel.StateManagerImpl.store(StateManagerImpl.java:719) > at > org.apache.openjpa.jdbc.meta.strats.HandlerFieldStrategy.setAutoAssignedValue(HandlerFieldStrategy.java:361) > at > org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:119) > at > org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:68) > at > org.apache.openjpa.jdbc.kernel.OperationOrderUpdateManager.flushPrimaryRow(OperationOrderUpdateManager.java:199) > at > org.apache.openjpa.jdbc.kernel.OperationOrderUpdateManager.flush(OperationOrderUpdateManager.java:86) > at > org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:88) > at > org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:68) > at > org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:512) > at > org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:127) > at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:1876) > at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:1772) > at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:1567) > ... 23 more -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira