naga eswar

Dave Tolls wrote:Converting the serialised BLOB back into meaningful data in PL/SQL is going to be very hard.
You'd need to look into what the structure of the data is (how Java serialises things).

You really need to use Java.

Thanks Dave. Yes, I googled the and till I found the  same thing.
Trying for if any alterate.

Dave Tolls wrote:Assuming this "Java Object" is a serialised instance of your DVO then you are going to need to write some Java code to convert that back to a Java object and then pick out the data you want.
I don't know what state Java in Oracle is in, but that would be the place to do it and call that Java stored procedure from your PL/SQL to get the info you need.

As for how to write that, you'll need to dig up the Oracle documentation for your version.

Dave Tolls wrote:Assuming this "Java Object" is a serialised instance of your DVO then you are going to need to write some Java code to convert that back to a Java object and then pick out the data you want.
I don't know what state Java in Oracle is in, but that would be the place to do it and call that Java stored procedure from your PL/SQL to get the info you need.

As for how to write that, you'll need to dig up the Oracle documentation for your version.

Thanks Dave. Yours Assuming is right. "Java Object" is a serialised instance of DVO and it is inserting in table. Below is the code.
       EmployeeDetails empDetails = new EmployeeDetails(); //DVO        empDetails.setFirstName("Krishna");        empDetails.setLastName("Gupta");        empDetails.setEmployeeID("540058");        Object payDtl = (Object)            ByteArrayOutputStream oByteArrOpStrm = new ByteArrayOutputStream();        ObjectOutputStream oObjOpStrm = new ObjectOutputStream(oByteArrOpStrm);        oObjOpStrm.writeObject(empDetails);        oObjOpStrm.flush();        oObjOpStrm.close();        byte[] arrByteArrOpStrm = oByteArrOpStrm.toByteArray();

       Finally  arrByteArrOpStrm is inserting in blob column of a table and Yes, java code is there is convert back.
       But we need handle this in PL/SQL Procedure.

Mike London wrote:Did you do some searches online for code that's already written for this?

For example:

https://docs.oracle.com/javase/tutorial/jdbc/basics/blob.html

http://www.java2s.com/Code/Java/Database-SQL-JDBC/GetBLOBdatafromresultset.htm

Please post the code you have so far so we can help you.

-- mike

Thank You Mike. But this is in java code how to retrieve or Insert Blob or Clob Object which we know already.
Here the main problem is that we need to retrieve the Blob Object which contains DVO Object in Byte[] form and use in the PL/SQL Procedures.
We need help.

Dave Tolls wrote:When you say "in Oracle procedure", do you mean you want to handle this in PL/SQL?

Thank  you Dave Tolls for your reply. I need handle in PL/SQL Procedures.

Hi to All,

We are facing an issue.
We have a table with column of type BLOB.
The column is inserted with java Object (A DVO contains geeters and setters) of byte[] data type from other of source which developed in Java program .


Now in the procedure I need to retrieve this BLOB Object and retrive the data fir futher procedure.
So, we need help that how can we retrieve Oracle Blob Object from that column and retrieve the data from that Object in Oracle procedure.

Hi Achilleas,

I am really sorry. Is I wrote anything wrong ?
Can you please me if I wrote anything wrong.

Hi All,

we are working on webservices Application which was build on top of EJB application and the application server is websphere. Is I can deploy same ear directly in JBoss or TomEE without making any changes ? Or any configuration files need to add ???

Can someone please help me.

Hi Tim,
Please find the below clarifications

Is that class in the classpath of where this code runs?
Yes. the class is in jar file and jar is in classpath.

How have you made sure it is? Are its class file (or jar file, more likely) uncorrupted?
we have checked by command jar -tvf Webclient.jar and below is the result

   25 Sun Aug 27 06:12:34 IST 2017 META-INF/MANIFEST.MF
39612 Sun Aug 27 06:11:26 IST 2017 org/tempuri/XxxHttpBinding_XXXServiceStub.class
 4641 Sun Aug 27 06:11:26 IST 2017 org/tempuri/XXServiceLocator.class
  401 Sun Aug 27 06:11:26 IST 2017 org/tempuri/XXService.class
 3815 Sun Aug 27 06:11:26 IST 2017 org/tempuri/YXCService.class
10146 Sun Aug 27 06:11:26 IST 2017 org/tempuri/YXCServiceProxy.class
 1223 Sun Aug 27 06:11:24 IST 2017 .classpath
  442 Fri Aug 25 15:43:34 IST 2017 .project
  253 Sun Aug 27 06:11:26 IST 2017 .settings/org.eclipse.core.resources.prefs
  598 Fri Aug 25 15:42:24 IST 2017 .settings/org.eclipse.jdt.core.prefs
