News: WSO2DS+T24 jdbc driver in production

[Dmitry.]

Web-Services published on WSO2 DataServices server
through temenos-ofs-jdbc driver are now in production.

Our front systems accessing T24 functionality using web-services.

[Kalya Elisha kipchirchir]

Hi Dmitry,
I am new on this jdbc driver. i have the download already. what i am looking form is the com.temenos.tocf.tcc package which is needed by T24Connection class
Could you please help me get started?

[Dmitry.]

The   com.temenos.tocf.tcc package delivered by temenos with tcclient installation.

If you have ant, command line svn, and checked out the sources, 

then you can use "ant depends" command to download old tcc libraries into ".tools" directory.

Dmitry.

[George Zhou]

Hello all. I am new to WSO2 dataservices. and with your help, i have been able to connect T24 with the WSO2 and been able to retrieve some data from the T24 USER table. But however, it is not all fields that i am able to pull.

Below is the error i get when i get

Fault: DS Fault Message: Error in 'StaticOutputElement.execute', cannot find Param with type:column name:staff.status Source Data Service:- Name: T24Test Location: /opt/wso2data/././repository/dataservices/T24Test.dbs Description: N/A Default Namespace: http://my.namespace Current Request Name: getCustomerById Current Params: {}  

Please any ideas? I am using T24 R10 and WSO2dataservices version 2.2.

[Dmitry.]

I think the column `staff.status` is absent  in enquiry USER

you should remember that through OFS you are accessing enquiries (not tables)

you can activate debug logging for 'org.t24.driver' in wso2ds and you can see all requests/responses to t24.

so you can check what columns do you have in response

Regards, Dmitry

[George Gyau]

Hello Dmitry,

I really appreciate your response. Your presentation has really inspired me a lot.  Do you happened to have other documentations that

i could reference?

I am currently able to access more enquiries but what i noticed is whenever the field has no value for all rows then i tend to get this errors.

In addition i would want to know what version of WSO2 you currently using and its t24 driiver.

I would also want to know if i could share a restful API with this for my ATMs? What i am looking to achieve with this is to be able 

let it be a middleware with which any third party app can connect through (ATMs, TIB, ETRS) and all that.

Kindly advise and how to go about it.

Thanks

--
You received this message because you are subscribed to the Google Groups "temenos-ofs-jdbc" group.
To unsubscribe from this group and stop receiving emails from it, send an email to temenos-ofs-jd...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
Tumalabs Ltd
P. O. Box MP 554
Accra, Ghana
Website: www.tumalabs.com
Email:    in...@tumalabs.com

[George Zhou]

Hi all,

Please i have been trying to connect to T24 R10 through java using ODBC but no luck.

i realised that i am able to do SQLSELECT CUSTOMER_CODE, MNEMONIC FROM FBNK.CUSTOMER WHERE CUSTOMER_CODE = 91983

on the jshell. And asuch i was wondering if i could use the code sample below to connect to T24 and query it through the Java ODBC.

So far i am able to connect but the queries fail with the below errors.

Please help with any documentation or support to enable me connect.

java.sql.SQLException: connection failure error during JRMP connection establishment; nested exception is: 

java.net.SocketException: Connection reset

at com.jbase.jdbc.driver.JBaseDBError.throwSQLException(Unknown Source)

at com.jbase.jdbc.connection.JbaseJDBCConnectionJavaObjex.doConnection(Unknown Source)

at com.jbase.jdbc.connection.JbaseJDBCConnectionImpl.doConnection(Unknown Source)

at com.jbase.jdbc.driver.JBaseJDBCDriver.connect(Unknown Source)

at java.sql.DriverManager.getConnection(DriverManager.java:579)

at java.sql.DriverManager.getConnection(DriverManager.java:221)

at net.egoleo.T24Test.connect(T24Test.java:20)

at net.egoleo.T24Test.main(T24Test.java:53)

and i get this from jbase_agent running too.

(37075|47060987604576) NOTICE starting up jAgent, Process Per Connection mode, listening on port 9797, SocketAcceptor.h +107

(37082|47266353925728) NOTICE RequestHandlerService::open: connected with <unknown>, RequestHandlerService.cpp +221

(37082|47266353925728) ERROR Client::authenticate:Client did not authenticate. Closing jagent connection., Client.cpp +238

(37082|47266353925728) NOTICE Closing connection to <unknown>, RequestHandlerService.cpp +127

(37082|47266353925728) NOTICE Shutting down Connection, JAgentSocketServer.cpp +115

import java.io.IOException;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

public class T24Test {

private Connection conn = null;

private Statement stmt = null;

public void connect() {

try {

Class.forName("com.jbase.jdbc.driver.JBaseJDBCDriver");

conn = DriverManager.getConnection("jdbc:jbase:thin:@localhost:9797:test1","test1","123456");

if(!conn.isClosed()) {

System.out.println("Connected now");

stmt = conn.createStatement();

System.out.println("Hello i am passed1");

ResultSet rs = stmt.executeQuery("SELECT CURRENCY_CODE FROM FBNK.CURRENCY");

System.out.println("Hello i am passed");

while(rs.next()) {

String custcode = rs.getString("CUSTOMER_CODE");

System.out.println(custcode);

}

} else {

System.out.println("Connection is closed");

}

} catch(ClassNotFoundException e) {

System.out.println("Error " + e);

} catch(SQLException e) {

e.printStackTrace ();

}

}

//public static void main(String args[]) throws SQLException, IOException {

public static void main(String args[]) {

new T24Test().connect();

}

}

On Wednesday, 24 February 2010 10:30:55 UTC, Dmitry. wrote: