MashZone with postgres: Method org.postgresql.jdbc4.Jdbc4Statement.setQueryTimeout(int) is not yet implemented.

Hello Phil,

the flaw occured in the postgres driver itself, unfortunately it obviously does not implement the complete java.sql.Statement interface, so the standard method "setQueryTimeout", which is adressed by MashZone to protect itself from not returning queries, throws this "Not-Implemented"-Exception. So there is no official way to disable the timeout restriction.

I think there are 2 approaches to solve your problem:

You might implement your own postgres-driver just by wrapping the genuine one and then simply catch the Not-Implemented Exception throw by the method, what is quite like hacking and might harm the Mashzone application during runtime.

The recommended and even more convenient solution is to look for a completely implemented postgre driver, perhaps a commercial one with some license fees.

Best regards

Thomas

Hello Phil,

i took a look at the latest postgre driver source code, what is version 9.0-801 JDBC Source, and there i found this confusing implementation.

snippet from class org.postgresql.jdbc2.AbstractJdbc2Statement.java:

    public void setQueryTimeout(int seconds) throws SQLException

    {

        checkClosed();

        if (seconds < 0)

            throw new PSQLException(GT.tr("Query timeout must be a value greater than or equals to 0."),

                                    PSQLState.INVALID_PARAMETER_VALUE);



        if (seconds > 0)

            throw Driver.notImplemented(this.getClass(), "setQueryTimeout(int)");



        timeout = seconds;

    }

I think if you only comment these lines

 //       if (seconds > 0)

 //           throw Driver.notImplemented(this.getClass(), "setQueryTimeout(int)");

your problem is fixed. Finally you only have to create a jar file of the whole source and use it instead of the genuine distributed postgre driver.

For sure this is no official supported approach to get the postgre driver running with mashzone, but it should work this way. :-)

Best regards

Thomas

You're welcome.

I am glad to hear that you were successful.

But please think twice before using this solution in a productive environment.

Best regards

Thomas