Just spent two days troubleshooting why CLOB inserts were failing on one Tomcat install. It came down to two arguments in the resource declaration of my database in Tomcat:
accessToUnderlyingConnectionAllowed="true"
factory="org.apache.commons.dbcp.BasicDataSourceFactory"
The observed failure was that CLOB columns were set to NULL, even though the insert appeared to work. In one table, the CLOB column was declared as XMLTYPE NOT NULL, and inserts would fail with an XMLType error at "line 241". The line 241 the error mentioned was not in my code but in Oracle's.
Besides this, it was necessary to make sure commons-dbcp-1.2.2.jar and commons-pool-1.3.jar were in tomcat's common/lib directory, otherwise I got NoClassDefFound errors in catalinia.out.
Subscribe to:
Post Comments (Atom)
Labels
- Java (34)
- Oracle (27)
- javascript (24)
- NIX administration (19)
- Reporting (18)
- XML (17)
- Web Graphics (10)
- perl (10)
- CSS (9)
- Tomcat (8)
- Android (7)
- Matlab (7)
- XSL (7)
- HTML (6)
- SQL (6)
- XForms (6)
- browser quirks (6)
- Orbeon XForms (5)
- Solaris (5)
- AJAX (4)
- Mirth Project (4)
- PHP (4)
- Video (4)
- Arduino (3)
- Eclipse (3)
- JPA (3)
- JSP (3)
- JSTL (3)
- LAMPS (3)
- SSH (3)
- SVN (3)
- Hibernate (2)
- Netbeans (2)
- Networking (2)
- Python (2)
- Windows (2)
- Wordpress (2)
- XHTML (2)
- Alfresco (1)
- Architecture (1)
- ArduPilot (1)
- Arduino Yun (1)
- Arduplane (1)
- Audio Recording (1)
- Betaflight (1)
- CouchDB (1)
- DIY (1)
- Design (1)
- FPV (1)
- JSON (1)
- JUnit (1)
- Mobile Development (1)
- Printing (1)
- RC Airplane (1)
- REST (1)
- Scalability (1)
- Struts (1)
- Tools (1)
- Virtualization (1)
- Web services (1)
- camera (1)
- canon (1)
- gphoto2 (1)
- jQuery (1)
- ubuntu (1)
- unix (1)
No comments:
Post a Comment