Plsql cursor jdbc

[ksatty]

Hi
I am working on unit testing ,
I have one issue I have to check that programmer is used cursor or not and also all the cursor that he have used
I have to use jdbc code for.
pls help me as soon as possible

[ksatty]

Thx in advance

[r035198x]

You can query v$sesstat where name='opened cursors current'.

[ksatty]

Thx
I am new to this. pls give me some sample code ?

[r035198x]

What code did you try that failed?

[ksatty]

If I excute above query it is showing


ERROR at line 1:
ORA-00942: table or view does not exist

[r035198x]

You need to be SYS to access those views in the system tablespace.
You should look those up in your oracle documentation. It has nothing to do with Java.

[Tolls]

If you're planning on trying to check all the cursors have been closed, you won't succeed. Oracle caches some, so you won't be able to tell if there's a leak that way, as far as I know...

[r035198x]

That's why I didn't suggest that they look in v$open_cursor instead.

They could tell about the leak using these methods if they are very clever and rigorous but the attitude they have shown so far suggests that they will not.

If you want to try it yourself see

Monitoring Open and Cached Cursors | Oracle FAQ

[Tolls]

Good article, but it does (sort of) agree with what I said about it being not really doable (at least as an automated thing). I did, however, get my terminology wrong. I thought it was down to the cacheing, but it's simply down to Oracle not closing cursors straight away.

I say automated, since they're talking about unit testing...and I would lay odds on that being JUnit. This is a hands on check and, arguably, doesn't lend itself to the sorts of things JUnit handles.