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]
_______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
