Tech-Today

JBoss datasource configuration settings

The following are sample configurations for different database (it's in the file standalone.xml subsystem=datasources):
H2, postgresql, mysql

<datasources>
 <datasource jndi-name="java:jboss/datasources/ExampleDS" pool-name="ExampleDS" enabled="true" use-java-context="true">
  <connection-url>jdbc:h2:mem:test;DB_CLOSE_DELAY=-1</connection-url>
  <driver>h2</driver>
  <security>
   <user-name>sa</user-name>
   <password>sa</password>
  </security>
 </datasource>
 <datasource jta="false" jndi-name="java:jboss/datasources/PostgreDatasource" pool-name="PostgrePool" enabled="true" use-java-context="true" use-ccm="false">
  <connection-url>jdbc:postgresql://localhost:5432/postgre</connection-url>
  <driver-class>org.postgresql.Driver</driver-class>
  <driver>postgresql</driver>
  <pool>
   <min-pool-size>2</min-pool-size>
   <max-pool-size>20</max-pool-size>
  </pool>
  <security>
   <user-name>postgre</user-name>
   <password>postgre</password>
  </security>
  <validation>
   <validate-on-match>false</validate-on-match>
   <background-validation>false</background-validation>
   <background-validation-millis>1</background-validation-millis>
  </validation>
  <statement>
   <prepared-statement-cache-size>10</prepared-statement-cache-size>
   <share-prepared-statements>false</share-prepared-statements>
  </statement>
 </datasource>
 <datasource jta="false" jndi-name="java:jboss/datasources/mysqlDataSource" pool-name="mysqlPool" enabled="true" use-java-context="true" use-ccm="false">
  <connection-url>jdbc:mysql://localhost:3306/mysql</connection-url>
  <driver-class>com.mysql.jdbc.Driver</driver-class>
  <driver>com.mysql</driver>
  <pool>
   <min-pool-size>2</min-pool-size>
   <max-pool-size>20</max-pool-size>
  </pool>
  <security>
   <user-name>mysql</user-name>
   <password>mysql</password>
  </security>
  <validation>
   <validate-on-match>false</validate-on-match>
   <background-validation>false</background-validation>
   <background-validation-millis>1</background-validation-millis>
  </validation>
  <statement>
   <prepared-statement-cache-size>10</prepared-statement-cache-size>
   <share-prepared-statements>false</share-prepared-statements>
  </statement>
 </datasource>

<datasource jndi-name="java:jboss/datasources/VmlaDS" pool-name="vmlaDS" enabled="true" use-java-context="true">
    <connection-url>jdbc:mysql://localhost:3306/vlma</connection-url>
    <driver>mysql</driver>
    <security>
        <user-name>vlma</user-name>
        <password>vlma</password>
    </security>
    <statement>
        <prepared-statement-cache-size>100</prepared-statement-cache-size>
        <share-prepared-statements>true</share-prepared-statements>
    </statement>
</datasource>
 <drivers>

<driver name="mysql" module="com.sql.mysql">
 <driver-class>com.mysql.jdbc.Driver</driver-class>
</driver>
  <driver name="h2" module="com.h2database.h2">
   <xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class>
  </driver>
  <driver name="postgresql" module="org.postgresql">
   <xa-datasource-class>org.postgresql.xa.PGXADataSource</xa-datasource-class>
  </driver>
   <driver name="com.mysql" module="com.mysql">
   <xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class>
  </driver>
 </drivers>
</datasources>

<datasource jndi-name="java:jboss/datasources/germ-popperDS" pool-name="GermPopperPool" enabled="true" use-java-context="true">
 <connection-url>jdbc:jtds:sqlserver://localhost:1433/germpopper;loginTimeout=30;instance=sqlexpress</connection-url>
 <driver>JTDS</driver>
 <new-connection-sql>select 1</new-connection-sql>
 <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
 <pool>
  <min-pool-size>5</min-pool-size>
  <max-pool-size>50</max-pool-size>
 </pool>
 <security>
  <user-name>unicomi</user-name>
  <password>unicomi</password>
 </security>
 <validation>
  <check-valid-connection-sql>select 1</check-valid-connection-sql>
 </validation>
 <timeout>
  <set-tx-query-timeout>true</set-tx-query-timeout>
  <blocking-timeout-millis>5000</blocking-timeout-millis>
  <idle-timeout-minutes>15</idle-timeout-minutes>
 </timeout>
 <statement>
  <track-statements>false</track-statements>
 </statement>
</datasource>

Then add the following modules in: jboss-as-7.1.3.Final\modules

postgresql

create org/postgresql/main
download and paste: postgresql-9.2-1002.jdbc4.jar
create module.xml with these contents

<?xml version="1.0" encoding="UTF-8"?>
<module xmlns="urn:jboss:module:1.0" name="org.postgresql">
 <resources>
 <resource-root path="postgresql-9.2-1002.jdbc4.jar"/>
 </resources>
 <dependencies>
 <module name="javax.api"/>
 <module name="javax.transaction.api"/>
 </dependencies>
</module>

mysql

create com/mysql/main
download mysql-connector-java
create module.xml with these contents

<?xml version="1.0" encoding="UTF-8"?>  
<module xmlns="urn:jboss:module:1.0" name="com.mysql">  
  <resources>  
 <resource-root path="mysql-connector-java-5.1.21.jar"/>  
  </resources>  
  <dependencies>  
 <module name="javax.api"/>  
  </dependencies>  
</module>

MSSQL


<driver name="JTDS" module="net.sourceforge.jtds">
 <driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class>
 <xa-datasource-class>net.sourceforge.jtds.jdbcx.JtdsDataSource</xa-datasource-class>
</driver>

- How To Use Mariadb And Liquibase Together With Maven On Jboss
First you must define the needed dependency in your pom file. <profile> <id>mariadb</id> <activation> <property> <name>env</name> <value>mariadb</value> </property> </activation> <properties>...

- How To Monitor The Data Source Connections And Sql Queries In Jboss
To allow us to debug our jboss server for possible connection leaks, wrong sql queries normally we do 2 changes: 1.) In persistence.xml, set hibernate.show_sql to true 2.) In jboss's standalone.xml, we set the hibernate logger to DEBUG <logger...

- How To Create A Modeshape Datasource Connection For Jboss
<datasource jndi-name="java:/jcr/myportal" pool-name="myJCRPortalPool" enabled="true" use-java-context="true"> <connection-url>jdbc:jcr:jndi:jcr?repositoryName=my</connection-url> <connection-property name="workspace"> extra </connection-property>...

- Jdbc Provider Setting In Java For Postgresql, Mysql And Oracle
Below are the summary of connection settings for differenct jdbc provider: Database Connection Url Driver Class Hibernate Dialect Cache Provider Class PostgreSQL jdbc:postgresql://[host]:[port]/[db] org.postgresql.Driver org.hibernate.dialect.PostgreSQLDialect...

- Things To Remember In Creating Jbpm With Seam
This writing will reference the TODO example from seam: http://docs.jboss.org/seam/latest/reference/en-US/html/tutorial.html#registration-example Note that I used seam-gen to generate the project. File you should have: +views +login.xhtml +todo.xhtml...

Tech-Today