T24:Integration of R8 with External Web Services

[Santosh]

Hi Group,

 

Currently we are in R8 / JBASE5.1 / with Browser.

 

We got a requirement to interact with other Web Services (In XML Format) to receive and send data for some online interfaces.  Example: As soon as user inputs the data and commit the record it must be converted to XML tags (Which our local development is taking care) and sends the request to External Web serivce and pick the response and update in few fields of T24 application.

 

Currently we are not using MQ stuff so it must be through M/W to process the request and response

 

I will be greatful if any one can share their integration experience how we can achieve this.

 

Regards

Santosh

 

[Anar S.V.]

you may develop "custom" listener for TCServer which will handle the
communication between T24 and external WebService.

[Imran Akbar]

Hi,

 

will give you an idea, but i dont say its the only way,

 

there needs to be a java classes which will consume those web services(using JAX-WS, AXIS or METRO, or HTTP POST method). when a user inputs and submits, a routine will collect the info and form a delimeted string and submits to the java class using CALLJ, the java class in return connects the external service and post the data and get the response back and send it back to T24.

Hope this helps.

 

Thanks,

 

Imran

 

--
Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines
 
IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24
 
To post, send email to jB...@googlegroups.com
To unsubscribe, send email to jBASE-un...@googlegroups.com
For more options, visit this group at http://groups.google.com/group/jBASE?hl=en

--
  -- Imran Akbar
  +91 9884365530

[sarfraz...@gmail.com]

Hi Santosh
You can do it without MQ but in anycase u required jbase_agent which
will start on particular TCP port through which connectivity can be
done.

[Santosh]

HI Anar,

 

Thanks for your reply.

 

My concern is for outgoing. Incoming i can define batch file listeners in tcserver level and manage to update. But incase of outgoing messages how to handle in tcserver?

 

Regards

Santohs

--
Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines

IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24

To post, send email to jB...@googlegroups.com
To unsubscribe, send email to jBASE-un...@googlegroups.com
For more options, visit this group at http://groups.google.com/group/jBASE?hl=en

--
Mobile: 973-39406098

"Nobody can go back and start a new beginning, but anyone can start today and make a new ending"

[Santosh]

Hi Sarfrz,

 

Can you please elaborate your idea? Do we need to develop any socket kind in TCP so that it will be keep listening to the ports of Web service? If we do so, how we can implement in our jbase programs?

 

Regards

Santosh

--
Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines

IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24

To post, send email to jB...@googlegroups.com
To unsubscribe, send email to jBASE-un...@googlegroups.com
For more options, visit this group at http://groups.google.com/group/jBASE?hl=en

[Anar Veliyev]

Hi Santosh,

For the outgoing message/string/info you may utilize CALLJ.

Anar Valiyev
tel: +99 450 559 02 74 (mobile)

[Nguyen Trong Dai]

Hi Santosh,

I had met the same problem before and solved it this way:

1. Web service received XML request from client and convert to OFS command
2. Web Service send OFS command to T24 thru TCServer and get response
3. Web Service check response, if the response is valid, convert it to XML and send back to client

I do that and it works.

[Nguyen Trong Dai]

Hi Anar,

Can You explain more detail about using CALLJ or give some samples of using that routine?

[Santosh]

Anar:

 

If you provide any sample it will be great....

--

Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines
 
IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24
 
To post, send email to jB...@googlegroups.com
To unsubscribe, send email to jBASE-un...@googlegroups.com
For more options, visit this group at http://groups.google.com/group/jBASE?hl=en

[Tony Gravagno]

[AD] I'll add a note since 5 days has gone by without a firm
solution.

Santosh, I don't know if this will help. You can try to create a
solution as I have, or I welcome you to contact me to purchase
the solution that I've created.

I recently completed a project for a client where all they need
to do is write items to a file and their data is sent out via an
outbound web service call. The results are then returned into
the same or different items, which the application can then
process as required. In other words, this is an asynchronous
process which operates as follows:
- you write items with our normal BASIC code
- your code then just goes on to other things
- at timed intervals, (seconds, minutes or hours) the data gets
processed
- at timed intervals, you check to see if there is a response
- you clean up the request/response data with your code

