Bom dia a todos,
Primeiramente gostaria de parabenizar a todos que mantem esse forum. Forum muito bom.
Essa é minha primeira mensagem no GUJ, entao me desculpem qualquer coisa que saia errado.
Seguinte, Estou com um problema no hibernate. Eu tenho um banco MySQL na minha maquina local e eu consegui acessa-lo normalmente com hibernate. Agora, eu tenho um banco Oracle 10G em um servidor aonde trabalho so que o Hibernate nao consegue estabelecer uma conexao com ele. Pelos testes que fiz conectando no banco MySQL local percebi que nao é falta de algum .jar do hibernate. Peço ajuda para solucionar este problema. Pesquisei nos foruns e nao consegui encontrar soluçao. Segue abaixo o hibernate.cfg.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<property name="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
<property name="hibernate.connection.url">jdbc:oracle:thin:@10.10.10.174:1521:MRSSM2DES</property>
<property name="hibernate.connection.username">usuario</property>
<property name="hibernate.connection.password">senha</property>
<property name="hibernate.dialect">org.hibernate.dialect.OracleDialect</property>
<property name="hibernate.format_sql">false</property>
<property name="hibernate.show_sql">true</property>
<property name="hibernate.hbm2ddl.auto">none</property>
<property name="hibernate.c3p0.acquire_increment">1</property>
<property name="hibernate.c3p0.idle_test_period">100</property>
<property name="hibernate.c3p0.max_size">10</property>
<property name="hibernate.c3p0.max_statements">0</property>
<property name="hibernate.c3p0.min_size">5</property>
<property name="hibernate.c3p0.timeout">100</property>
<property name="hibernate.transaction.factory_class">org.hibernate.transaction.JDBCTransactionFactory</property>
<property name="hibernate.current_session_context_class">thread</property>
<mapping class="br.com.hibernate.entidade.Cliente" />
</session-factory>
</hibernate-configuration>
Quando debugo o projeto, ele fica parado na seguinte linha de codigo
Depois lança a excessao
9:26:01,625 WARN SettingsFactory:117 - Could not obtain connection metadata
java.sql.SQLException: Connections could not be acquired from the underlying database!
at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:529)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)
at org.hibernate.connection.C3P0ConnectionProvider.getConnection(C3P0ConnectionProvider.java:56)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:84)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2073)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1298)
at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:859)
at br.com.hibernate.util.HibernateUtil.<clinit>(HibernateUtil.java:13)
at br.com.hibernate.DAO.ClienteDAO.salvar(ClienteDAO.java:19)
at Main.main(Main.java:21)
Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source.
at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1319)
at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:557)
at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:477)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:525)
... 9 more
09:26:01,921 INFO Dialect:152 - Using dialect: org.hibernate.dialect.OracleDialect
09:26:01,968 WARN Oracle9Dialect:37 - The Oracle9Dialect dialect has been deprecated; use either Oracle9iDialect or Oracle10gDialect instead
09:26:02,031 WARN OracleDialect:26 - The OracleDialect dialect has been deprecated; use Oracle8iDialect instead
09:26:02,078 INFO TransactionFactoryFactory:34 - Transaction strategy: org.hibernate.transaction.JDBCTransactionFactory
09:26:02,109 INFO TransactionManagerLookupFactory:33 - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
09:26:02,125 INFO SettingsFactory:143 - Automatic flush during beforeCompletion(): disabled
09:26:02,140 INFO SettingsFactory:147 - Automatic session close at end of transaction: disabled
09:26:02,171 INFO SettingsFactory:162 - Scrollable result sets: disabled
09:26:02,171 INFO SettingsFactory:170 - JDBC3 getGeneratedKeys(): disabled
09:26:02,187 INFO SettingsFactory:178 - Connection release mode: auto
09:26:02,218 INFO SettingsFactory:205 - Default batch fetch size: 1
09:26:02,218 INFO SettingsFactory:209 - Generate SQL with comments: disabled
09:26:02,234 INFO SettingsFactory:213 - Order SQL updates by primary key: disabled
09:26:02,250 INFO SettingsFactory:217 - Order SQL inserts for batching: disabled
09:26:02,265 INFO SettingsFactory:386 - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
09:26:02,312 INFO ASTQueryTranslatorFactory:24 - Using ASTQueryTranslatorFactory
09:26:02,343 INFO SettingsFactory:225 - Query language substitutions: {}
09:26:02,343 INFO SettingsFactory:230 - JPA-QL strict compliance: disabled
09:26:02,375 INFO SettingsFactory:235 - Second-level cache: enabled
09:26:02,437 INFO SettingsFactory:239 - Query cache: disabled
09:26:02,437 INFO SettingsFactory:373 - Cache provider: org.hibernate.cache.NoCacheProvider
09:26:02,546 INFO SettingsFactory:254 - Optimize cache for minimal puts: disabled
09:26:02,562 INFO SettingsFactory:263 - Structured second-level cache entries: disabled
09:26:02,656 INFO SettingsFactory:283 - Echoing all SQL to stdout
09:26:02,656 INFO SettingsFactory:290 - Statistics: disabled
09:26:02,671 INFO SettingsFactory:294 - Deleted entity synthetic identifier rollback: disabled
09:26:02,687 INFO SettingsFactory:309 - Default entity-mode: pojo
09:26:02,703 INFO SettingsFactory:313 - Named query checking : enabled
09:26:03,218 INFO SessionFactoryImpl:161 - building session factory
09:26:06,562 INFO SessionFactoryObjectFactory:82 - Not binding factory to JNDI, no JNDI name configured
Quem puder ajudar, eu agradeço muito.
Obrigado.