Problem while Loading data in Oracle 9i Database

["GunjanTiwari" <gunjan@iopsis.com>]

     Hi all,

             I am using Oracle 9i database with latest beta release of ebxmlrr registry Server but i am getting the following exceptions when  I execute the "createDemoDB" target.The error is while loading the Object Types taxonomy.It gives "No suitable driver" while both the oracle thin drivers(classes111.jar,classes12.jar) are in my classpath & it also creates all the tables successfully in the database.

Anyone, who has used Oracle 9i DB with registry server, plz help

 

     [echo] Loading ObjectTypes taxonomy as RegistryOperator
     [java] <?xml version="1.0"?>
     [java] <soap-env:Envelope
     [java]     xmlns:soap-env="http://schemas.xmlsoap.org/soap/envelope/"
     [java]     xmlns:SOAP-SEC="http://schemas.xmlsoap.org/soap/security/2000-12
" soap-env:actor="some-uri"
     [java]     soap-env:mustUnderstand="1">

 

     [java]     <soap-env:Header>
     [java]     </soap-env:Header>

 

     [java]     <soap-env:Body SOAP-SEC:id="Body">

 

     [java] <RegistryResponse status="Failure" xmlns="urn:oasis:names:tc:ebxml-r
egrep:registry:xsd:2.1"><RegistryErrorList><RegistryError codeContext="RegistryJ
AXMServlet" errorCode="Unknown" severity="Error">com.sun.ebxml.registry.Registry
Exception: No suitable driver
     [java]     at com.sun.ebxml.registry.persistence.rdb.SQLPersistenceManagerI
mpl.executeSQLQuery(SQLPersistenceManagerImpl.java:905)
     [java]     at com.sun.ebxml.registry.query.sql.SQLQueryProcessor.executeQue
ry(SQLQueryProcessor.java:58)
     [java]     at com.sun.ebxml.registry.security.authentication.Authentication
ServiceImpl.getUserFromAlias(AuthenticationServiceImpl.java:309)
     [java]     at com.sun.ebxml.registry.security.authentication.Authentication
ServiceImpl.getUserFromXMLSignature(AuthenticationServiceImpl.java:383)
     [java]     at com.sun.ebxml.registry.interfaces.Request.process(Request.jav
a:87)
     [java]     at com.sun.ebxml.registry.interfaces.soap.RegistryJAXMServlet.on
Message(RegistryJAXMServlet.java:183)
     [java]     at javax.xml.messaging.JAXMServlet.doPost(Unknown Source)
     [java]     at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
     [java]     at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
     [java]     at org.apache.catalina.core.ApplicationFilterChain.internalDoFil
ter(ApplicationFilterChain.java:247)
     [java]     at org.apache.catalina.core.ApplicationFilterChain.doFilter(Appl
icationFilterChain.java:193)
     [java]     at org.apache.catalina.core.StandardWrapperValve.invoke(Standard
WrapperValve.java:260)
     [java]     at org.apache.catalina.core.StandardPipeline$StandardPipelineVal
veContext.invokeNext(StandardPipeline.java:643)
     [java]     at org.apache.catalina.core.StandardPipeline.invoke(StandardPipe
line.java:480)
     [java]     at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.j
ava:995)
     [java]     at org.apache.catalina.core.StandardContextValve.invoke(Standard
ContextValve.java:191)
     [java]     at org.apache.catalina.core.StandardPipeline$StandardPipelineVal
veContext.invokeNext(StandardPipeline.java:643)
     [java]     at org.apache.catalina.core.StandardPipeline.invoke(StandardPipe
line.java:480)
     [java]     at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.j
ava:995)
     [java]     at org.apache.catalina.core.StandardContext.invoke(StandardConte
xt.java:2396)
     [java]     at org.apache.catalina.core.StandardHostValve.invoke(StandardHos
tValve.java:180)
     [java]     at org.apache.catalina.core.StandardPipeline$StandardPipelineVal
veContext.invokeNext(StandardPipeline.java:643)
     [java]     at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorD
ispatcherValve.java:170)
     [java]     at org.apache.catalina.core.StandardPipeline$StandardPipelineVal
veContext.invokeNext(StandardPipeline.java:641)
     [java]     at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorRepor
tValve.java:172)
     [java]     at org.apache.catalina.core.StandardPipeline$StandardPipelineVal
veContext.invokeNext(StandardPipeline.java:641)
     [java]     at org.apache.catalina.core.StandardPipeline.invoke(StandardPipe
line.java:480)
     [java]     at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.j