The advantage here is that your code never needs to know anything
about web services, XML, Java, or anything else "foreign". A
disadvantage is that a CallJ or CallDotNet would be better for
synchronous processing when you need a more immediate response.
That said, you can get an almost guaranteed turnaround from
request to response within anywhere from about 2 to 7 seconds.
That's not bad.

As to architecture, this was intended to run the same when the
DBMS is on Windows, AIX, or Linux, and independent of the DBMS
release. The web services components are based on .NET, and
therefore the actual client runs on a local Windows server. If
the DBMS is on Windows then the data can be pulled from OS files,
and the web service client can be hosted on the same system. If
the data is in hashed files in Windows or any other OS, then
mv.NET is used as the connectivity pipe.

mv.NET facilitates access to jBase/T24 and other Pick/MultiValue
DBMS platforms. My company, Nebula Research and Development is a
worldwide distributor of mv.NET and provides related development
services. mv.NET is produced by BlueFinity International which
is one of the Mpower1 (Temenos partner) companies along with
jBase International.

I would be happy to work with anyone here to implement
site-specific solutions, or to create a similar "horizontal"
solution that can be used by all T24 sites.

Thanks for your time.
Tony Gravagno
Nebula Research and Development
TG@ remove.pleaseNebula-RnD.com
remove.pleaseNebula-RnD.com/blog
Visit PickWiki.com! Contribute!
http://Twitter.com/TonyGravagno

[Anar Veliyev]

CALLJ enables to call methods in some JAVA library .

CALLJ "your.class.name", "$method_name", v_putString  SETTING v_opStr

--

Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines
 
IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24
 
To post, send email to jB...@googlegroups.com
To unsubscribe, send email to jBASE-un...@googlegroups.com
For more options, visit this group at http://groups.google.com/group/jBASE?hl=en

[sarfraz...@gmail.com]

Hi,

For that you don't write a program just ask to distribution to provide
latest version of jbase for R08 which has jbase_Agent functionality as
well.

Regards,

Sarfraz.

On Oct 26, 7:22 pm, Santosh <santosh.kancha...@gmail.com> wrote:
> Hi Sarfrz,
>
> Can you please elaborate your idea? Do we need to develop any socket kind in
> TCP so that it will be keep listening to the ports of Web service? If we do
> so, how we can implement in our jbase programs?
>
> Regards
> Santosh
>

> On Tue, Oct 26, 2010 at 2:37 AM, sarfraz.raj...@gmail.com <

[vidhyadharan]

Hi ,

You can get the samples for CALLJ form the jbase installed directory ,
<JBASE_HOME>/5.0/SAMPLES/CALLJ/

What is CALLJ?

CallJ is nothing but calling a java method from infobasic.


