posted 16 years ago
I am trying to connect to oracle database by a jndi lookup.I am using sun's blackbox resource adapter (blackboxnotx.rar).
app server-embedded oc4j.I have configured all the files(datasources.xml,oc4j.xml,ra.xml,oc4j-connectors.xml etc..)to include blackbox resource adapter.
when i do the jndi look up for the datasource i get the following error
I have added classes12.zip on my classpath.
08/12/09 10:28:57 com.sun.connector.blackbox.JdbcDataSource@241391
08/12/09 10:28:57 Exception raisedSQLException: No suitable driver
08/12/09 10:28:57 java.sql.SQLException: SQLException: No suitable driver
08/12/09 10:28:57 at com.sun.connector.blackbox.JdbcDataSource.getConnection(JdbcDataSource.java:77)
08/12/09 10:28:57 at Dao.MainDao.getconnection(MainDao.java:31)
08/12/09 10:28:57 at struts.LoginAction.execute(LoginAction.java:20)
08/12/09 10:28:57 at org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:58)
08/12/09 10:28:57 at org.apache.struts.chain.commands.AbstractExecuteAction.execute(AbstractExecuteAction.java:67)
08/12/09 10:28:57 at org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51)
08/12/09 10:28:57 at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
08/12/09 10:28:57 at org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:304)
08/12/09 10:28:57 at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
08/12/09 10:28:57 at org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283)
08/12/09 10:28:57 at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
08/12/09 10:28:57 at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462)
08/12/09 10:28:57 at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
08/12/09 10:28:57 at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
08/12/09 10:28:57 at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:713)
08/12/09 10:28:57 at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
08/12/09 10:28:57 at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871)
08/12/09 10:28:57 at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)
08/12/09 10:28:57 at com.evermind.server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:221)
08/12/09 10:28:57 at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:122)
08/12/09 10:28:57 at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:111)
08/12/09 10:28:57 at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
08/12/09 10:28:57 at oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:234)
08/12/09 10:28:57 at oracle.oc4j.network.ServerSocketAcceptHandler.access$700(ServerSocketAcceptHandler.java:29)
08/12/09 10:28:57 at oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:879)
08/12/09 10:28:57 at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
08/12/09 10:28:57 at java.lang.Thread.run(Thread.java:595)
Please help me find a solution.
Thanks