Re: possible bug - Mailing list pgsql-jdbc

Alberto Rodriguez Galdo wrote:

> This is the stackTrace:
>
> org.postgresql.util.PSQLException: ERROR: invalid message format
>         at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1471)
>         at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1256)
>         at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:175)
>         at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:389)
>         at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:314)
>         at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:306)

Can't reproduce this against 8.0.0 with the build 310 jar. Testcase
attached. What are you doing differently to this testcase? The schema I
used (in case it wasn't an error at the Parse stage) is:

test=# \d backupitem
     Table "public.backupitem"
    Column    |  Type   | Modifiers
--------------+---------+-----------
 idbackup     | integer |
 pathservidor | text    |
 pathoriginal | text    |
 hash         | text    |
 esenlace     | text    |
 metadatos    | text    |

You might want to try appending '?loglevel=2' to your connection URL;
that should generate screeds of debugging to stderr that may be useful
in debugging this. (send it to me off-list if it's large)

-O
import java.sql.*;

// Run with one argument: a JDBC url to connect to.
public class TestQuotes {
    private static final String QUERY = "insert into backupItem
(idbackup,pathservidor,pathoriginal,hash,esenlace,metadatos)values
(null,'/home/argaldo/datos/software/tomcat/tomcat/webapps/ubt/backup/dani/null/home/argaldo/test/prueba','/home/argaldo/test/prueba','1C940736976FFFFFFFCFFFFFF866EFFFFFFECFFFFFF827EFFFFFFDC413F7FFFFFFAF76FFFFFFF967','false','<rdf:RDF\n
  xmlns:ubt=\"http://www.pepe.es/ubt/\"\n    xmlns:rdf=\"http://www.w3.org/1999/02/22-rdf-syntax-ns#\" >\n
<rdf:Descriptionrdf:about=\"http://www.pepe.es/ubt/archivo\">\n    <ubt:permisos>420</ubt:permisos>\n
<ubt:UID>1000</ubt:UID>\n   <ubt:tipoArchivo>UNIX</ubt:tipoArchivo>\n    <ubt:esEnlace>false</ubt:esEnlace>\n
<ubt:esEnlaceDuro>false</ubt:esEnlaceDuro>\n   <ubt:ultimaModificacion>1114629588</ubt:ultimaModificacion>\n
<ubt:GID>1000</ubt:GID>\n   <ubt:ultimoAcceso>1114644020</ubt:ultimoAcceso>\n  </rdf:Description>\n</rdf:RDF>\n')"; 

    public static void main(String[] args) throws Exception {
        Class.forName("org.postgresql.Driver");
        Connection c = DriverManager.getConnection(args[0]);

        Statement s = c.createStatement();
        s.executeUpdate(QUERY);

        c.close();
    }
}