Expand my Community achievements bar.

Dive into Adobe Summit 2024! Explore curated list of AEM sessions & labs, register, connect with experts, ask questions, engage, and share insights. Don't miss the excitement.

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

Avatar

Former Community Member
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
9 Replies

Avatar

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



Jasmin

Avatar

Former Community Member
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

Level 2

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

Level 2

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

Level 2

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

Level 2

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

Level 2

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

Level 10

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