Hi Nicklas,

I'm trying to inject local Datasource and Persitence Unit file with Hibernate.

I've noticed that I forgot to comment:

persitence.xml

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

<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 persistence_2_0.xsd" version="2.0">

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

    <!-- DATA SOURCE -->

              <jta-data-source>java:jboss/datasources/MySQLDS</jta-data-source>

    <!-- PROVIDER -->

                    <provider>org.hibernate.ejb.HibernatePersistence</provider>

        <!-- PROPERTIES -->

        <properties>           

            <!-- Properties for Hibernate -->

                   <property name="hibernate.hbm2ddl.auto" value="validate" />

                   <property name="hibernate.show_sql" value="false" />

        </properties>

    </persistence-unit>

</persistence>

module.xml configuration file which is located in "com.mysql.jdbc.main" package and in the same directory I've added the driver of MySql "mysql-connector-java-5.1.24-bin.jar"

<module xmlns="urn:jboss:module:1.1" name="com.mysql.jdbc">

    <resources>

        <resource-root path="mysql-connector-java-5.1.24-bin.jar"/>

        <!-- Insert resources here -->

    </resources>

    <dependencies>

        <module name="javax.api"/>

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

    </dependencies>

</module>

Finally, the hibernate.cfg.xml file:

<hibernate-configuration>

    <session-factory>

        <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>

        <property name="hibernate.connection.url">jdbc:mysql://localhost:3306/test</property>

        <property name="hibernate.connection.username">root</property>

        <property name="hibernate.connection.password"></property>

        <property name="hibernate.connection.pool_size">10</property>

        <property name="show_sql">true</property>

        <property name="hibernate.transaction.factory_class">org.hibernate.transaction.JDBCTransactionFactory</property>

        <property name="hibernate.current_session_context_class">thread</property>

        <property name="dialect">org.hibernate.dialect.MySQLDialect</property>  

    <property name="hbm2ddl.auto">validate</property>

    <property name="hibernate.id.new_generator_mappings">true</property>

    <!--the mapping resources here -->

</hibernate-configuration>

So, could tell me what I am doing wrong???

If you need more information or something I've not talked about my code ask me please!

Thanks in advance.

Yes, it's a doployment error. Although, It tells me that I've missed the driver class... it's not possible because, I added the driver class in the belonging folder. I'm targeting Hibernate.

I've checked to replace this line of datasource, removing  jta="true", but searching in the documentation I suppose that it's an irrelevante change.

<datasource jndi-name="java:jboss/mysql/MySQLDS" pool-name="mdissphoto_pool" enabled="true" use-java-context="true" use-ccm="true">

I'm following steps for this URL.

http://planet.jboss.org/post/how_to_create_and_manage_datasources_in_as7

Hi Stephen,

I'm using Maven 2, so I've all the jars in the m2 directory. Is it possible I'd forgotten to tell pom.xml where is the driver alocated??

Thanks in advance for helping.

Hi Nicklas,

I added the captures of jars.

Thanks in advance for helping.

Hi Nicklas,

I've followed the URL, it's similar to I've implemented, but I did a few changes.

I've changed the jndi-name and the pool-name (I think there aren't irrelevant changes but I did it)

Finally, you tell me use:

@Resource(mappedName="java:jboss/mysql/MySQLDS")

private Datasource datasource

What dependency I have to add to use Datasource object????

I've added this, but it doesn't detect the import of the object!!!

<dependency>

              <groupId>springframework</groupId>

    <artifactId>spring-jdbc</artifactId>

    <version>1.2.6</version>

</dependency>

--------------------------------------------------------------------------------------------------------------------

Hi Stephen,

I've a few modules in my Maven project, so it's not going to be easy to post all of them, and obviously to follow it!

Anyway, I post it all of them in different blocks in order to make easier you the reading.

In the other hand, I've gain accessed to the Admin Console of JBoss EAP 6, How can I test the datasource connection?

nbaCommunity (Main project)

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

  xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">

  <modelVersion>4.0.0</modelVersion>

  <groupId>org.modino.nbaCommunity</groupId>

  <artifactId>nbaCommunity</artifactId>

  <version>1.0</version>

  <packaging>pom</packaging>

  <name>nbaCommunity</name>

  <url>http://maven.apache.org</url>

  <properties>

    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>

  </properties>

  <!-- MODULES DEFINITION --> 

  <modules>

            <module>nbaCommunity-model</module>

            <module>nbaCommunity-web</module>

            <module>nbaCommunity-utils</module>

            <module>nbaCommunity-notifier</module>

  </modules>

  <dependencies>

    <!-- JBOSS DEPENDENCY -->

    <dependency>

              <groupId>org.jboss.as.plugins</groupId>

              <artifactId>jboss-as-maven-plugin</artifactId>

              <version>7.4.Final</version>

              <type>maven-plugin</type>

    </dependency>

