#1 not intentionally #2 I'm not sure what xml generation has to do with this issue. Maybe i am misunderstanding you. If you are developing a web application you will have to do something like what was provided if you want individuals to use their own username and password for database access. Considering you work with connection pools there is no easy way to add a username and password to the connection and maintain security without doing what the link mentioned. So, this is not an issue with iBatis as much as it is an issue with pooled connections.
Brandon On 6/9/05, Dmitry Skavish <[EMAIL PROTECTED]> wrote: > > 1) iBatis does not support DDL script execution. > > Are there any plans to support this? > > > 2) > > http://opensource.atlassian.com/confluence/oss/display/IBATIS/How+do+I+connect+using+a+user%27s+credentials%3F > > It seems to be an overkill for such simple thing. If this is the only > way? I would rather generate xml and give it to iBatis than doing what > is suggested there. > > > > > 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 > > > > > > > > -- > Dmitry Skavish >
