JBoss Community

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>