Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

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
Coach
Level 10
Jasmin_Charbonn
Level 10

Likes

149 likes

Total Posts

2,154 posts

Correct Reply

97 solutions
Top badges earned
Coach
Give Back 1000
Give back 900
Give Back 800
Give back 600
View profile

Avatar
Coach
Level 10
Jasmin_Charbonn
Level 10

Likes

149 likes

Total Posts

2,154 posts

Correct Reply

97 solutions
Top badges earned
Coach
Give Back 1000
Give back 900
Give Back 800
Give back 600
View profile
Jasmin_Charbonn
Level 10

18-03-2009

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



Jasmin

Avatar

Avatar
Boost 500
Level 10
pguerett
Level 10

Likes

612 likes

Total Posts

7,689 posts

Correct Reply

692 solutions
Top badges earned
Boost 500
Boost 50
Boost 5
Boost 3
Boost 250
View profile

Avatar
Boost 500
Level 10
pguerett
Level 10

Likes

612 likes

Total Posts

7,689 posts

Correct Reply

692 solutions
Top badges earned
Boost 500
Boost 50
Boost 5
Boost 3
Boost 250
View profile
pguerett
Level 10

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
Level 2
Balaji_Gurumurt
Level 2

Likes

0 likes

Total Posts

26 posts

Correct Reply

0 solutions
View profile

Avatar
Level 2
Balaji_Gurumurt
Level 2

Likes

0 likes

Total Posts

26 posts

Correct Reply

0 solutions
View profile
Balaji_Gurumurt
Level 2

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
Level 2
Balaji_Gurumurt
Level 2

Likes

0 likes

Total Posts

26 posts

Correct Reply

0 solutions
View profile

Avatar
Level 2
Balaji_Gurumurt
Level 2

Likes

0 likes

Total Posts

26 posts

Correct Reply

0 solutions
View profile
Balaji_Gurumurt
Level 2

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
Level 2
Balaji_Gurumurt
Level 2

Likes

0 likes

Total Posts

26 posts

Correct Reply

0 solutions
View profile

Avatar
Level 2
Balaji_Gurumurt
Level 2

Likes

0 likes

Total Posts

26 posts

Correct Reply

0 solutions
View profile
Balaji_Gurumurt
Level 2

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
Level 2
Balaji_Gurumurt
Level 2

Likes

0 likes

Total Posts

26 posts

Correct Reply

0 solutions
View profile

Avatar
Level 2
Balaji_Gurumurt
Level 2

Likes

0 likes

Total Posts

26 posts

Correct Reply

0 solutions
View profile
Balaji_Gurumurt
Level 2

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
Level 2
Balaji_Gurumurt
Level 2

Likes

0 likes

Total Posts

26 posts

Correct Reply

0 solutions
View profile

Avatar
Level 2
Balaji_Gurumurt
Level 2

Likes

0 likes

Total Posts

26 posts

Correct Reply

0 solutions
View profile
Balaji_Gurumurt
Level 2

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
Coach
Level 10
Jasmin_Charbonn
Level 10

Likes

149 likes

Total Posts

2,154 posts

Correct Reply

97 solutions
Top badges earned
Coach
Give Back 1000
Give back 900
Give Back 800
Give back 600
View profile

Avatar
Coach
Level 10
Jasmin_Charbonn
Level 10

Likes

149 likes

Total Posts

2,154 posts

Correct Reply

97 solutions
Top badges earned
Coach
Give Back 1000
Give back 900
Give Back 800
Give back 600
View profile
Jasmin_Charbonn
Level 10

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