[jboss-user] [EJB 3.0] New message: "howto setup jpa using oracle 10g unicode nvarchar2"

[Michael Glöckner]

User development,

A new message was posted in the thread "howto setup jpa using oracle 10g unicode nvarchar2":

http://community.jboss.org/message/527586#527586

Author  : Michael Glöckner
Profile : http://community.jboss.org/people/michael.gloeckner

Message:
--------------------------------------------------------------
Hello folks,
 
i like to setup jpa to use oracles nvarchar2 datatyp for string columns. Im using ejb3.0 and oracle 10.2.0.4.0
 
 
I already tried the suggestions made in http://community.jboss.org/message/489679#489679, but the only think which worked out was the following annotation added to the specific String variables.
 
@Column(columnDefinition="nvarchar2")
 
 

 
But this would force me to implement the source code in a oracle database depended way.
Is there any standard way to customize the datasource or the persistence.xml so the jpa framework is switching automatically to nvarchar2.
 
my persistence.xml looks like:
 
   <persistence-unit name="MyPersistentUnit" transaction-type="JTA">
       <jta-data-source>java:/MyDS</jta-data-source>
       <properties>
            <property name="hibernate.hbm2ddl.auto" value="create"/> 
             <property name="hibernate.show_sql" value="true"/>
             <property name="hibernate.dialect" value="org.hibernate.dialect.OracleDialect"/> 
            <property name="jboss.entity.manager.factory.jndi.name" value="java:/MyEjbTestEntityManagerFactory"/>
       </properties>
   </persistence-unit>


My ds.xml file looks like:
 <xa-datasource>
    <jndi-name>MyDS</jndi-name>
    <track-connection-by-tx/>
    <isSameRM-override-value>false</isSameRM-override-value>
    <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
    <xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>
    <xa-datasource-property name="URL">jdbc:oracle:thin:@localhost:1521:XE</xa-datasource-property>
    <xa-datasource-property name="User">user</xa-datasource-property>
    <xa-datasource-property name="Password">password</xa-datasource-property>
    <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
       <no-tx-separate-pools/>
  </xa-datasource>

 
Thanks in advanced,
Micha

--------------------------------------------------------------

To reply to this message visit the message page: http://community.jboss.org/message/527586#527586