(0 comments, 3 posts)
This user hasn't shared any profile information
Posts by Gregory Beumer
For a couple of months I have been discovering the Android platform. As an original Oracle developer I was wondering how an Android app can be connected to an Oracle database. For this purpose I developed an Android app that stores speed traps that users may hit while driving, into an Oracle database. The app also retrieves these speed traps from the database and draws them onto a Google map:
Oracle 8.1.5 introduced the ability to choose Java as a language to implement a stored procedure.
One of our customers required the following functionalities from within an Oracle database:
- Running an operating system command
- The ability to copy a file
- Listing all of the files in a given directory
These things are missing in UTL_FILE. PL/SQL cannot do this – Java can quite easily. Here is how (I have tested this on an Oracle 8.1.7 and 10.1.0.2.0): (more…)
My first days at AMIS I examined JasperReports (v. 0.6.3), an open source report-generating library. This tool is entirely written in Java and uses XML report templates to generate reports you can display on the screen, send to a printer, or save as a PDF document.
In order to fill a report with data, the report design (template) must be compiled first. This compilation is performed by the compileReport() method exposed by the net.sf.jasperreports.engine.JasperCompileManager class. Through compilation, the report design is loaded into a report design object that is then serialized and stored on disk (net.sf.jasperreports.engine.JasperReport). This serialized object is then used when the application wants to fill the specified report design with data. In fact, the compilation of a report design implies the compilation of all Java expressions defined in the XML file representing the report design. Various verifications are made at compilation time, to check the report design consistency. The result is a ready to fill report design that will be then used to generate documents on different sets of data. (more…)