Olá pessoal, eu acho que to errando na URL de conexão… nesse projeto eu to usando JSF + Hibernate + Spring
Localmente eu acesso a base assim…
context.xml
<?xml version="1.0" encoding="UTF-8"?>
<Context reloadable="true" path="/Pesquisa">
<Resource auth="Container" driverClassName="org.postgresql.Driver" maxActive="20" maxIdle="20" maxWait="20" name="jdbc/pesquisatcc" password="postgres" type="javax.sql.DataSource" url="jdbc:postgresql://localhost:5432/diogoh_pesquisatcc?autoReconnect=true" username="postgres"/>
</Context>hibernate.cfg.xml
<property name="connection.datasource">java:/comp/env/jdbc/pesquisatcc</property>
<property name="current_session_context_class">thread</property>
<property name="hibernate.hbm2ddl.auto">update</property>
<!-- Usando as configurações do C3PO para pool de conexões -->
<property name="c3po.min_size">5</property>
<property name="c3po.max_size">20</property>
<property name="c3po.timeout">300</property>
<property name="c3po.max_statements">50</property>
<property name="c3po.idle_test_period">3000</property>
....Antes de Construir e Limpar no Netbeans eu mudei essas conexões, eu criei uma base de dados na minha hospedagem pela Integrator, e criei um usuário e senha para essa base de dados, ai ficou assim os arquivos de conexão…
hibernate.cfg.xml
<property name="connection.datasource">java:/comp/env/jdbc/diogoh_pesquisatcc</property>
<property name="current_session_context_class">thread</property>
<property name="hibernate.hbm2ddl.auto">update</property>
<!-- Usando as configurações do C3PO para pool de conexões -->
<property name="c3po.min_size">5</property>
<property name="c3po.max_size">20</property>
<property name="c3po.timeout">300</property>
<property name="c3po.max_statements">50</property>
<property name="c3po.idle_test_period">3000</property>
context.xml
<?xml version="1.0" encoding="UTF-8"?>
<Context reloadable="true" path="/Pesquisa">
<Resource auth="Container" driverClassName="org.postgresql.Driver" maxActive="20" maxIdle="20" maxWait="20" name="jdbc/diogoh_pesquisatcc" password="xxxxx" type="javax.sql.DataSource" url="jdbc:postgresql://www.diogoh.info/diogoh_pesquisatcc?autoReconnect=true" username="xxxxxx"/>
</Context>O log no servidor é esse…
Mar 22, 2013 10:14:52 PM org.hibernate.cfg.Configuration getConfigurationInputStream
INFO: Configuration resource: hibernate.cfg.xml
Mar 22, 2013 10:14:52 PM org.hibernate.cfg.Configuration doConfigure
INFO: Configured SessionFactory: null
Mar 22, 2013 10:14:52 PM org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class: pesquisa.usuario.Usuario
Mar 22, 2013 10:14:52 PM org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity pesquisa.usuario.Usuario on table Usuario
Mar 22, 2013 10:14:52 PM org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class: pesquisa.formulario.Formulario
Mar 22, 2013 10:14:52 PM org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity pesquisa.formulario.Formulario on table Formulario
Mar 22, 2013 10:14:52 PM org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class: pesquisa.estado.Estado
Mar 22, 2013 10:14:52 PM org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity pesquisa.estado.Estado on table Estado
Mar 22, 2013 10:14:52 PM org.hibernate.cfg.AnnotationConfiguration secondPassCompile
INFO: Hibernate Validator not found: ignoring
Mar 22, 2013 10:14:52 PM org.hibernate.util.NamingHelper getInitialContext
INFO: JNDI InitialContext properties:{}
Mar 22, 2013 10:14:52 PM org.hibernate.connection.DatasourceConnectionProvider configure
INFO: Using datasource: java:/comp/env/jdbc/diogoh_pesquisatcc
Mar 22, 2013 10:14:52 PM org.hibernate.cfg.SettingsFactory buildSettings
WARNING: Could not obtain connection metadata
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
at org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:69)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:84)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2009)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1292)
at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:859)
at pesquisa.util.HibernateUtil.buildSessionFactory(HibernateUtil.java:14)
at pesquisa.util.HibernateUtil.(HibernateUtil.java:8)
at pesquisa.web.ConexaoHibernateFilter.init(ConexaoHibernateFilter.java:19)
at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:277)
at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:258)
at org.apache.catalina.core.ApplicationFilterConfig.setFilterDef(ApplicationFilterConfig.java:382)
at org.apache.catalina.core.ApplicationFilterConfig.(ApplicationFilterConfig.java:103)
at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4650)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5306)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:633)
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:968)
at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1646)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
Caused by: org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:138)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
at org.postgresql.jdbc2.AbstractJdbc2Connection.(AbstractJdbc2Connection.java:125)
at org.postgresql.jdbc3.AbstractJdbc3Connection.(AbstractJdbc3Connection.java:30)
at org.postgresql.jdbc3g.AbstractJdbc3gConnection.(AbstractJdbc3gConnection.java:22)
at org.postgresql.jdbc4.AbstractJdbc4Connection.(AbstractJdbc4Connection.java:32)
at org.postgresql.jdbc4.Jdbc4Connection.(Jdbc4Connection.java:24)
at org.postgresql.Driver.makeConnection(Driver.java:393)
at org.postgresql.Driver.connect(Driver.java:267)
at org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
at org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)
... 28 more
Caused by: java.net.ConnectException: Connection refused
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:351)
at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:213)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:200)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
at java.net.Socket.connect(Socket.java:529)
at java.net.Socket.connect(Socket.java:478)
at java.net.Socket.(Socket.java:375)
at java.net.Socket.(Socket.java:189)
at org.postgresql.core.PGStream.(PGStream.java:62)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:76)
... 40 more
Cria��o inicial do objeto SessionFactory falhou. Erro: org.hibernate.HibernateException: Hibernate Dialect must be explicitly set
Mar 22, 2013 10:14:52 PM org.apache.catalina.core.StandardContext startInternal
SEVERE: Error filterStart
Mar 22, 2013 10:14:52 PM org.apache.catalina.core.StandardContext startInternal
SEVERE: Context [/Pesquisa] startup failed due to previous errors
Mar 22, 2013 10:14:52 PM org.springframework.context.support.AbstractApplicationContext doClose
INFO: Closing Root WebApplicationContext: startup date [Fri Mar 22 22:14:49 BRT 2013]; root of context hierarchy
Mar 22, 2013 10:14:52 PM org.springframework.beans.factory.support.DefaultSingletonBeanRegistry destroySingletons
INFO: Destroying singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@326cbecf: defining beans [pesquisatccDataSource,org.springframework.security.web.PortMapperImpl#0,org.springframework.security.web.context.HttpSessionSecurityContextRepository#0,org.springframework.security.web.authentication.session.SessionFixationProtectionStrategy#0,org.springframework.security.authentication.ProviderManager#0,org.springframework.security.access.vote.AffirmativeBased#0,org.springframework.security.web.access.intercept.FilterSecurityInterceptor#0,org.springframework.security.web.access.DefaultWebInvocationPrivilegeEvaluator#0,org.springframework.security.authentication.AnonymousAuthenticationProvider#0,org.springframework.security.web.authentication.rememberme.TokenBasedRememberMeServices#0,org.springframework.security.authentication.RememberMeAuthenticationProvider#0,org.springframework.security.web.savedrequest.HttpSessionRequestCache#0,org.springframework.security.web.authentication.UsernamePasswordAuthenticationFilter#0,org.springframework.security.config.http.UserDetailsServiceInjectionBeanPostProcessor#0,org.springframework.security.filterChainProxy,org.springframework.security.provisioning.JdbcUserDetailsManager#0,org.springframework.security.authentication.dao.DaoAuthenticationProvider#0,org.springframework.security.authentication.DefaultAuthenticationEventPublisher#0,org.springframework.security.authenticationManager]; root of factory hierarchy
Mar 22, 2013 10:14:52 PM org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc
SEVERE: The web application [/Pesquisa] registered the JDBC driver [org.postgresql.Driver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.
Mar 22, 2013 10:14:52 PM org.apache.catalina.loader.WebappClassLoader checkThreadLocalMapForLeaks
SEVERE: The web application [/Pesquisa] created a ThreadLocal with key of type [javax.faces.context.FacesContext$1] (value [javax.faces.context.FacesContext$1@65459c6f]) and a value of type [com.sun.faces.config.InitFacesContext] (value [com.sun.faces.config.InitFacesContext@3d216f5a]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable memory leak.
Mar 22, 2013 10:14:52 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory /home/diogoh/appservers/apache-tomcat-7x/webapps/host-manager
Mar 22, 2013 10:14:52 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory /home/diogoh/appservers/apache-tomcat-7x/webapps/manager
Mar 22, 2013 10:14:52 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory /home/diogoh/appservers/apache-tomcat-7x/webapps/ROOT
Mar 22, 2013 10:14:52 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory /home/diogoh/appservers/apache-tomcat-7x/webapps/docs
Mar 22, 2013 10:14:52 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory /home/diogoh/appservers/apache-tomcat-7x/webapps/examples
Mar 22, 2013 10:14:52 PM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["http-bio-127.0.0.1-4994"]
Mar 22, 2013 10:14:52 PM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["http-bio-127.0.0.1-4993"]
Mar 22, 2013 10:14:52 PM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["ajp-bio-127.0.0.1-4992"]
Mar 22, 2013 10:14:52 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 6718 msOnde eu poderia estar errando ? e o meu primeiro Deploy, to apanhando em kkkkkkk
Minha URL de conexão está certa ?
Ele cria a pasta Pesquisa no webapps tranquilamente, mas da erro erro no log, e quando vou acessar a página da aplicação da erro 404.