Could not create connection !!!!

[shailesh kumar]

HI 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

<datasources> 
  <local-tx-datasource> 
    <jndi-name>TEST_CONN</jndi-name>
<use-java-context>false</use-java-context>
    <connection-url>jdbc :-o	 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> 
    <password>sys_admin</password> 
    <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> 
</datasources> 

web.xml --file

<resource-ref>
<description>Test Database Connection Pool</description>
<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:

private Context getInitialContext() throws NamingException {  
        Context ctx = new InitialContext();  
        return ctx; }

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)

[Dave Salter]

It looks like you are using the wrong Oracle drivers for your version of your database. Are you using the correct drivers?

[shailesh kumar]

I think i have to classes12.jar file in lib directory, i removed the ojdbc14.jar and i copied classes12.jar file. now iam getting diffrent error..i dont understand why jboss is loading this driver..this unrelated to my application

 
13:48:32,082 INFO  [STDOUT] DatasSource>>>>>>>>>org.jboss.resource.adapter.jdbc.
WrapperDataSource@335053
13:48:32,082 INFO  [WebappClassLoader] Illegal access: this web application inst
ance has been stopped already.  Could not load org.hsqldb.jdbcDriver.  The event
ual following stack trace is caused by an error thrown for debugging purposes as
 well as to attempt to terminate the thread which caused the illegal access, and
 has no functional impact.
13:48:32,082 WARN  [JBossManagedConnectionPool] Throwable while attempting to ge
t a new connection: null
java.lang.ThreadDeath
        at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoa
der.java:1221)
        at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoa
der.java:1181)
        at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:315)
        at java.lang.Class.forName0(Native Method)
        at java.lang.Class.forName(Class.java:217)
        at java.sql.DriverManager.getCallerClass(DriverManager.java:440)
        at java.sql.DriverManager.getDrivers(DriverManager.java:336)
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:294)
        at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.c
reateManagedConnection(LocalManagedConnectionFactory.java:151)
        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)

[norman richards]

Do not put database drivers in WEB-INF/lib. Put them in the lib directory for your configuration.

[somkiat puisungnoen]

Could not load org.hsqldb.jdbcDriver.

Because , you deleted driver of HypersonicDB from lib directory of jboss. ( restore driver )

[trinity]

For oracle 10g and if you are using jdk1.4 or higher use ojdbc14.jar. Download ojdbc14.jar from oracle website.

Place it inthe jboss/default/lib directory.

Connection conn = null;
Context ic =null;
DataSource ds=null;
// To be used in JBoss Server
try{
ic = new InitialContext();

ds=(DataSource)ic.lookup("java:/OracleDS");
System.out.println(ds.toString());
//System.out.println(ds.);
conn = ds.getConnection();
}
catch(Exception ere)
{
ere.printStackTrace();
}

OraceDS is the JNDI name give inghe Oracle-ds.xml file

If your problem is not fixed, let me help you.

Trinity