tag:blogger.com,1999:blog-1839316484051079047.post4231676427325611598..comments2024-03-28T06:38:40.958+01:00Comments on Java / Oracle SOA blog: Exposing database artifacts as Web Services without writing any Java codeEdwin Biemondhttp://www.blogger.com/profile/02338716126881111629noreply@blogger.comBlogger20125tag:blogger.com,1999:blog-1839316484051079047.post-44967114340436286532014-05-09T10:59:05.804+02:002014-05-09T10:59:05.804+02:00Did you get an answer for this?Did you get an answer for this?Anonymoushttps://www.blogger.com/profile/12377946083817707506noreply@blogger.comtag:blogger.com,1999:blog-1839316484051079047.post-81921096370417684392013-07-08T15:23:53.734+02:002013-07-08T15:23:53.734+02:00Hi,
It should also work on other JEE servers, pro...Hi,<br /><br />It should also work on other JEE servers, probably you are missing eclipselink jars or a jdbc driver. Can you try Tomcat EE or Glassfish.<br /><br />Thanks<br />Edwin Biemondhttps://www.blogger.com/profile/02338716126881111629noreply@blogger.comtag:blogger.com,1999:blog-1839316484051079047.post-42791080740129179502013-07-01T12:16:54.491+02:002013-07-01T12:16:54.491+02:00Hi I am new to Eclipse link and trying to deploy i...Hi I am new to Eclipse link and trying to deploy it obn Tomcat but its giving error ....Can't it be deployed on any other server except Weblogic<br />Waiting for the response....Ankithttps://www.blogger.com/profile/13141113195826144095noreply@blogger.comtag:blogger.com,1999:blog-1839316484051079047.post-66110971335288857872012-12-19T23:18:41.207+01:002012-12-19T23:18:41.207+01:00Hi,
oh oracle types must be mapped to something e...Hi,<br /><br />oh oracle types must be mapped to something else ( need a wrapper I think ) and you need oracle toplink for this ( no dbws). <br />What is possible, use eclipselink with PLSQL / ORacle object record types, plsql tables etc but not with DBWS, You need to program it.<br /><br />like this <a href="http://biemond.blogspot.nl/2012/03/oracle-bulk-insert-or-select-from-java.html" rel="Edwin Biemondhttps://www.blogger.com/profile/02338716126881111629noreply@blogger.comtag:blogger.com,1999:blog-1839316484051079047.post-82478368183636961052012-12-13T15:08:55.138+01:002012-12-13T15:08:55.138+01:00Hi Edwin...
I was trying dbws and works perfect f...Hi Edwin...<br /><br />I was trying dbws and works perfect for simple pakages and stored procedure<br />But now i have an error when a stored procedure has oracle types for variable.<br /><br />example ocryaAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-1839316484051079047.post-55894660588208062262012-04-19T11:27:11.658+02:002012-04-19T11:27:11.658+02:00Hi,
Looks like something goes wrong with ip6 It c...Hi,<br /><br />Looks like something goes wrong with ip6 It cannot retrieve the xsd of the wsdl. Check the ip on which wls runs and the nat setting of your router. The xsd import in the wsdl should also use your router address and forward to the wls server. Maybe there is a setting in eclipse link to say what your exposed ip isEdwin Biemondhttps://www.blogger.com/profile/02338716126881111629noreply@blogger.comtag:blogger.com,1999:blog-1839316484051079047.post-55427284290870011042012-04-19T10:42:15.005+02:002012-04-19T10:42:15.005+02:00Hi Edwin,
Thank you. I was using weblogic webse...Hi Edwin,<br /><br /> Thank you. I was using weblogic webservice test client to invoke the web Service.So there is no way the the xsd can be generated with minOccurs,maxOccurs param for a certain parameter?<br /><br />Also I faced a problem while executing in different network. At my home network the webservice worked well but it failed at my office network.<br />It failed with below message:<brRonyhttps://www.blogger.com/profile/15412003304702731924noreply@blogger.comtag:blogger.com,1999:blog-1839316484051079047.post-5101169108122307422012-04-18T22:03:53.113+02:002012-04-18T22:03:53.113+02:00Hi,
I mean in the tool which send the soap reques...Hi,<br /><br />I mean in the tool which send the soap request like soapui , when you got an element and this element is optIonal you need to provide it with nill is true instead of removing it .<br /><br /><br /><br />ThanksEdwin Biemondhttps://www.blogger.com/profile/02338716126881111629noreply@blogger.comtag:blogger.com,1999:blog-1839316484051079047.post-21015094361205871252012-04-18T21:07:32.710+02:002012-04-18T21:07:32.710+02:00Hi
I think I didn't get your point.
In whic...Hi <br /> I think I didn't get your point.<br /> In which file I need to update the nill attribute of the param tag ?<br /><br /> a> eclipselink-dbws-sessions.xml<br /> b> eclipselink-dbws.xml <br /> c> eclipselink-dbws.wsdl<br /> d> eclipselink-dbws-schema.wsdl<br /><br />Can't I generate the same during running the command line utility?<br />Thanks for your help.<br /><br />Ronyhttps://www.blogger.com/profile/15412003304702731924noreply@blogger.comtag:blogger.com,1999:blog-1839316484051079047.post-52674397392977399042012-04-17T21:16:50.485+02:002012-04-17T21:16:50.485+02:00Hi,
I think for optional parameters you should us...Hi,<br /><br />I think for optional parameters you should use param nill = true and not < param /> or < param >< /param > , this is not empty and can't converted to a number,<br /><br />Hope this helpsEdwin Biemondhttps://www.blogger.com/profile/02338716126881111629noreply@blogger.comtag:blogger.com,1999:blog-1839316484051079047.post-12329171107253240812012-04-16T20:28:45.072+02:002012-04-16T20:28:45.072+02:00Hi
First of you I want to thank you for such a w...Hi <br /><br />First of you I want to thank you for such a wonderful blog.<br />I have tested for a function which is having four input parameters.<br />It is working well when all the parameters are provided but fails when<br />one parameter which is optional and having type as Number in function<br />is not provided and invoked. How can I control the type and number of input parameters to Ronyhttps://www.blogger.com/profile/15412003304702731924noreply@blogger.comtag:blogger.com,1999:blog-1839316484051079047.post-87672628326712094352011-03-23T20:59:17.061+01:002011-03-23T20:59:17.061+01:00Hi,
can you check the generated war, it should be...Hi,<br /><br />can you check the generated war, it should be located in WEB-INF\classes\META-INF<br /><br />and add the eclipselink jars to the setDomainenv.bat <br /><br />thanksEdwin Biemondhttps://www.blogger.com/profile/02338716126881111629noreply@blogger.comtag:blogger.com,1999:blog-1839316484051079047.post-87870060327860021622011-03-23T04:53:04.192+01:002011-03-23T04:53:04.192+01:00Yes, it fails with
[EclipseLink-47000] (Eclipse ...Yes, it fails with <br /><br />[EclipseLink-47000] (Eclipse Persistence Services - 2.2.0.v20110202-r8913): org.eclipse.persistence.exceptions.DBWSException<br />Exception Description: Could not locate file [eclipselink-dbws-sessions.xml]<br /><br /><br />No matter what I try. Though I have tried it with 10.3.0 and JBoss 5.1.0 only so far.Donhttps://www.blogger.com/profile/06777701266147001081noreply@blogger.comtag:blogger.com,1999:blog-1839316484051079047.post-31590535073910152002011-03-21T14:09:53.034+01:002011-03-21T14:09:53.034+01:00Hi,
I think it is 10.3.3 (ps3) or 10.3.2. Do you ...Hi,<br /><br />I think it is 10.3.3 (ps3) or 10.3.2. Do you get a particular error message. <br /><br />you can try to download the latest eclipselink and update these jars in weblogic.<br /><br />thanksEdwin Biemondhttps://www.blogger.com/profile/02338716126881111629noreply@blogger.comtag:blogger.com,1999:blog-1839316484051079047.post-13482050453785214442011-03-21T13:55:09.405+01:002011-03-21T13:55:09.405+01:00Could you please specify which version of WebLogic...Could you please specify which version of WebLogic did you use? 10gR3 (10.3.0) does not seem to work....Donhttps://www.blogger.com/profile/06777701266147001081noreply@blogger.comtag:blogger.com,1999:blog-1839316484051079047.post-33915785283864358772010-09-10T18:41:45.258+02:002010-09-10T18:41:45.258+02:00Hi,
I dont thinks so , this is a DB to WS framew...Hi, <br /><br />I dont thinks so , this is a DB to WS framework. <br /><br />But you can check jersey or one of its implementation <br />https://jersey.dev.java.net/<br /><br />thanksEdwin Biemondhttps://www.blogger.com/profile/02338716126881111629noreply@blogger.comtag:blogger.com,1999:blog-1839316484051079047.post-11875552039624950672010-09-08T23:23:23.559+02:002010-09-08T23:23:23.559+02:00Do you know if you can use DBWS as a REST service ...Do you know if you can use DBWS as a REST service as well?BradWhttps://www.blogger.com/profile/16750044668400024875noreply@blogger.comtag:blogger.com,1999:blog-1839316484051079047.post-45846903588379054832010-07-12T13:58:08.219+02:002010-07-12T13:58:08.219+02:00Hi Edwin,
I tried out this and working perfectly....Hi Edwin,<br /><br />I tried out this and working perfectly...<br /><br />Thanks...Ashokhttps://www.blogger.com/profile/02584603953244146342noreply@blogger.comtag:blogger.com,1999:blog-1839316484051079047.post-7837481577490379442010-06-29T11:36:08.143+02:002010-06-29T11:36:08.143+02:00Hi,
I know this XDB feature and I am using it for...Hi,<br /><br />I know this XDB feature and I am using it for rest web services in combination with OSB.<br /><br />+ve of my solution is database independed, no licensing ( don't need to have WLS or Ora DB) and you don't need to know OSB. <br /><br />I think Oracle customer will use Soa Suite or OSB with the DB /EJB adapter.<br /><br />thanksEdwin Biemondhttps://www.blogger.com/profile/02338716126881111629noreply@blogger.comtag:blogger.com,1999:blog-1839316484051079047.post-81721364000604280052010-06-29T11:17:33.484+02:002010-06-29T11:17:33.484+02:00First of all, thanks for an excellent blog.
Are yo...First of all, thanks for an excellent blog.<br />Are you aware of this: <a rel="nofollow">http://download.oracle.com/docs/cd/E11882_01/appdev.112/e10492/xdb_web_services.htm#ADXDB5676</a><br />It's basically a native way of exposing data and procedures without any code. And when coupled with OSB it really makes securely publishing legacy procedures as services a really simple trick.Petteri M.noreply@blogger.com