Home » Developer & Programmer » JDeveloper, Java & XML » Web Service /XML / JDeveloper Question
Web Service /XML / JDeveloper Question [message #205386] Fri, 24 November 2006 07:33
Messages: 7
Registered: June 2005
Junior Member
I have to design an automatic -and periodic- process that performs next tasks:

1) Read Oracle table to build a XML file
2) Connect with a Web Service and send the XML. (In the specification says that SOAP with attachments is not supported , so we have to use a "proxy J2EE client" to interact with this web service)
3) Also this web service uses security sign with a X.509 v3 certificate in BASE64, which must be passed as a 'string' parameter when is invoked.

I'm new in these subjects, and I need some help, my questions:

1) Is it possible to define an automatic process with JDEVELOPER that connects to the DB, build the XML file and invoke the Web service?
2) How could I make this proccess automatic and periodic, for example every friday.
3) What are the tools I have to use:
3.1.- To Connect with DB -> JDBC?
3.2.- To Build XML, programmatically? or is there any tool?
3.3.- To define it as a periodic proccess??

4) Others alternatives? Is it possible to develope this directly in PL/SQL as a job in ORACLE?

thanks in advance...
Previous Topic: new to JDev and Struts - OracleJSP:java.io.FileNotFoundException
Next Topic: upload document to DB
Goto Forum:

Current Time: Sat Mar 02 17:34:25 CST 2024