Spring/JPA/TopLink 11g extensions

[Rune Kvamme]

Hi,

Im currently trying to use Spring/JPA with some TopLink 11g extensions for Conversion but are unable to get this working.
I have tried a lot of different converters but it seems like all my TopLink annotations are ignored.

I would really appriciate all help I can get on this.

Iv included a small "dummy" below.

When using the converter on the class below I was hoping that the generated schema would be like:

CREATE TABLE TYPECONVTEST (ID NUMERIC(19) NOT NULL, AGE VARCHAR2(255), PRIMARY KEY (ID))

But the generated schema is:

CREATE TABLE TYPECONVTEST (ID NUMERIC(19) NOT NULL, AGE INTEGER, PRIMARY KEY (ID))


Dummy example:

import java.io.Serializable;
 
import javax.persistence.Entity;
import javax.persistence.Id;
 
import oracle.toplink.annotations.Convert;
import oracle.toplink.annotations.TypeConverter;
 
@Entity
@TypeConverter(name = "intToString", dataType = String.class, objectType = Integer.class)
public class TypeConvTest implements Serializable {
    
    @Id
    private long id;
    
    @Convert("intToString")
    int age;
    
    public long getId() {
        return this.id;
    }
    
    public void setId(long id) {
        this.id = id;
    }
    
    public int getAge() {
        return this.age;
    }
    
    public void setAge(int age) {
        this.age = age;
    }
}

My Spring configuration is like this:

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xmlns:tx="http://www.springframework.org/schema/tx"
  xsi:schemaLocation="http://www.springframework.org/schema/beans
      <a href="http://www.springframework.org/schema/beans/spring-beans.xsd" target="_blank" rel="nofollow">http://www.springframework.org/schema/beans/spring-beans.xsd</a>
      <a href="http://www.springframework.org/schema/tx" target="_blank" rel="nofollow">http://www.springframework.org/schema/tx</a>
      <a href="http://www.springframework.org/schema/tx/spring-tx.xsd">" target="_blank" rel="nofollow">http://www.springframework.org/schema/tx/spring-tx.xsd"></a>
  
  <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
    <property name="driverClassName" value="org.hsqldb.jdbcDriver" />
    <property name="url" value="jdbc:hsqldb:mem:test" />
    <property name="username" value="sa" />
    <property name="password" value="" />
  </bean>
 
  <bean id="jpaAdapter" class="org.springframework.orm.jpa.vendor.OracleTopLinkJpaVendorAdapter">
    <property name="showSql" value="true" />
    <property name="generateDdl" value="true" />
    <property name="databasePlatform" value="oracle.toplink.platform.database.HSQLPlatform" />
  </bean>
 
  <bean id="entityManagerFactory" class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
    <property name="dataSource" ref="dataSource" />
    <property name="jpaVendorAdapter" ref="jpaAdapter" />
    <property name="jpaProperties">
      <props>
        <prop key="toplink.weaving">static</prop>
        <prop key="toplink.logging.level">FINE</prop>
        <prop key="toplink.ddl-generation">create-tables</prop>
        <prop key="toplink.ddl-generation.output-mode">both</prop>
        <prop key="toplink.drop-ddl-jdbc-file-name">generated_jpa.sql</prop>
        <!-- <prop key="toplink.session.customizer">com.statoil.sas.invpilot.converter.ConverterCustomizer</prop>-->
      </props>
    </property>
  </bean>
  
</beans>

[Mike Keith]

Hi Rune,

Why you are using a type converter if you are generating the schema. Why not just use an int on both sides? Converters are normally used for mapping an object model to a pre-existing legacy database, not when you have the choice to generate a schema.

