RE: Web..Java..Oracle..PDF

Here's another approach which you may or may not have considered.  

Oracle Reports generates PDF.  

So the steps would be:
1) A user enters data in a jhtml web form; 2) The server side Java VM takes the form fields and invokes an OracleReport which not only queries the Oracle DB for extra data, but formats it to your liking;

You can specify the destination format(DESFORMAT=PDF), destination type as mail and destination name can be the email address or a distribution list.

The Oracle Reports Server even has scheduling, load balancing etc. features which may come in handy. We have such a setup where reports are scheduled for month-end reporting and are mailed out to users.

-----Original Message-----

From: Steve McClure [mailto:steve_at_pactr.com] Sent: Friday, August 25, 2000 11:16 AM
To: Multiple recipients of list ORACLE-L Subject: Re: Web..Java..Oracle..PDF

I would direct you to the Adobe website, and then to their technical support. They do have products that allow you to merge data from a database with pdf document. The result is as you described.  

A client I worked with in the past did something very similar, but I was handling the Database side of things so I don't remember the PDF details. The folks at adobe were very helpfull though, and there were several white papers on their site about this kind of thing.  

Steve McClure

• Original Message ----- From: Brian <mailto:bmaclean_at_homebid.com> MacLean To: Multiple recipients of list ORACLE-L <mailto:ORACLE-L_at_fatcity.com> Sent: Thursday, August 24, 2000 6:06 PM Subject: Web..Java..Oracle..PDF

We are looking for a method of generating PDF doc's in the following scenario:

1. A user enters data in a jhtml web form;
2. The server side Java VM takes the form fields and queries the Oracle DB for extra data;
3. A PDF document is produced (somehow) and mailed to the original web user;

Platform:

        Oracle v8.1.5 
        Solaris 7 
        Apache 
        Dynamo (Java VM) 

The real issue is how to get everything into the PDF file format.

        Is there a way to fill in a PDF doc?

        Should I write to a post script file (or some other format) 
        then use some tool to convert to PDF? 

All answers, hints, or web (research) links are greatly appreciated.

Brian P. Mac Lean
Senior Oracle Database Administrator
OCPv8/Oracle Master
HomeBid.Com
8700 N. Gainey Center Drive
Suite 150
Scottsdale, AZ 85258
Tel:480.609.4624
Cel:602.617.6075 Received on Fri Aug 25 2000 - 15:12:35 CDT