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
Continue reading »
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:
but adding some character set information to the URL in Birt resolves this issue
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 !
- When creating the report’s datasource you have to use the same name you use in your jACOB application. Otherwise jACOB will not be able to use your Report.
- Create your report and specify the required parameters.
- When having finished your report, upload the .rptdesign file to a document field in your application. (e.g. a config table)
- The following code opens the report, hands over a parameter and returns a .pdf
BirtReport rpt = new BirtReport(cnfrec.getDocumentValue("report"));
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:
- Tree browser with drag and drop.
- Radio buttons to select functions.
- Hideable Forms
- Enum fields with I18N
- Tooltips. A combination of error messages and tips on how to correct.
- Foreign fields as combo box.
- Breadcrumb control.
- Single sign on functionality through CAS.
- Embedded transactions
- Dynamic changeable forms.
- Full text search on long text fields.
- Distinguish between primary and secondary DBâs in multiple databases, dependent on who owns the data.
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
Continue reading »
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 »