JBoss Configurations For Databases:
Cofiguring jboss:

JBOSS-MySQL Enterprise Setup:-
==========================================
1. Download/Copy mysql-connector-java-5.1.13-bin.jar to "server/default/lib" of JBOSS
2. Comment out hsqldb-ds.xml like ~hsqldb-ds.xml~ from path server/default/deploy (This is default Hipersonic Database configuration)
3. Comment out hsqldb-persistence-service.xml like ~hsqldb-persistence-service.xml~ from path server/default/deploy/messaging.
4. Add the files to respective paths(server/default/deploy) from "deploy" folder I have sent.
5. Create a empty database in MySQL (Ex. 247_Enterprise)
5. After copy mysql-ds.xml from "deploy" to "server/default/deploy", change the DB Configurations in the XML for the above created "FIC_Enterprise" database.
6. Place all the WAR files in "server/default/deploy" path.
7. start the JBOSS server to access applicaiton in Browser: http://localhost:8080/<your application>

My Sql DataBase:
Driver: Mysql driver
Configuration (mysql-ds.xml):

Hibernate SQL Dialects: org.hibernate.dialect.MySQLDialect(all oracle Versions)

(dielect Details) http://www.javabeat.net/qna/163-list-of-hibernate-sql-dialects/ 


<?xml version="1.0" encoding="UTF-8"?>

<!-- See http://www.jboss.org/community/wiki/Multiple1PC for information about local-tx-datasource -->
<!-- $Id: mysql-ds.xml 88948 2009-05-15 14:09:08Z jesper.pedersen $ -->
<!--  Datasource config for MySQL using 3.0.9 available from:
http://www.mysql.com/downloads/api-jdbc-stable.html
-->

<datasources>
  <local-tx-datasource>
    <jndi-name>DefaultDs</jndi-name>
    <connection-url>jdbc:mysql://localhost:3306/jbossdb</connection-url>
    <driver-class>com.mysql.jdbc.Driver</driver-class>
    <user-name>root</user-name>
    <password>root</password>
    <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>
    <!-- should only be used on drivers after 3.22.1 with "ping" support
    <valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLValidConnectionChecker</valid-connection-checker-class-name>
    -->
    <!-- sql to call when connection is created
    <new-connection-sql>some arbitrary sql</new-connection-sql>
      -->
    <!-- sql to call on an existing pooled connection when it is obtained from pool - MySQLValidConnectionChecker is preferred for newer drivers
    <check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>
      -->

    <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->
    <metadata>
       <type-mapping>mySQL</type-mapping>
    </metadata>
  </local-tx-datasource>
</datasources>


Oracle Database:

Driver: Oracle driver
Configuration (oracle-ds.xml):

Hibernate SQL Dialects: org.hibernate.dialect.OracleDialect(all oracle Versions)

<?xml version="1.0" encoding="UTF-8"?>


<!-- ===================================================================== -->
<!--                                                                       -->
<!--  JBoss Server Configuration                                           -->
<!--                                                                       -->
<!-- ===================================================================== -->


<!-- See http://www.jboss.org/community/wiki/Multiple1PC for information about local-tx-datasource -->
<!-- $Id: oracle-ds.xml 88948 2009-05-15 14:09:08Z jesper.pedersen $ -->
<!-- ==================================================================== -->
<!--  Datasource config for Oracle originally from Steven Coy             -->
<!-- ==================================================================== -->




<datasources>
  <local-tx-datasource>
    <jndi-name>DefaultDS</jndi-name>
    <connection-url>jdbc:oracle:thin:@127.0.0.1:1521:XE</connection-url>
<!--


Here are a couple of the possible OCI configurations.
For more information, see http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/java.920/a96654/toc.htm


<connection-url>jdbc:oracle:oci:@youroracle-tns-name</connection-url>
or
<connection-url>jdbc:oracle:oci:@(description=(address=(host=youroraclehost)(protocol=tcp)(port=1521))(connect_data=(SERVICE_NAME=yourservicename)))</connection-url>


Clearly, its better to have TNS set up properly.
-->
    <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
    <user-name>jboss</user-name>
    <password>jboss</password>
    <!-- Uses the pingDatabase method to check a connection is still valid before handing it out from the pool -->
    <!--valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker</valid-connection-checker-class-name-->
    <!-- Checks the Oracle error codes and messages for fatal errors -->
    <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
        <!-- sql to call when connection is created
        <new-connection-sql>some arbitrary sql</new-connection-sql>
        -->


        <!-- sql to call on an existing pooled connection when it is obtained from pool - the OracleValidConnectionChecker is prefered
        <check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>
        -->


      <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->
      <metadata>
         <type-mapping>Oracle9i</type-mapping>
      </metadata>
  </local-tx-datasource>


</datasources>

MSSql Database:

Driver: sqljdbc4.jar

sqljdbc.jar

Configuration (mssql-ds.xml):

Steps To Configure MsSql database with Jboss:

1. download and unZip the mssql driver.exe (Microsoft SQL Server JDBC Driver 3.0\sqljdbc_3.0\enu) unZiped folder will be like this.
2. navigate to (Microsoft SQL Server JDBC Driver 3.0\sqljdbc_3.0\enu) copy sqljdbc4.jar to "server/default/lib" of JBOSS.
3. add sqljdbc4.jar to ur class path in environment variables.
4. open SQL server Configuration manager --> SQL server Network COnfiguration -->protocols for SQLEXPRESS-->Enable TCP/IP
5. Disable The Fire wall.
6. Note:
7. sqljdbc4.jar for JRE 6.0 +
8. for lower version use sqljdbc.jar

example for Connection Url:

server name\instance name(naveen-pc\MSQLExpress) 

Hibernate SQL Dialects: org.hibernate.dialect.SQLServerDialect(all MsSQl Versions)

MSSQL-ds.Xml

<?xml version="1.0" encoding="UTF-8"?>

<datasources>

  <local-tx-datasource>

  <jndi-name>DefaultDS</jndi-name>

  <connection-url>jdbc:sqlserver://server name\instance name;DatabaseName=jbossdb</connection-url>

  <driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>

  <user-name>jbossdb</user-name>

  <password>jbossdb</password>

  <check-valid-connection-sql>SELECT 1 FROM sysobjects</check-valid-connection-sql>

  <metadata>

 <type-mapping>MS SQLSERVER2000</type-mapping>

  </metadata>

  </local-tx-datasource>

</datasources>