I do have sql-maps written for Oracle Database. Is there any tool or something that I can use to automatically convert to Sql-Server? The sql-queries for oracle has some usage of oracle functions (to_date etc).
Thanks. ________________________________ From: Chema <[email protected]> To: [email protected] Sent: Thu, March 18, 2010 5:19:33 PM Subject: Re: Ibatis sql-maps 2010/3/18 kiran vuppla <[email protected]>: > Actually I don't like to write a java client too as I need to provide this > to DBA to verify the SQL queries. He don't have any idea of Java. I would > appreciate if there is something I can use without writing Java Code and get > the generated SQLs from sql-maps. > Thanks. These SQL sentences are generated in runtime. So, you need some type of application who calls these methods. If you just need capture the SQL sentence, you can run your app and use p6spy or log4j ( or Java logging ) to send these SQL sentences to you DBA --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
