开发者

jboss with oracle db - connection issue

开发者 https://www.devze.com 2023-02-14 12:44 出处:网络
I\'m struggling for two hours to deploy an application on Jboss server which connects to my Oracle DB.

I'm struggling for two hours to deploy an application on Jboss server which connects to my Oracle DB.

The dbname-ds.xml has:

<datasources>
    <local-tx-datasource>
        <jndi-name>dbnameDatasource</jndi-name>
        <use-java-context>false</use-java-context>
        <connection-url>jdbc:oracle:thin:@192.168.168.105:1521:XE</connection开发者_如何学运维-url>
        <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
        <user-name>system</user-name>
        <password>password</password>
    </local-tx-datasource>
</datasources>

The credentials are ok because I've tested them using DataBase home page tool from Oracle.

The error I receive in jboss is:

  00:14:28,383 INFO  [ConnectionProviderFactory] Initializing connection provider:
 org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider
00:14:28,389 INFO  [InjectedDataSourceConnectionProvider] Using provided datasou
rce
00:14:49,476 WARN  [JBossManagedConnectionPool] Throwable while attempting to ge
t a new connection: null
org.jboss.resource.JBossResourceException: Could not create connection; - nested
 throwable: (java.sql.SQLException: Io exception: The Network Adapter could not
establish the connection)
        at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.g
etLocalManagedConnection(LocalManagedConnectionFactory.java:225)

//etc

and caused by:

 Caused by: java.sql.SQLException: Io exception: The Network Adapter could not es
tablish the connection
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:112)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java

Do you have any idea where to look?

I've also modified the default localhost to be my ip from ds file:

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.168.105)(PORT = 1521))

so the host and port is correct.

What else can be the cause...?

Thanks a lot...

0

精彩评论

暂无评论...
验证码 换一张
取 消