Executing PL/SQL procs from migration tool.

2009-10-19 Thread camelContext
Hi All, I am using iBatis migration tool to create my service schema. My service schema demands that i execute couple of PL/SQL procedures for some permission related things (post schema creation). I tried to execute the following from one of my scripts BEGIN oracle.grants.everything('SUBSCRI

Re: Executing PL/SQL procs from migration tool.

2009-10-20 Thread camelContext
gt; Server... >> But otherwise we'll need some creative thinking to figure out how to deal >> with the double ; >> Clinton >> >> On Mon, Oct 19, 2009 at 8:12 PM, Clinton Begin >> wrote: >>> >>> The double ; will cause problems.  I'm

Post script annotation

2009-10-20 Thread camelContext
Hi All, i am using the iBATIS migration tool to manage my DB SQLs. We have a convention to create a synonym and grant read access to the application. We do have a public stored procedure which does this for us. But i hate to call it in all my scripts. Suppose i have 5 sql script file, i will h

Re: Post script annotation

2009-10-21 Thread camelContext
trunk/ibatis-3-core > > Regards > > Kai > > --- Original Nachricht --- > Absender: camelContext > Datum: 20.10.2009 22:46 >> Hi All, >> >> i am using the iBATIS migration tool to manage my DB SQLs. We have a >> convention to create a synonym and gra

Re: Post script annotation

2009-10-21 Thread camelContext
. Thanks Praveen camelContext wrote: > > Cool, will try to come up with a solution for the post script stuff. Will > also send code reviews, if you think it might be useful feature. > > Hey BTW, i am not able to do a simple mvn clean compile on the > ibatis-3-core project. It is thro

Custom path for drivers

2009-11-05 Thread camelContext
Hi All, I am using iBATIS tool for running all my DB migrations. As of now, the script mandates that i have all the driver jar files, inside a drivers folder in my root folder i.e ROOT | -- scripts | -- environments | -- drivers | -- ojdbc.jar . I have

Re: Custom path for drivers

2009-11-05 Thread camelContext
DriverPath != null && customDriverPath.length()>0){ + driverPath = new File(customDriverPath); + } if (driverClassLoader == null && driverPath.exists()) { List urlList = new ArrayList(); for (File file : driverPath.listFiles()) { camelContext

Re: Custom path for drivers

2009-11-05 Thread camelContext
Added a jira request with the patch attached to it. https://issues.apache.org/jira/browse/IBATIS-685 Clinton Begin wrote: > > Please atttache your patch (or just the BaseCommand.java is easier) to a > JIRA feature request... > > Clinton > > On Thu, Nov 5, 2009 at

Re: Custom path for drivers

2009-12-02 Thread camelContext
May i know if the patch is accepted. the Jira status still says unassigned. This is an essential feature and will be a good addon to the tool. camelContext wrote: > > Added a jira request with the patch attached to it. > > https://issues.apache.org/jira/browse/IBATIS-685 >