EDM usage assistance needed

[Andy Knight]

Some javascript/style in this post has been disabled (why?)

I have worked through the example http://docs.sun.com/app/docs/doc/820-7856/dsgn_mashup_project_p?a=view

The data I am working with has changed slightly from that which is supplied.

Let's say I do an HTTP GET using this URL:-

http://localhost:9080/casaService1/casaPort1?page=0&row=0&column=0&FILE_LOC_S1_SUPPLIER_ADDRESS=0&FILE_LOC_S2_SANDRA_DATA=0

I get back a number of "records". With the sample data that I'm using, I get 10 records.

If I change the page parameter to 1, I get the same data returned. However, if I change it to 2, I get different data (2 records in my case).

This suggests to me that we acquire data on a page by page basis and that values of 0 and 1 are synonymous.

Question #1

How/Where do I configure to return more or less data per page?

Question #2

How do I know when I've reached the end of all data? [ Bear in mind that if exactly 20 records are to be returned on 2 pages of 10 each, I wouldn't want to make a 3rd invocation of the WS. I assume that if a page returns less than 10 records that I can infer that that's the end ]

Question #3

Where can I find documentation that describes how each of the 5 HTTP/WSDL(SOAP) parameters are to be used?

	Andy Knight Principal Engineer, Sun Microsystems, Inc. Java House, Guillemont Park, Minley Road, Camberley, Surrey GU17 9QG United Kingdom Home office: [phone] Mobile: [phone] Skype: aprknight Email: [hidden email] Blog: http://blogs.sun.com/andky

[Nilesh Apte]

Some javascript/style in this post has been disabled (why?)

Hi Andy:

Find my response in-line below.

Thanks,

Nilesh.

On 15-Oct-09, at 5:06 PM, Andy Knight wrote:

I have worked through the example http://docs.sun.com/app/docs/doc/820-7856/dsgn_mashup_project_p?a=view

The data I am working with has changed slightly from that which is supplied.

Let's say I do an HTTP GET using this URL:-

http://localhost:9080/casaService1/casaPort1?page=0&row=0&column=0&FILE_LOC_S1_SUPPLIER_ADDRESS=0&FILE_LOC_S2_SANDRA_DATA=0

I get back a number of "records". With the sample data that I'm using, I get 10 records.

If I change the page parameter to 1, I get the same data returned. However, if I change it to 2, I get different data (2 records in my case).

This suggests to me that we acquire data on a page by page basis and that values of 0 and 1 are synonymous.

<Nilesh> Yes, we have implemented "Pagination" in Data Mashup and values of 0 and 1 are synonymous for the parameter "page".

Question #1

How/Where do I configure to return more or less data per page?

<Nilesh> There is a component level property called "Page Size" (see attached screen shot). Changing this value needs a component re-start.

Question #2

How do I know when I've reached the end of all data? [ Bear in mind that if exactly 20 records are to be returned on 2 pages of 10 each, I wouldn't want to make a 3rd invocation of the WS. I assume that if a page returns less than 10 records that I can infer that that's the end ]

<Nilesh> Unfortunately, there is not programatic/configurable way currently supported to know the total number of records generated by the query (scope for improvement). The only way is when the page returns less than the "Page Size" number of records for an invocation.

Question #3

Where can I find documentation that describes how each of the 5 HTTP/WSDL(SOAP) parameters are to be used?

<Nilesh> We need to improve the current documentation. Here is the brief:

The parameters are variable in number,but, there will always be at least three mandatory parameters (which defaults to 0), i.e. page, row and column.

Depending on the number of runtime arguments added explicitly or number of flat file tables used in the collaboration, the number of parameters will change dynamically.

1. page: specifies the page you want to jump to

2. row: Particular row on a particular page (mentioned above).

3. column: particular child node from the page and row mentioned using other two parameters.

so, using these three parameters one can drill down to various levels in the data.

