[jboss-user] [Beginner's Corner] - org.jboss.util.NestedSQLException
Joseph Hwang
do-not-reply at jboss.com
Tue Mar 1 13:44:29 EST 2011
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&containerType=14&container=2075]
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20110301/52d38be9/attachment.html
More information about the jboss-user
mailing list