Entity Bean hangs while fetching database table column having large size

[swap Inam]

Hi All

New to the EJB's.

Here is the scenario :

Entity Bean (BMT) fetches a 'postgres' database column of type 'bytea'.
If the record size is large say 20MB, it hangs in the fetch.
If the record size is small say 2MB, it works fine.

I guess this is a common scenario already faced by many.

Could I have the possible solutions.

When it hangs while fetching,
[1] is there any way of debugging the same.....
[2] is there any setting for timeout, size in bytes to be fetched...any other setting...

Please let me know if any information is missing from the scenario (using jboss container) ...

Thanks in advance.

[swap Inam]

Hi All,

Could anybody please provide any help on this......

Thanks in advance