If you are in a situation (either because you are just performing testing, or for whatever other reason the database you are generating needs to map an int in the object model to a string in the data model then you should be able to use the @Column annotation to explicitly dictate the column to get generated. For example:

@Convert("intToString")
@Column(name="AGE", columnDefinition="VARCHAR2(255)")
int age;

[Rune Kvamme]

Hi Mike,

Thank you for your answer. I realize that the example Iv included was a bit to simple. It was just to illustrate that I did not manage to get any of the Oracle TopLink extensions annotations to work properly.

What Im really trying to do is to write a converter that converts the Eric Evans Time&money library class com.domainlanguage.time.CalendarDate. The CalendarDate class consist of three properties, i.e. year, month and day, which I want to persist as a date column in the database.

We could use embeddable, but this will not be possible due to the JPA limitation with embeddables (embeddable within embeddable).

Im really was hoping that the new feature in TopLink 11g would help me.

BTW. Iv managed to do this with TopLink essentials using a session custimizer, but I really would like to use the annotation style.

public class ConverterCustomizer implements SessionCustomizer {

    /** {@inheritDoc} */
    public void customize(Session session) throws Exception {
        
        RelationalDescriptor descriptor = (RelationalDescriptor) session.getDescriptor(Customer.class);
        
        DirectToFieldMapping mapping = (DirectToFieldMapping) descriptor.getMappingForAttributeName("calendarDate");
        mapping.setConverter(new MyCalendarDateConverter(mapping));
    }
}

Best regards,
Rune

[Mike Keith]

Oh, so your real problem is simply that your annotations don't appear to be getting recognized? I can only think of a few things that could be causing that. Either your class is not being discovered (i.e. it is not packaged in a place where discovery is occurring) or it is not annotated as an entity. Other than that it could only be a configuration error (TopLink not being invoked for that entity, etc).

You can turn logging on to debug mode to see the entities it is finding. Do this by setting your logging property to "FINEST". I have noticed that the Spring "showSQL" property seems to hammer whatever the provider logging property is set to, so you need to remove the Spring property in order to set the logging to any other mode than FINE.

[Rune Kvamme]

Mike,

Thank you for taking interest in my issue.

I have set the logging level to FINEST and can see that my entity class is discovered and that a table is created.

--CREATE TABLE CUSTOMER (ID NUMERIC(19) NOT NULL, AGE NUMERIC(38), CALENDARDATE BINARY, PRIMARY KEY (ID))

The table is however not as expected as the converter annotations are not discovered. Im running the test as a JUnit test and have event tried to set a breakpoint in the converter class. It does not break.

I did however make a small test using a standalone Java application without Spring. Then the converter annotations was discovered and the create table statement was as expected.

--CREATE TABLE CUSTOMER (ID NUMERIC(19) NOT NULL, AGE VARCHAR(255), CALENDARDATE DATE, PRIMARY KEY (ID))

My conclusion is that it must have something to do with my Spring configuration. Could it have something do with not using the oracle.toplink.ejb.cmp3.EntityManagerFactoryProvider directly as I do in the standalone application?

I have included the not working example and my Spring configuration below.

Many thanks
Rune

Entity class

package com.statoil.sas.invpilot.customer.domain;
 
import java.io.Serializable;
 
import javax.persistence.Basic;
import javax.persistence.Entity;
import javax.persistence.Id;
 
import oracle.toplink.annotations.Convert;
import oracle.toplink.annotations.Converter;
import oracle.toplink.annotations.TypeConverter;
import com.statoil.sas.invpilot.converter.CalendarDateConverter;
 
import com.domainlanguage.time.CalendarDate;
 
@Entity
public class Customer implements Serializable {
    
    @Id
    private long id;
    
    @Basic
    @TypeConverter(name = "doubleToString", dataType = String.class, objectType = Float.class)
    @Convert("doubleToString")
    private Number age;
    
    @Basic
    @Converter(name = "convertDate", converterClass = CalendarDateConverter.class)
    @Convert("convertDate")
    private CalendarDate calendarDate;
    
    public CalendarDate getCalendarDate() {
        return this.calendarDate;
    }
    
    public void setCalendarDate(CalendarDate calendarDate) {
        this.calendarDate = calendarDate;
    }
    
    public long getId() {
        return this.id;
    }
    
    public void setId(long id) {
        this.id = id;
    }
    
    public Number getAge() {
        return this.age;
    }
    
    public void setAge(Number age) {
        this.age = age;
    }
    
}

applicationContext.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xmlns:tx="http://www.springframework.org/schema/tx" xsi:schemaLocation="http://www.springframework.org/schema/beans
      <a href="http://www.springframework.org/schema/beans/spring-beans.xsd" target="_blank" rel="nofollow">http://www.springframework.org/schema/beans/spring-beans.xsd</a>
      <a href="http://www.springframework.org/schema/tx" target="_blank" rel="nofollow">http://www.springframework.org/schema/tx</a>
      <a href="http://www.springframework.org/schema/tx/spring-tx.xsd">" target="_blank" rel="nofollow">http://www.springframework.org/schema/tx/spring-tx.xsd"></a>
            
  <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
    <property name="driverClassName" value="org.hsqldb.jdbcDriver" />
    <property name="url" value="jdbc:hsqldb:mem:test" />
    <property name="username" value="sa" />
    <property name="password" value="" />
  </bean>
 
  <bean id="jpaAdapter" class="org.springframework.orm.jpa.vendor.OracleTopLinkJpaVendorAdapter">
    <property name="generateDdl" value="true" />
    <property name="databasePlatform" value="oracle.toplink.platform.database.HSQLPlatform" />
    <property name="database" value="HSQL"/>
  </bean>
 
  <bean id="entityManagerFactory" class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
    <property name="dataSource" ref="dataSource" />
    <property name="jpaVendorAdapter" ref="jpaAdapter" />
    <property name="jpaProperties">
      <props>
        <prop key="toplink.weaving">static</prop>
        <prop key="toplink.logging.level">FINEST</prop>
        <prop key="toplink.ddl-generation">create-tables</prop>
        <prop key="toplink.ddl-generation.output-mode">both</prop>
        <prop key="toplink.drop-ddl-jdbc-file-name">generated_jpa.sql</prop>
      </props>
    </property>
  </bean>
 
  <bean id="transactionManager" class="org.springframework.orm.jpa.JpaTransactionManager">
    <property name="entityManagerFactory" ref="entityManagerFactory" />
    <property name="dataSource" ref="dataSource" />
  </bean>
 
  <bean name="abstractRepository" abstract="true" class="org.springframework.orm.jpa.JpaTemplate">
    <property name="entityManagerFactory" ref="entityManagerFactory" />
  </bean>
 
  <bean id="customerRepository" parent="abstractRepository"  class="com.statoil.sas.invpilot.customer.repository.CustomerRepositoryImpl"/> 
  
</beans>

persistence.xml

<?xml version="1.0" encoding="UTF-8" ?>
<persistence xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xsi:schemaLocation="http://java.sun.com/xml/ns/persistence
        <a href="http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd"" target="_blank" rel="nofollow">http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd"</a>
  version="1.0">
  <persistence-unit name="invpilot" transaction-type="RESOURCE_LOCAL">
 
  </persistence-unit>
</persistence>

orm.xml

I have removed this file since Im only using annotations.

[Mike Keith]

Hi Rune,

DDL generation occurs through a slightly different path in a container than when using the factory API. One possibility is that the TopLink annotations are not recognized in the Container scenario until after the generation. You can test this out in one of two ways.

You can use the Column annotation to cause the correct column type to be generated and then run a few tests that will test whether the types get converted at runtime (if they do then the annotations were indeed detected, they just weren't used at generation-time).

Another thing to try is to change the Spring factory bean to be a LocalEntityManagerFactoryBean instead of a LocalContainerEntityManagerFactoryBean. This will cause Spring to use the regular factory API instead of the special container API and you can compare the results.

[James Sutherland]

Make sure you are using TopLink 11g, not TopLink Essentials in your Spring server. You should see the TopLink version printed in your TopLink log, does it say 11g or Essentials?

[Rune Kvamme]

Hi,

I tried to use the LocalEntityManagerFactoryBean and then the annotations was detected. The log below shows that the default serialization is ignored due to the @Convert annotation.


TopLink Finest]: 2007.11.14 03:34:01.077--ServerSession(32486590)--Thread(Thread[main,5,main])--property=toplink.orm.throw.exceptions; default value=true
[TopLink Finer]: 2007.11.14 03:34:01.077--ServerSession(32486590)--Thread(Thread[main,5,main])--Searching for default mapping file in file:/C:/devtools/NG/eclipse/workspace/JpaTestProject%20-%20TopLink%2011g/target/classes/
[TopLink Config]: 2007.11.14 03:34:01.280--ServerSession(32486590)--Thread(Thread[main,5,main])--The alias name for the entity class [class com.statoil.sas.invpilot.customer.domain.Customer] is being defaulted to: Customer.
[TopLink Config]: 2007.11.14 03:34:01.280--ServerSession(32486590)--Thread(Thread[main,5,main])--The table name for entity [class com.statoil.sas.invpilot.customer.domain.Customer] is being defaulted to: CUSTOMER.
[TopLink Config]: 2007.11.14 03:34:01.312--ServerSession(32486590)--Thread(Thread[main,5,main])--The column name for element [private long com.statoil.sas.invpilot.customer.domain.Customer.id] is being defaulted to: ID.
[TopLink Config]: 2007.11.14 03:34:01.343--ServerSession(32486590)--Thread(Thread[main,5,main])--The column name for element [private java.lang.Number com.statoil.sas.invpilot.customer.domain.Customer.age] is being defaulted to: AGE.
[TopLink Warning]: 2007.11.14 03:34:01.343--ServerSession(32486590)--Thread(Thread[main,5,main])--Ignoring default serialization on element [private java.lang.Number com.statoil.sas.invpilot.customer.domain.Customer.age] within entity class [class com.statoil.sas.invpilot.customer.domain.Customer] since a @Convert is specified.

[TopLink Config]: 2007.11.14 03:34:01.359--ServerSession(32486590)--Thread(Thread[main,5,main])--The column name for element [private com.domainlanguage.time.CalendarDate com.statoil.sas.invpilot.customer.domain.Customer.calendarDate] is being defaulted to: CALENDARDATE.
[TopLink Warning]: 2007.11.14 03:34:01.359--ServerSession(32486590)--Thread(Thread[main,5,main])--Ignoring default serialization on element [private com.domainlanguage.time.CalendarDate com.statoil.sas.invpilot.customer.domain.Customer.calendarDate] within entity class [class com.statoil.sas.invpilot.customer.domain.Customer] since a @Convert is specified.
[TopLink Finest]: 2007.11.14 03:34:01.374--ServerSession(32486590)--Thread(Thread[main,5,main])--End predeploying Persistence Unit invpilot; state Predeployed; factoryCount 0
[TopLink Finer]: 2007.11.14 03:34:01.374--Thread(Thread[main,5,main])--cmp_init_transformer_is_null

Then, when using the LocalContainerEntityManagerFactoryBean I get the following log. As you can see, there is no indication of any Converters:-(

14.nov.2007 15:23:37 org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions
INFO: Loading XML bean definitions from class path resource [applicationContext.xml]
14.nov.2007 15:23:37 org.springframework.context.support.AbstractApplicationContext prepareRefresh
INFO: Refreshing org.springframework.context.support.GenericApplicationContext@1ce784b: display name [org.springframework.context.support.GenericApplicationContext@1ce784b]; startup date [Wed Nov 14 15:23:37 CET 2007]; root of context hierarchy
14.nov.2007 15:23:37 org.springframework.context.support.AbstractApplicationContext obtainFreshBeanFactory
INFO: Bean factory for application context [org.springframework.context.support.GenericApplicationContext@1ce784b]: org.springframework.beans.factory.support.DefaultListableBeanFactory@12884e0
14.nov.2007 15:23:37 org.springframework.context.support.AbstractApplicationContext$BeanPostProcessorChecker postProcessAfterInitialization
INFO: Bean 'org.springframework.aop.config.internalAutoProxyCreator' is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
14.nov.2007 15:23:37 org.springframework.beans.factory.support.DefaultListableBeanFactory preInstantiateSingletons
INFO: Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@12884e0: defining beans [org.springframework.aop.config.internalAutoProxyCreator,org.springframework.transaction.interceptor.TransactionAttributeSourceAdvisor,dataSource,jpaAdapter,entityManagerFactory,transactionManager,abstractRepository,customerRepository]; root of factory hierarchy
14.nov.2007 15:23:37 org.springframework.jdbc.datasource.DriverManagerDataSource setDriverClassName
INFO: Loaded JDBC driver: org.hsqldb.jdbcDriver
14.nov.2007 15:23:37 org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean createNativeEntityManagerFactory
INFO: Building JPA container EntityManagerFactory for persistence unit 'invpilot'
[TopLink Finest]: 2007.11.14 03:23:38.136--ServerSession(3874616)--Thread(Thread[main,5,main])--Begin predeploying Persistence Unit invpilot; state Initial; factoryCount 0
[TopLink Finest]: 2007.11.14 03:23:38.167--ServerSession(3874616)--Thread(Thread[main,5,main])--property=toplink.weaving; value=false
[TopLink Finest]: 2007.11.14 03:23:38.167--ServerSession(3874616)--Thread(Thread[main,5,main])--property=toplink.orm.throw.exceptions; default value=true
[TopLink Finer]: 2007.11.14 03:23:38.198--ServerSession(3874616)--Thread(Thread[main,5,main])--Searching for default mapping file in file:/C:/devtools/NG/eclipse/workspace/JpaTestProject%20-%20TopLink%2011g/target/classes/
[TopLink Config]: 2007.11.14 03:23:38.433--ServerSession(3874616)--Thread(Thread[main,5,main])--The alias name for the entity class [class com.statoil.sas.invpilot.customer.domain.Customer] is being defaulted to: Customer.
[TopLink Config]: 2007.11.14 03:23:38.433--ServerSession(3874616)--Thread(Thread[main,5,main])--The table name for entity [class com.statoil.sas.invpilot.customer.domain.Customer] is being defaulted to: CUSTOMER.
[TopLink Config]: 2007.11.14 03:23:38.480--ServerSession(3874616)--Thread(Thread[main,5,main])--The column name for element [private long com.statoil.sas.invpilot.customer.domain.Customer.id] is being defaulted to: ID.
[TopLink Config]: 2007.11.14 03:23:38.511--ServerSession(3874616)--Thread(Thread[main,5,main])--The column name for element [private java.lang.Number com.statoil.sas.invpilot.customer.domain.Customer.age] is being defaulted to: AGE.
[TopLink Config]: 2007.11.14 03:23:38.511--ServerSession(3874616)--Thread(Thread[main,5,main])--The column name for element [private com.domainlanguage.time.CalendarDate com.statoil.sas.invpilot.customer.domain.Customer.calendarDate] is being defaulted to: CALENDARDATE.
[TopLink Finest]: 2007.11.14 03:23:38.526--ServerSession(3874616)--Thread(Thread[main,5,main])--End predeploying Persistence Unit invpilot; state Predeployed; factoryCount 1
[TopLink Finest]: 2007.11.14 03:23:39.230--ServerSession(3874616)--Thread(Thread[main,5,main])--Begin deploying Persistence Unit invpilot; state Predeployed; factoryCount 1
[TopLink Finest]: 2007.11.14 03:23:39.276--ServerSession(3874616)--Thread(Thread[main,5,main])--property=toplink.logging.level; value=FINEST; translated value=FINEST
[TopLink Finest]: 2007.11.14 03:23:39.276--ServerSession(3874616)--Thread(Thread[main,5,main])--property=toplink.logging.level; value=FINEST; translated value=FINEST
[TopLink Finest]: 2007.11.14 03:23:39.276--ServerSession(3874616)--Thread(Thread[main,5,main])--property=toplink.target-database; value=oracle.toplink.platform.database.HSQLPlatform
[TopLink Info]: 2007.11.14 03:23:39.276--ServerSession(3874616)--Thread(Thread[main,5,main])--TopLink, version: Oracle TopLink - 11g Technology Preview 2 (11.1.1.0.0) (Build 070830)
14.nov.2007 15:23:39 org.springframework.test.AbstractTransactionalSpringContextTests startNewTransaction
INFO: Began transaction (1): transaction manager [org.springframework.orm.jpa.JpaTransactionManager@5a2eaa]; default rollback = true
14.nov.2007 15:23:39 org.springframework.test.AbstractTransactionalSpringContextTests endTransaction
INFO: Rolled back transaction after test execution
[TopLink Config]: 2007.11.14 03:23:39.308--ServerSession(3874616)--Connection(17567590)--Thread(Thread[main,5,main])--connecting(DatabaseLogin(
platform=>HSQLPlatform
user name=> ""
connector=>JNDIConnector datasource name=>null
))
[TopLink Config]: 2007.11.14 03:23:39.542--ServerSession(3874616)--Connection(749304)--Thread(Thread[main,5,main])--Connected: jdbc:hsqldb:mem:test
User: SA
Database: HSQL Database Engine  Version: 1.8.0
Driver: HSQL Database Engine Driver  Version: 1.8.0
[TopLink Config]: 2007.11.14 03:23:39.542--ServerSession(3874616)--Connection(10656878)--Thread(Thread[main,5,main])--connecting(DatabaseLogin(
platform=>HSQLPlatform
user name=> ""
connector=>JNDIConnector datasource name=>null
))
[TopLink Config]: 2007.11.14 03:23:39.542--ServerSession(3874616)--Connection(30149247)--Thread(Thread[main,5,main])--Connected: jdbc:hsqldb:mem:test
User: SA
Database: HSQL Database Engine  Version: 1.8.0
Driver: HSQL Database Engine Driver  Version: 1.8.0
[TopLink Finest]: 2007.11.14 03:23:39.589--ServerSession(3874616)--Thread(Thread[main,5,main])--sequencing connected, state is Preallocation_Transaction_NoAccessor_State
[TopLink Finest]: 2007.11.14 03:23:39.589--ServerSession(3874616)--Thread(Thread[main,5,main])--sequence SEQ_GEN: preallocation size 50
[TopLink Info]: 2007.11.14 03:23:39.651--ServerSession(3874616)--Thread(Thread[main,5,main])--file:/C:/devtools/NG/eclipse/workspace/JpaTestProject%20-%20TopLink%2011g/target/classes/-invpilot login successful
[TopLink Finest]: 2007.11.14 03:23:39.683--ServerSession(3874616)--Thread(Thread[main,5,main])--Execute query DataModifyQuery()
[TopLink Finest]: 2007.11.14 03:23:39.683--ServerSession(3874616)--Thread(Thread[main,5,main])--reconnecting to external connection pool
[TopLink Fine]: 2007.11.14 03:23:39.683--ServerSession(3874616)--Connection(13129484)--Thread(Thread[main,5,main])--DROP TABLE CUSTOMER
[TopLink Warning]: 2007.11.14 03:23:39.698--ServerSession(3874616)--Thread(Thread[main,5,main])--Exception [TOPLINK-4002] (Oracle TopLink - 11g Technology Preview 2 (11.1.1.0.0) (Build 070830)): oracle.toplink.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Table not found: CUSTOMER in statement [DROP TABLE CUSTOMER]
Error Code: -22
Call: DROP TABLE CUSTOMER
Query: DataModifyQuery()
[TopLink Finest]: 2007.11.14 03:23:39.698--ServerSession(3874616)--Thread(Thread[main,5,main])--Execute query DataModifyQuery()
[TopLink Finest]: 2007.11.14 03:23:39.698--ServerSession(3874616)--Thread(Thread[main,5,main])--reconnecting to external connection pool
[TopLink Fine]: 2007.11.14 03:23:39.698--ServerSession(3874616)--Connection(11349040)--Thread(Thread[main,5,main])--CREATE TABLE CUSTOMER (ID NUMERIC(19) NOT NULL, AGE NUMERIC(38), CALENDARDATE BINARY, HUGE_SALERY NUMERIC(19), PRIMARY KEY (ID))
[TopLink Finest]: 2007.11.14 03:23:39.698--ServerSession(3874616)--Thread(Thread[main,5,main])--Execute query DataModifyQuery()
[TopLink Finest]: 2007.11.14 03:23:39.698--ServerSession(3874616)--Thread(Thread[main,5,main])--reconnecting to external connection pool
[TopLink Fine]: 2007.11.14 03:23:39.698--ServerSession(3874616)--Connection(4781685)--Thread(Thread[main,5,main])--CREATE TABLE SEQUENCE (SEQ_NAME VARCHAR(50) NOT NULL, SEQ_COUNT NUMERIC(38), PRIMARY KEY (SEQ_NAME))
[TopLink Finest]: 2007.11.14 03:23:39.698--ServerSession(3874616)--Thread(Thread[main,5,main])--Execute query DataModifyQuery()
[TopLink Finest]: 2007.11.14 03:23:39.714--ServerSession(3874616)--Thread(Thread[main,5,main])--reconnecting to external connection pool
[TopLink Fine]: 2007.11.14 03:23:39.714--ServerSession(3874616)--Connection(2920707)--Thread(Thread[main,5,main])--DELETE FROM SEQUENCE WHERE SEQ_NAME = 'SEQ_GEN'
[TopLink Finest]: 2007.11.14 03:23:39.714--ServerSession(3874616)--Thread(Thread[main,5,main])--Execute query DataReadQuery()
[TopLink Finest]: 2007.11.14 03:23:39.714--ServerSession(3874616)--Thread(Thread[main,5,main])--reconnecting to external connection pool
[TopLink Fine]: 2007.11.14 03:23:39.714--ServerSession(3874616)--Connection(17165167)--Thread(Thread[main,5,main])--SELECT * FROM SEQUENCE WHERE SEQ_NAME = 'SEQ_GEN'
[TopLink Finest]: 2007.11.14 03:23:39.714--ServerSession(3874616)--Thread(Thread[main,5,main])--Execute query DataModifyQuery()
[TopLink Finest]: 2007.11.14 03:23:39.714--ServerSession(3874616)--Thread(Thread[main,5,main])--reconnecting to external connection pool
[TopLink Fine]: 2007.11.14 03:23:39.714--ServerSession(3874616)--Connection(7099522)--Thread(Thread[main,5,main])--INSERT INTO SEQUENCE(SEQ_NAME, SEQ_COUNT) values ('SEQ_GEN', 1)
[TopLink Finest]: 2007.11.14 03:23:39.730--ServerSession(3874616)--Thread(Thread[main,5,main])--End deploying Persistence Unit invpilot; state Deployed; factoryCount 1
[TopLink Finer]: 2007.11.14 03:23:39.761--ServerSession(3874616)--Thread(Thread[main,5,main])--client acquired
[TopLink Finer]: 2007.11.14 03:23:39.761--ClientSession(9518529)--Connection(23953814)--Thread(Thread[main,5,main])--begin transaction
[TopLink Finest]: 2007.11.14 03:23:39.761--ClientSession(9518529)--Thread(Thread[main,5,main])--reconnecting to external connection pool
[TopLink Finest]: 2007.11.14 03:23:39.792--UnitOfWork(7310123)--Thread(Thread[main,5,main])--Execute query DoesExistQuery()
[TopLink Finest]: 2007.11.14 03:23:39.808--UnitOfWork(7310123)--Thread(Thread[main,5,main])--PERSIST operation called on: com.statoil.sas.invpilot.customer.domain.Customer@15bfdbd.
[TopLink Finest]: 2007.11.14 03:23:39.808--ClientSession(9518529)--Thread(Thread[main,5,main])--Execute query DataModifyQuery()
[TopLink Fine]: 2007.11.14 03:23:39.808--ClientSession(9518529)--Connection(25862088)--Thread(Thread[main,5,main])--UPDATE SEQUENCE SET SEQ_COUNT = SEQ_COUNT + ? WHERE SEQ_NAME = ?
bind => [50, SEQ_GEN]
[TopLink Finest]: 2007.11.14 03:23:39.808--ClientSession(9518529)--Thread(Thread[main,5,main])--Execute query ValueReadQuery()
[TopLink Fine]: 2007.11.14 03:23:39.808--ClientSession(9518529)--Connection(25862088)--Thread(Thread[main,5,main])--SELECT SEQ_COUNT FROM SEQUENCE WHERE SEQ_NAME = ?
bind => [SEQ_GEN]
[TopLink Finest]: 2007.11.14 03:23:39.808--ClientSession(9518529)--Connection(25862088)--Thread(Thread[main,5,main])--local sequencing preallocation for SEQ_GEN: objects: 50 , first: 2, last: 51
[TopLink Finest]: 2007.11.14 03:23:39.808--UnitOfWork(7310123)--Thread(Thread[main,5,main])--assign sequence to the object (2 -> com.statoil.sas.invpilot.customer.domain.Customer@15bfdbd)
[TopLink Finer]: 2007.11.14 03:23:39.823--UnitOfWork(7310123)--Thread(Thread[main,5,main])--release unit of work
[TopLink Finer]: 2007.11.14 03:23:39.823--ClientSession(9518529)--Connection(25862088)--Thread(Thread[main,5,main])--rollback transaction
[TopLink Finest]: 2007.11.14 03:23:39.823--ServerSession(3874616)--Connection(25862088)--Thread(Thread[main,5,main])--local sequencing preallocation is discarded after transaction roll back
[TopLink Finer]: 2007.11.14 03:23:39.823--UnitOfWork(7310123)--Thread(Thread[main,5,main])--initialize identitymaps
[TopLink Finer]: 2007.11.14 03:23:39.823--ClientSession(9518529)--Thread(Thread[main,5,main])--client released

As you can see Im using TopLink 11g. Have any of you tried using toplink 11g annotations successfully with Spring LocalContainerEntityManagerFactoryBean?

Still struggling and hoping:-)

Best regards,
Rune

[James Sutherland]

Very odd, the only thing I can think of is that you are deploying different code somehow with the Container deployment. Try changing something else in the class and see if it is picked up.

If still no luck, try other annotations add see if they have the same issue.

[Rune Kvamme]

Hi James,

I have tried to use several different annotations and have also changed different parts of the entity. It all results in the same, TopLink annotations not beeing discovered when using the LocalContainerEntityManagerFactoryBean and not discovered when using the LocalEntityManagerFactoryBean.

Im not really deploying to a server as Im running it withing Eclipse. Could that be a problem?

Is it at all possible that this is a bug?

Have you tried this before? Do you have any working examples?

I could of course email you my test project, but I guess you are to busy to test it, or?:-)

