JDBC problem

Support - Assistance technique
1

$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.
2

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@gmail.com 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

3

I have seen this appear randomly at times as well, but its one of those hard to reproduce bugs…

Another funny/serious thing I observed on slow internet connections, the reports showed different values during different times of the day!

···

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@gmail.com

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@gmail.com 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

Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

4

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@gmail.com 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@gmail.com 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

5

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@gmail.com

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@gmail.com 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@gmail.com 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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

6

Because I didn’t set up the database…will put in a request for this to be changed.

Knut

···

On Thu, Apr 30, 2009 at 1:38 PM, Saptarshi Purkayastha sunbiz@gmail.com wrote:

Yes MyISAM lacks transactions… But y would u still use MyISAM tables?? InnoDB as everything now that most people need.

7

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@gmail.com <mailto:knutst@gmail.com>>

    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@gmail.com > <mailto:knutst@gmail.com>> 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@gmail.com > <mailto:knutst@gmail.com>> 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@lists.launchpad.net
    <mailto:dhis2-devs@lists.launchpad.net>
    Unsubscribe : https://launchpad.net/~dhis2-devs
    More help : https://help.launchpad.net/ListHelp

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

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