Results 1 to 6 of 6
  1. #1
    Join Date
    Mar 2009
    Posts
    2

    Unanswered: Enabling Transaction

    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

  2. #2
    Join Date
    Feb 2009
    Posts
    51
    Maybe your database is not in logging mode.
    Your DBA can turn on logging mode for your database.

  3. #3
    Join Date
    Mar 2009
    Posts
    2

    Turning on looging

    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

  4. #4
    Join Date
    Feb 2009
    Posts
    51
    If your server runs on UNIX you can see database status:
    onmonitor -> status -> database see colomn "Log Status"

  5. #5
    Join Date
    Nov 2004
    Posts
    60
    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

  6. #6
    Join Date
    Dec 2003
    Location
    North America
    Posts
    146
    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.
    Last edited by mjldba; 03-04-09 at 09:16.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •