-
Type:
Bug
-
Resolution: Obsolete
-
Priority:
Medium
-
None
-
Affects Version/s: 3.1, 3.1.1
-
Component/s: Navigation - Search
-
3.01
Under certain conditions, connections are leaked:
- Tomcat (not certain if we need this)
- Oracle (with tryclob...) or MSSQL
- Try running quicksearch with a key that isn't found - this will search through the change history
- Because Oracle (and MSSQL presumably) can't do exact text match queries in CLOBs (though 'like' queries work), and exception is thrown
- This exception propagates up to JIRA code. However, ofbiz doesn't close the connection.
- If you do this enough times (more than number of connections in DB pool - 8 in Tomcat's commons-dbcp) then you run out of connections, and JIRA appears to hang.