Version 1

    hi i'm new baby for Jboss:D

    this error few day my headache.

    javax.persistence.PersistenceException: Exception [EclipseLink-4003] (Eclipse Persistence Services - 2.3.1.v20111018-r10243): org.eclipse.persistence.exceptions.DatabaseException

    Exception Description: Configuration error.  Class [com.microsoft.jdbc.sqlserver.SQLServerDriver] not found.

     

    my standalone.xml

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

     

     

    <server xmlns="urn:jboss:domain:1.1">

     

     

        <extensions>

            <extension module="org.jboss.as.clustering.infinispan"/>

            <extension module="org.jboss.as.configadmin"/>

            <extension module="org.jboss.as.connector"/>

            <extension module="org.jboss.as.deployment-scanner"/>

            <extension module="org.jboss.as.ee"/>

            <extension module="org.jboss.as.ejb3"/>

            <extension module="org.jboss.as.jaxrs"/>

            <extension module="org.jboss.as.jdr"/>

            <extension module="org.jboss.as.jmx"/>

            <extension module="org.jboss.as.jpa"/>

            <extension module="org.jboss.as.logging"/>

            <extension module="org.jboss.as.mail"/>

            <extension module="org.jboss.as.naming"/>

            <extension module="org.jboss.as.osgi"/>

            <extension module="org.jboss.as.pojo"/>

            <extension module="org.jboss.as.remoting"/>

            <extension module="org.jboss.as.sar"/>

            <extension module="org.jboss.as.security"/>

            <extension module="org.jboss.as.threads"/>

            <extension module="org.jboss.as.transactions"/>

            <extension module="org.jboss.as.web"/>

            <extension module="org.jboss.as.webservices"/>

            <extension module="org.jboss.as.weld"/>

        </extensions>

     

     

        <management>

            <security-realms>

                <security-realm name="ManagementRealm">

                    <authentication>

                        <properties path="mgmt-users.properties" relative-to="jboss.server.config.dir"/>

                    </authentication>

                </security-realm>

                <security-realm name="ApplicationRealm">

                    <authentication>

                        <properties path="application-users.properties" relative-to="jboss.server.config.dir"/>

                    </authentication>

                </security-realm>

            </security-realms>

            <management-interfaces>

                <native-interface security-realm="ManagementRealm">

                    <socket-binding native="management-native"/>

                </native-interface>

                <http-interface security-realm="ManagementRealm">

                    <socket-binding http="management-http"/>

                </http-interface>

            </management-interfaces>

        </management>

     

     

        <profile>

            <subsystem xmlns="urn:jboss:domain:logging:1.1">

                <console-handler name="CONSOLE">

                    <level name="INFO"/>

                    <formatter>

                        <pattern-formatter pattern="%d{HH:mm:ss,SSS} %-5p [%c] (%t) %s%E%n"/>

                    </formatter>

                </console-handler>

                <periodic-rotating-file-handler name="FILE">

                    <formatter>

                        <pattern-formatter pattern="%d{HH:mm:ss,SSS} %-5p [%c] (%t) %s%E%n"/>

                    </formatter>

                    <file relative-to="jboss.server.log.dir" path="server.log"/>

                    <suffix value=".yyyy-MM-dd"/>

                    <append value="true"/>

                </periodic-rotating-file-handler>

                <logger category="com.arjuna">

                    <level name="WARN"/>

                </logger>

                <logger category="org.apache.tomcat.util.modeler">

                    <level name="WARN"/>

                </logger>

                <logger category="sun.rmi">

                    <level name="WARN"/>

                </logger>

                <logger category="jacorb">

                    <level name="WARN"/>

                </logger>

                <logger category="jacorb.config">

                    <level name="ERROR"/>

                </logger>

                <root-logger>

                    <level name="INFO"/>

                    <handlers>

                        <handler name="CONSOLE"/>

                        <handler name="FILE"/>

                    </handlers>

                </root-logger>

            </subsystem>

            <subsystem xmlns="urn:jboss:domain:configadmin:1.0"/>

            <subsystem xmlns="urn:jboss:domain:datasources:1.0">

                <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:/testMysql" pool-name="Iserver-mysql" enabled="true" use-ccm="false">

                        <connection-url>jdbc:mysql://192.168.100.2:3306/SystemInfo</connection-url>

                        <driver-class>com.mysql.jdbc.Driver</driver-class>

                        <driver>mysql</driver>

                        <security>

                            <user-name>root</user-name>

                            <password>yDzqgk4odmL8s41$AjEL0g#yAMV6l_</password>

                        </security>

                        <validation>

                            <validate-on-match>false</validate-on-match>

                            <background-validation>false</background-validation>

                            <background-validation-millis>0</background-validation-millis>

                        </validation>

                        <statement>

                            <prepared-statement-cache-size>0</prepared-statement-cache-size>

                            <share-prepared-statements>false</share-prepared-statements>

                        </statement>

                    </datasource>

                    <datasource jta="true" jndi-name="java:/test" pool-name="school" enabled="true" use-ccm="false">

                        <connection-url>jdbc:jtds://192.168.100.5:1433/ADiamond;tds=8.0;lastupdatecount=true;tds=8.0;lastupdatecount=true;prepareSQL=0&lt;/connection-url></connection-url>

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

                        <driver>mssql</driver>

                        <transaction-isolation>TRANSACTION_NONE</transaction-isolation>

                        <security>

                            <user-name>sa</user-name>

                            <password>diamond</password>

                        </security>

                        <validation>

                            <validate-on-match>false</validate-on-match>

                            <background-validation>false</background-validation>

                            <background-validation-millis>0</background-validation-millis>

                        </validation>

                        <statement>

                            <prepared-statement-cache-size>0</prepared-statement-cache-size>

                            <share-prepared-statements>false</share-prepared-statements>

                        </statement>

                    </datasource>

                    <datasource jta="true" jndi-name="java:/jon" pool-name="jon" enabled="true" use-ccm="false">

                        <connection-url>jdbc:jtds:sqlserver://192.168.100.5:1433/ADiamond</connection-url>

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

                        <driver>sqljdbc4.jar</driver>

                        <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>

                        <security>

                            <user-name>sa</user-name>

                            <password>diamond</password>

                        </security>

                        <validation>

                            <validate-on-match>false</validate-on-match>

                            <background-validation>false</background-validation>

                            <background-validation-millis>0</background-validation-millis>

                        </validation>

                        <statement>

                            <prepared-statement-cache-size>0</prepared-statement-cache-size>

                            <share-prepared-statements>false</share-prepared-statements>

                        </statement>

                    </datasource>

                    <drivers>

                        <driver name="h2" module="com.h2database.h2">

                            <xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class>

                        </driver>

                        <driver name="oracle" module="com.oracle.ojdbc6">

                            <xa-datasource-class>oracle.jdbc.OracleDriver</xa-datasource-class>

                        </driver>

                        <driver name="mysql" module="com.mysql.jdbc">

                            <xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class>

                        </driver>

                        <driver name="MSSQLXA" module="com.microsoft.sqlserver">

                            <xa-datasource-class>com.microsoft.sqlserver.jdbc.SQLServerXADataSource</xa-datasource-class>

                        </driver>

                        <driver name="mssql" module="net.sourceforge.jtds">

                            <xa-datasource-class>net.sourceforge.jtds.jdbcx.JtdsDataSource</xa-datasource-class>

                        </driver>

                    </drivers>

                </datasources>

            </subsystem>

            <subsystem xmlns="urn:jboss:domain:deployment-scanner:1.1">

                <deployment-scanner path="deployments" relative-to="jboss.server.base.dir" scan-interval="5000"/>

            </subsystem>

            <subsystem xmlns="urn:jboss:domain:ee:1.0"/>

            <subsystem xmlns="urn:jboss:domain:ejb3:1.2">

                <session-bean>

                    <stateless>

                        <bean-instance-pool-ref pool-name="slsb-strict-max-pool"/>

                    </stateless>

                    <stateful default-access-timeout="5000" cache-ref="simple"/>

                    <singleton default-access-timeout="5000"/>

                </session-bean>

                <mdb>

                    <resource-adapter-ref resource-adapter-name="hornetq-ra"/>

                    <bean-instance-pool-ref pool-name="mdb-strict-max-pool"/>

                </mdb>

                <pools>

                    <bean-instance-pools>

                        <strict-max-pool name="slsb-strict-max-pool" max-pool-size="20" instance-acquisition-timeout="5" instance-acquisition-timeout-unit="MINUTES"/>

                        <strict-max-pool name="mdb-strict-max-pool" max-pool-size="20" instance-acquisition-timeout="5" instance-acquisition-timeout-unit="MINUTES"/>

                    </bean-instance-pools>

                </pools>

                <caches>

                    <cache name="simple" aliases="NoPassivationCache"/>

                    <cache name="passivating" passivation-store-ref="file" aliases="SimpleStatefulCache"/>

                </caches>

                <passivation-stores>

                    <file-passivation-store name="file"/>

                </passivation-stores>

                <async thread-pool-name="default"/>

                <timer-service thread-pool-name="default">

                    <data-store path="timer-service-data" relative-to="jboss.server.data.dir"/>

                </timer-service>

                <remote connector-ref="remoting-connector" thread-pool-name="default"/>

                <thread-pools>

                    <thread-pool name="default">

                        <max-threads count="10"/>

                        <keepalive-time time="100" unit="milliseconds"/>

                    </thread-pool>

                </thread-pools>

            </subsystem>

            <subsystem xmlns="urn:jboss:domain:infinispan:1.1" default-cache-container="hibernate">

                <cache-container name="hibernate" default-cache="local-query">

                    <local-cache name="entity">

                        <transaction mode="NON_XA"/>

                        <eviction strategy="LRU" max-entries="10000"/>

                        <expiration max-idle="100000"/>

                    </local-cache>

                    <local-cache name="local-query">

                        <transaction mode="NONE"/>

                        <eviction strategy="LRU" max-entries="10000"/>

                        <expiration max-idle="100000"/>

                    </local-cache>

                    <local-cache name="timestamps">

                        <transaction mode="NONE"/>

                        <eviction strategy="NONE"/>

                    </local-cache>

                </cache-container>

            </subsystem>

            <subsystem xmlns="urn:jboss:domain:jaxrs:1.0"/>

            <subsystem xmlns="urn:jboss:domain:jca:1.1">

                <archive-validation enabled="true" fail-on-error="true" fail-on-warn="false"/>

                <bean-validation enabled="false"/>

                <default-workmanager>

                    <short-running-threads>

                        <core-threads count="50"/>

                        <queue-length count="50"/>

                        <max-threads count="50"/>

                        <keepalive-time time="10" unit="seconds"/>

                    </short-running-threads>

                    <long-running-threads>

                        <core-threads count="50"/>

                        <queue-length count="50"/>

                        <max-threads count="50"/>

                        <keepalive-time time="10" unit="seconds"/>

                    </long-running-threads>

                </default-workmanager>

            </subsystem>

            <subsystem xmlns="urn:jboss:domain:jdr:1.0"/>

            <subsystem xmlns="urn:jboss:domain:jmx:1.1">

                <show-model value="true"/>

                <remoting-connector/>

            </subsystem>

            <subsystem xmlns="urn:jboss:domain:jpa:1.0">

                <jpa default-datasource=""/>

            </subsystem>

            <subsystem xmlns="urn:jboss:domain:mail:1.0">

                <mail-session jndi-name="java:jboss/mail/Default">

                    <smtp-server outbound-socket-binding-ref="mail-smtp"/>

                </mail-session>

            </subsystem>

            <subsystem xmlns="urn:jboss:domain:naming:1.1"/>

            <subsystem xmlns="urn:jboss:domain:osgi:1.2" activation="lazy">

                <properties>

                    <property name="org.osgi.framework.startlevel.beginning">

                        1

                    </property>

                </properties>

                <capabilities>

                    <capability name="javax.servlet.api:v25"/>

                    <capability name="javax.transaction.api"/>

                    <capability name="org.apache.felix.log" startlevel="1"/>

                    <capability name="org.jboss.osgi.logging" startlevel="1"/>

                    <capability name="org.apache.felix.configadmin" startlevel="1"/>

                    <capability name="org.jboss.as.osgi.configadmin" startlevel="1"/>

                </capabilities>

            </subsystem>

            <subsystem xmlns="urn:jboss:domain:pojo:1.0"/>

            <subsystem xmlns="urn:jboss:domain:remoting:1.1">

                <connector name="remoting-connector" socket-binding="remoting" security-realm="ApplicationRealm"/>

            </subsystem>

            <subsystem xmlns="urn:jboss:domain:resource-adapters:1.0"/>

            <subsystem xmlns="urn:jboss:domain:sar:1.0"/>

            <subsystem xmlns="urn:jboss:domain:security:1.1">

                <security-domains>

                    <security-domain name="other" cache-type="default">

                        <authentication>

                            <login-module code="Remoting" flag="optional">

                                <module-option name="password-stacking" value="useFirstPass"/>

                            </login-module>

                            <login-module code="RealmUsersRoles" flag="required">

                                <module-option name="usersProperties" value="${jboss.server.config.dir}/application-users.properties"/>

                                <module-option name="rolesProperties" value="${jboss.server.config.dir}/application-roles.properties"/>

                                <module-option name="realm" value="ApplicationRealm"/>

                                <module-option name="password-stacking" value="useFirstPass"/>

                            </login-module>

                        </authentication>

                    </security-domain>

                    <security-domain name="jboss-web-policy" cache-type="default">

                        <authorization>

                            <policy-module code="Delegating" flag="required"/>

                        </authorization>

                    </security-domain>

                    <security-domain name="jboss-ejb-policy" cache-type="default">

                        <authorization>

                            <policy-module code="Delegating" flag="required"/>

                        </authorization>

                    </security-domain>

                </security-domains>

            </subsystem>

            <subsystem xmlns="urn:jboss:domain:threads:1.1"/>

            <subsystem xmlns="urn:jboss:domain:transactions:1.1">

                <core-environment>

                    <process-id>

                        <uuid/>

                    </process-id>

                </core-environment>

                <recovery-environment socket-binding="txn-recovery-environment" status-socket-binding="txn-status-manager"/>

                <coordinator-environment default-timeout="300"/>

            </subsystem>

            <subsystem xmlns="urn:jboss:domain:web:1.1" native="false" default-virtual-server="default-host">

                <connector name="http" protocol="HTTP/1.1" scheme="http" socket-binding="http"/>

                <virtual-server name="default-host" enable-welcome-root="true">

                    <alias name="localhost"/>

                    <alias name="example.com"/>

                </virtual-server>

            </subsystem>

            <subsystem xmlns="urn:jboss:domain:webservices:1.1">

                <modify-wsdl-address>true</modify-wsdl-address>

                <wsdl-host>${jboss.bind.address:192.168.100.24}</wsdl-host>

                <endpoint-config name="Standard-Endpoint-Config"/>

                <endpoint-config name="Recording-Endpoint-Config">

                    <pre-handler-chain name="recording-handlers" protocol-bindings="##SOAP11_HTTP ##SOAP11_HTTP_MTOM ##SOAP12_HTTP ##SOAP12_HTTP_MTOM">

                        <handler name="RecordingHandler" class="org.jboss.ws.common.invocation.RecordingServerHandler"/>

                    </pre-handler-chain>

                </endpoint-config>

            </subsystem>

            <subsystem xmlns="urn:jboss:domain:weld:1.0"/>

        </profile>

     

     

        <interfaces>

            <interface name="management">

                <inet-address value="${jboss.bind.address.management:192.168.100.24}"/>

            </interface>

            <interface name="public">

                <inet-address value="${jboss.bind.address:192.168.100.24}"/>

            </interface>

        </interfaces>

     

     

        <socket-binding-group name="standard-sockets" default-interface="public" port-offset="${jboss.socket.binding.port-offset:0}">

            <socket-binding name="http" port="8080"/>

            <socket-binding name="https" port="8443"/>

            <socket-binding name="management-native" interface="management" port="${jboss.management.native.port:9999}"/>

            <socket-binding name="management-http" interface="management" port="${jboss.management.http.port:9990}"/>

            <socket-binding name="management-https" interface="management" port="${jboss.management.https.port:9443}"/>

            <socket-binding name="osgi-http" interface="management" port="8090"/>

            <socket-binding name="remoting" port="4447"/>

            <socket-binding name="txn-recovery-environment" port="4712"/>

            <socket-binding name="txn-status-manager" port="4713"/>

            <outbound-socket-binding name="mail-smtp">

                <remote-destination host="localhost" port="25"/>

            </outbound-socket-binding>

        </socket-binding-group>

     

     

        <deployments>

            <deployment name="School.ear" runtime-name="School.ear">

                <content sha1="5c2457d82b5361387cc2444f1326a6e9ee3b558e"/>

            </deployment>

        </deployments>

    </server>

     

    And my Persistence.xml

    <?xml version="1.0" encoding="windows-1252" ?>

    <persistence xmlns="http://java.sun.com/xml/ns/persistence"

                 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

                 xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd"

                 version="2.0">

      <persistence-unit name="Entities" transaction-type="RESOURCE_LOCAL">

        <provider>org.eclipse.persistence.jpa.PersistenceProvider</provider>

        <class>entities.DataType</class>

        <class>entities.DataTypeUtil</class>

        <class>entities.DataTypeCalendar</class>

        <class>entities.Student</class>

        <class>entities.Form</class>

        <class>entities.FormRole</class>

        <class>entities.FormDetail</class>

        <class>entities.FormModule</class>

        <class>entities.User</class>

        <class>entities.UserGroup</class>

        <class>entities.UserGroupFormRole</class>

        <class>entities.Child</class>

        <class>entities.Parent</class>

        <class>entities.ChildTest</class>

        <class>entities.ParentTest</class><properties>

          <property name="eclipselink.ddl-generation"

                    value="drop-and-create-tables"/>

          <property name="eclipselink.ddl-generation.output-mode" value="database"/>

          <property name="javax.persistence.jdbc.driver"

                    value="com.microsoft.jdbc.sqlserver.SQLServerDriver"/>

          <property name="javax.persistence.jdbc.url"

                    value="jdbc:sqlserver://192.168.100.5:1433;databaseName=ADiamond;"/>

          <property name="javax.persistence.jdbc.user" value="sa"/>

          <property name="javax.persistence.jdbc.password"

                    value="diamond"/>

          <property name="eclipselink.jdbc.exclusive-connection.mode"

                    value="Transactional"/>

          <property name="eclipselink.cache.shared.default" value="false"/>

          <property name="javax.persistence.cache.storeMode" value="REFRESH"/>

        </properties>

      </persistence-unit>

      <persistence-unit name="EntitiesOracleJndi" transaction-type="RESOURCE_LOCAL">

        <provider>org.eclipse.persistence.jpa.PersistenceProvider</provider>

        <class>entities.DataType</class>

        <class>entities.DataTypeUtil</class>

        <class>entities.DataTypeCalendar</class>

        <class>entities.Student</class>

        <class>entities.Form</class>

        <class>entities.FormRole</class>

        <class>entities.FormDetail</class>

        <class>entities.FormModule</class>

        <class>entities.User</class>

        <class>entities.UserGroup</class>

        <class>entities.UserGroupFormRole</class>

        <class>entities.Child</class>

        <class>entities.Parent</class>

        <class>entities.ChildTest</class>

        <class>entities.ParentTest</class>

        <properties>

          <property name="eclipselink.jdbc.exclusive-connection.mode"

                    value="Transactional"/>

          <property name="eclipselink.cache.shared.default" value="false"/>

          <property name="javax.persistence.cache.storeMode" value="REFRESH"/>

          <property name="javax.persistence.jdbc.driver"

                    value="com.microsoft.jdbc.sqlserver.SQLServerDriver"/>

          <property name="javax.persistence.jdbc.url"

                    value="jdbc:microsoft:sqlserver://192.168.100.5:1433;databaseName=ADiamond;"/>

          <property name="javax.persistence.jdbc.user" value="sa"/>

          <property name="javax.persistence.jdbc.password"

                    value="diamond"/>

          <property name="eclipselink.target-server" value="JBoss"/>

          <property name="eclipselink.ddl-generation" value="create-tables"/>

          <property name="eclipselink.ddl-generation.output-mode" value="database"/>

        </properties>

      </persistence-unit>

    </persistence>