Joseph Hwang [
http://community.jboss.org/people/aupres] created the discussion
"org.jboss.util.NestedSQLException"
To view the discussion, visit:
http://community.jboss.org/message/590408#590408
--------------------------------------------------------------
When Jboss 5 and Oracle 11g jdbc driver integrated, org.jboss.util.NestedSQLException
occurs!
OS : CentOS Linux 5.5
JDK : JDK 1.5
JBoss : JBoss 5.0.0.GA
DB : 예) Oracle 11g
I put ojdbc5.jar file into jboss-5.0.0.GA/common/lib folder and set oracle-ds.xml file
like below
<datasources>
<local-tx-datasource>
<jndi-name>OracleDS</jndi-name>
<connection-url>jdbc:oracle:thin:@localhost:1521:orcl</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>scott</user-name>
<password>tiger</password>
<min-pool-size>2</min-pool-size>
<max-pool-size>5</max-pool-size>
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
<metadata>
<type-mapping>Oracle11g</type-mapping>
</metadata>
</local-tx-datasource>
</datasources>
In JSP file, code is
ctx=new initialContext();
ds=(DataSource)ctx.lookup("java:/OracleDS");
con=ds.getConnection();
However, code does net generate connection objects.In Eclipse Console, messages are
10:26:07,923 ERROR [STDERR] org.jboss.util.NestedSQLException: Could not create
connection; - nested throwable: (java.sql.SQLException: IO Exception: The Network Adapter
could not establish the connection); - nested throwable:
(org.jboss.resource.JBossResourceException: Could not create connection; - nested
throwable: (java.sql.SQLException: IO Exception: The Network Adapter could not establish
the connection))
10:26:07,923 ERROR [STDERR] at
org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:95)
10:26:07,923 ERROR [STDERR] at
org.apache.jsp.oracletest_jsp._jspService(oracletest_jsp.java:92)
10:26:07,923 ERROR [STDERR] at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)...
Sqlplus of oracle db works well.
I need your advise. Best Regards..
--------------------------------------------------------------
Reply to this message by going to Community
[
http://community.jboss.org/message/590408#590408]
Start a new discussion in Beginner's Corner at Community
[
http://community.jboss.org/choose-container!input.jspa?contentType=1&...]