← Back to team overview

dhis2-devs team mailing list archive

Re: JDBC problem

 

I has this sometimes.

Once was when I updade the war. And I solved by poiting the new war to an empty database.

Then I reinserted the data on the tables manually. I dislike this way but it solved.

Caveman


Saptarshi Purkayastha wrote:
Yes MyISAM lacks transactions... But y would u still use MyISAM tables?? InnoDB as everything now that most people need.
---
Regards,
Saptarshi PURKAYASTHA
Director R & D, HISP India
Health Information Systems Programme

My Tech Blog:  http://sunnytalkstech.blogspot.com
You Live by CHOICE, Not by CHANCE


2009/4/30 Knut Staring <knutst@xxxxxxxxx <mailto:knutst@xxxxxxxxx>>

    Hm...the error came back quickly - I suspect it is related to MyIsam
    tables instead of Innodb, as Myisam doesn't support transactions, right?


    On Thu, Apr 30, 2009 at 1:04 PM, Knut Staring <knutst@xxxxxxxxx
    <mailto:knutst@xxxxxxxxx>> wrote:

        Trying installation on a remote server, and got this error when
        I pretty much tried anything...but could have been a glitch with
        the server, as it seems to work again now. So hopefully false alarm.

        Knut

        On Thu, Apr 30, 2009 at 12:57 PM, Knut Staring <knutst@xxxxxxxxx
        <mailto:knutst@xxxxxxxxx>> wrote:


                $i18n.getString( "an_exception_occured" )

            $encoder.htmlEncode( $i18n.getString(
            "exception_explanation_text" ))


                      [+] $i18n.getString( "exception" )
                      (org.hibernate.TransactionException): JDBC commit
                      failed


                      [+] $i18n.getString( "caused_by" )
                      (com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException):
                      Connection.close() has already been called.
                      Invalid operation in this state.




-- Cheers,
        Knut Staring




-- Cheers,
    Knut Staring

    _______________________________________________
    Mailing list: https://launchpad.net/~dhis2-devs
    Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
    <mailto:dhis2-devs@xxxxxxxxxxxxxxxxxxx>
    Unsubscribe : https://launchpad.net/~dhis2-devs
    More help   : https://help.launchpad.net/ListHelp



------------------------------------------------------------------------

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp





References