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

Avatar

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

Avatar

Avatar

Jasmin_Charbonn

Avatar

Jasmin_Charbonn

Jasmin_Charbonn

18-03-2009

Can you send the error from the server.log file.



Jasmin

Avatar

Avatar

pguerett

Avatar

pguerett

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.

Avatar

Avatar

Balaji_Gurumurt

Avatar

Balaji_Gurumurt

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 ..

Avatar

Avatar

Balaji_Gurumurt

Avatar

Balaji_Gurumurt

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.

Avatar

Avatar

Balaji_Gurumurt

Avatar

Balaji_Gurumurt

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

Avatar

Avatar

Balaji_Gurumurt

Avatar

Balaji_Gurumurt

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

Avatar

Avatar

Balaji_Gurumurt

Avatar

Balaji_Gurumurt

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.

Avatar

Avatar

Jasmin_Charbonn

Avatar

Jasmin_Charbonn

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