1599570 Sun Aug 27 05:16:28 IST 2017 lib/axis-1.4.jar
71442 Sun Aug 27 05:19:10 IST 2017 lib/commons-discovery-0.2.jar
168203 Sun Aug 27 05:16:28 IST 2017 lib/javax.wsdl_1.6.2.v201012040545.jar
31191 Sun Aug 27 05:17:02 IST 2017 lib/jaxrpc.jar
68107 Sun Aug 27 05:16:28 IST 2017 lib/org.apache.commons.logging_1.1.1.v201101211721.jar
18979 Sun Aug 27 05:17:02 IST 2017 lib/saaj.jar

Hi Tim. Thank you for reply.

Please find the below full stacktrace of the exception

[8/27/17 0:39:55:643 IST] 00000066 RemoteExcepti E   CNTR0020E: EJB threw an unexpected (non-declared) exception during invocation of method "getRenewalPremium" on bean "BeanId(OC4J_ADKVDEV#AMHIServicesEJB.jar#RenewalPremiumCalculatorEJB, null)". Exception data: java.lang.NoClassDefFoundError: org/tempuri/BasicHttpBinding_IBCServiceStub
at com.apollomunichinsurance.businessservices.renewalpremiumservice.RenewalPremiumCalculatorHttpBindingImpl.getRenewalPremium(RenewalPremiumCalculatorHttpBindingImpl.java:92)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at com.ibm.ws.webservices.engine.dispatchers.java.JavaDispatcher.invokeMethod(JavaDispatcher.java:203)
at com.ibm.ws.webservices.dispatchers.ejb.J2ee14EJBDispatcher.invokeMethod(J2ee14EJBDispatcher.java:269)
at com.ibm.ws.webservices.engine.dispatchers.java.JavaDispatcher.invokeOperation(JavaDispatcher.java:158)
at com.ibm.ws.webservices.engine.dispatchers.SoapRPCProcessor.processRequestResponse(SoapRPCProcessor.java:490)
at com.ibm.ws.webservices.engine.dispatchers.SoapRPCProcessor.processMessage(SoapRPCProcessor.java:433)
at com.ibm.ws.webservices.engine.dispatchers.BasicDispatcher.processMessage(BasicDispatcher.java:134)
at com.ibm.ws.webservices.dispatchers.ejb.J2ee14EJBDispatcher.invoke(J2ee14EJBDispatcher.java:168)
at com.ibm.ws.webservices.engine.PivotHandlerWrapper.invoke(PivotHandlerWrapper.java:264)
at com.ibm.ws.webservices.engine.handlers.jaxrpc.JAXRPCHandler.invoke(JAXRPCHandler.java:148)
at com.ibm.ws.webservices.engine.handlers.WrappedHandler.invoke(WrappedHandler.java:64)
at com.ibm.ws.webservices.engine.PivotHandlerWrapper.invoke(PivotHandlerWrapper.java:264)
at com.ibm.ws.webservices.engine.PivotHandlerWrapper.invoke(PivotHandlerWrapper.java:264)
at com.ibm.ws.webservices.engine.WebServicesEngine.invoke(WebServicesEngine.java:336)
at com.ibm.ws.webservices.engine.transport.http.WebServicesServlet.doPost(WebServicesServlet.java:1239)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
at com.ibm.ws.webservices.engine.transport.http.WebServicesServletBase.service(WebServicesServletBase.java:344)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:668)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1232)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:781)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:480)
at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1114)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:87)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:940)
at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1817)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:200)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:463)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:530)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:316)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:287)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminators(NewConnectionInitialReadCallback.java:214)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:113)
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:175)
at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)
at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1881)

[8/27/17 0:39:55:643 IST] 00000066 RemoteExcepti E   CNTR0020E: EJB threw an unexpected (non-declared) exception during invocation of method "getRenewalPremium" on bean "BeanId(OC4J_ADKVDEV#AMHIServicesEJB.jar#RenewalPremiumCalculatorEJB, null)". Exception data: java.lang.NoClassDefFoundError: org/tempuri/BasicHttpBinding_IBCServiceStub
at com.apollomunichinsurance.businessservices.renewalpremiumservice.RenewalPremiumCalculatorHttpBindingImpl.getRenewalPremium(RenewalPremiumCalculatorHttpBindingImpl.java:92)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at com.ibm.ws.webservices.engine.dispatchers.java.JavaDispatcher.invokeMethod(JavaDispatcher.java:203)
at com.ibm.ws.webservices.dispatchers.ejb.J2ee14EJBDispatcher.invokeMethod(J2ee14EJBDispatcher.java:269)
at com.ibm.ws.webservices.engine.dispatchers.java.JavaDispatcher.invokeOperation(JavaDispatcher.java:158)
at com.ibm.ws.webservices.engine.dispatchers.SoapRPCProcessor.processRequestResponse(SoapRPCProcessor.java:490)
at com.ibm.ws.webservices.engine.dispatchers.SoapRPCProcessor.processMessage(SoapRPCProcessor.java:433)
at com.ibm.ws.webservices.engine.dispatchers.BasicDispatcher.processMessage(BasicDispatcher.java:134)
at com.ibm.ws.webservices.dispatchers.ejb.J2ee14EJBDispatcher.invoke(J2ee14EJBDispatcher.java:168)
at com.ibm.ws.webservices.engine.PivotHandlerWrapper.invoke(PivotHandlerWrapper.java:264)
at com.ibm.ws.webservices.engine.handlers.jaxrpc.JAXRPCHandler.invoke(JAXRPCHandler.java:148)
at com.ibm.ws.webservices.engine.handlers.WrappedHandler.invoke(WrappedHandler.java:64)
at com.ibm.ws.webservices.engine.PivotHandlerWrapper.invoke(PivotHandlerWrapper.java:264)
at com.ibm.ws.webservices.engine.PivotHandlerWrapper.invoke(PivotHandlerWrapper.java:264)
at com.ibm.ws.webservices.engine.WebServicesEngine.invoke(WebServicesEngine.java:336)
at com.ibm.ws.webservices.engine.transport.http.WebServicesServlet.doPost(WebServicesServlet.java:1239)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
at com.ibm.ws.webservices.engine.transport.http.WebServicesServletBase.service(WebServicesServletBase.java:344)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:668)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1232)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:781)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:480)
at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1114)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:87)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:940)
at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1817)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:200)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:463)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:530)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:316)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:287)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminators(NewConnectionInitialReadCallback.java:214)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:113)
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:175)
at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)
at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1881)

