ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dmitry Skavish <skav...@gmail.com>
Subject create tables and dynamic configuration
Date Thu, 09 Jun 2005 17:30:48 GMT
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

Mime
View raw message