jboss with oracle db - connection issue
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...
精彩评论