• Post Reply Bookmark Topic Watch Topic
  • New Topic

oracle temp space full?Didn't close JDBC connection  RSS feed

 
CFTang
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Dear all:
my temp space is keep growing to full after I run some application with JDBC connection to retrieve data. I found sometime after I make the JDBC call then I forgot to close the connection. I am not sure the temp space full is causing the "unclose" JDBC connection or the stupid query I did becasuae I remember temp space is using for the soprting purpose. Can someone give me a hand? Is the no-closing JDBC connection going to cause any kind of problem. Thanks a lot
 
Jamie Robertson
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by CFTang:
... Is the no-closing JDBC connection going to cause any kind of problem. Thanks a lot
It can if you don't explicitly close every ResultSet/Statement using that connection. If you are closing them, then maybe you just have your Oracle settings to low for TEMP tablespace( MAXEXTENTS value? ).
Jamie
 
Don't get me started about those stupid light bulbs.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!