Many thanks,
Rune

[Rune Kvamme]

Hi again,

Another question,

Is it possible to configure a converter using an alternative approach?
I know it is possible using a session customizer, but is it possible to configure this in the orm.xml?

Best regards,
Rune

[Mike Keith]

Hi Rune,

I think there actually is a problem with using Container API in Spring with TopLink-specific annotations. I tried it out and the container classloader in Spring loads them in a different classloader than what is expected. I could give you a patch for the Spring classloader class, but if you are not running in a server then you may as well just use the LocalEntityManagerFactoryBean. You are not losing anything at all, and you would just need to specify the TopLink agent jar when you start the application and you would get all the weaving, etc.

[Rune Kvamme]

Hi Mike,

Thank you very much, I really appriciate your help. We will be running our applications within a container, its just for testing purposes I have been running outside the container.

If you could supply me with at a patch for the Spring class loader I would be very greatful. Is this a bug in Spring or TopLink? Do you think it will will be fixed?

Many thanks:-)

Best regards,
Rune

[Mike Keith]

Rune,

I wouldn't really consider it a bug in either Spring or TopLink, since both are actually correctly fulfilling their roles as Container and Provider using the SPI. The problem seems to be a side-effect of a few things mixed together. We will have to get together with the Spring guys and work out the best way to fix it long-term. The simplest fix is to put some code in the Spring classloader, but that might not be the best long-term solution. I will send you the patch.