Database Objects

[daph]

Hi,

Is there a way to know how many database objects are open in a program?

Thanks
daph

 

[Diancecht]

I don't know by code, but there's a tool called JProbe used for monitorization that can help you.

Cheers,

Dian

 

[daph]

Is there a way to do this in the code? I would like to check this without using a third-party application/tool.

Thanks,
Daph

 

[Diancecht]

Well, you can always have an static variable and increment or decrement it everytime you instantiate or free a database object.

Cheers,

Dian

 

[timw]

...and it depends on your motivation for wanting to know this. If you're using Connection Pooling software, then even when you've finished with a database object and close it, it is usually returned to the pool and is still an open database object as far as the database is concerned.

Tim