openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Noll <bwn...@gmail.com>
Subject Re: [jira] Commented: (OPENJPA-13) GenerationType.IDENTITY problem with MS SQL Server
Date Wed, 04 Oct 2006 21:09:11 GMT
will do

Abe White (JIRA) wrote:
>     [ http://issues.apache.org/jira/browse/OPENJPA-13?page=comments#action_12439964 ]

>             
> Abe White commented on OPENJPA-13:
> ----------------------------------
>
> I just committed a possible fix for this issue by changing HandlerStrategies.setAutoAssignedValue
to conver the DB-produced auto-assigned value to the Java type the field expects for the given
column.  Bryan, can you test with your SQLServer and/or MySQL driver?
>
>   
>> 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
>>     
>
>   

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message