For the dynamic parameters, for ex. FILE_LOC_S1_SUPPLIER_ADDRESS in your case, one needs to specify the file name that one wants to use for the invocation (which defaults to its default design time value if not specified or left empty.).

	Andy Knight Principal Engineer, Sun Microsystems, Inc. Java House, Guillemont Park, Minley Road, Camberley, Surrey GU17 9QG United Kingdom Home office: [phone] Mobile: [phone] Skype: aprknight Email: [hidden email] Blog: http://blogs.sun.com/andky

[Andy Knight]

Some javascript/style in this post has been disabled (why?)

This is all very useful. Thank you. One further question stems from this...

You say that the "dynamic parameters" are used to specify a different source for the data. I had no idea that that was what these are used for. Is this documented anywhere?

In the published example one is instructed to fill all parameters with numeric zero. I can see how this makes sense in the context of page, row & column but what about the "dynamic parameters"? If there's a value of "0" in there, isn't the runtime system going to look for a file called "0"? Or are you using "0" to indicate "default".

Would it not make sense to have all 5 parameters defined as optional and/or nillable?

	Andy Knight Principal Engineer, Sun Microsystems, Inc. Java House, Guillemont Park, Minley Road, Camberley, Surrey GU17 9QG United Kingdom Home office: [phone] Mobile: [phone] Skype: aprknight Email: [hidden email] Blog: http://blogs.sun.com/andky

On 15 Oct 2009, at 20:38, Nilesh Apte wrote:

Hi Andy:

Find my response in-line below.

Thanks,

Nilesh.

On 15-Oct-09, at 5:06 PM, Andy Knight wrote:

I have worked through the example http://docs.sun.com/app/docs/doc/820-7856/dsgn_mashup_project_p?a=view

The data I am working with has changed slightly from that which is supplied.

Let's say I do an HTTP GET using this URL:-

http://localhost:9080/casaService1/casaPort1?page=0&row=0&column=0&FILE_LOC_S1_SUPPLIER_ADDRESS=0&FILE_LOC_S2_SANDRA_DATA=0

I get back a number of "records". With the sample data that I'm using, I get 10 records.

If I change the page parameter to 1, I get the same data returned. However, if I change it to 2, I get different data (2 records in my case).

This suggests to me that we acquire data on a page by page basis and that values of 0 and 1 are synonymous.

<Nilesh> Yes, we have implemented "Pagination" in Data Mashup and values of 0 and 1 are synonymous for the parameter "page".

Question #1

How/Where do I configure to return more or less data per page?

<Nilesh> There is a component level property called "Page Size" (see attached screen shot). Changing this value needs a component re-start.

Question #2

How do I know when I've reached the end of all data? [ Bear in mind that if exactly 20 records are to be returned on 2 pages of 10 each, I wouldn't want to make a 3rd invocation of the WS. I assume that if a page returns less than 10 records that I can infer that that's the end ]

<Nilesh> Unfortunately, there is not programatic/configurable way currently supported to know the total number of records generated by the query (scope for improvement). The only way is when the page returns less than the "Page Size" number of records for an invocation.

Question #3

Where can I find documentation that describes how each of the 5 HTTP/WSDL(SOAP) parameters are to be used?

<Nilesh> We need to improve the current documentation. Here is the brief:

The parameters are variable in number,but, there will always be at least three mandatory parameters (which defaults to 0), i.e. page, row and column.

Depending on the number of runtime arguments added explicitly or number of flat file tables used in the collaboration, the number of parameters will change dynamically.

1. page: specifies the page you want to jump to

2. row: Particular row on a particular page (mentioned above).

3. column: particular child node from the page and row mentioned using other two parameters.

so, using these three parameters one can drill down to various levels in the data.

For the dynamic parameters, for ex. FILE_LOC_S1_SUPPLIER_ADDRESS in your case, one needs to specify the file name that one wants to use for the invocation (which defaults to its default design time value if not specified or left empty.).

<Picture 1.png>

	Andy Knight Principal Engineer, Sun Microsystems, Inc. Java House, Guillemont Park, Minley Road, Camberley, Surrey GU17 9QG United Kingdom Home office: [phone] Mobile: [phone] Skype: aprknight Email: [hidden email] Blog: http://blogs.sun.com/andky