> Am 25.01.2018 um 18:44 schrieb Ramos, Luis (DOC) <[email protected]>: > > The pdf documents are stored in a BLOB column. The reason we are trying to do > it inside the DB is to avoid to download to filesystem to process pdftoimage > method and upload the image back to the DB from filesystem. >
couldn't you read the BLOB as an InputStream and pass that to the PDDocument.load() method? e.g. ResultSet.getBinaryStream() or Blob.getBinaryStream(). The same way you could use Blob.setBinaryStream() to get an OutputStream to write to. BR Maruan > Now I am trying to load/compile the sources of each method in the DB. Do you > know the order in which to compile each individual method? > > > > Please consider your environmental responsibility before printing this > email. > > ************************************************************************************* > This communication is for the use of the intended recipient only. It may > contain > information that is privileged and confidential. If you are not the intended > recipient of > this information, any disclosure, copying, further distribution or use > thereof is prohibited. > If you have received this communication in error, please advise me by return > e-mail or by telephone and delete/destroy it. > ************************************************************************************* > > > -----Original Message----- > From: Diego Azevedo [mailto:[email protected]] > Sent: Wednesday, January 24, 2018 8:08 PM > To: [email protected] > Subject: Re: Does anyone has experience in using pdfbox in oracle database > jvm? > > Well, > > Then you already know that the integration between pdfbox and the jvm is not > the issue. If you’re having problems integrating with the Oracle database, > you will probably find more helpful asking on their list. > > Unless it’s a very particular situation, I’d advise you to separate any pdf > processing from the database itself, since I think it will be easier to > maintain and loading the whole library probably won’t help in the database > performance. > > _______________________________________________ > > Diego Azevedo > Software Developer > E-SEC Digital Security > www.esec.com.br > > > > The information transmitted, including any attachments, is intended only for > the person or entity to which it is addressed and may contain confidential > and/or privileged material. Any review, retransmission, dissemination or > other use of, or taking of any action in reliance upon, this information by > persons or entities other than the intended recipient is prohibited, and all > liability arising therefrom is disclaimed. If you received this in error, > please contact the sender and delete the material from any computer > >> On 24 Jan 2018, at 19:56, Ramos, Luis (DOC) <[email protected]> wrote: >> >> Hi, >> Tried the test >> >> [oracle@dev01 dacs_workarea]$ >> /u01/app/oracle/product/11.2.0/dbhome_1/jdk/jre/bin/java -version java >> version "1.5.0_30" >> Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_30-b03) >> Java HotSpot(TM) 64-Bit Server VM (build 1.5.0_30-b03, mixed mode) >> >> [oracle@dev01 dacs_workarea]$ >> /u01/app/oracle/product/11.2.0/dbhome_1/jdk/jre/bin/java -jar >> pdfbox-app-1.8.13.jar ExtractText releasechecklist.pdf >> >> All good I got the text file >> >> P Please consider your environmental responsibility before printing this >> email. >> >> ********************************************************************** >> *************** This communication is for the use of the intended >> recipient only. It may contain information that is privileged and >> confidential. If you are not the intended recipient of this >> information, any disclosure, copying, further distribution or use thereof is >> prohibited. >> If you have received this communication in error, please advise me by >> return e-mail or by telephone and delete/destroy it. >> ********************************************************************** >> *************** >> >> >> -----Original Message----- >> From: Diego Azevedo [mailto:[email protected]] >> Sent: Monday, January 22, 2018 6:10 PM >> To: [email protected] >> Subject: Re: Does anyone has experience in using pdfbox in oracle database >> jvm? >> >> Luis, >> >> To check whether pdfbox runs ok on the db jvm, I'm gonna advise you to run >> something simpler: >> Can you just run a pdf text extraction (using command-line tools) while >> pointing to the db jvm? >> >> If this works, you'll know that pdfbox is capable of running on the jvm >> itself. The integration with the database will probably be trickier. >> >> If it doesn't work, please provide the full command you used, the pdf >> (you'll need to host somewhere, attachments are usually blocked) and >> the output. It's easier to help with all info =) >> >> >> On Mon, Jan 22, 2018 at 6:18 PM, Ramos, Luis (DOC) >> <[email protected]> >> wrote: >> >>> Hi, >>> My setup is >>> Oracle DB 11.2.0.3 , pdfbox 1.8.13, fontbox 1.8.13, jempbox 1.8.13. >>> I have tried to use loadjava to load the jars files into the DB, but >>> I am having issues loading the pdfbox. >>> For example : this is the last output from loadjava The following >>> operations failed >>> class org/apache/pdfbox/cos/COSArray: creation (createFailed) >>> class org/apache/pdfbox/cos/COSBase: creation (createFailed) >>> class org/apache/pdfbox/cos/COSDictionary: creation (createFailed) >>> class org/apache/pdfbox/cos/COSName: creation (createFailed) >>> class org/apache/pdfbox/exceptions/COSVisitorException: creation >>> (createFailed) >>> class org/apache/pdfbox/exceptions/WrappedException: creation >>> (createFailed) >>> class org/apache/pdfbox/filter/Filter: creation (createFailed) >>> class org/apache/pdfbox/filter/FilterManager: creation (createFailed) >>> class org/apache/pdfbox/pdmodel/PDPage: creation (createFailed) >>> class org/apache/pdfbox/pdmodel/common/COSObjectable: creation >>> (createFailed) >>> exiting : Failures occurred during processing >>> >>> P Please consider your environmental responsibility before printing >>> this email. >>> >>> ************************************************************ >>> ************************* >>> This communication is for the use of the intended recipient only. It >>> may contain information that is privileged and confidential. If you >>> are not the intended recipient of this information, any disclosure, >>> copying, further distribution or use thereof is prohibited. >>> If you have received this communication in error, please advise me by >>> return e-mail or by telephone and delete/destroy it. >>> ************************************************************ >>> ************************* >>> >>> -----Original Message----- >>> From: Andreas Lehmkuehler [mailto:[email protected]] >>> Sent: Sunday, January 14, 2018 8:32 AM >>> To: [email protected] >>> Subject: Re: Does anyone has experience in using pdfbox in oracle >>> database jvm? >>> >>> Hi, >>> >>> >>>> Am 11.01.2018 um 19:48 schrieb Ramos, Luis (DOC): >>>> Does anyone has experience in using pdfbox in oracle database jvm? >>> I guess you have to be more specific. AFAIK the oracle db jvm is a >>> fully featured jvm. Saying that, PDFBox should work as long a the >>> minimum requirement for the java version is fullfilled (java5 for >>> 1.8.x and java6 for 2.0.x) >>> >>> Andreas >>> >>>> >>>> P Please consider your environmental responsibility before printing >>> this email. >>>> >>>> ******************************************************************** >>>> ** >>>> *************** This communication is for the use of the intended >>>> recipient only. It may contain information that is privileged and >>>> confidential. If you are not the intended recipient of this >>>> information, any disclosure, copying, further distribution or use >>> thereof is prohibited. >>>> If you have received this communication in error, please advise me >>>> by return e-mail or by telephone and delete/destroy it. >>>> ******************************************************************** >>>> ** >>>> *************** >>>> >>>> >>> >>> >>> --------------------------------------------------------------------- >>> To unsubscribe, e-mail: [email protected] >>> For additional commands, e-mail: [email protected] >>> >>> >> >> >> -- >> []'s >> >> Diego Azevedo >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: [email protected] >> For additional commands, e-mail: [email protected] >> > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
