I use the following for PostgreSQL:
In JBOSS_HOME/conf/jboss.conf:
<MLET CODE = "org.jboss.jdbc.DataSourceImpl"
ARCHIVE="jboss.jar,jdbc2_0-stdext.jar" CODEBASE="../lib/ext/">
<ARG TYPE="java.lang.String"
VALUE="jdbc:postgresql://<host>/<database>">
<ARG TYPE="java.lang.String" VALUE="PostgreSQLPool">
<ARG TYPE="java.lang.String" VALUE="postgresql.Driver">
<ARG TYPE="java.lang.String" VALUE="<user name>">
<ARG TYPE="java.lang.String" VALUE="<password>">
</MLET>
In jboss.properties:
jdbc.drivers=postgresql.Driver
In the jaws.xml of the deployed bean, the above-mentioned DataSource
must be specified. The default PostgreSQL mappings, by rthe way, don't
seem to work in my setup, so I've added to the jaws.xml file, too:
<jaws>
<datasource>PostgreSQLPool</datasource>
<type-mapping>PostgreSQL</type-mapping>
<type-mappings>
<type-mapping>
<name>PostgreSQL</name>
<mapping>
<java-type>java.lang.Boolean</java-type>
<jdbc-type></jdbc-type>
<sql-type>BIT</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Short</java-type>
<jdbc-type>INTEGER</jdbc-type>
<sql-type>INTEGER</sql-type>
</mapping>
<mapping>
<java-type>java.util.Date</java-type>
<jdbc-type>DATE</jdbc-type>
<sql-type>DATE</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Double</java-type>
<jdbc-type>DOUBLE</jdbc-type>
<sql-type>FLOAT8</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Character</java-type>
<jdbc-type>CHAR</jdbc-type>
<sql-type>CHAR</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Object</java-type>
<jdbc-type>BLOB</jdbc-type>
<sql-type>BLOB</sql-type>
</mapping>
<mapping>
<java-type>java.sql.TimeStamp</java-type>
<jdbc-type>TIMESTAMP</jdbc-type>
<sql-type>TIMESTAMP</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Integer</java-type>
<jdbc-type>INTEGER</jdbc-type>
<sql-type>INTEGER</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Byte</java-type>
<jdbc-type>TINYINT</jdbc-type>
<sql-type>TINYINT</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Float</java-type>
<jdbc-type>FLOAT</jdbc-type>
<sql-type>FLOAT4</sql-type>
</mapping>
<mapping>
<java-type>java.lang.String</java-type>
<jdbc-type>VARCHAR</jdbc-type>
<sql-type>TEXT</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Long</java-type>
<jdbc-type>BIGINT</jdbc-type>
<sql-type>BIGINT</sql-type>
</mapping>
</type-mapping>
</type-mappings>
</jaws>
Hope it helps
--
"Es tristi di pidil, piru is mas tristi di pidil un duminiu .es"
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
