Problema JDBC connection e ConexaoHibernateFilter

0 respostas
ramonquitane

Boa Tarde Pessoal!
Pessoal estou desenvolvendo um sistema do livro “Programação Java para Web” ,ou seja, sou iniciante.
Me deparei com o seguinte problema conforme o console abaixo:

14/02/2012 14:58:06 org.apache.catalina.core.AprLifecycleListener init

INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\Arquivos de programas\Java\jre6\bin;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;C:/Arquivos de programas/Java/jre6/bin/client;C:/Arquivos de programas/Java/jre6/bin;C:/Arquivos de programas/Java/jre6/lib/i386;C:\oracle\ora92\bin;C:\Arquivos de programas\Oracle\jre\1.3.1\bin;C:\Arquivos de programas\Oracle\jre\1.1.8\bin;C:\Arquivos de programas\AMD APP\bin\x86;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Arquivos de programas\ZipGenius 6;C:\Arquivos de programas\Java\jdk1.6.0_30\bin;C:\Arquivos de programas\MySQL\MySQL Server 5.5\bin;C:\eclipse;;.

14/02/2012 14:58:07 org.apache.tomcat.util.digester.SetPropertiesRule begin

AVISO: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting property source to org.eclipse.jst.jee.server:FinanceiroWeb did not find a matching property.

14/02/2012 14:58:07 org.apache.coyote.http11.Http11Protocol init

INFO: Initializing Coyote HTTP/1.1 on http-8080

14/02/2012 14:58:07 org.apache.catalina.startup.Catalina load

INFO: Initialization processed in 769 ms

14/02/2012 14:58:07 org.apache.catalina.core.StandardService start

INFO: Starting service Catalina

14/02/2012 14:58:07 org.apache.catalina.core.StandardEngine start

INFO: Starting Servlet Engine: Apache Tomcat/6.0.35

14/02/2012 14:58:07 com.sun.faces.config.ConfigureListener contextInitialized

INFO: Inicializando Mojarra 2.0.6 (FCS FCS) para o contexto /FinanceiroWeb

14/02/2012 14:58:09 com.sun.faces.mgbean.BeanManager addBean

AVISO: JSF1074: O bean gerenciado denominado usuarioBean  foi registrado.  Substituindo o tipo de classe do bean gerenciado financeiro.web.UsuarioBean por financeiro.web.UsuarioBean.

281 [main] INFO org.hibernate.annotations.common.Version - Hibernate Commons Annotations 3.2.0.Final

297 [main] INFO org.hibernate.cfg.Environment - Hibernate 3.6.2.Final

297 [main] INFO org.hibernate.cfg.Environment - hibernate.properties not found

297 [main] INFO org.hibernate.cfg.Environment - Bytecode provider name : javassist

313 [main] INFO org.hibernate.cfg.Environment - using JDK 1.4 java.sql.Timestamp handling

469 [main] INFO org.hibernate.cfg.Configuration - configuring from resource: hibernate.cfg.xml

469 [main] INFO org.hibernate.cfg.Configuration - Configuration resource: hibernate.cfg.xml

531 [main] WARN org.hibernate.util.DTDEntityResolver - recognized obsolete hibernate namespace <a href="http://hibernate.sourceforge.net/">http://hibernate.sourceforge.net/</a>. Use namespace <a href="http://www.hibernate.org/dtd/">http://www.hibernate.org/dtd/</a> instead. Refer to Hibernate 3.6 Migration Guide!

609 [main] INFO org.hibernate.cfg.Configuration - Configured SessionFactory: null

688 [main] INFO org.hibernate.cfg.AnnotationBinder - Binding entity from annotated class: financeiro.usuario.Usuario

781 [main] INFO org.hibernate.cfg.annotations.EntityBinder - Bind entity financeiro.usuario.Usuario on table Usuario

906 [main] INFO org.hibernate.cfg.Configuration - Hibernate Validator not found: ignoring

922 [main] INFO org.hibernate.cfg.search.HibernateSearchEventListenerRegister - Unable to find org.hibernate.search.event.FullTextIndexEventListener on the classpath. Hibernate Search is not enabled.

938 [main] WARN org.hibernate.connection.UserSuppliedConnectionProvider - No connection properties specified - the user must supply JDBC connections

1000 [main] INFO org.hibernate.dialect.Dialect - Using dialect: org.hibernate.dialect.MySQL5InnoDBDialect

1016 [main] INFO org.hibernate.engine.jdbc.JdbcSupportLoader - Disabling contextual LOB creation as connection was null

1031 [main] INFO org.hibernate.transaction.TransactionFactoryFactory - Using default transaction strategy (direct JDBC transactions)

1031 [main] INFO org.hibernate.transaction.TransactionManagerLookupFactory - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)

1031 [main] INFO org.hibernate.cfg.SettingsFactory - Automatic flush during beforeCompletion(): disabled

1031 [main] INFO org.hibernate.cfg.SettingsFactory - Automatic session close at end of transaction: disabled

1031 [main] INFO org.hibernate.cfg.SettingsFactory - Scrollable result sets: disabled

