Showing posts with label ORA-01000. Show all posts
Showing posts with label ORA-01000. Show all posts
Friday, November 21, 2014
Weekend Learning: Maximum open cursors with JDBC 12.1.0.2
Were you aware that "overuse" of the OracleDatabaseMetaData.getTables method in JDBC 12.1.0.2 causes an ORA-01000 error to happen? "ORA-01000: Maximum Open Cursors Exceeded With OracleDatabaseMetaData.getTables In JDBC 12.1.0.2" in My Oracle Support via document ID 1939417.1 tells the whole (but short) story and which version of the driver has this issue fixed.
Friday, November 14, 2014
Weekend Learning: JDBC driver cursor leak on 11.2.0.4
Do you know how sometimes you can stumble across a solution for a problem, when you are not even looking for it? Well let me introduce you to My Oracle Support document "Cursor Leak After Upgrading to JDBC Driver 11.2.0.4" via note ID 1939530.1 and ask if you have been having problem with "middleware" or "web services" after upgrading to 11.2.0.4? We are not on 11.2.0.4 YET, but on 11.2.0.3 we have had some issues with memory leaks so this type of issue could be the next condition we encounter so now I am aware of it and can potentially start looking for it when we start upgrading (and testing). Luckily we have not had the ORA-01000 errors indicated in this article, but forewarned is forearmed.
Subscribe to:
Posts (Atom)