<!-- JUNIT 4 -->

<dependency>

  <groupId>junit</groupId>

  <artifactId>junit</artifactId>

  <version>4.11</version>

</dependency>

<!-- SLF4j logging -->

<dependency>

  <groupId>org.slf4j</groupId>

  <artifactId>slf4j-log4j12</artifactId>

  <version>1.7.2</version>

</dependency>

  </dependencies>

</project>

------------------------------------------------------------------------------------------------------------------------------------

nbaCommunity-model

<?xml version="1.0"?>

<project xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd" xmlns="http://maven.apache.org/POM/4.0.0"

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

  <modelVersion>4.0.0</modelVersion>

  <parent>

    <groupId>org.modino.nbaCommunity</groupId>

    <artifactId>nbaCommunity</artifactId>

    <version>1.0</version>

  </parent>

  <groupId>org.modino.nbaCommunity.model</groupId>

  <artifactId>nbaCommunity-model</artifactId>

  <version>0.0.1-SNAPSHOT</version>

  <packaging>jar</packaging>

  <name>nbaCommunity-model</name>

  <url>http://maven.apache.org</url>

  <properties>

    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>

    <eclipselink.version>2.4.0</eclipselink.version>

    <jboss.home></jboss.home>

    <jboss.server.name>default</jboss.server.name>

    <jboss.host.name>localhost</jboss.host.name>

    <jboss.port></jboss.port>

    <deployUrlPath></deployUrlPath>

    <undeployUrlPath></undeployUrlPath>

    <fileName></fileName>

  </properties>

  <!-- ECLIPSELINK PROJECT REPOSITORY -->

   <repositories>

<repository>

                    <id>EclipseLink</id>

                    <url>http://download.eclipse.org/rt/eclipselink/maven.repo</url>

</repository>

   </repositories>

  <dependencies>

    <dependency>

              <groupId>javax.inject</groupId>

    <artifactId>javax.inject</artifactId>

    <version>1</version>

    </dependency>

    <dependency>

              <groupId>javax.enterprise</groupId>

    <artifactId>cdi-api</artifactId>

              <version>1.1-20130305</version>

    </dependency>

    <!-- SPRING TEST -->

<dependency>

                    <groupId>org.springframework</groupId>

  <artifactId>spring-test</artifactId>

                    <version>3.2.1.RELEASE</version>

</dependency>   

    <!-- HIBERNATE 4 DEPENDENCIES -->

    <dependency>

              <groupId>org.hibernate</groupId>

    <artifactId>hibernate-core</artifactId>

              <version>4.2.0.CR2</version>

    </dependency>

    <dependency>

              <groupId>org.hibernate</groupId>

              <artifactId>hibernate-validator</artifactId>

              <version>5.0.0.CR1</version>

    </dependency>

    <dependency>

                    <groupId>org.hibernate</groupId>

                    <artifactId>hibernate-commons-annotations</artifactId>

  <version>3.2.0.Final</version>

</dependency>

    <!-- SHIRO DEPENDENCIES -->

    <dependency>

                    <groupId>org.apache.shiro</groupId>

  <artifactId>shiro-core</artifactId>

  <version>1.2.1</version>

</dependency>

    <dependency>

                    <groupId>org.apache.shiro</groupId>

  <artifactId>shiro-ehcache</artifactId>

  <version>1.2.1</version>

</dependency>

    <dependency>

                    <groupId>org.apache.shiro</groupId>

  <artifactId>shiro-web</artifactId>

  <version>1.2.1</version>

</dependency>

<!-- SPRING DEPENDENCIES -->

    <dependency>

              <groupId>org.springframework</groupId>

    <artifactId>spring-beans</artifactId>

              <version>3.2.1.RELEASE</version>

    </dependency>

    <dependency>

              <groupId>org.springframework</groupId>

    <artifactId>spring-jms</artifactId>

              <version>3.2.1.RELEASE</version>

    </dependency>

    <dependency>

              <groupId>org.springframework</groupId>

    <artifactId>spring-web</artifactId>

              <version>3.2.1.RELEASE</version>

    </dependency>

    <!-- MYSQL -->

<dependency>

  <groupId>mysql</groupId>

                    <artifactId>mysql-connector-java</artifactId>

  <version>5.1.23</version>

</dependency>

  <!-- eclipselink.jar with dependencies except commonj.sdo -->

