xCp2.2 app - display values from database

Dan_M

Hi guys,

I tried to display some values from database on value display fields.

I create a stateless process with one activity: Read from database. In debug mode this process is working fine.

In my app nothing is show after introduce input value.

I add process as interaction in my page and configured:

- for input I use widgets.my_input_var.value

- for output: dataservices.my_process_initiate_staless_ds.processVariables.my_output_var

Process variables are single value.

When I input value in input field, in log file I receive:

Error occured while instantiating driver for: com.microsoft.jdbc.sqlserver.SQLServerDriver

Thx,

Dan.

Find more posts tagged with

Documentum

Comments

Vinojass

Check that end point whether it is reachable from server machine?

Dan_M

Hi Vinod,

Thx for your message.

Regarding endpoint, database is on the same database server as repository, on the same machine and it can be reached from server machine.

Regarding answer you send me earlier - it doesn't appear on this post:

If it works in debug mode then it should works... then check the following things

1. check whether you mapped correctly to the input of stateless process or not

2. Check you are invoke the stateless process properly by button or on page load event or any other events

3. Clear the browser cache and check

4. Open the browser's developer tool and then check in the network tab that your stateless process invoked or not and check in the console tab also

5. Validate actual input value of your stateless process

6. And finally still you are facing the same issue then I think you are trying without deployment (preview mode) so deploy at lease once

1. I mapped for input "widgets.my_input_var.value".

2. I try with:

- on page load

- when value changes

Nothing happened

3.i already do

4. In network tab I have, before enter input value:

For request headers:

Key	Value
X-Requested-With	XMLHttpRequest
x-csrf-token	43f228a7-64bc-48be-8d25-835edb21aee5
User-Agent	Mozilla/5.0 (Windows NT 6.3; WOW64; Trident/7.0; rv:11.0) like Gecko
Request	POST /cms11/processes/cmsd_preluare_auto_db?id= HTTP/1.1
Referer	http://192.168.42.128:8083/cms11/#cmsd_polita/cmsd_adauga_polita
Host	192.168.42.128:8083
DNT	1
Cookie	xcp-locale=en_US; JSESSIONID=1F00EE60A1D7CE8D3D4898EACB754332; xcp-login-hash=; x-csrf-token=43f228a7-64bc-48be-8d25-835edb21aee5; __dmfClientId=1427366185315; lockFresh=free; allFreshClient=%%cookieTS__client-1274169216##1427366191642%%__dmfFreshClient__client-1274169216##stale%%__dmfFreshForm__client-1274169216##1427366185904
Content-Type	application/json
Content-Length	57
Connection	Keep-Alive
Cache-Control	no-cache
Accept-Language	en-US
Accept-Encoding	gzip, deflate
Accept	application/json

For Request body:

{"run-stateless":"true","data":{"variables":{"nume":""}}}

Response headers:

Key	Value
Response	HTTP/1.1 201 Created
Server	Apache-Coyote/1.1
Pragma	no-cache
Expires	Thu, 01 Jan 1970 00:00:00 GMT
Cache-Control	no-cache
Cache-Control	no-store
Location	http://192.168.42.128:8083/cms11/processes/cmsd_preluare_auto_db/null
Content-Type	application/json;charset=UTF-8
Transfer-Encoding	chunked
Date	Thu, 26 Mar 2015 13:46:11 GMT

For Response body:

{"name":"process","type":"cmsd_preluare_auto_db","definition":"http://192.168.42.128:8083/cms11/types/processes/cmsd_preluare_auto_db","properties":{},"data":{"variables":{"prenume":""}},"links":[{"rel":"type","href":"types/processes/cmsd_preluare_auto_db"}]}

5. What do you mean?

Thx,

Dan

Dan_M

I put a drop down list and I can see values from database in this drop-down.

But I can't see the vaue in value display field...

dnvhariprasad

What is the return datatype? Did you change the datatype in the value display widget?

Dan_M

hmm..

One is string and one is date.

dnvhariprasad

whatever you are displaying in the value-display, make sure you configure the correct datatype in the properties panel.

Dan_M

there are correct

TSK77

Hi Dan, which xCP application URL to get the token, x-csrf-token for POST request header.

All my POST request returns "HTTP Status 403 - Validation failed" Access to the specified resource has been forbidden.

GET - DELETE works with user/password Authorization