Highlighted

sample Datasource name for Query Single row/Query for multiple rows as XML services

Avatar

Guest

17-03-2009

Hi,

What is the input I should give in the "Datasource name" property in

Query Single row/Query for multiple rows as XML services. Can anyone

provide me an example for the same? I am using weblogic server and

oracle database.



When I enter the query(select NAME from TABLE where USERID=1;) in SQL

statement info editor and click the "Test" button am getting the

following error in Test Results field - "Exception: Internal error..

Cause: ALC-DSC-000-000: com.adobe.idp.dsc.DSCRuntimeException:

Internal error." Is this caused because of the connection problems?



Thanks.

kripa

Replies

Highlighted

pguerett

18-03-2009

That parameter should be the JNDI data source name. There is one created for you called IDP_DS that connects to the LiveCycle Databases. I suggest trying to connect to that one to make sure it works for you. Use the edcprincipaluserentity tabel to query against (as a test). Once you verify that it works for you, add your own JNDI name and use your own DB.
Highlighted

Balaji_Gurumurt

30-01-2010

hi

     Am working in Adobe LC ES2. I tried to invoke a webservice using a Single Query Row service but it throwed the exception (see attached screenshot).

what should i do now .? Can u helpme on this ..

Highlighted

Balaji_Gurumurt

30-01-2010

Also can u list the configuration parameters of all the stuff to be done here ...

It will be more appreciated if issue is solved.

thanx

Balaji.

Highlighted

Balaji_Gurumurt

30-01-2010

Now i can able to invoke service without error but with a blank output.

I couln't find why it doesn't return any rows even if it is single row.

Anyone tried of the same ..? Pls provide an input.

thanx

Balaji

Highlighted

Balaji_Gurumurt

30-01-2010

PFA the screenshot of how the input is provided but the output is BLANK..

In Detail of the webservice workflow :

1. Get_Email:283831 is the input.

2. Am seperating this 283831 (which is the uid) as input from the string and passing it to Query Single Row and also mapped the output to the seperate output string variable.

thanx

Balaji

Highlighted

Balaji_Gurumurt

30-01-2010

hi,

     Am trying to use "Query for Multiple Rows as XML" service in LC ES2 and have succeeded in that too.

Can anyone guide me on how to proceed after taking the output from that service as xml (but mentioned as document type) or what's next to do..?

PFA the screenshot of the service configurations.

thanx

Balaji.

Highlighted

Jasmin_Charbonn

01-02-2010

You could put it in a XML variable type instead (even if it says Document type). That way you can use an xPath expression to get to the data you need from that resulting XML.

Jasmin