1031 [main] INFO org.hibernate.cfg.SettingsFactory - JDBC3 getGeneratedKeys(): disabled

1031 [main] INFO org.hibernate.cfg.SettingsFactory - Connection release mode: auto

1031 [main] INFO org.hibernate.cfg.SettingsFactory - Maximum outer join fetch depth: 2

1031 [main] INFO org.hibernate.cfg.SettingsFactory - Default batch fetch size: 1

1031 [main] INFO org.hibernate.cfg.SettingsFactory - Generate SQL with comments: disabled

1031 [main] INFO org.hibernate.cfg.SettingsFactory - Order SQL updates by primary key: disabled

1031 [main] INFO org.hibernate.cfg.SettingsFactory - Order SQL inserts for batching: disabled

1031 [main] INFO org.hibernate.cfg.SettingsFactory - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory

1031 [main] INFO org.hibernate.hql.ast.ASTQueryTranslatorFactory - Using ASTQueryTranslatorFactory

1031 [main] INFO org.hibernate.cfg.SettingsFactory - Query language substitutions: {}

1031 [main] INFO org.hibernate.cfg.SettingsFactory - JPA-QL strict compliance: disabled

1031 [main] INFO org.hibernate.cfg.SettingsFactory - Second-level cache: enabled

1031 [main] INFO org.hibernate.cfg.SettingsFactory - Query cache: disabled

1031 [main] INFO org.hibernate.cfg.SettingsFactory - Cache region factory : org.hibernate.cache.impl.NoCachingRegionFactory

1047 [main] INFO org.hibernate.cfg.SettingsFactory - Optimize cache for minimal puts: disabled

1047 [main] INFO org.hibernate.cfg.SettingsFactory - Structured second-level cache entries: disabled

1063 [main] INFO org.hibernate.cfg.SettingsFactory - Statistics: disabled

1063 [main] INFO org.hibernate.cfg.SettingsFactory - Deleted entity synthetic identifier rollback: disabled

1063 [main] INFO org.hibernate.cfg.SettingsFactory - Default entity-mode: pojo

1063 [main] INFO org.hibernate.cfg.SettingsFactory - Named query checking : enabled

1063 [main] INFO org.hibernate.cfg.SettingsFactory - Check Nullability in Core (should be disabled when Bean Validation is on): enabled

1094 [main] INFO org.hibernate.impl.SessionFactoryImpl - building session factory

1109 [main] INFO org.hibernate.type.BasicTypeRegistry - Type registration [clob] overrides previous : org.hibernate.type.ClobType@8eae04

1109 [main] INFO org.hibernate.type.BasicTypeRegistry - Type registration [java.sql.Clob] overrides previous : org.hibernate.type.ClobType@8eae04

1109 [main] INFO org.hibernate.type.BasicTypeRegistry - Type registration [characters_clob] overrides previous : org.hibernate.type.PrimitiveCharacterArrayClobType@142c778

1109 [main] INFO org.hibernate.type.BasicTypeRegistry - Type registration [wrapper_materialized_blob] overrides previous : org.hibernate.type.WrappedMaterializedBlobType@135ae7e

1109 [main] INFO org.hibernate.type.BasicTypeRegistry - Type registration [blob] overrides previous : org.hibernate.type.BlobType@1531164

1109 [main] INFO org.hibernate.type.BasicTypeRegistry - Type registration [java.sql.Blob] overrides previous : org.hibernate.type.BlobType@1531164

1109 [main] INFO org.hibernate.type.BasicTypeRegistry - Type registration [wrapper_characters_clob] overrides previous : org.hibernate.type.CharacterArrayClobType@9abce9

1109 [main] INFO org.hibernate.type.BasicTypeRegistry - Type registration [materialized_clob] overrides previous : org.hibernate.type.MaterializedClobType@e8a0cd

1109 [main] INFO org.hibernate.type.BasicTypeRegistry - Type registration [materialized_blob] overrides previous : org.hibernate.type.MaterializedBlobType@95215b

1625 [main] INFO org.hibernate.impl.SessionFactoryObjectFactory - Not binding factory to JNDI, no JNDI name configured

1641 [main] INFO org.hibernate.tool.hbm2ddl.SchemaUpdate - Running hbm2ddl schema update

1641 [main] INFO org.hibernate.tool.hbm2ddl.SchemaUpdate - fetching database metadata

1641 [main] ERROR org.hibernate.tool.hbm2ddl.SchemaUpdate - could not complete schema update

java.lang.UnsupportedOperationException: The user must supply a JDBC connection

at org.hibernate.connection.UserSuppliedConnectionProvider.getConnection(UserSuppliedConnectionProvider.java:54)

at org.hibernate.tool.hbm2ddl.SuppliedConnectionProviderConnectionHelper.prepare(SuppliedConnectionProviderConnectionHelper.java:51)

at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:168)

at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:375)

at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1845)

at financeiro.util.HibernateUtil.buildSessionFactory(HibernateUtil.java:14)

at financeiro.util.HibernateUtil.<clinit>(HibernateUtil.java:8)

at financeiro.web.filter.ConexaoHibernateFilter.init(ConexaoHibernateFilter.java:19)

