Re: Call a 4gl program from java

Em 20-01-2012 18:19, CESAR ALFONSO escreveu:
> Is there a way to call 4gl program from java?

Short answer, yes.

> I read about a JCA connector.  I want to know if the 4gl JCA
connector is free or no?

My company, MoreData, has developed the 4GLConnector based on JCA. It's 
a commercial open source product. We provide it via a service contract 
(training+consulting+support).

> I have a legacy system with several 4gl programs and I want to call
this 4gl programs from Java (JEE Web Application). Is that possible?

Yes it is. 4GLConnector is used in places where 4GL logic is complex and 
stable but has to be executed from all kinds of interfaces. From 
webpages to IVR systems. The connector provides a pooling mechanism with 
high throughput (hundreds of requests per second with a single instance).

> In the past we called a few 4gl programs doing:
> - Java opens a command line execution in database server .
> - The command line executes 4gl.
> - The 4gl program return an succesful or error code.
> - Java program returns that code.

That works, of course. But with several limitations, like the difficulty 
of returning data to the caller and the low performance. The 
4GLconnector is built in a way that you don't have to write new 4GL 
code. Existing 4GL functions are "exposed" in JEE as classes or 
webservices, automatically generated from 4GL code. Those classes, in 
the background, connect to a "4gl server" through ssh channels. That 
"4gl server" launches 4GL processes and keeps them in a pool, to 
optimize performance. User ids are kept intact, so that 4GL programs 
(and the database server) are able to apply user permissions and logging 
as usual in SQL.

If you need more info please contact me directly.

Hope this helps

Fernando


------------------------------------------------------------------------------
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-d2d