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
_______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
