Could not create connection !!
shon2004 Jul 21, 2005 2:38 PMHI Everybody,
I am new bie to JBoss and I am trying to connect Oracle and having some problems, would appreciate if somobody can respond urgently. I have ojdbc14.jar in WEB-INF/lib diretory
Here are my app-ds.xml file
code:
--------------------------------------------------------------------------------
<local-tx-datasource> <jndi-name>TEST_CONN</jndi-name> <use-java-context>false</use-java-context> <connection-url>jdbc racle:thin:@dev:1521:test_dev</connection-url> <driver-class>oracle.jdbc.driver.OracleDriver</driver-class> <connection-property name="autoCommit">false</connection-property> <user-name>sysadmin</user-name> sys_admin <blocking-timeout-millis>50000</blocking-timeout-millis> <!-- Checks the Oracle error codes and messages for fatal errors --> <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name> <new-connection-sql>select * from dual</new-connection-sql> </local-tx-datasource>
--------------------------------------------------------------------------------
web.xml --file
code:
--------------------------------------------------------------------------------
<resource-ref> Test Database Connection Pool <res-ref-name>jdbc/TEST_CONN</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth></resource-ref>
--------------------------------------------------------------------------------
Here is the code by which I am trying to get the connection:
code:
--------------------------------------------------------------------------------
private Context getInitialContext() throws NamingException { Context ctx = new InitialContext(); return ctx; }
--------------------------------------------------------------------------------
code:
--------------------------------------------------------------------------------
try { ds = (javax.sql.DataSource) getInitialContext().lookup( "TEST_CONN"); System.out.print("ds**********" + ds); } catch (Exception e) { e.printStackTrace(); throw new RuntimeException("cannot get database pool", e); } try{ Connection localConnection = ds.getConnection(); System.out.println("localConnection>>>>>>>>>>>>>" + localConnection); } catch(SQLException e){ e.printStackTrace(); } finally { try { if (localConnection != null) localConnection.close(); } catch (SQLException e) { log.error(e); }
--------------------------------------------------------------------------------
Here is the error:
10:37:59,262 INFO [STDOUT] ds**********org.jboss.resource.adapter.jdbc.WrapperD
ataSource@335053
10:37:59,402 WARN [JBossManagedConnectionPool] Throwable while attempting to ge
t a new connection: null
org.jboss.resource.JBossResourceException: Could not create connection; - nested
throwable: (org.jboss.resource.JBossResourceException: Apparently wrong driver
class specified for URL: class: oracle.jdbc.driver.OracleDriver, url: jdbc racle:thin:@dev:1521:test_dev at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.c
reateManagedConnection(LocalManagedConnectionFactory.java:161)
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.cr
eateConnectionEventListener(InternalManagedConnectionPool.java:508)
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.ge
tConnection(InternalManagedConnectionPool.java:207)
at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BaseP
ool.getConnection(JBossManagedConnectionPool.java:534)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManage
dConnection(BaseConnectionManager2.java:395)
at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedCo
nnection(TxConnectionManager.java:297)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateC
onnection(BaseConnectionManager2.java:447)
at org.jboss.resource.connectionmanager.BaseConnectionManager2$Connectio
nManagerProxy.allocateConnection(BaseConnectionManager2.java:874)
at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(Wrapp
erDataSource.java:103)
at com.exelixis.plateloader.ProcessBarcodeAction.execute(ProcessBarcodeA
ction.java:78)
at org.apache.struts.action.RequestProcessor.processActionPerform(Reques
tProcessor.java:421)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.ja
va:226)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:116
4)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)