[jboss-user] [jBPM] - Re: JBPM 5.2 and tomcat 7.0 and oracle 10 integration

[smclenahan]

smclenahan [https://community.jboss.org/people/smclenahan] created the discussion

"Re: JBPM 5.2 and tomcat 7.0 and oracle 10 integration"

To view the discussion, visit: https://community.jboss.org/message/741449#741449

--------------------------------------------------------------
I have posted an example of how to do this with Oracle 11g Express at the following location - note this will assume you have the H2 installation working as described in a related post.

 http://ironclaws.wordpress.com/2012/06/13/jbpm-5-2-tomcat-7-oracle-11g-express-demo/ http://ironclaws.wordpress.com/2012/06/13/jbpm-5-2-tomcat-7-oracle-11g-express-demo/

For Oracle 10g - If using Express you will probably find that this example will work as is - maybe a slightly different Oracle JDBC driver version required.

For non express Oracle - assuming you have granted create database privileges to your user - all should work fine. 

I think though from a best practices point of view it is probably better to continue the pattern set by express and create the target database independently in the instance, and grant only the object creation rights to the user.
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/741449#741449]

Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20120613/f5a78f59/attachment-0001.html