You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by camelContext <pr...@citrix.com> on 2009/10/20 22:46:00 UTC
Post script annotation
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 have to add that single line (fo
calling the SP) to all these files in order to ensure the synonyms are being
created.
I was wondering if there is a better way to tackle this repetitive stuff :-(
Is there some kind of post processing configuration that i can do? Or can
you please point me to the tool codebase. If there is a better way to do
this, i would like to try it out and if it is working, would submit it to
the group.
Thanks
Praveen
--
View this message in context: http://www.nabble.com/Post-script-annotation-tp25982252p25982252.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org
Re: Post script annotation
Posted by camelContext <pr...@citrix.com>.
Never mind, resolved the issue, i did not have the parent pom.
I would really love to know if the feature of post processing would be
really helpful?
I have actually added another property to the development.properties called
postProcessorFile, which states the file name to be executed after, applying
all the SQLs. This gets invoked in the UPCommand.java, after completing all
the change sql files.
IMHO, this is a pretty good feature, which might be used to tackle all those
db admin related things for the tables/views that we created using the tool.
Please share your thoughts.
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 throwing up some maven related error
>
> Pasting the error below
>
>
> [INFO]
> ------------------------------------------------------------------------
> [ERROR] FATAL ERROR
> [INFO]
> ------------------------------------------------------------------------
> [INFO] Error building POM (may not be this project's POM).
>
>
> Project ID: null:ibatis-3-core:jar:null
>
> Reason: Cannot find parent: org.apache.ibatis:ibatis-3 for project:
> null:ibatis-3-core:jar:null for project null:ibatis-3-core:jar:null
>
>
> [INFO]
> ------------------------------------------------------------------------
> [INFO] Trace
> org.apache.maven.reactor.MavenExecutionException: Cannot find parent:
> org.apache.ibatis:ibatis-3 for project: null:ibatis-3-core:jar:null for
> project null:ibatis-3-core:jar:null
> at
> org.apache.maven.DefaultMaven.getProjects(DefaultMaven.java:404)
> at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:272)
> at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:138)
> at org.apache.maven.cli.MavenCli.main(MavenCli.java:362)
> at
> org.apache.maven.cli.compat.CompatibleMain.main(CompatibleMain.java:60)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at
> org.codehaus.classworlds.Launcher.launchEnhanced(Launcher.java:315)
> at org.codehaus.classworlds.Launcher.launch(Launcher.java:255)
> at
> org.codehaus.classworlds.Launcher.mainWithExitCode(Launcher.java:430)
> at org.codehaus.classworlds.Launcher.main(Launcher.java:375)
> Caused by: org.apache.maven.project.ProjectBuildingException: Cannot find
> parent: org.apache.ibatis:ibatis-3 for project:
> null:ibatis-3-core:jar:null for project null:ibatis-3-core:jar:null
> at
> org.apache.maven.project.DefaultMavenProjectBuilder.assembleLineage(DefaultMavenProjectBuilder.java:1396)
> at
> org.apache.maven.project.DefaultMavenProjectBuilder.buildInternal(DefaultMavenProjectBuilder.java:823)
> at
> org.apache.maven.project.DefaultMavenProjectBuilder.buildFromSourceFileInternal(DefaultMavenProjectBuilder.java:508)
> at
> org.apache.maven.project.DefaultMavenProjectBuilder.build(DefaultMavenProjectBuilder.java:200)
> at org.apache.maven.DefaultMaven.getProject(DefaultMaven.java:604)
> at
> org.apache.maven.DefaultMaven.collectProjects(DefaultMaven.java:487)
> at
> org.apache.maven.DefaultMaven.getProjects(DefaultMaven.java:391)
> ... 12 more
> Caused by: org.apache.maven.project.ProjectBuildingException: POM
> 'org.apache.ibatis:ibatis-3' not found in repository: Unable to download
> the artifact from any repository
>
> org.apache.ibatis:ibatis-3:pom:3.0-SNAPSHOT
>
> from the specified remote repositories:
> archiva.snapshots
> (http://repo.ad.corp.expertcity.com:8080/archiva/repository/snapshots),
> Ibatis repo
> (http://svn.apache.org/repos/asf/ibatis/trunk/java/ibatis-3/),
> archiva.ibiblio
> (http://repo.ad.corp.expertcity.com:8080/archiva/repository/ibiblio),
> internal
> (http://repo.ad.corp.expertcity.com:8080/archiva/repository/internal),
> spring-milestone
> (http://s3.amazonaws.com/maven.springframework.org/milestone),
> archiva.default
> (http://repo.ad.corp.expertcity.com:8080/archiva/repository/internal)
>
> for project org.apache.ibatis:ibatis-3
> at
> org.apache.maven.project.DefaultMavenProjectBuilder.findModelFromRepository(DefaultMavenProjectBuilder.java:605)
> at
> org.apache.maven.project.DefaultMavenProjectBuilder.assembleLineage(DefaultMavenProjectBuilder.java:1392)
>
>
>
>
> Kai Grabfelder-3 wrote:
>>
>> Hi,
>>
>> I'm not into the migration tool that much, but you should be able to
>> finde the code within the ibatis3-core
>> project:
>> https://svn.apache.org/repos/asf/ibatis/java/ibatis-3/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 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 have to add that single line
>>> (fo
>>> calling the SP) to all these files in order to ensure the synonyms are
>>> being
>>> created.
>>>
>>> I was wondering if there is a better way to tackle this repetitive stuff
>>> :-(
>>>
>>> Is there some kind of post processing configuration that i can do? Or
>>> can
>>> you please point me to the tool codebase. If there is a better way to do
>>> this, i would like to try it out and if it is working, would submit it
>>> to
>>> the group.
>>>
>>> Thanks
>>> Praveen
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
>> For additional commands, e-mail: user-java-help@ibatis.apache.org
>>
>>
>>
>
>
--
View this message in context: http://www.nabble.com/Post-script-annotation-tp25982252p26001247.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org
Re: Post script annotation
Posted by camelContext <pr...@citrix.com>.
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 throwing up some maven related error
Pasting the error below
[INFO]
------------------------------------------------------------------------
[ERROR] FATAL ERROR
[INFO]
------------------------------------------------------------------------
[INFO] Error building POM (may not be this project's POM).
Project ID: null:ibatis-3-core:jar:null
Reason: Cannot find parent: org.apache.ibatis:ibatis-3 for project:
null:ibatis-3-core:jar:null for project null:ibatis-3-core:jar:null
[INFO]
------------------------------------------------------------------------
[INFO] Trace
org.apache.maven.reactor.MavenExecutionException: Cannot find parent:
org.apache.ibatis:ibatis-3 for project: null:ibatis-3-core:jar:null for
project null:ibatis-3-core:jar:null
at org.apache.maven.DefaultMaven.getProjects(DefaultMaven.java:404)
at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:272)
at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:138)
at org.apache.maven.cli.MavenCli.main(MavenCli.java:362)
at
org.apache.maven.cli.compat.CompatibleMain.main(CompatibleMain.java:60)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org.codehaus.classworlds.Launcher.launchEnhanced(Launcher.java:315)
at org.codehaus.classworlds.Launcher.launch(Launcher.java:255)
at
org.codehaus.classworlds.Launcher.mainWithExitCode(Launcher.java:430)
at org.codehaus.classworlds.Launcher.main(Launcher.java:375)
Caused by: org.apache.maven.project.ProjectBuildingException: Cannot find
parent: org.apache.ibatis:ibatis-3 for project: null:ibatis-3-core:jar:null
for project null:ibatis-3-core:jar:null
at
org.apache.maven.project.DefaultMavenProjectBuilder.assembleLineage(DefaultMavenProjectBuilder.java:1396)
at
org.apache.maven.project.DefaultMavenProjectBuilder.buildInternal(DefaultMavenProjectBuilder.java:823)
at
org.apache.maven.project.DefaultMavenProjectBuilder.buildFromSourceFileInternal(DefaultMavenProjectBuilder.java:508)
at
org.apache.maven.project.DefaultMavenProjectBuilder.build(DefaultMavenProjectBuilder.java:200)
at org.apache.maven.DefaultMaven.getProject(DefaultMaven.java:604)
at
org.apache.maven.DefaultMaven.collectProjects(DefaultMaven.java:487)
at org.apache.maven.DefaultMaven.getProjects(DefaultMaven.java:391)
... 12 more
Caused by: org.apache.maven.project.ProjectBuildingException: POM
'org.apache.ibatis:ibatis-3' not found in repository: Unable to download the
artifact from any repository
org.apache.ibatis:ibatis-3:pom:3.0-SNAPSHOT
from the specified remote repositories:
archiva.snapshots
(http://repo.ad.corp.expertcity.com:8080/archiva/repository/snapshots),
Ibatis repo (http://svn.apache.org/repos/asf/ibatis/trunk/java/ibatis-3/),
archiva.ibiblio
(http://repo.ad.corp.expertcity.com:8080/archiva/repository/ibiblio),
internal
(http://repo.ad.corp.expertcity.com:8080/archiva/repository/internal),
spring-milestone
(http://s3.amazonaws.com/maven.springframework.org/milestone),
archiva.default
(http://repo.ad.corp.expertcity.com:8080/archiva/repository/internal)
for project org.apache.ibatis:ibatis-3
at
org.apache.maven.project.DefaultMavenProjectBuilder.findModelFromRepository(DefaultMavenProjectBuilder.java:605)
at
org.apache.maven.project.DefaultMavenProjectBuilder.assembleLineage(DefaultMavenProjectBuilder.java:1392)
Kai Grabfelder-3 wrote:
>
> Hi,
>
> I'm not into the migration tool that much, but you should be able to finde
> the code within the ibatis3-core
> project:
> https://svn.apache.org/repos/asf/ibatis/java/ibatis-3/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 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 have to add that single line (fo
>> calling the SP) to all these files in order to ensure the synonyms are
>> being
>> created.
>>
>> I was wondering if there is a better way to tackle this repetitive stuff
>> :-(
>>
>> Is there some kind of post processing configuration that i can do? Or can
>> you please point me to the tool codebase. If there is a better way to do
>> this, i would like to try it out and if it is working, would submit it to
>> the group.
>>
>> Thanks
>> Praveen
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
> For additional commands, e-mail: user-java-help@ibatis.apache.org
>
>
>
--
View this message in context: http://www.nabble.com/Post-script-annotation-tp25982252p25999908.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org
Re: Post script annotation
Posted by Kai Grabfelder <no...@kaigrabfelder.de>.
Hi,
I'm not into the migration tool that much, but you should be able to finde the code within the ibatis3-core
project: https://svn.apache.org/repos/asf/ibatis/java/ibatis-3/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 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 have to add that single line (fo
> calling the SP) to all these files in order to ensure the synonyms are being
> created.
>
> I was wondering if there is a better way to tackle this repetitive stuff :-(
>
> Is there some kind of post processing configuration that i can do? Or can
> you please point me to the tool codebase. If there is a better way to do
> this, i would like to try it out and if it is working, would submit it to
> the group.
>
> Thanks
> Praveen
---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org