<dependency>

                    <groupId>org.eclipse.persistence</groupId>

  <artifactId>eclipselink</artifactId>

                    <version>${eclipselink.version}</version>

  <exclusions>

  <exclusion>

  <artifactId>commonj.sdo</artifactId>

                                        <groupId>commonj.sdo</groupId>

  </exclusion>

  </exclusions>

</dependency>

  </dependencies>

</project>

------------------------------------------------------------------------------------------------------------------------------------

nbaCommunity-utils

<?xml version="1.0"?>

<project xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd" xmlns="http://maven.apache.org/POM/4.0.0"

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

  <modelVersion>4.0.0</modelVersion>

  <parent>

    <groupId>org.modino.nbaCommunity</groupId>

    <artifactId>nbaCommunity</artifactId>

    <version>1.0</version>

  </parent>

  <groupId>org.modino.nbaCommunity.utils</groupId>

  <artifactId>nbaCommunity-utils</artifactId>

  <packaging>jar</packaging>

  <version>0.0.1-SNAPSHOT</version>

  <name>nbaCommunity-utils</name>

  <url>http://maven.apache.org</url>

  <!-- Ubicacion de los ficheros de propiedades para el objeto PropertiesFacade.java

   PATHS, GLOBAL, OAUTH, THUMBNAILS, RESOLUTIONS    -->

  <properties>

    <nbaCommunity.resources.home>${env.NBACOMMUNITY_RESOURCES_HOME}</nbaCommunity.resources.home>

  </properties>

  <dependencies>

    <dependency>

      <groupId>junit</groupId>

      <artifactId>junit</artifactId>

      <version>3.8.1</version>

      <scope>test</scope>

    </dependency>

  </dependencies>

  <build>

  <resources>

  <resource>

                                        <directory>src/main/resources</directory>

  </resource>

  <!-- resources for all -->

  <resource>

                                        <directory>${nbaCommunity.resources.home}</directory>

  </resource>

  </resources>

              <plugins>

  <!-- Add dependencies (libs) to jar and make executable -->

  <plugin>

                                        <artifactId>maven-assembly-plugin</artifactId>

  <configuration>

  <descriptorRefs>

                                                            <descriptorRef>jar-with-dependencies</descriptorRef>

  </descriptorRefs>

  </configuration>

  <!-- <executions>

                                                  <execution>

                                                  <id>jar-with-dependencies</id>

                                                  <phase>package</phase>

                                                  <goals>

                                                            <goal>single</goal>

                                                  </goals>

                                                  </execution>

                                        </executions> -->

  </plugin>

  </plugins>

</build>

</project>

------------------------------------------------------------------------------------------------------------------------------------

nbaCommunity-web

<?xml version="1.0"?>

<project xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd" xmlns="http://maven.apache.org/POM/4.0.0"

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

  <modelVersion>4.0.0</modelVersion>

  <parent>

    <groupId>org.modino.nbaCommunity</groupId>

    <artifactId>nbaCommunity</artifactId>

    <version>1.0</version>

  </parent>

  <groupId>org.modino.nbaCommunity.web</groupId>

  <artifactId>nbaCommunity-web</artifactId>

  <version>0.0.1-SNAPSHOT</version>

  <packaging>war</packaging>

  <name>nbaCommunity-web</name>

  <url>http://maven.apache.org</url>

  <properties>

    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>

    <spring-security.version>3.1.3.RELEASE</spring-security.version>

    <spring.version>3.2.2.RELEASE</spring.version>

  </properties>

  <repositories>

<!-- PRIMEFACES -->

<repository>

              <id>prime-repo</id>

              <name>PrimeFaces Maven Repository</name>

              <url>http://repository.primefaces.org</url>

              <layout>default</layout>

</repository>

<!-- JSF 2.1 and Later -->

<repository>

            <id>jvnet-nexus-releases</id>

            <name>jvnet-nexus-releases</name>

            <url>https://maven.java.net/content/repositories/releases/</url>

</repository>

  </repositories>

  <dependencies>

<!-- PRIMEFACES 3.5 -->

<dependency>

                    <groupId>org.primefaces</groupId>

  <artifactId>primefaces</artifactId>

  <version>3.5</version>

</dependency>

<!-- PRIMEFACES MOBILE -->

<dependency>

                    <groupId>org.primefaces</groupId>

  <artifactId>primefaces-mobile</artifactId>

  <version>0.9.3</version>

</dependency>

<!-- JSF 2.1 -->

<dependency>

               <groupId>javax.faces</groupId>

        <artifactId>jsf-api</artifactId>

        <version>2.1</version>

    </dependency>

