I am creating a CallableStatement to execute an Oracle (9i) PL/SQL procedure. The out parameters of this procedure have been described to me as a TABLE type. I'm not sure how to process this within my Java code. I have hunted around a little bit, but I'm a little lost.
Unfortunately we only ran these as Struts applications in a local test environment. So we never had a multi-user/concurrency test on an application server. I suppose we could test this out fairly easily.
We're experiencing a strange and dangerous behavior in WSP 5.0. We've developed and deployed a set of portlets. These were built as Struts-based stand-alone applications and then later converted to portlets and deployed. The portlets accept user search criteria and then do a database search through a custom-built persistence layer. Then the Action class of the portlet puts the results into session scope and renders the JSP.
The problem is that sometimes, other users logged into the portal will refresh the page that that portlet is on, and see the other user's result set and search criteria. This is not good. =)
We modified our BaseAction class (of which we extend all of our other Action classes), and made it use PortletSession instead of HttpSession. This still didn't help. I'm at a loss here and any help would be greatly appreciated.
The compiler determines which classes get compiled with your class depending on which ones you use. So an import statement like: java.sql.*; Is no less efficient than importing the specific class you are using.
I'd like to set up some bug tracking software for our developers. Currently we track enhancements and bugs on an Excel spreadsheet. I'm sure there's a better option. What are the best products for this? Both commercial and open-source would be considered.