Archive for June, 2011

I couldn’t find this in the documentation, so I thought I would post it in case someone else has the same question. If you have an XMLTYPE datatpe column stored as a CLOB, you can modify attributes using the example below. ALTER TABLE xwc.xwcmd_xml_data MODIFY lob(mdata_xml.xmldata) (pctversion 1); Notice the xmldata appended to the... »

We had an issue in a development database where a group of developers were not using a connection manager, but trying to manage their own connections. This did not end well. To limit our exposure and the impact on other application users, we implemented a simple profile for the problematic user. A simple test... »

This just doesn’t sound good. Having multiple threads use the same physical connection sounds like an exercise in frustration. Although the OracleDataSource connection object is thread safe, there is really no need to create a smaller number of connections than threads and then use them as static class variables. We had this issue last... »