|
»
»
Post script annotation
|
View:
New views
4 Messages
—
Rating Filter:
Alert me
|
 |
Post script annotation
by camelContext
::
Rate this Message:
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 |
|
|
Re: Post script annotation
by Kai Grabfelder-3
::
Rate this Message:
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@... For additional commands, e-mail: user-java-help@... |
|
|
Re: Post script annotation
by camelContext
::
Rate this Message:
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)
|
|
|
Re: Post script annotation
by camelContext
::
Rate this Message:
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
|
| Free embeddable forum powered by Nabble | Forum Help |
