Joined: 10 Feb 2004
Location: columbia SC
|Posted: Tue Feb 10, 2004 7:42 am Post subject: jdbc postgresql get data in resultset plug into write doc
I'm attempting to revamp a printing process in my organization. As a part of that, I'd like to be able to use a java program that:
1) Gets invoked upon boot of Linux machine.
2) At 30 second intervals, read a remote PostgreSQL database via jdbc, get data in a resultset, and based on a database column indicating the type of an OpenOffice Write predefined form type or template, insert the values contained within other database columns (same row) into some type of placeholder or variable insertion point within the form or template.
3) Initiate the printing of the document via a mechanism within the java program to invoke OpenOffice and pass the document to it and have the printing start automatically to any printer which may be one of many.
4) Via JDBC, update the PostgreSQL database that the print operation has completed successfully.
All of the above I feel confident of accomplishing except for the OpenOffice portion. I'm new to OpenOffice and although I've downloaded and installed the OpenOffice Developer SDK, I would like to solicit advice about the feasibility of my plan from anyone more experienced in the use of the OpenOffice API. Thanks.