I need some help in one of my requirements. I have a xml file stored as Blob object in the Oracle database. My requirement is to connect to the database, get the xml file, parse the xml file and output the content of the xml to a pdf. My pdf should be of specific format. Can any one help me with any ideas in this context please? I appreciate if someone can provide me with some sample code.
I know I should use an XML parser to parse the xml and I should use itext to output to a pdf. I have written the jdbc connection code also. I stopped at Blob blob = resultSet.getBlob("blobObject").I don't know how to proceed next.