JBoss Community

Hibernate Dialect for DefaultDS

created by Frank Langelage in Datasource Configuration - View the full discussion

Using JBoss-6.0.0-SNAPSHOT, how can I specify the hibernate dialect to use for the DefaultDS?

The default hsqldb-ds.xml was replaced by this:

<?xml version="1.0" encoding="UTF-8"?>
<datasources>
<xa-datasource>
    <jndi-name>DefaultDS</jndi-name>
    <track-connection-by-tx/>
    <isSameRM-override-value>false</isSameRM-override-value>
    <xa-datasource-class>com.informix.jdbcx.IfxXADataSource</xa-datasource-class>
    <xa-datasource-property name="IfxIFXHOST">sb2000</xa-datasource-property>
    <xa-datasource-property name="PortNumber">9088</xa-datasource-property>
    <xa-datasource-property name="DatabaseName">jboss6</xa-datasource-property>
    <xa-datasource-property name="ServerName">sb2000_net</xa-datasource-property>
    <xa-datasource-property name="User">xxx</xa-datasource-property>
    <xa-datasource-property name="Password">xxx</xa-datasource-property>
    <xa-datasource-property name="IfxLOBCACHE">-1</xa-datasource-property>
    <user-name>xxx</user-name>
    <password>xxx</password>
    <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.InformixExceptionSorter</exception-sorter-class-name>
    <metadata>
       <type-mapping>InformixDB</type-mapping>
    </metadata>
</xa-datasource>
</datasources>

Using a database config from an ear file, the ear comes with an persistence.xml file which specifies the hibernate dialect, as InformixDialect in this case.

Reply to this message by going to Community

Start a new discussion in Datasource Configuration at Community