• Post Reply Bookmark Topic Watch Topic
  • New Topic

Cursors and PreparedStatements

 
kg manuel
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi guys, i used the built-in google search to check if any previous posts might be relevant and found none so i am posting this question.

Our DBA is having troubles with having too many cursors with a specific sql. i am not authorized to post the exact sql. but here is a general idea.

initially, the table has 25+ fields all inserted using a PreparedStatement. statistically, this sql runs atleast 50-100 times a day.

within the database system, Oracle 10g to be specific, a trigger is created to fill the primary key field. this trigger is runned before the actual insert is runned.

now, i am already expecting the trigger as a source of the cursor population. i would like to ask if the PreparedStatement adds up that much as well.
 
Scott Selikoff
author
Bartender
Posts: 4033
18
Eclipse IDE Flex Google Web Toolkit
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Good Oracle DBAs are hard to find...

Also, are you sure all connections/statements are being regularly closed or is it one particular transaction that is hurting performance?
 
kg manuel
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
thanks scott for your time.

yes there is one statement not being closed properly. that one is already fixed. i would like to confirm however if the number of '?' in the PreparedStatement has something to do with it.

thanks again in advance.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!