[RESOLVIDO] -Erro Mapeamento postGree (projeto esperando) - (imagem e o erro)

3 respostas
D

Bom Galera... estou com um projeto esperando só alguns testes do hibernate...
com mysql vai q é uma beleza... mas com o jdbc do postgre eu não estou conseguindo de jeito nenhum...

quero usar o hibernate no projeto... mas os membros querem alguns testes de desepmenho....
mas pra isso preciso pelo menos conseguir mapear minhas classes - -.... esse projeto é apenas pra teste...

Engraçado q parece q está tudo ok....

[img]http://oi54.tinypic.com/j5ftl0.jpg[/img]

[img]http://oi52.tinypic.com/mcrklj.jpg[/img]

1. INFO: Binding entity from annotated class: modelo.Aluno  
   2. INFO: Bind entity modelo.Aluno on table Aluno  
   3. INFO: Hibernate Validator not found: ignoring  
   4. INFO: Instantiated an instance of org.hibernate.validator.engine.resolver.JPATraversableResolver.  
   5. INFO: Instantiated an instance of org.hibernate.validator.engine.resolver.JPATraversableResolver.  
   6. INFO: Unable to find org.hibernate.search.event.FullTextIndexEventListener on the classpath. Hibernate Search is not enabled.  
   7. INFO: Instantiated an instance of org.hibernate.validator.engine.resolver.JPATraversableResolver.  
   8. INFO: Using Hibernate built-in connection pool (not for production use!)  
   9. INFO: Hibernate connection pool size: 20  
  10. INFO: autocommit mode: true  
  11. INFO: using driver: org.postgresql.Driver at URL: jdbc:postgresql://localhost:5432/tabela  
  12. INFO: connection properties: {user=root, password=****, autocommit=true, release_mode=auto}  
  13. AVISO: Could not obtain connection to query metadata  
  14. java.sql.SQLException: No suitable driver found for jdbc:postgresql://localhost:5432/tabela  
  15.     at java.sql.DriverManager.getConnection(DriverManager.java:602)  
  16.     at java.sql.DriverManager.getConnection(DriverManager.java:154)  
  17.     at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:133)  
  18.     at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:114)  
  19.     at org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2163)  
  20.     at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2159)  
  21.     at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1383)  
  22.     at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:954)  
  23.     at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:883)  
  24.     at org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:56)  
  25.     at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:78)  
  26.     at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:54)  
  27.     at bean.AlunoManaged.GeraTabelas(AlunoManaged.java:28)  
  28.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)  
  29.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)  
  30.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)  
  31.     at java.lang.reflect.Method.invoke(Method.java:597)  
  32.     at com.sun.el.parser.AstValue.invoke(AstValue.java:234)  
  33.     at com.sun.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:297)  
  34.     at com.sun.faces.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:98)  
  35.     at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:88)  
  36.     at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102)  
  37.     at javax.faces.component.UICommand.broadcast(UICommand.java:315)  
  38.     at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:775)  
  39.     at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:1267)  
  40.     at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:82)  
  41.     at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101)  
  42.     at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118)  
  43.     at javax.faces.webapp.FacesServlet.service(FacesServlet.java:312)  
  44.     at org.apache.catalina.core.StandardWrapper.service(StandardWrapper.java:1523)  
  45.     at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:279)  
  46.     at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:188)  
  47.     at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:641)  
  48.     at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:97)  
  49.     at com.sun.enterprise.web.PESessionLockingStandardPipeline.invoke(PESessionLockingStandardPipeline.java:85)  
  50.     at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:185)  
  51.     at org.apache.catalina.connector.CoyoteAdapter.doService(CoyoteAdapter.java:325)  
  52.     at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:226)  
  53.     at com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMapper.java:165)  
  54.     at com.sun.grizzly.http.ProcessorTask.invokeAdapter(ProcessorTask.java:791)  
  55.     at com.sun.grizzly.http.ProcessorTask.doProcess(ProcessorTask.java:693)  
  56.     at com.sun.grizzly.http.ProcessorTask.process(ProcessorTask.java:954)  
  57.     at com.sun.grizzly.http.DefaultProtocolFilter.execute(DefaultProtocolFilter.java:170)  
  58.     at com.sun.grizzly.DefaultProtocolChain.executeProtocolFilter(DefaultProtocolChain.java:135)  
  59.     at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:102)  
  60.     at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:88)  
  61.     at com.sun.grizzly.http.HttpProtocolChain.execute(HttpProtocolChain.java:76)  
  62.     at com.sun.grizzly.ProtocolChainContextTask.doCall(ProtocolChainContextTask.java:53)  
  63.     at com.sun.grizzly.SelectionKeyContextTask.call(SelectionKeyContextTask.java:57)  
  64.     at com.sun.grizzly.ContextTask.run(ContextTask.java:69)  
  65.     at com.sun.grizzly.util.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:330)  
  66.     at com.sun.grizzly.util.AbstractThreadPool$Worker.run(AbstractThreadPool.java:309)  
  67.     at java.lang.Thread.run(Thread.java:662)  
  68.   
  69. INFO: Using dialect: org.hibernate.dialect.PostgreSQLDialect  
  70. INFO: Disabling contextual LOB creation as connection was null  
  71. INFO: Transaction strategy: org.hibernate.transaction.JDBCTransactionFactory  
  72. INFO: No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)  
  73. INFO: Automatic flush during beforeCompletion(): disabled  
  74. INFO: Automatic session close at end of transaction: disabled  
  75. INFO: Scrollable result sets: disabled  
  76. INFO: JDBC3 getGeneratedKeys(): disabled  
  77. INFO: Connection release mode: auto  
  78. INFO: Default batch fetch size: 1  
  79. INFO: Generate SQL with comments: disabled  
  80. INFO: Order SQL updates by primary key: disabled  
  81. INFO: Order SQL inserts for batching: disabled  
  82. INFO: Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory  
  83. INFO: Using ASTQueryTranslatorFactory  
  84. INFO: Query language substitutions: {}  
  85. INFO: JPA-QL strict compliance: enabled  
  86. INFO: Second-level cache: enabled  
  87. INFO: Query cache: disabled  
  88. INFO: Cache region factory : org.hibernate.cache.impl.NoCachingRegionFactory  
  89. INFO: Optimize cache for minimal puts: disabled  
  90. INFO: Structured second-level cache entries: disabled  
  91. INFO: Statistics: disabled  
  92. INFO: Deleted entity synthetic identifier rollback: disabled  
  93. INFO: Default entity-mode: pojo  
  94. INFO: Named query checking : enabled  
  95. INFO: Check Nullability in Core (should be disabled when Bean Validation is on): disabled  
  96. INFO: building session factory  
  97. INFO: Not binding factory to JNDI, no JNDI name configured  
  98. INFO: Running hbm2ddl schema update  
  99. INFO: fetching database metadata  
 100. GRAVE: could not get database metadata  
 101. java.sql.SQLException: No suitable driver found for jdbc:postgresql://localhost:5432/tabela  
 102.     at java.sql.DriverManager.getConnection(DriverManager.java:602)  
 103.     at java.sql.DriverManager.getConnection(DriverManager.java:154)  
 104.     at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:133)  
 105.     at org.hibernate.tool.hbm2ddl.SuppliedConnectionProviderConnectionHelper.prepare(SuppliedConnectionProviderConnectionHelper.java:51)  
 106.     at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:168)  
 107.     at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:384)  
 108.     at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1385)  
 109.     at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:954)  
 110.     at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:883)  
 111.     at org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:56)  
 112.     at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:78)  
 113.     at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:54)  
 114.     at bean.AlunoManaged.GeraTabelas(AlunoManaged.java:28)  
 115.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)  
 116.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)  
 117.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)  
 118.     at java.lang.reflect.Method.invoke(Method.java:597)  
 119.     at com.sun.el.parser.AstValue.invoke(AstValue.java:234)  
 120.     at com.sun.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:297)  
 121.     at com.sun.faces.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:98)  
 122.     at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:88)  
 123.     at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102)  
 124.     at javax.faces.component.UICommand.broadcast(UICommand.java:315)  
 125.     at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:775)  
 126.     at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:1267)  
 127.     at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:82)  
 128.     at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101)  
 129.     at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118)  
 130.     at javax.faces.webapp.FacesServlet.service(FacesServlet.java:312)  
 131.     at org.apache.catalina.core.StandardWrapper.service(StandardWrapper.java:1523)  
 132.     at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:279)  
 133.     at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:188)  
 134.     at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:641)  
 135.     at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:97)  
 136.     at com.sun.enterprise.web.PESessionLockingStandardPipeline.invoke(PESessionLockingStandardPipeline.java:85)  
 137.     at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:185)  
 138.     at org.apache.catalina.connector.CoyoteAdapter.doService(CoyoteAdapter.java:325)  
 139.     at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:226)  
 140.     at com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMapper.java:165)  
 141.     at com.sun.grizzly.http.ProcessorTask.invokeAdapter(ProcessorTask.java:791)  
 142.     at com.sun.grizzly.http.ProcessorTask.doProcess(ProcessorTask.java:693)  
 143.     at com.sun.grizzly.http.ProcessorTask.process(ProcessorTask.java:954)  
 144.     at com.sun.grizzly.http.DefaultProtocolFilter.execute(DefaultProtocolFilter.java:170)  
 145.     at com.sun.grizzly.DefaultProtocolChain.executeProtocolFilter(DefaultProtocolChain.java:135)  
 146.     at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:102)  
 147.     at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:88)  
 148.     at com.sun.grizzly.http.HttpProtocolChain.execute(HttpProtocolChain.java:76)  
 149.     at com.sun.grizzly.ProtocolChainContextTask.doCall(ProtocolChainContextTask.java:53)  
 150.     at com.sun.grizzly.SelectionKeyContextTask.call(SelectionKeyContextTask.java:57)  
 151.     at com.sun.grizzly.ContextTask.run(ContextTask.java:69)  
 152.     at com.sun.grizzly.util.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:330)  
 153.     at com.sun.grizzly.util.AbstractThreadPool$Worker.run(AbstractThreadPool.java:309)  
 154.     at java.lang.Thread.run(Thread.java:662)  
 155.   
 156. GRAVE: could not complete schema update  
 157. java.sql.SQLException: No suitable driver found for jdbc:postgresql://localhost:5432/tabela  
 158.     at java.sql.DriverManager.getConnection(DriverManager.java:602)  
 159.     at java.sql.DriverManager.getConnection(DriverManager.java:154)  
 160.     at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:133)  
 161.     at org.hibernate.tool.hbm2ddl.SuppliedConnectionProviderConnectionHelper.prepare(SuppliedConnectionProviderConnectionHelper.java:51)  
 162.     at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:168)  
 163.     at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:384)  
 164.     at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1385)  
 165.     at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:954)  
 166.     at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:883)  
 167.     at org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:56)  
 168.     at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:78)  
 169.     at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:54)  
 170.     at bean.AlunoManaged.GeraTabelas(AlunoManaged.java:28)  
 171.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)  
 172.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)  
 173.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)  
 174.     at java.lang.reflect.Method.invoke(Method.java:597)  
 175.     at com.sun.el.parser.AstValue.invoke(AstValue.java:234)  
 176.     at com.sun.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:297)  
 177.     at com.sun.faces.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:98)  
 178.     at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:88)  
 179.     at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102)  
 180.     at javax.faces.component.UICommand.broadcast(UICommand.java:315)  
 181.     at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:775)  
 182.     at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:1267)  
 183.     at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:82)  
 184.     at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101)  
 185.     at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118)  
 186.     at javax.faces.webapp.FacesServlet.service(FacesServlet.java:312)  
 187.     at org.apache.catalina.core.StandardWrapper.service(StandardWrapper.java:1523)  
 188.     at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:279)  
 189.     at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:188)  
 190.     at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:641)  
 191.     at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:97)  
 192.     at com.sun.enterprise.web.PESessionLockingStandardPipeline.invoke(PESessionLockingStandardPipeline.java:85)  
 193.     at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:185)  
 194.     at org.apache.catalina.connector.CoyoteAdapter.doService(CoyoteAdapter.java:325)  
 195.     at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:226)  
 196.     at com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMapper.java:165)  
 197.     at com.sun.grizzly.http.ProcessorTask.invokeAdapter(ProcessorTask.java:791)  
 198.     at com.sun.grizzly.http.ProcessorTask.doProcess(ProcessorTask.java:693)  
 199.     at com.sun.grizzly.http.ProcessorTask.process(ProcessorTask.java:954)  
 200.     at com.sun.grizzly.http.DefaultProtocolFilter.execute(DefaultProtocolFilter.java:170)  
 201.     at com.sun.grizzly.DefaultProtocolChain.executeProtocolFilter(DefaultProtocolChain.java:135)  
 202.     at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:102)  
 203.     at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:88)  
 204.     at com.sun.grizzly.http.HttpProtocolChain.execute(HttpProtocolChain.java:76)  
 205.     at com.sun.grizzly.ProtocolChainContextTask.doCall(ProtocolChainContextTask.java:53)  
 206.     at com.sun.grizzly.SelectionKeyContextTask.call(SelectionKeyContextTask.java:57)  
 207.     at com.sun.grizzly.ContextTask.run(ContextTask.java:69)  
 208.     at com.sun.grizzly.util.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:330)  
 209.     at com.sun.grizzly.util.AbstractThreadPool$Worker.run(AbstractThreadPool.java:309)  
 210.     at java.lang.Thread.run(Thread.java:662)  
 211.   
 212. INFO: AVISO: FacesMessage(s) foram enfileirados, mas podem não ter sido exibidos.  
 213. sourceId=null[severity=(ERROR 2), summary=(Um ou mais recursos possuem o destino de 'head', mas nenhum componente de 'head' foi definido na exibição.), detail=(Um ou mais recursos possuem o destino de 'head', mas nenhum componente de 'head' foi definido na exibição.)]

Agradeço desde já

3 Respostas

jeangos

Possíveis problemas: O usuário não é postgres e, vez de root ???

INFO: connection properties: {user=root, password=****, autocommit=true, release_mode=auto}

Acho que por isso ele não conectou!!

13. AVISO: Could not obtain connection to query metadata

Você disponibilizou o Driver do postgre no servidor, ele é externo ao projeto, geralmente o eclipse não o incorpora!!!

14. java.sql.SQLException: No suitable driver found for jdbc:postgresql://localhost:5432/tabela

Voilá!

D

ele é root mesmo… … eu inclusive criei outra base para tentar…

quanto ao driver ser externo? não entendi…

eu adicionei o driver jdbc do mysql como podem ver aí nas imagens… e do mysql conectou certinho…

bom… no caso eu coloco o nome da base certo?? tabela mesmo… não do esquema?

vou tentar conectar direto com o driver

D

Acheiiiiiiiiii o problema…
afff

foi como nosso amigo disse… eu adicionei o driver do postgre só no projeto… coloquei o driver na pasta do servidor…

na pasta lib do glassfish… ele funcionou direitinho - -

vlw parceiro

Criado 17 de fevereiro de 2011
Ultima resposta 20 de fev. de 2011
Respostas 3
Participantes 2