We help IT Professionals succeed at work.

PDFLIB

Medium Priority
883 Views
Last Modified: 2012-05-11
Oracle database includes a Java Virtual Machine that I have never use directly. I have used PDFLIB with PHP to create reports from the office queries. Now I will like to use it with the Java option from PDFlib GmbH. Oracle offers the option to run Java code directly from PLSQL. Any ideas on how to carry on with this task or if it is even posible. The intention is to generate PDF document on the fly with the PLSQL code stored in the Oracle Database?
Comment
Watch Question

Commented:
Take a look at this link and it maybe help you: http://www.akadia.com/services/java_mail_plsql.html

I have already used java on PL/SQL and it is no big deal to configure.

Good luck.

Author

Commented:
I  installed Oracle Database 10g Express Edition and don't see anything that looks like a java installation in the directory structure. This database edition is recomended for Java developers as well. Can I load the PDF JAR files as it is done in http://www.akadia.com/services/java_mail_plsql.html safely too?
Sean StuberDatabase Developer & Administrator
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2012

Commented:
I don't who recommended it for java developers, but it was a bad recommendation


Oracle XE does not support java


http://download.oracle.com/docs/cd/B25329_01/doc/license.102/b25456/toc.htm#BABHACFJ

Commented:
The Oracle XE has some restrictions. To test java I suggest you to use EE (Enterprise Edition).
Database Developer & Administrator
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2012
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
At the moment I can not follow your solution because I don't have the database available.
Sean StuberDatabase Developer & Administrator
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2012

Commented:
why the B penalty?

Author

Commented:
I have another question on Oracle DB. I have a PLSQL program that writes XML text output to an Oracle Table. The final table takes several gigabytes of space, and it shouldn't occupy so much. The table has three fields :


Id number(10) PK,
line  number(10),
xml_text varchar2(4000).


The XML text has a lot of blank spaces, they  are all trim out before they are stored, anyhow, it  seems that no matter what I do each record takes 4000+ Bytes and not the space VARCHAR2 fields are suppose to occupy.


Can you give me some orientation as to what might be happening with so much space taken?


Thanks for your prompt response,


Regards,
Sean StuberDatabase Developer & Administrator
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2012

Commented:
this really should be a separate question

but, basically it comes down to space being allocated in extents, not a byte at a time
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.