at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:295)

at org.apache.catalina.core.ApplicationFilterConfig.setFilterDef(ApplicationFilterConfig.java:422)

at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:115)

at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4072)

at org.apache.catalina.core.StandardContext.start(StandardContext.java:4726)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)

at org.apache.catalina.core.StandardHost.start(StandardHost.java:840)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)

at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)

at org.apache.catalina.core.StandardService.start(StandardService.java:525)

at org.apache.catalina.core.StandardServer.start(StandardServer.java:754)

at org.apache.catalina.startup.Catalina.start(Catalina.java:595)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)

at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)

ConexaoHibernateFilter

14/02/2012 14:58:11 org.apache.coyote.http11.Http11Protocol start

INFO: Starting Coyote HTTP/1.1 on http-8080

14/02/2012 14:58:11 org.apache.jk.common.ChannelSocket init

INFO: JK: ajp13 listening on /0.0.0.0:8009

14/02/2012 14:58:11 org.apache.jk.server.JkMain start

INFO: Jk running ID=0 time=0/46  config=null

14/02/2012 14:58:11 org.apache.catalina.startup.Catalina start

INFO: Server startup in 4084 ms

Eu acredito que seja pelo fato das portas serem diferentes por nao estar conseguindo conectar no banco.Porque o projeto ele esta rodando na porta 8080 e o Mysql esta na 3306.
Ou tem que editar o server.xml e trocar as portas?

Segue o hibernate.cfg

<?xml version=“1.0” encoding=“UTF-8”?>
<!DOCTYPE hibernate-configuration PUBLIC
“-//Hibernate/Hibernate Configuration DTD//EN”
http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd”>
<hibernate-configuration>
<session-factory>
<property name=“dialect”>org.hibernate.dialect.MySQL5InnoDBDialect</property>
<!-- <property name=“connection.driver_class”>com.mysql.jdbc.Driver</property>
<property name=“connection.url”>jdbc:mysql://localhost:8080/financeiro</property>
<property name=“connection.username”>root</property>
<property name=“connection.password”>root</property>–>
<property name=“current_session_context_class”>thread</property>
<property name=“hibernate.hbm2ddl.auto”>update</property>

&lt;mapping class="financeiro.usuario.Usuario"/&gt;
</session-factory>

</hibernate-configuration>

<div class="lightbox-wrapper"><a class="lightbox" href="/uploads/3X/3/b/3b9d79c38a91044a4a5436b2e89f473b81ab9156.jpg_.webp" data-download-href="/uploads/default/3b9d79c38a91044a4a5436b2e89f473b81ab9156" title="2012/2/14/531ddcd75c88dc7d5f199193b8178f55_110124.jpg_"><img src="/uploads/3X/3/b/3b9d79c38a91044a4a5436b2e89f473b81ab9156.jpeg.webp" width="690" height="500" srcset="/uploads/3X/3/b/3b9d79c38a91044a4a5436b2e89f473b81ab9156.jpeg.webp, /uploads/3X/3/b/3b9d79c38a91044a4a5436b2e89f473b81ab9156.jpg_.webp 1.5x, /uploads/3X/3/b/3b9d79c38a91044a4a5436b2e89f473b81ab9156.jpg_.webp 2x"><div class="meta">
<svg class="fa d-icon d-icon-far-image svg-icon" aria-hidden="true"><use xlink:href="#far-image"></use></svg>2012/2/14/531ddcd75c88dc7d5f199193b8178f55_110124.jpg_897×330 124 KB<svg class="fa d-icon d-icon-discourse-expand svg-icon" aria-hidden="true"><use xlink:href="#discourse-expand"></use></svg>
</div></a></div>


<div class="lightbox-wrapper"><a class="lightbox" href="/uploads/3X/a/7/a75edd4216bdf7b0ce5160a516e726faeebf1311.jpg_.webp" data-download-href="/uploads/default/a75edd4216bdf7b0ce5160a516e726faeebf1311" title="2012/2/14/c6b3b950017d2babda42ad34e6404519_110124.jpg_"><img src="/uploads/3X/a/7/a75edd4216bdf7b0ce5160a516e726faeebf1311.jpeg.webp" width="690" height="500" srcset="/uploads/3X/a/7/a75edd4216bdf7b0ce5160a516e726faeebf1311.jpeg.webp, /uploads/3X/a/7/a75edd4216bdf7b0ce5160a516e726faeebf1311.jpeg.webp 1.5x, /uploads/3X/a/7/a75edd4216bdf7b0ce5160a516e726faeebf1311.jpg_.webp 2x"><div class="meta">
<svg class="fa d-icon d-icon-far-image svg-icon" aria-hidden="true"><use xlink:href="#far-image"></use></svg>2012/2/14/c6b3b950017d2babda42ad34e6404519_110124.jpg_1280×711 343 KB<svg class="fa d-icon d-icon-discourse-expand svg-icon" aria-hidden="true"><use xlink:href="#discourse-expand"></use></svg>
</div></a></div>
Criado 14 de fevereiro de 2012
Respostas 0
Participantes 1