I have rather large LOB objects and I get the error "not enough memory
to process statement" -- I increased the query_heap_sz directly on the
server, but cannot do this on the runtime client since this option is
not available for the client. How do I get rid of this error on the
client? I am using java and jdbc. Thank you very much.

This parameter is meaningless on the client - query_heap is only used on
the server. The server will need to be stopped and restarted for the new
value to take effect.

sea wrote:[color=blue]
> I have rather large LOB objects and I get the error "not enough memory
> to process statement" -- I increased the query_heap_sz directly on the
> server, but cannot do this on the runtime client since this option is
> not available for the client. How do I get rid of this error on the
> client? I am using java and jdbc. Thank you very much.[/color]

This parameter is meaningless on the client - query_heap is only used on
the server. The server will need to be stopped and restarted for the new
value to take effect.

sea wrote:[color=blue]
> I have rather large LOB objects and I get the error "not enough memory
> to process statement" -- I increased the query_heap_sz directly on the
> server, but cannot do this on the runtime client since this option is
> not available for the client. How do I get rid of this error on the
> client? I am using java and jdbc. Thank you very much.[/color]