Welcome to temenos-ofs-jdbc discussion group

[Dmitry.]

This group dedicated to support temenos-ofs-jdbc project.

[Manoel]

Hi pls help. I'm new to this project

I'm getting error with my SENDOFS

Nested Exception:-

org.t24.driver.T24Exception: T24 Parser Error at line SENDOFS ENQUIRY.SELECT,,{ETMENSON}/{{tmens@123},%USER                 END.

Can't find close tag for header expression: SENDOFS ENQUIRY.SELECT,,{USER1}/{{pwd@1234},%USER                 END

[Dmitry.]

command must be multiline
check the examples:
http://code.google.com/p/temenos-ofs-jdbc/wiki/Examples

in your case it should be something like this:

SENDOFS ENQUIRY.SELECT,,{{USER}}/{{PASS}},%USER
END

{{USER}} and {{PASS}} will be replaced with user and password specified in jdbc parameters

or you can them as constants in the query

SENDOFS ENQUIRY.SELECT,,ETMENSON/tmens@123,%USER
END

Regards, Dmitry

[Manoel]

Hi Dmitry

I'm still getting error with my query

org.t24.driver.T24Exception: T24 Parser Error at line CUSTOMER.NO:EQ  =  101111.

Unknown command : 101111

<operation name="getUserList">

            <description>Get User List</description>

            <call-query href="getUserList"/>

         </operation>

         <query id="getUserList" useConfig="t24">

            <sql>SELECT SENDOFS ENQUIRY.SELECT,,{{USER}}/{{PASS}},ARC.MO.ACCT.LIST,CUSTOMER.NO:EQ  =  101111

  END

</sql>

            <result element="getUserListResponse" rowName="user">

               <element column="CO.CODE" name="COMPANY"/>

            </result>

         </query>

Pls help

thanks

[Manoel]

I tried multiline still getting error:

 <operation name="getUserList">

            <description>Get User List</description>

            <call-query href="getUserList"/>

         </operation>

         <query id="getUserList" useConfig="t24">

            <sql>

SELECT SENDOFS ENQUIRY.SELECT,,{{USER}}/{{PASS}},%USER

END

</sql>

            <result element="getUserListResponse" rowName="user">

               <element column="@ID" name="USER.ID"/>

            </result>

         </query>

It returns :

Nested Exception:-

javax.xml.stream.XMLStreamException: DS Fault Message: Error in 'SQLQuery.processNormalQuery'

DS Code: DATABASE_ERROR

Source Data Service:-

Name: T24Test

Location: /T24Test.dbs

Description: Test service

Default Namespace: http://my.namespace

Current Request Name: getUserList

Current Params: {}

Nested Exception:-

org.t24.driver.T24Exception: T24 Send Exception: _sOfsResponse

</soapenv:Text>

   </soapenv:Reason>

   <soapenv:Detail>

      <axis2ns17:DataServiceFault xmlns:axis2ns17="http://ws.wso2.org/dataservice">

         <axis2ns17:current_params>{}</axis2ns17:current_params>

         <axis2ns17:current_request_name>getUserList</axis2ns17:current_request_name>

         <axis2ns17:nested_exception>org.t24.driver.T24Exception: T24 Send Exception: _sOfsResponse</axis2ns17:nested_exception>

         <axis2ns17:source_data_service>

            <axis2ns17:location>/T24Test.dbs</axis2ns17:location>

            <axis2ns17:default_namespace>http://my.namespace</axis2ns17:default_namespace>

            <axis2ns17:description>Test service</axis2ns17:description>

            <axis2ns17:data_service_name>T24Test</axis2ns17:data_service_name>

         </axis2ns17:source_data_service>

         <axis2ns17:ds_code>DATABASE_ERROR</axis2ns17:ds_code>

      </axis2ns17:DataServiceFault>

   </soapenv:Detail>

</soapenv:Fault>

Pls help

[Dmitry Lukyanov]

http://code.google.com/p/temenos-ofs-jdbc/w/list

http://code.google.com/p/temenos-ofs-jdbc/wiki/Examples
operations that you can use after `=`
http://code.google.com/p/temenos-ofs-jdbc/wiki/OfsJdbcMacroLanguage

SELECT SENDOFS ENQUIRY.SELECT,,{{USER}}/{{PASS}},ARC.MO.ACCT.LIST

CUSTOMER.NO:EQ  = const 101111

END

 
if you want to pass a parameter

SELECT SENDOFS ENQUIRY.SELECT,,{{USER}}/{{PASS}},ARC.MO.ACCT.LIST

CUSTOMER.NO:EQ  = set ?1
END

--
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/d/optout.

--
Regards,
Dmitry

[Dmitry Lukyanov]

Activate debug logging for  `org.t24.driver`
check wso2 server logs
there should more info.

Also check full stacktrace in error log

Regards,
Dmitry

--- Original message ---
From: "Manoel" <mens...@gmail.com>

--

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/d/optout.

--
Regards,
Dmitry

[Manoel]

Hi thank you so much for your assistance

I guess i'm not making the right requests. I'm new to wso2

This what i'm sending:

<body>

   <p:TestARCEnq xmlns:p="http://test">

      <!--Exactly 1 occurrence-->

      

   </p:TestARCEnq>

</body>

And I get the response:

<soapenv:Fault xmlns:soapenv="http://www.w3.org/2003/05/soap-envelope">

   <soapenv:Code>

      <soapenv:Value>soapenv:Receiver</soapenv:Value>

   </soapenv:Code>

   <soapenv:Reason>

      <soapenv:Text xml:lang="en-US" xmlns:xml="http://www.w3.org/XML/1998/namespace">The T24ARCTest service, which is not valid, does not belong to the T24ARCTest service group.</soapenv:Text>

   </soapenv:Reason>

   <soapenv:Detail/>

</soapenv:Fault>

The service is:

<?xml version="1.0" encoding="UTF-8"?>

<data name="T24ARCTest" baseURI="http://my.namespace">

<description>Test ARC service</description>

<config id="t24">

        <property name="org.wso2.ws.dataservice.driver">org.t24.driver.T24Driver</property>

        <!-- in your channel.xml there should be channel named MYCHANNEL -->

        <property name="org.wso2.ws.dataservice.protocol">jdbc:org:t24:MYCHANNEL</property>

        <property name="org.wso2.ws.dataservice.user">T24WSO2</property>

        <property name="org.wso2.ws.dataservice.password">wso2@123</property>

        <property name="org.wso2.ws.dataservice.minpoolsize">0</property>

        <property name="org.wso2.ws.dataservice.maxpoolsize">3</property>

</config>

<!--================================= getUserList ======================================-->

<operation name="getARCList">

    <description>Get ARC List</description>

    <call-query href="getARCList" />

</operation>

<query id="getARCList" useConfig="t24">

        <sql>

SELECT

SENDOFS ENQUIRY.SELECT,,{{USER}}/{{PASS}},ARC.MO.ACCT.LIST

CUSTOMER.NO:EQ = const 101111

END

        </sql>

        <result element="getARCListResponse" rowName="user" >

                <element name="Account"               column="@ID" />

                <element name="AcName"            column="ACCOUNT.TITLE.1"/>

                <element name="Balance"        column="WORKING.BALANCE"/>

                <element name="Company"         column="CO.CODE"/>

        </result>

</query>

<operation name="TestARCEnq">

</operation>

[Manoel]

 at java.lang.Thread.run(Thread.java:724)

[2014-06-24 09:42:14,949] ERROR {org.apache.catalina.core.StandardWrapperValve} -  Servlet.service() for servlet [bridgeservlet] in context with path [/] threw exception [Servlet execution threw an exception] with root cause

java.lang.Error: INVALID_INPUT_EXCEPTION. Invalid input was : <p:TestARCEnq xmlns="http://test"><!--Exactly 1 occurrence--></p:TestARCEnq>

        at org.apache.jsp.admin.jsp.WSRequestXSSproxy_005fajaxprocessor_jsp._jspService(org.apache.jsp.admin.jsp.WSRequestXSSproxy_005fajaxprocessor_jsp:248)

        at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:111)

.....

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

        at java.lang.Thread.run(Thread.java:724)

[2014-06-24 09:42:18,634] ERROR {org.wso2.carbon.security.config.SecurityConfigAdmin} -  Error while reading persisted data

org.wso2.carbon.security.SecurityConfigException: AxisService is Null

        at org.wso2.carbon.security.config.SecurityConfigAdmin.getCurrentScenario(SecurityConfigAdmin.java:200)

        at org.wso2.carbon.security.pox.POXSecurityHandler.invoke(POXSecurityHandler.java:93)

        at org.apache.axis2.engine.Phase.invokeHandler(Phase.java:340)

[Manoel]

Do i need to set xmlns in my request?

[Dmitry Lukyanov]

The main thing that

The T24ARCTest service is not valid 

Regards

--- Original message ---
From: "Manoel" <mens...@gmail.com>

--
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/d/optout.

--
Regards,
Dmitry

[Manoel]

Can you pls tell me what is wrong with the service?

[Dmitry Lukyanov]

Send me your service, request, response, exception stacktrace from log
then probably I could help you

Regards,
  Dmitry 

--- Original message ---
From: "Manoel" <mens...@gmail.com>

--

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/d/optout.