create tables and dynamic configuration

[Dmitry Skavish <sk...@gmail.com>]

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