OFC JDBC T24 Updated record shows as unauthorized

[Priyantha Debegama]

Hi

I used T24Test.dbs and update record .it warks fine but issue is
updated record shows as unauthorized.
How to update record directly as authoried ? pls help me

Thanks
Priyantha

[Dmitry.]

Your T24 developers could create a special version with "zero" authorization.
If you will use this version, your change will be automatically authorized.

Regards,
  Dmitry

[Priyantha Debegama]

Thanks Your reply.and it works fine.

 

 I have one issue please help me

 

i Used following Queary to update customer table

<sql>SELECT SENDOFS CUSTOMER,/I/PROCESS,{{AAAA}}/{{BBB}}/,{{set ?1}}

SHORT.NAME:1: = set ?2

INTRODUCER:: = set ?3

END

</sql>

It updated correctly.but issue is Inputer name is not my quary user name.its shows  another user name .I want to update inputer as Queary uaser(AAAA)  name. how can i do ir?

 

ple help

 

Thanke

[Dmitry.]

I'm not sure I understand your question correctly.

If you want to use USER and PASSWORD defined in t24 connection parameters, then you have to set exactly those values:

SELECT SENDOFS CUSTOMER,/I/PROCESS,{{USER}}/{{PASS}}/,{{set ?1}}

Note:
in previous query USER and PASS are special  macro-functions that returns username and password defined in jdbc connection parameters.

If you want to pass user and password as web service parameters:
for example you defined parameters 5 and 6 as user and password, then your query should be like this:

SELECT SENDOFS CUSTOMER,/I/PROCESS,{{set ?5}}/{{set ?6}}/,{{set ?1}}

Note:
As you can see, we replaced functions USER and PASS with function "set "
This function returns corresponding input parameter.

You can remove function usage and define you user and password statically:
SELECT SENDOFS CUSTOMER,/I/PROCESS,AAAAA/BBBBB/,{{set ?1}}

To read more about macro functions:
http://code.google.com/p/temenos-ofs-jdbc/wiki/OfsJdbcMacroLanguage

And here you can read about OFS message syntax:
http://code.google.com/p/temenos-ofs-jdbc/wiki/OFSSyntax

Regards,
  Dmitry

[Priyantha Debegama]

Thanks your quick reply. I did the way u said . but problem is still pick some randome username and update it as inputter ( random name comes from users in the system log in  at that time ). not specify user name  im given

 

 if i enter user name as incorrect its validate an give error message but if i enter password incorrectly it not give error and update record well

 

 

 This is my configuration

  

 

 

 

 

 

<operation name="modifyCustomer">

<description>modify customer SHORT NAME. You must specify CUSTOMER ID and new LAST-NAME</description>

<call-query href="modifyCustomer" >

<with-param name="usern" query-param="usern" />

<with-param name="pass" query-param="pass" />

<with-param name="id" query-param="id" />

<with-param name="lastName" query-param="lastName" />

<with-param name="lastName2" query-param="lastName2" />

</call-query>

</operation>

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

 

<sql>SELECT SENDOFS CUSTOMER,/I/PROCESS,{{set ?1}}/{{set ?2}}/,{{set ?3}}

SHORT.NAME:1: = set ?4

INTRODUCER:: = set ?5

END

</sql>

<!-- application always returns @id -->

<result element="modifyCustomerResponse" rowName="return" >

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

</result>

<param name="usern" sqlType="STRING" type="IN" ordinal="1" />

<param name="pass" sqlType="STRING" type="IN" ordinal="2" />

<param name="id" sqlType="STRING" type="IN" ordinal="3" />

<param name="lastName" sqlType="STRING" type="IN" ordinal="4" />

<param name="lastName2" sqlType="STRING" type="IN" ordinal="5" />

　

</query>

 

 

Pls help me.

 

 

Thanks

Priyantha

[Dmitry.]

Jdbc driver sends ofs message directly to TCServer.
There is no additional user/password management.

I'm sure this is somewhere in T24 or TCServer configuration.
Contact your T24 developers/administrators.


Regards,
  Dmitry