Vraptor 3.6 JPA + JNDI + tomcat 7

Opa,

Se alguém souber como ajudar vou agradecer muito hehe.

Estou tentando configurar o jndi com meu projeto vraptor 3.6 passei o dia todo hoje tentando e não conseguir. Procurei bastante e não achei nada que funcionasse com meu projeto, o q será q fiz de errado. Segue meus problemas:

Erro:

java.sql.SQLException: No suitable driver
	at java.sql.DriverManager.getDriver(DriverManager.java:278)
	at com.mchange.v2.c3p0.DriverManagerDataSource.driver(DriverManagerDataSource.java:224)
	at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:120)
	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:143)
	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:132)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)
	at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
	at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
	at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
	at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)

hibernate.properties

#hibernate.connection.driver_class=com.mysql.jdbc.Driver
#hibernate.connection.url=jdbc:mysql://127.0.0.1:3306/bd_sistema_pilates
#hibernate.connection.username=root
#hibernate.connection.password=root

hibernate.connection.datasource=java:/comp/env/jdbc/sistema
#hibernate.connection.driver_class=com.mysql.jdbc.Driver
#hibernate.transaction.factory_class = org.hibernate.transaction.JTATransactionFactory
#hibernate.transaction.manager_lookup_class = org.hibernate.transaction.JBossTransactionManagerLookup
hibernate.dialect = org.hibernate.dialect.MySQLDialect
hibernate.hbm2ddl.auto=update
hibernate.query.substitutions=true=1, false=0
hibernate.show_sql=true
hibernate.format_sql=true

#DATASOURCE POOL CONFIGURATIONS
hibernate.connection.provider_class=org.hibernate.connection.C3P0ConnectionProvider
maxPoolSize=20
minPoolSize=3
initialPoolSize=3
timeout=25200
acquireIncrement=5
preferredTestQuery=select 1
idleConnectionTestPeriod=100

web.xml

<resource-ref>
 <description>sistema</description>
 <res-ref-name>jdbc/sistema</res-ref-name>
 <res-type>javax.sql.DataSource</res-type>
 <res-auth>Container</res-auth>
</resource-ref>

context.xml

<Resource name="jdbc/sistema" auth="Container"
        type="javax.sql.DataSource"
        driverClass="com.mysql.jdbc.Driver"
        url="jdbc:mysql://127.0.0.1:3306/bd_sistema_pilates"
        username="root" password="root"/>

Topicos relacionados