But when you implement webservice client using CALLJ, it will take
minimum 20 to 30 seconds to initiate property and to load libraries :(


I would suggest CALLJ and user-defined TC-server listener to consume
webservice,

1. Develop user-defined listener to consume webservice,
2. Use callj to post message to the listener, so u need to write
socket program to post message to the listener.
3. Once listener received the Input/message ,format the message and
consume the webservice.
4. reply back the response to the CALLJ

Happy coding.


Cheers,
vidhya.
Sun Certified Java Programmer.

On Oct 28, 9:56 pm, Nguyen Trong Dai <daint.teme...@gmail.com> wrote:
> Hi Anar,
>
> Can You explain more detail about using CALLJ or give some samples of using
> that routine?
>

[Santosh]

Hi,

 

1. Web service received XML request from client and convert to OFS command
2. Web Service send OFS command to T24 thru TCServer and get response
3. Web Service check response, if the response is valid, convert it to XML and send back to client

In the above case do we need any middleware support?

--

Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines
 
IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24
 
To post, send email to jB...@googlegroups.com
To unsubscribe, send email to jBASE-un...@googlegroups.com
For more options, visit this group at http://groups.google.com/group/jBASE?hl=en

[Santosh]

Hi Sarfraz,

 

Thanks a lot for your information. Jbase_Agent do not come with our regular jbase pack?

--
Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines

IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24

To post, send email to jB...@googlegroups.com
To unsubscribe, send email to jBASE-un...@googlegroups.com
For more options, visit this group at http://groups.google.com/group/jBASE?hl=en

[daint....@gmail.com]

Hi Santosh,

You are in R08, so don't care about jBase agent, in R08 you always use TCServer to connect T24 with others Web services (like browserweb ở ArcIB).

In the structrue I sugguest you, you only need develop a Java web service and the is no need any middle ware. Let's try it :)

------Original Message------
From: Santosh <santosh....@gmail.com>
To: jb...@googlegroups.com <jb...@googlegroups.com>
ReplyTo: Santosh <santosh....@gmail.com>
Re: T24:Integration of R8 with External Web Services
3 Nov 2010 14:50



Hi Sarfraz,
 
Thanks a lot for your information. Jbase_Agent do not come with our regular jbase pack?


On Tue, Oct 26, 2010 at 2:37 AM, sarfraz...@gmail.com<sarfraz...@gmail.com> wrote:
Hi Santosh
You can do it without MQ but in anycase u required jbase_agent which
will start on particular TCP port through which connectivity can be

done.




On Oct 26, 12:03 am, Santosh <santosh.kancha...@gmail.com> wrote:
> Hi Group,
>
> Currently we are in R8 / JBASE5.1 / with Browser.

>
> We got a requirement to interact with other Web Services (In XML Format) to
> receive and send data for some online interfaces.  Example: As soon as user
> inputs the data and commit the record it must be converted to XML tags

> (Which our local development is taking care) and sends the request to

> External Web serivce and pick the response and update in few fieldsof T24

> application.
>
> Currently we are not using MQ stuff so it must be through M/W to process the

> request and response
>

> I will be greatful if any one canshare their integration experience how we

> can achieve this.
>
> Regards
> Santosh




--
Please read the posting guidelines at:

<http://groups.google.com/group/jBASE/web/Posting%20Guidelines>http://groups.google.com/group/jBASE/web/Posting%20Guidelines

IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24

To post, send email to jB...@googlegroups.com
To unsubscribe, send email to jBASE-un...@googlegroups.com

For more options, visit this group at

<http://groups.google.com/group/jBASE?hl=en>http://groups.google.com/group/jBASE?hl=en

--
Mobile: 973-39406098

"Nobody can go back and start a new beginning, but anyone can start today and make a new ending"

--

Please read the posting guidelines at:

<http://groups.google.com/group/jBASE/web/Posting%20Guidelines>http://groups.google.com/group/jBASE/web/Posting%20Guidelines

IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24



To post, send email to jB...@googlegroups.com

To unsubscribe, send email to jBASE-un...@googlegroups.com

For more options, visit this group at

<http://groups.google.com/group/jBASE?hl=en>http://groups.google.com/group/jBASE?hl=en

[Anar Veliyev]

Depends on the answer of the question:
 - How do you manage/plan/imagine to implement the steps 2&3?

If you're able to talk to TCServer directly then none, if not then "MQ".

[Ramkumar Sreeni]

Hi Santosh,

 

We have had a similar requirement, and we have used TAG (Temenos Application gateway) for webservices purpose, now there is a advanced tool call TWS (T24 Webservices) tool which is being support by Temenos Helpdesk.  There can be 2 kinds of integration

 

1)  Online integration - (Where in the front end hits T24 webservices and then T24 eg, T24 version and T24 Online Enquiries), where in you need to create T24 versions and enquiries and using TAG Webservice factory you need to build the webservice and you will get the WSDL and XSD page, which external front end system can access.

 

2)  Batch integration - CALLJ was used (Where you run a T24 routine or TSA.SERVICE or BATCH record in COB, and in the routine you invoke the Java method that is present in the Java class)

 

 

Regards,

Ramkumar.S

[Ramkumar Sreeni]

Hi Soufyan,

 

Below is the sample piece of code

 

