Enabling Transaction

mohanreddy83 · #1 (**permalink**) 03-04-09, 03:34

Hi All,
I am developing a project in Java plat form with Informix DB. When I am trying to connect the Informix DB through application I am getting Exception as

Exception in thread "AWT-EventQueue-0" org.springframework.transaction.CannotCreateTransa ctionException: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: Transactions not supported.

I got the solution for this exception is Enabling Transaction in Informix DB.

So,Please any one tell me how to enable transactions in informix DB?

Thanks in Advance,
Mohan Reddy. M

rootdbs · #2 (**permalink**) 03-04-09, 03:46

Maybe your database is not in logging mode.
Your DBA can turn on logging mode for your database.

mohanreddy83 · #3 (**permalink**) 03-04-09, 04:37

Thank you for your qucik reply,

I tried the looging mode with ontape command, But it is not working.

That command is::: ontape -s -B <DBNAME>..

Could you tell me the command for turning on looging in Informix DB?..

Thanks
Mohan Reddy. M

rootdbs · #4 (**permalink**) 03-04-09, 05:30

If your server runs on UNIX you can see database status:
onmonitor -> status -> database see colomn "Log Status"

theeiledon · #5 (**permalink**) 03-04-09, 06:50

You can also use:
ondblog unbuf dbname log
or
ondblog buf dbname log
then perform a level 0 archive for example
ontape -s -L 0

mjldba · #6 (**permalink**) 03-04-09, 08:38

if you're using AIX / UNIX you can use ontape -s -U <db_name> to set unbuffered logging, this command should be run by userID "informix"
or by the owner of the DB.

Internet Services

Web Development

Digital Marketing

Consumer Tech