<!-- PRETTY FACES for JSF 2.x-->

<dependency>

             <groupId>com.ocpsoft</groupId>

             <artifactId>prettyfaces-jsf2</artifactId>

             <version>3.3.3</version>

</dependency>

<!-- MODULE NBACOMMUNITY-MODEL -->

<dependency>

                    <groupId>org.modino.nbaCommunity.model</groupId>

                      <artifactId>nbaCommunity-model</artifactId>

                      <version>0.0.1-SNAPSHOT</version>

</dependency>

<!-- MODULE NBACOMMUNITY-UTILS -->

<dependency>

                    <groupId>org.modino.nbaCommunity.utils</groupId>

                    <artifactId>nbaCommunity-utils</artifactId>

                    <version>0.0.1-SNAPSHOT</version>

</dependency>

<!-- MODULE NBACOMMUNITY-NOTIFIER -->

<dependency>

                    <groupId>org.modino.nbaCommunity.notifier</groupId>

                    <artifactId>nbaCommunity-notifier</artifactId>

                    <version>0.0.1-SNAPSHOT</version>

</dependency>

<!-- SPRING SECURITY DEPENDENCIES -->

<dependency>

                    <groupId>org.springframework.security</groupId>

                    <artifactId>spring-security-core</artifactId>

                    <version>${spring-security.version}</version>

</dependency>

<dependency>

                    <groupId>org.springframework.security</groupId>

                    <artifactId>spring-security-web</artifactId>

                    <version>${spring-security.version}</version>

</dependency>

<dependency>

                    <groupId>org.springframework.security</groupId>

                    <artifactId>spring-security-config</artifactId>

                    <version>${spring-security.version}</version>

</dependency>

<dependency>

                    <groupId>org.springframework.security</groupId>

                    <artifactId>spring-security-taglibs</artifactId>

                    <version>${spring-security.version}</version>

</dependency>

<!-- SPRING 3 DEPENDENCIES -->

<dependency>

                    <groupId>org.springframework</groupId>

  <artifactId>spring-core</artifactId>

                    <version>${spring.version}</version>

</dependency>

<dependency>

                    <groupId>org.springframework</groupId>

  <artifactId>spring-web</artifactId>

                    <version>${spring.version}</version>

</dependency>

<!-- HttpServletRequest & HttpServletResponse dependency -->

<dependency>

                    <groupId>javax.servlet</groupId>

  <artifactId>servlet-api</artifactId>

  <version>3.0-alpha-1</version>

</dependency>

<dependency>

                    <groupId>org.apache.commons</groupId>

  <artifactId>commons-lang3</artifactId>

  <version>3.1</version>

</dependency>

<!-- MYSQL -->

<dependency>

  <groupId>mysql</groupId>

                    <artifactId>mysql-connector-java</artifactId>

  <version>5.1.23</version>

</dependency>

  </dependencies>

  <!-- web.xml file location-->

<build>

        <plugins>

            <plugin>

                <groupId>org.apache.maven.plugins</groupId>

                <artifactId>maven-war-plugin</artifactId>

                <configuration>

                    <webXml>src\main\webapp\WebContent\WEB-INF\web.xml</webXml>

                </configuration>

            </plugin>

        </plugins>

    </build>

</project>

Hi Stephen,

I've done you told me in the last comment.... and I've arrived to the same way. JBoss Server throws the same exception again:

Caused by: org.hibernate.service.classloading.spi.ClassLoadingException: Unable to load class [com.mysql.jdbc.Driver]

      at org.hibernate.service.classloading.internal.ClassLoaderServiceImpl.classForName(ClassLoaderServiceImpl.java:141)

          at org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl.configure(DriverManagerConnectionProviderImpl.java:104)

          ... 60 more

Caused by: java.lang.ClassNotFoundException: Could not load requested class : com.mysql.jdbc.Driver

          at org.hibernate.service.classloading.internal.ClassLoaderServiceImpl$1.findClass(ClassLoaderServiceImpl.java:99)

          at java.lang.ClassLoader.loadClass(ClassLoader.java:306)

          at java.lang.ClassLoader.loadClass(ClassLoader.java:247)

          at java.lang.Class.forName0(Native Method)

          at java.lang.Class.forName(Class.java:249)

          at org.hibernate.service.classloading.internal.ClassLoaderServiceImpl.classForName(ClassLoaderServiceImpl.java:138)

          ... 61 more

Caused by: org.hibernate.service.classloading.spi.ClassLoadingException: Specified JDBC Driver com.mysql.jdbc.Driver class not found

Thanks for helping!! I'm very desperated!!

Thanks in advance!