cancel
Showing results for 
Search instead for 
Did you mean: 

Problem retrieving data in a table

Former Member
0 Kudos

Hai,

I am using table element to view the data retrieve by the webservice.

the database is maxdb it have around 5000 rows, when i tried to retrieve data the table does not showing the data, i tried to run the webservice from dispatcher, at that time i got the message like read timeout error.

any body please help me to encounter this problem.

regards,

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Naga,

First, try to figure out where bottleneck occurs:

1. Execute same query in SQL Studio. Does it runs quickly? If not then problem is query complexity and query / database should be optimize (records indexing etc)

2. Try to execute same query from Java application via JDBC, application must run on WebAS server If this also works ok, then problem is probably XML marshaling/unmarhalling of data, otherwise it is slow connection between server and DB host.

VS

Former Member
0 Kudos

Hai Valery,

I tried as you said,

I tried the query in sql studio. its very fine

I used jdbc to retrieve working fine.

I tried by removing around half of the records, table shows the data.

why its happening , how to solve the marshaling/unmarshaling problem.

regards,

Former Member
0 Kudos

Naga,

Just to clarify scenario:

1. You have some (probably EJB) middle layer that expose data from database via WebService

2. You are consuming WebService in WebDynpro for data display.

3. Reducing data set in half (from 5000 records to 2500) make things work correctly.

So, you need to investigate what part is wrong:

-- middle layer serializes data inefficiently

-- WebDynpro part deserializes data inefficiently

-- both.

Solutions could be different, the most natural one is

to reduce number of fields transfered, exclude large texts and blob-like structures. Probably you may skip WebService transport alltogether, accessing middle tier directly via JavaBeans model rather then WS model.

VS

Former Member
0 Kudos

Hai Valery,

Thanks for help,

I am now trying the same thing . i think it will solve my problem.

regards,

Answers (0)