Assuming you have a default installation of Apache 2 and Tomcat 5.5 running on your Ubuntu box.
Like apache on http://hiserver and Tomcat on http://hiserver:8080
Now you want to accces i.e. http://hiserver:8080/baula through apache with http://hiserver/baula
The following has only been testet with jACOB / MySQL / Birt running on Ubuntu 10.04 (Lucid Lynx).
For some strange reason it happens that text containing Euro signs (€) displays perfectly well between OpenJacob and MySQL but when running a Birt Report they aren’t displayed correctly.
This happens with a driver URL in Birt like:
jdbc:mysql://localhost:3306/databasename
but adding some character set information to the URL in Birt resolves this issue
jdbc:mysql://localhost:3306/databasename?characterSetResults=UTF-8
Maybe someone from Tarragon Software could be so nice to comment on this.
Integrating Birt Reports into OpenJacob is quite straightforward but note that (at the time of this writing) you need Birt Version 2.5 !
BirtReport rpt = new BirtReport(cnfrec.getDocumentValue("report"));
rpt.setParameterValue("mypar", currentRecord.getStringValue("pkey"));
byte[] barr = rpt.createPDF();
context.createDocumentDialog(null, "doc.pdf", barr).show();
With Open-jACOB 2.9 tarragon-software.com made another big step forward.
The new version contains many many improvements compared to the previous official release like:
Installation instructions can be found at openjacob.org
The Java Docs are here.
I’ve written a small servlet that communicates with a Jacob Application through CommandEntry Points. Not the most elegant solution for sure but _very_ flexible.
When the servlet calls the entry point’s Url then we have everything UTF-8 encoded and additionally used URLEncoder.encode(URL).
On the jacob side the Data arrives as ISO8859-1 although everything in Jacob appears to be UTF-8. But a simple
String data1= new String(properties.getProperty("data1").getBytes("ISO8859-1"),"UTF-8");
does the job.
Open-Jacob (currently) does not support cascading deletes. Depending on the database used you could implement this at the database level but this would be no good idea since Open-Jacob itself keeps track of the data and could stumble when records are getting modified from another side.
Let’s assume the following database schema
In order to reverse engineer a existing database you can use the FetchDatasourceSchemaInfo Entry Point. Continue reading »
I have been developing M$-Access based solutions for about a decade. The more I dug deeper the more I’ve been dissatisfied. Therefore I started to look around for a new development tool. Continue reading »
