Driver Orcale para sistema web em java

24 de março de 2011 6 respostas

poletto81 24 de março de 2011

Ola,

Estou desenvolvendo um sistema web que conecta-se à uma BD Oracle 9i e usa um servidor Jboss 4.0.5GA.
COnfigurei o hibernate e coloquei nas libs o arquivo ojdbc5.
Mas ao tentar acessar o banco aparece o seguinte erro:

15:12:04,496 WARN  [JBossManagedConnectionPool] Throwable while attempting to get a new connection: null
org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: The Network Adapter could not establish the connection)
	
Caused by: java.sql.SQLException: The Network Adapter could not establish the connection
	
Caused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection
	
15:12:04,497 INFO  [STDOUT] 15:12:04,497 WARN  [SettingsFactory] Could not obtain connection metadata
org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (java.sql.SQLException: The Network Adapter could not establish the connection); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: The Network Adapter could not establish the connection))
	
Caused by: org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: The Network Adapter could not establish the connection)
	
Caused by: java.sql.SQLException: The Network Adapter could not establish the connection
	
Caused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection

Alguem pode me auxiliar e corrigir isso?

Obrigado desde já !

6 Respostas

Gustavo_Sperandio 24 de mar. de 2011

posta seu onde você configura a conexão!

poletto81 24 de mar. de 2011

<local-tx-datasource>
    <jndi-name>edbDS</jndi-name>
    <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
    <connection-url>jdbc:oracle:thin:@(DESCRIPTION = (FAILOVER=ON)(ADDRESS = (PROTOCOL = TCP)(HOST = lasjljslajsa-vip)(PORT = 00000))(ADDRESS = (PROTOCOL = TCP)(HOST = sjaskjalksaj-vip)(PORT = 1521))(LOAD_BALANCE = yes)(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = aaaaaaaa)))</connection-url>
    <user-name>XXXXX</user-name>
    <password>YYYY</password>
    <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
    <check-valid-connection-sql>SELECT 1 FROM DUAL</check-valid-connection-sql>
    <min-pool-size>1</min-pool-size>
    <max-pool-size>10</max-pool-size>
    <metadata>
       <type-mapping>Oracle9i</type-mapping>
    </metadata>
  </local-tx-datasource>

</datasources>

drigo.angelo 24 de mar. de 2011

Voce consegue se conectar ao banco “por fora” da aplicação?

poletto81 24 de mar. de 2011

Sim, sem problema nenhum

drigo.angelo 24 de mar. de 2011

roda a consulta que tá em check-valid-connection-sql direto no banco…

poletto81 24 de mar. de 2011

eu ja rodei, eu estou achando que é alguma configuração do driver do Oracle 9i para o JBOSS 4.0.5GA

alguem pode confirmar se é mesmo o OJDBC5.JAR?

Criado 24 de março de 2011

Ultima resposta 24 de mar. de 2011

Respostas 6

Participantes 3

6 Respostas

Topicos relacionados