[8/27/17 0:39:55:690 IST] 00000066 WebServicesSe E com.ibm.ws.webservices.engine.transport.http.WebServicesServlet doPost WSWS3227E:  Error: Exception:
                                WebServicesFault
faultCode: Server
faultString: Internal Error
faultActor: null
faultDetail:

Internal Error
at com.ibm.ws.webservices.engine.PivotHandlerWrapper.bindExceptionToResponse(PivotHandlerWrapper.java:531)
at com.ibm.ws.webservices.engine.PivotHandlerWrapper.invoke(PivotHandlerWrapper.java:353)
at com.ibm.ws.webservices.engine.handlers.jaxrpc.JAXRPCHandler.invoke(JAXRPCHandler.java:148)
at com.ibm.ws.webservices.engine.handlers.WrappedHandler.invoke(WrappedHandler.java:64)
at com.ibm.ws.webservices.engine.PivotHandlerWrapper.invoke(PivotHandlerWrapper.java:264)
at com.ibm.ws.webservices.engine.PivotHandlerWrapper.invoke(PivotHandlerWrapper.java:264)
at com.ibm.ws.webservices.engine.WebServicesEngine.invoke(WebServicesEngine.java:336)
at com.ibm.ws.webservices.engine.transport.http.WebServicesServlet.doPost(WebServicesServlet.java:1239)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
at com.ibm.ws.webservices.engine.transport.http.WebServicesServletBase.service(WebServicesServletBase.java:344)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:668)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1232)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:781)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:480)
at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1114)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:87)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:940)
at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1817)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:200)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:463)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:530)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:316)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:287)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminators(NewConnectionInitialReadCallback.java:214)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:113)
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:175)
at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)
at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1881)

Hi,

we need to create a web client in our application in order to consume a soap based web service.

We have created a new java project and created web client in new project by using WSDL. Then the new project was converted into jar file and same jar was kept in our application.

we have build (using ANT tool)the code and ear file was generated in without any errors. Till now this was done in windows.

Our dev websphere server is in Linux system. So we have deployed the ear file in websphere. and it deployed successfully.

So when we are executing the request through SOAP we are getting about  stub file filenotfound runtime exception which that file is from generated through webclient. Can someone shed light on this issue. Is I have to do anything else ???

Hi all,

while we are deploying ear in websphere console, we observed that path is showing where the ear deploys.
I searched where this path comes from and found that websphere injects deployment.xml into ear file under META-INF folder and path mention in this file.

My doubt is that where this path comes into deployment.xml  and if we are deploying a ear file which already contains deployment.xml, can I override it with default deployment.xml with existing websphere...???

Please let me know if any confusion.

Thank you Tim,

We have started working on rest. Below is the imports we are using.
In eclipse when I configure the coresponding jar files in Build path, Eclipse is not showing any errors.

import javax.ws.rs.Consumes;
import javax.ws.rs.POST;
import javax.ws.rs.Path;
import javax.ws.rs.Produces;
import javax.ws.rs.core.MediaType;
import javax.ws.rs.core.Response;

When we are building with Ant it is showing error "package javax.ws.rs does not exist".
Please can some one shade a light on it.

Thank you for your reply Claude Moore and Tim Moores ,

Actually, in our application till now we used SOAP webservice without annotations and learned exact flow.
Same flow I want to learn without annotations.

can some one please proivide website or any document to learn

Hi all,

I am trying to learn REST web services. But it seems to use annotations every where. Is there any implementation of Rest framework without using annotations

Hi one and all,

At present we are working on webservices Application which was build on top of EJB application and the application server is websphere.
Recently management decided to move to weblogic. So can please help me what are the changes/precautions need to be done in order to migrate ear file from websphere to weblogic.

We are using SOAP based webservices and also in future they are trying to convert the services in to REST base.