[rules-users] Capturing DDLs from Guvnor
Hi, I have configured Guvnor to work with Oracle. With this configuration I can see that Guvnor uses my Oracle Database as the datastore, and creates the necessary tables in the Oracle database. I want to capture the Oracle "DDLs" that Guvnor (Jackrabbit) builds to create the table in the Oracle Database, this is required to facilitate application and installs in different environments in the organization. I can go to the database and create the DDLs from there, but am wondering if there is an easier way to achieve the same. Thanks, dme -- View this message in context: http://drools.46999.n3.nabble.com/Capturing-DDLs-from-Guvnor-tp4019855.html Sent from the Drools: User forum mailing list archive at Nabble.com. ___ rules-users mailing list rules-users@lists.jboss.org https://lists.jboss.org/mailman/listinfo/rules-users
Re: [rules-users] Capturing DDLs from Guvnor
Look in the org.apache.jackrabbit.core.persistence.db package in jackrabbit-core-2.2.8.jar for DDLs for the databases supported by JackRabbit. On 19 September 2012 21:22, dme1 wrote: > Hi, > > I have configured Guvnor to work with Oracle. With this configuration I can > see that Guvnor uses my Oracle Database as the datastore, and creates the > necessary tables in the Oracle database. I want to capture the Oracle > "DDLs" > that Guvnor (Jackrabbit) builds to create the table in the Oracle Database, > this is required to facilitate application and installs in different > environments in the organization. > > I can go to the database and create the DDLs from there, but am wondering > if > there is an easier way to achieve the same. > > Thanks, > dme > > > > -- > View this message in context: > http://drools.46999.n3.nabble.com/Capturing-DDLs-from-Guvnor-tp4019855.html > Sent from the Drools: User forum mailing list archive at Nabble.com. > ___ > rules-users mailing list > rules-users@lists.jboss.org > https://lists.jboss.org/mailman/listinfo/rules-users > ___ rules-users mailing list rules-users@lists.jboss.org https://lists.jboss.org/mailman/listinfo/rules-users
Re: [rules-users] Capturing DDLs from Guvnor
Thanks. There doesn't seem to be a way to log the DDLs, so the only option seems to be to modify the source. -- View this message in context: http://drools.46999.n3.nabble.com/Capturing-DDLs-from-Guvnor-tp4019855p4019873.html Sent from the Drools: User forum mailing list archive at Nabble.com. ___ rules-users mailing list rules-users@lists.jboss.org https://lists.jboss.org/mailman/listinfo/rules-users
Re: [rules-users] Capturing DDLs from Guvnor
What did you mean "log the DDLs"? I thought you needed the DDL to create the JCR schema on different RDBMS's - hence I pointed you to the DDL JackRabbit uses. IIRC you can enable logging of SQL statements (DDL and DML) on Oracle (and probably other RDBMS's) if you want to log the DDL JackRabbit uses - but I suspect it'll be the same as the DDL files I pointed you to. If you are expecting a schema that shows a table for Asset, Rule, Enum etc etc you will have along time looking. If JackRabbit is configured to store it's internal data-structures in a RDBMS it uses (and I quote the JavaDocs) "...a simple custom binary serialization format and a very basic non-normalized database schema...". If you want to use a RDBMS not natively supported I suspect you'll need to write your own DatabasePersistenceManager, but this is out of the scope of the Drools mailing lists and questions should be submitted to the JackRabbit mailing lists. With kind regards, Mike On 20 September 2012 15:36, dme1 wrote: > Thanks. There doesn't seem to be a way to log the DDLs, so the only option > seems to be to modify the source. > > > > -- > View this message in context: > http://drools.46999.n3.nabble.com/Capturing-DDLs-from-Guvnor-tp4019855p4019873.html > Sent from the Drools: User forum mailing list archive at Nabble.com. > ___ > rules-users mailing list > rules-users@lists.jboss.org > https://lists.jboss.org/mailman/listinfo/rules-users > ___ rules-users mailing list rules-users@lists.jboss.org https://lists.jboss.org/mailman/listinfo/rules-users
Re: [rules-users] Capturing DDLs from Guvnor
Thanks. You are correct I am just looking to pull out the DDLs used by JackRabbit to create the schema in various databases, and I understand that I will not be able to get the schemas for Rules, Enums etc. as JackRabbit stores in its internal format. I did not see logs in the JackRabbit code, but you are correct I should explore the JDBC drivers. Thanks for the response, dme -- View this message in context: http://drools.46999.n3.nabble.com/Capturing-DDLs-from-Guvnor-tp4019855p4019877.html Sent from the Drools: User forum mailing list archive at Nabble.com. ___ rules-users mailing list rules-users@lists.jboss.org https://lists.jboss.org/mailman/listinfo/rules-users