1) iBatis does not support DDL script execution. 2) http://opensource.atlassian.com/confluence/oss/display/IBATIS/How+do+I+connect+using+a+user%27s+credentials%3F
Brandon On 6/9/05, Dmitry Skavish <[EMAIL PROTECTED]> wrote: > Hello everybody, > > I am pretty new to iBATIS, but already love it! I have couple of questions: > > 1. I am developing a client app which will be using iBatis. On the > first run I want to create tables in a db if they are not there yet. > Can I use iBatis for that? If yes how? Basically I need to send a > bunch of "create table ..." in one transaction. Currently I get > connection manually from jdbc and then create stmt and create all > those tables. I would prefer to do it via iBatis the same way I query > or update it. Another related problem is that i was trying to obtain > connection from iBatis using this code: > > SqlMapClient map .... > > map.startTransaction(); > Connection connection = map.getCurrentConnection(); > createDB(connection); > map.endTransaction(); > > but it fails on the first sql, some noninformant jdbc exception saying > that transaction is aborted without any clue why. I use postgress db. > > 2. How do I pass connection properties, i.e. user, password, in > runtime. I mean I don't want it to be hardcoded in xml config. > > Thanks! > -- > Dmitry Skavish >