|
Home > Archive > PostgreSQL JDBC > September 2005 > org.postgresql.util.PSQLException: Eingabe/Ausgabe-Fehler {0} beim Senden an das Backend
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
org.postgresql.util.PSQLException: Eingabe/Ausgabe-Fehler {0} beim Senden an das Backend
|
|
| Sven Hütten 2005-09-15, 9:24 am |
|
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(QueryExecuto
rImpl.java:201)
at
org.postgresql.jdbc2. AbstractJdbc2Stateme
nt. execute(AbstractJdbc
2Statement.j
ava:389)
at
org.postgresql.jdbc2. AbstractJdbc2Stateme
nt. executeWithFlags(Abs
tractJdbc2St
atement.java:314)
at
org.postgresql.jdbc2. AbstractJdbc2Stateme
nt. executeQuery(Abstrac
tJdbc2Statem
ent.java:221)
at
org.postgresql.jdbc2. AbstractJdbc2Databas
eMetaData. getMaxNameLength(Abs
tract
Jdbc2DatabaseMetaDat
a.java:81)
at
org.postgresql.jdbc2. AbstractJdbc2Databas
eMetaData. getColumns(AbstractJ
dbc2D
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
| |
| Dave Cramer 2005-09-15, 11:24 am |
| 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. AbstractJdbc2Stateme
nt.execute
> (AbstractJdbc2Statem
ent.j
> ava:389)
> at
> org.postgresql.jdbc2. AbstractJdbc2Stateme
nt.executeWithFlags
> (AbstractJdbc2St
> atement.java:314)
> at
> org.postgresql.jdbc2. AbstractJdbc2Stateme
nt.executeQuery
> (AbstractJdbc2Statem
> ent.java:221)
> at
> org.postgresql.jdbc2. AbstractJdbc2Databas
eMetaData.getMaxNameLength
> (Abstract
> Jdbc2DatabaseMetaDat
a.java:81)
> at
> org.postgresql.jdbc2. AbstractJdbc2Databas
eMetaData.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@postgresql
.org so that your
message can get through to the mailing list cleanly
| |
| Sven Hütten 2005-09-15, 1:23 pm |
|
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(Resu
ltSet. TYPE_SCROLL_INSENSIT
IVE,ResultSet.CONCU
R_READ_ONLY);
....
DatabaseMetaData metaData = connection.getMetaData();
.....
ResultSet result = metaData.getColumns("",schema,table,"");
.....
PreparedStatement ps = dbConnection. prepareStatement(dyn
amicQuery);
....
ParameterMetaData meta = ps. getParameterMetaData
();
....
dbConnection. executePreparedState
ment(ps);
....
stmt.close();
Sven Hütten
-----Ursprüngliche Nachricht-----
Von: pgsql-jdbc- owner+M13848@postgre
sql.org
[mailto:pgsql-jdbc- owner+M13848@postgre
sql.org] Im Auftrag von Dave Cramer
Gesendet: Donnerstag, 15. September 2005 16:27
An: Sven Hütten
Cc: pgsql-jdbc@postgresql.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. AbstractJdbc2Stateme
nt.execute
> (AbstractJdbc2Statem
ent.j
> ava:389)
> at
> org.postgresql.jdbc2. AbstractJdbc2Stateme
nt.executeWithFlags
> (AbstractJdbc2St
> atement.java:314)
> at
> org.postgresql.jdbc2. AbstractJdbc2Stateme
nt.executeQuery
> (AbstractJdbc2Statem
> ent.java:221)
> at
> org.postgresql.jdbc2. AbstractJdbc2Databas
eMetaData.getMaxNameLength
> (Abstract
> Jdbc2DatabaseMetaDat
a.java:81)
> at
> org.postgresql.jdbc2. AbstractJdbc2Databas
eMetaData.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@postgresql
.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@postgresql
.org so that your
message can get through to the mailing list cleanly
| |
| Dave Cramer 2005-09-15, 1:23 pm |
|
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_INSENSIT
IVE,ResultSet.CONCU
> R_READ_ONLY);
> ...
> DatabaseMetaData metaData = connection.getMetaData();
> ....
> ResultSet result = metaData.getColumns("",schema,table,"");
> ....
> PreparedStatement ps = dbConnection. prepareStatement(dyn
amicQuery);
> ...
> ParameterMetaData meta = ps. getParameterMetaData
();
> ...
> dbConnection. executePreparedState
ment(ps);
> ...
> stmt.close();
>
>
> Sven Hütten
>
>
>
> -----Ursprüngliche Nachricht-----
> Von: pgsql-jdbc- owner+M13848@postgre
sql.org
> [mailto:pgsql-jdbc- owner+M13848@postgre
sql.org] Im Auftrag von Dave
> Cramer
> Gesendet: Donnerstag, 15. September 2005 16:27
> An: Sven Hütten
> Cc: pgsql-jdbc@postgresql.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:
>
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql
.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@postgresql
.org so that
> your
> message can get through to the mailing list cleanly
>
>
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
| |
| Sven Hütten 2005-09-15, 8:24 pm |
| Hello Dave,
the exception is generated by metaData.getColumns("",schema,table,"");.
Is it a problem, if i open a statement and a perparedStatement?
Best regards
Sven Hütten
-----Ursprüngliche Nachricht-----
Von: pgsql-jdbc- owner+M13850@postgre
sql.org
[mailto:pgsql-jdbc- owner+M13850@postgre
sql.org] Im Auftrag von Dave Cramer
Gesendet: Donnerstag, 15. September 2005 20:03
An: Sven Hütten
Cc: pgsql-jdbc@postgresql.org
Betreff: Re: [JDBC] org.postgresql.util.PSQLException:
Eingabe/Ausgabe-Fehler {0} beim Senden an das Backend
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_INSENSIT
IVE,ResultSet.CONCU
> R_READ_ONLY);
> ...
> DatabaseMetaData metaData = connection.getMetaData(); ....
> ResultSet result = metaData.getColumns("",schema,table,"");
> ....
> PreparedStatement ps = dbConnection. prepareStatement(dyn
amicQuery);
> ...
> ParameterMetaData meta = ps. getParameterMetaData
(); ...
> dbConnection. executePreparedState
ment(ps);
> ...
> stmt.close();
>
>
> Sven Hütten
>
>
>
> -----Ursprüngliche Nachricht-----
> Von: pgsql-jdbc- owner+M13848@postgre
sql.org
> [mailto:pgsql-jdbc- owner+M13848@postgre
sql.org] Im Auftrag von Dave
> Cramer
> Gesendet: Donnerstag, 15. September 2005 16:27
> An: Sven Hütten
> Cc: pgsql-jdbc@postgresql.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:
>
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql
.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@postgresql
.org so that
> your
> message can get through to the mailing list cleanly
>
>
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
|
|
|
|
|