Java on top of vs Java inside Oracle
Since finishing my last project I have had some time on the 'bench', giving me the perfect opportunity to get some training in and up to speed for my next project, again with the same client (I must be doing something right). The project is going to predominately involve Database 10g, Apps Server 10g, Java and ApEx. As I mentioned in a previous post my development environment of choice at the moment is Oracle XE, due to its small memory footprint (comparatively). It provides most the features I've needed for projects I've worked on thus far. Furthermore, the prospect of installing 10g Enterprise is a task that doesn't sit too well, as I've known it to be a bit of a mission in the past. Unfortunately as I have become more experienced, I've discovered that XE lacks certain features that I would sorely like to make use of in my next Project. One such feature is Java Stored Procedures. After some digging around and posts on the Oracle Forums. Another user pointed me in the direction of this matrix which lists features available between the different versions, from XE to Enterprise. I need to write some Java which basically manipulates a PDF form which users will fill out and upload to the system we're developing. The Java code will then strip these responses out and store them in the appropriate database fields. Technically I can see two possible ways of accomplishing this, through:
- Java Stored Procedures
- Use of Java Containers/Extensions outside the DBMS. I.E a java app on the App Server, OC4J etc.