Where ICMCallBPEL - is the class name so there should be a valid ICMCallBPEL.java file in the path say '/t24/R09/bnk/bnk.run/javalib' and the same path has to be added to the variable CLASSPATH and the ICMCallBPEL.java when compiled using javac should yield ICMCallBPEL.class file under the path '/t24/R09/bnk/bnk.run/javalib'

 

callT24ICMDepositRates - is the method name in the file ICMCallBPEL.java, and the 'param' variable could be extracted using the method callT24ICMDepositRates.  Not sure about the coding that needs to be done in the .java file, you can get in touch with some java people

 

ret - is the return variable from the destination server and could be used for population 'Success', 'Failure' etc

 

In Short 'Param' is the Outgoing variable from T24 to destination server and 'ret' is the Incoming variable to T24 from destination server

 

************************************************************Sample code start************************************************************************

 

CALLJ "ICMCallBPEL","callT24ICMDepositRates",param SETTING ret ON ERROR GOTO errHandler1

CRT "Received batch from Java : " : ret

RETURN

errHandler1:

err = SYSTEM(0)

IF err = 2 THEN

CRT "Cannot find the libjvm.so !"

RETURN

END

IF err = 1 THEN

CRT " fatal err"

RETURN

END

IF err = 3 THEN

CRT "NO CLASS"

RETURN

END

IF err = 4 THEN

CRT "CONVERSION ERR"

RETURN

END

IF err = 5 THEN

CRT "NO METHOD"

RETURN

END

IF err = 6 THEN

CRT "NO OBJECT"

RETURN

END

IF err = 7 THEN

CRT "CANNOT INSTANTIATE OBECT"

RETURN

END

************************************************************Sample code end************************************************************************

 

This is the knowledge I got from the implementation project, please see whether this helps you.

 

Regards,

Ramkumar.S

 

On Fri, May 6, 2011 at 9:22 PM, soufyan oulad youssef <soufy...@gmail.com> wrote:

The Big problem was as i can see in the CALLJ Performances and the how
to use callJ .
i have the same problem for an implementation.
My question is :in the methode that u will call in Java can return (1
string, 2 or return perhaps vector...)??
If some one can explain to as the capability of the CALLJ :
packageAndClassName, [$]methodName, param SETTING ret [ON ERROR]
statements

Best Regards
Soufyan

On 16 nov 2010, 09:18, Ramkumar Sreeni <ramkumar.sre...@gmail.com>

wrote:
> Hi Santosh,
>

> We have had a similar requirement, and we have used TAG (Temenos Application
> gateway) for webservices purpose, now there is a advanced tool call TWS (T24
> Webservices) tool which is being support by Temenos Helpdesk.  There can be
> 2 kinds of integration
>
> 1)  Online integration - (Where in the front end hits T24 webservices and
> then T24 eg, T24 version and T24 Online Enquiries), where in you need to
> create T24 versions and enquiries and using TAG Webservice factory you need
> to build the webservice and you will get the WSDL and XSD page, which
> external front end system can access.
>
> 2)  Batch integration - CALLJ was used (Where you run a T24 routine or
> TSA.SERVICE or BATCH record in COB, and in the routine you invoke the Java
> method that is present in the Java class)
>
> Regards,
> Ramkumar.S
>

> On Wed, Nov 3, 2010 at 3:13 PM, Anar Veliyev <anar.veli...@gmail.com> wrote:
> > Depends on the answer of the question:
> >  - How do you manage/plan/imagine to implement the steps 2&3?
>
> > If you're able to talk to TCServer directly then none, if not then "MQ".
>

> > On Wed, Nov 3, 2010 at 3:48 PM, Santosh <santosh.kancha...@gmail.com>wrote:

>
> >>  Hi,
>
> >>  1. Web service received XML request from client and convert to OFS
> >> command
> >> 2. Web Service send OFS command to T24 thru TCServer and get response
> >> 3. Web Service check response, if the response is valid, convert it to XML
> >> and send back to client
>
> >> In the above case do we need any middleware support?
>
> >>   On Thu, Oct 28, 2010 at 10:55 AM, Nguyen Trong Dai <