mysql - C3P0ConnectionProvider error when deploying on JBoss -
i'm attempting connect mysql database via jpa on jboss server.
i following exception when deploying project.
13:04:41,035 error [org.jboss.msc.service.fail] (msc service thread 1-1) msc00001: failed start service jboss.persistenceunit."dryrun.war#dbname": org.jboss.msc.service.startexception in service jboss.persistenceunit."dryrun.war#dbname": failed start service @ org.jboss.msc.service.servicecontrollerimpl$starttask.run(servicecontrollerimpl.java:1767) [jboss-msc-1.0.2.ga.jar:1.0.2.ga] @ java.util.concurrent.threadpoolexecutor.runworker(threadpoolexecutor.java:1145) [rt.jar:1.7.0_15] @ java.util.concurrent.threadpoolexecutor$worker.run(threadpoolexecutor.java:615) [rt.jar:1.7.0_15] @ java.lang.thread.run(thread.java:722) [rt.jar:1.7.0_15] caused by: javax.persistence.persistenceexception: [persistenceunit: dbname] unable build entitymanagerfactory @ org.hibernate.ejb.ejb3configuration.buildentitymanagerfactory(ejb3configuration.java:914) @ org.hibernate.ejb.ejb3configuration.buildentitymanagerfactory(ejb3configuration.java:889) @ org.hibernate.ejb.hibernatepersistence.createcontainerentitymanagerfactory(hibernatepersistence.java:73) @ org.jboss.as.jpa.service.persistenceunitserviceimpl.createcontainerentitymanagerfactory(persistenceunitserviceimpl.java:162) @ org.jboss.as.jpa.service.persistenceunitserviceimpl.start(persistenceunitserviceimpl.java:85) @ org.jboss.msc.service.servicecontrollerimpl$starttask.startservice(servicecontrollerimpl.java:1811) [jboss-msc-1.0.2.ga.jar:1.0.2.ga] @ org.jboss.msc.service.servicecontrollerimpl$starttask.run(servicecontrollerimpl.java:1746) [jboss-msc-1.0.2.ga.jar:1.0.2.ga] ... 3 more caused by: org.hibernate.service.spi.serviceexception: unable create requested service [org.hibernate.service.jdbc.connections.spi.connectionprovider] @ org.hibernate.service.internal.abstractserviceregistryimpl.createservice(abstractserviceregistryimpl.java:187) @ org.hibernate.service.internal.abstractserviceregistryimpl.initializeservice(abstractserviceregistryimpl.java:150) @ org.hibernate.service.internal.abstractserviceregistryimpl.getservice(abstractserviceregistryimpl.java:131) @ org.hibernate.engine.jdbc.internal.jdbcservicesimpl.buildjdbcconnectionaccess(jdbcservicesimpl.java:234) @ org.hibernate.engine.jdbc.internal.jdbcservicesimpl.configure(jdbcservicesimpl.java:91) @ org.hibernate.service.internal.standardserviceregistryimpl.configureservice(standardserviceregistryimpl.java:75) @ org.hibernate.service.internal.abstractserviceregistryimpl.initializeservice(abstractserviceregistryimpl.java:159) @ org.hibernate.service.internal.abstractserviceregistryimpl.getservice(abstractserviceregistryimpl.java:131) @ org.hibernate.cfg.settingsfactory.buildsettings(settingsfactory.java:71) @ org.hibernate.cfg.configuration.buildsettingsinternal(configuration.java:2270) @ org.hibernate.cfg.configuration.buildsettings(configuration.java:2266) @ org.hibernate.cfg.configuration.buildsessionfactory(configuration.java:1735) @ org.hibernate.ejb.entitymanagerfactoryimpl.<init>(entitymanagerfactoryimpl.java:84) @ org.hibernate.ejb.ejb3configuration.buildentitymanagerfactory(ejb3configuration.java:904) ... 9 more caused by: org.hibernate.hibernateexception: not instantiate connection provider [org.hibernate.service.jdbc.connections.internal.c3p0connectionprovider] @ org.hibernate.service.jdbc.connections.internal.connectionproviderinitiator.instantiateexplicitconnectionprovider(connectionproviderinitiator.java:190) @ org.hibernate.service.jdbc.connections.internal.connectionproviderinitiator.initiateservice(connectionproviderinitiator.java:112) @ org.hibernate.service.jdbc.connections.internal.connectionproviderinitiator.initiateservice(connectionproviderinitiator.java:54) @ org.hibernate.service.internal.standardserviceregistryimpl.initiateservice(standardserviceregistryimpl.java:69) @ org.hibernate.service.internal.abstractserviceregistryimpl.createservice(abstractserviceregistryimpl.java:177) ... 22 more caused by: org.hibernate.service.classloading.spi.classloadingexception: unable load class [org.hibernate.service.jdbc.connections.internal.c3p0connectionprovider] @ org.hibernate.service.classloading.internal.classloaderserviceimpl.classforname(classloaderserviceimpl.java:141) @ org.hibernate.service.jdbc.connections.internal.connectionproviderinitiator.instantiateexplicitconnectionprovider(connectionproviderinitiator.java:187) ... 26 more caused by: java.lang.classnotfoundexception: not load requested class : org.hibernate.service.jdbc.connections.internal.c3p0connectionprovider @ org.hibernate.service.classloading.internal.classloaderserviceimpl$1.findclass(classloaderserviceimpl.java:99) @ java.lang.classloader.loadclass(classloader.java:423) [rt.jar:1.7.0_15] @ java.lang.classloader.loadclass(classloader.java:356) [rt.jar:1.7.0_15] @ org.hibernate.service.classloading.internal.classloaderserviceimpl.classforname(classloaderserviceimpl.java:138) ... 27 more my persistence.xml file :
<?xml version="1.0" encoding="utf-8"?> <persistence-unit name="dbname" transaction-type="resource_local"> <properties> <property name="hibernate.show_sql" value="false" /> <property name="hibernate.format_sql" value="false" /> <property name="hibernate.connection.driver_class" value="com.mysql.jdbc.driver" /> <property name="hibernate.connection.url" value="jdbc:mysql://localhost:3306/dbname" /> <property name="hibernate.connection.username" value="root" /> <property name="hibernate.connection.password" value="" /> <property name="hibernate.dialect" value="org.hibernate.dialect.mysqldialect" /> <property name="hibernate.connection.provider_class" value="org.hibernate.service.jdbc.connections.internal.c3p0connectionprovider" /> <property name="hibernate.c3p0.minpoolsize" value="0" /> <property name="hibernate.c3p0.maxpoolsize" value="25" /> <property name="hibernate.c3p0.maxconnectionage" value="14400" /> <property name="hibernate.c3p0.maxidletime" value="100" /> </properties> </persistence-unit> my pom.xml file is:
<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>projectname</groupid> <artifactid>projectname</artifactid> <version>0.0.1-snapshot</version> <packaging>war</packaging> <properties> <version.jboss.bom>1.0.4.final</version.jboss.bom> </properties> <build><!-- maven append version finalname (which name given generated war, , hence context root) --> <finalname>${project.artifactid}</finalname> <plugins><!-- compiler plugin enforces java 1.6 compatibility , activates annotation processors --> <plugin> <artifactid>maven-compiler-plugin</artifactid> <version>2.3.2</version> <configuration> <source>1.7</source> <target>1.7</target> </configuration> </plugin> <plugin> <artifactid>maven-war-plugin</artifactid> <version>2.2</version> <configuration><!-- java ee 6 doesn't require web.xml, maven needs catch up! --> <failonmissingwebxml>false</failonmissingwebxml> </configuration> </plugin><!-- jboss plugin deploys war local jboss container --><!-- use, run: mvn package jboss-as:deploy --> <plugin> <groupid>org.jboss.as.plugins</groupid> <artifactid>jboss-as-maven-plugin</artifactid> <version>7.1.1.final</version> </plugin> </plugins> </build> <dependencies> <dependency> <groupid>junit</groupid> <artifactid>junit</artifactid> <version>4.11</version> </dependency> <dependency> <groupid>org.hibernate</groupid> <artifactid>hibernate-core</artifactid> <version>3.6.3.final</version> </dependency> <dependency> <groupid>mysql</groupid> <artifactid>mysql-connector-java</artifactid> <version>5.1.15</version> </dependency> <dependency> <groupid>org.jboss.as</groupid> <artifactid>jboss-as-jpa-hibernate3</artifactid> <version>7.1.3.final</version> </dependency> <dependency> <groupid>jexcelapi</groupid> <artifactid>jxl</artifactid> <version>2.6</version> </dependency> <dependency> <groupid>javax.ws.rs</groupid> <artifactid>javax.ws.rs-api</artifactid> <version>2.0-rc1</version> </dependency> <dependency> <groupid>javax.enterprise</groupid> <artifactid>cdi-api</artifactid> <version>1.1-20130222</version> </dependency> <dependency> <groupid>org.slf4j</groupid> <artifactid>slf4j-simple</artifactid> <version>1.6.0</version> </dependency> <dependency> <groupid>com.mchange</groupid> <artifactid>c3p0</artifactid> <version>0.9.2-pre8</version> </dependency> </dependencies> i've tried number of different c3p0 related dependencies hibernate , other ones find, nothing seems project working. please point me in right direction. thank you.
the particular dependency missing is
<dependency> <groupid>org.hibernate</groupid> <artifactid>hibernate-c3p0</artifactid> <version>3.6.3.final</version> </dependency> the class missing used in hibernate-core, moved here around version 3.3
http://mvnrepository.com/artifact/org.hibernate/hibernate-c3p0
http://gazelle.ihe.net/content/how-use-c3p0-jdbc-connection-pool-your-maven-project
Comments
Post a Comment