ava:995)
     [java]     at org.apache.catalina.core.StandardEngineValve.invoke(StandardE
ngineValve.java:174)
     [java]     at org.apache.catalina.core.StandardPipeline$StandardPipelineVal
veContext.invokeNext(StandardPipeline.java:643)
     [java]     at org.apache.catalina.core.StandardPipeline.invoke(StandardPipe
line.java:480)
     [java]     at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.j
ava:995)
     [java]     at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter
.java:223)
     [java]     at org.apache.coyote.http11.Http11Processor.process(Http11Proces
sor.java:405)
     [java]     at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandl
er.processConnection(Http11Protocol.java:380)
     [java]     at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpo
int.java:508)
     [java]     at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run
(ThreadPool.java:533)
     [java]     at java.lang.Thread.run(Thread.java:536)

 

     [java] Nested exception was:
     [java] java.sql.SQLException: No suitable driver
     [java]     at java.sql.DriverManager.getConnection(DriverManager.java:532)
     [java]     at java.sql.DriverManager.getConnection(DriverManager.java:171)
     [java]     at com.sun.ebxml.registry.persistence.rdb.ConnectionPool.newConn
ection(ConnectionPool.java:168)
     [java]     at com.sun.ebxml.registry.persistence.rdb.ConnectionPool.&lt;ini
t&gt;(ConnectionPool.java:46)
     [java]     at com.sun.ebxml.registry.persistence.rdb.SQLPersistenceManagerI
mpl.createConnectionPool(SQLPersistenceManagerImpl.java:133)
     [java]     at com.sun.ebxml.registry.persistence.rdb.SQLPersistenceManagerI
mpl.&lt;init&gt;(SQLPersistenceManagerImpl.java:82)
     [java]     at com.sun.ebxml.registry.persistence.rdb.SQLPersistenceManagerI
mpl.getInstance(SQLPersistenceManagerImpl.java:177)
     [java]     at com.sun.ebxml.registry.query.sql.SQLParser.&lt;init&gt;(SQLPa
rser.java:19)
     [java]     at com.sun.ebxml.registry.query.sql.SQLQueryProcessor.executeQue
ry(SQLQueryProcessor.java:50)
     [java]     at com.sun.ebxml.registry.security.authentication.Authentication
ServiceImpl.getUserFromAlias(AuthenticationServiceImpl.java:309)
     [java]     at com.sun.ebxml.registry.security.authentication.Authentication
ServiceImpl.getUserFromXMLSignature(AuthenticationServiceImpl.java:383)
     [java]     at com.sun.ebxml.registry.interfaces.Request.process(Request.jav
a:87)
     [java]     at com.sun.ebxml.registry.interfaces.soap.RegistryJAXMServlet.on
Message(RegistryJAXMServlet.java:183)
     [java]     at javax.xml.messaging.JAXMServlet.doPost(Unknown Source)
     [java]     at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
     [java]     at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
     [java]     at org.apache.catalina.core.ApplicationFilterChain.internalDoFil
ter(ApplicationFilterChain.java:247)
     [java]     at org.apache.catalina.core.ApplicationFilterChain.doFilter(Appl
icationFilterChain.java:193)
     [java]     at org.apache.catalina.core.StandardWrapperValve.invoke(Standard
WrapperValve.java:260)
     [java]     at org.apache.catalina.core.StandardPipeline$StandardPipelineVal
veContext.invokeNext(StandardPipeline.java:643)
     [java]     at org.apache.catalina.core.StandardPipeline.invoke(StandardPipe
line.java:480)
     [java]     at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.j
ava:995)
     [java]     at org.apache.catalina.core.StandardContextValve.invoke(Standard
ContextValve.java:191)
     [java]     at org.apache.catalina.core.StandardPipeline$StandardPipelineVal
veContext.invokeNext(StandardPipeline.java:643)
     [java]     at org.apache.catalina.core.StandardPipeline.invoke(StandardP

Thanks
Gunjan Tiwari
________________________iopsis Software______
This email may contain material that is confidential and/or privileged. It is for the sole use of the intended recipient. Any review, reliance or distribution by others of the e-mail or its contents or forwarding without express permission is strictly prohibited. No contractual undertakings are accepted by virtue of transmission of this e-mail unless expressly stated otherwise in the text of the e-mail itself. If you are not the intended recipient, please contact the sender and delete all copies. Contact us directly or via our website at http://www.iopsis.com

________________________iopsis Software______