Hi,

I am calling an user-defined function(UDF) in my query for retrieving certain output. The UDF inturn will estabish connection with a database and returns a result set, since the number of connections being established is proportional to the results,I am planning to implement connection pooling using DBCP api for reducing the number of connections made.

I tried the approach, but facing some issue while invoking the function.The same function without connection pooling is working fine, but it gives an error saying cannot find the implementation for function when invoked with connection pooling.

Am I missing something here or is there any other options available for implementing the connection pooling in metamatrix?

Any suggestions?

Thanks