From: | Dave Cramer <pg(at)fastcrypt(dot)com> |
---|---|
To: | Sven Hütten <sven(dot)huetten(at)web(dot)de> |
Cc: | <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: org.postgresql.util.PSQLException: Eingabe/Ausgabe-Fehler {0} beim Senden an das Backend |
Date: | 2005-09-15 18:02:46 |
Message-ID: | 96662A0F-C4C7-4830-818F-92B48681FE83@fastcrypt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Sven,
Well, seeing as your query is dynamic, we will have to rely on the
server logs
can you look through your logs and find the query that fails?
Dave
On 15-Sep-05, at 1:31 PM, Sven Hütten wrote:
>
> We build querys dynamicly (mapping) with the information of the
> metadatas in
> our framework.
>
> Here are the important sql-commands to insert a data row in our
> framework:
>
> Statement stmt =
> connection.createStatement
> (ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCU
> R_READ_ONLY);
> ...
> DatabaseMetaData metaData = connection.getMetaData();
> ....
> ResultSet result = metaData.getColumns("",schema,table,"");
> ....
> PreparedStatement ps = dbConnection.prepareStatement(dynamicQuery);
> ...
> ParameterMetaData meta = ps.getParameterMetaData();
> ...
> dbConnection.executePreparedStatement(ps);
> ...
> stmt.close();
>
>
> Sven Hütten
>
>
>
> -----Ursprüngliche Nachricht-----
> Von: pgsql-jdbc-owner+M13848(at)postgresql(dot)org
> [mailto:pgsql-jdbc-owner+M13848(at)postgresql(dot)org] Im Auftrag von Dave
> Cramer
> Gesendet: Donnerstag, 15. September 2005 16:27
> An: Sven Hütten
> Cc: pgsql-jdbc(at)postgresql(dot)org
> Betreff: Re: [JDBC] org.postgresql.util.PSQLException:
> Eingabe/Ausgabe-Fehler {0} beim Senden an das Backend
>
> Hi,
>
> Can you tell us what the program is doing when it does this?
>
> What is it attempting to execute ?
>
> Dave
> On 15-Sep-05, at 10:12 AM, Sven Hütten wrote:
>
>
>>
>> Hello Postgresql Friends,
>>
>> i have a problem with postgresql 8.0.3. My Application use the
>> function getColumns of DatabaseMetaData. When i start the application
>> the function will go for some times, but the the function produces
>> errors. Here my Stacktrace. I have no idea. With SAPDB my program is
>> ok.
>>
>>
>> org.postgresql.util.PSQLException: Eingabe/Ausgabe-Fehler {0} beim
>> Senden an
>> das Backend.
>> at
>> org.postgresql.core.v3.QueryExecutorImpl.execute
>> (QueryExecutorImpl.java:201)
>>
>> at
>> org.postgresql.jdbc2.AbstractJdbc2Statement.execute
>> (AbstractJdbc2Statement.j
>> ava:389)
>> at
>> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags
>> (AbstractJdbc2St
>> atement.java:314)
>> at
>> org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery
>> (AbstractJdbc2Statem
>> ent.java:221)
>> at
>> org.postgresql.jdbc2.AbstractJdbc2DatabaseMetaData.getMaxNameLength
>> (Abstract
>> Jdbc2DatabaseMetaData.java:81)
>> at
>> org.postgresql.jdbc2.AbstractJdbc2DatabaseMetaData.getColumns
>> (AbstractJdbc2D
>> atabaseMetaData.java:2382)
>>
>>
>> ----------------------------------------------------------------
>> My code:
>>
>> DatabaseMetaData metaData = connection.getMetaData();
>> ResultSet result = metaData.getColumns("",schema,table,"");
>>
>>
>> Has anybody a solution for my problem?
>>
>> Best regards
>>
>> Sven Hütten
>>
>>
>> ---------------------------(end of
>> broadcast)---------------------------
>> TIP 2: Don't 'kill -9' the postmaster
>>
>>
>>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that
> your
> message can get through to the mailing list cleanly
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that
> your
> message can get through to the mailing list cleanly
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Sven Hütten | 2005-09-15 18:23:32 | Re: org.postgresql.util.PSQLException: Eingabe/Ausgabe-Fehler {0} beim Senden an das Backend |
Previous Message | Sven Hütten | 2005-09-15 17:31:00 | Re: org.postgresql.util.PSQLException: Eingabe/Ausgabe-Fehler {0} beim Senden an das Backend |