@@nestlevel 2 higher than expected

We're using MS SQL Server with Tomcat and Java (MS JDBC driver) and the nestlevel in called stored procedures is 2 higher than when making the same calls not thru tomcat.

any ideas?
LVL 92
objectsAsked:
Who is Participating?
 
arbertConnect With a Mentor Commented:
I would suggest running SQL Server profiler  to capture the SQL Statements being executed.  This way, you can see what the 2extra levels are.
0
 
objectsAuthor Commented:
I haven't forgotten about this. The DBA is currently overseas, when he gets back we'll see what profiler can tell us.
0
 
arbertCommented:
Sounds good!
0
 
objectsAuthor Commented:
he still hasn't returned yet so i'll close this and ask for more info if needed when he returns.

Thanks :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.