Re: DBC Connection - Protocol error when execute Select
- From: jenser55@xxxxxxxxxxxxxx
- Date: Fri, 14 Dec 2007 00:43:58 -0800 (PST)
On 13 Dez., 16:50, jense...@xxxxxxxxxxxxxx wrote:
i have some trouble in executing a select Statement.
I tested the Program which is shown at the Community wiki:http://community.ingres.com/wiki/Java_Example
The example works fine on inserting and deleting a dataset. But when I
try to execute the Select-Statement - I got this exception:
com.ingres.gcf.util.SqlEx: Connection aborted due to communications
protocol error.
at com.ingres.gcf.util.SqlEx.get(SqlEx.java:97)
at com.ingres.gcf.jdbc.DrvObj.readResult(DrvObj.java:1050)
at com.ingres.gcf.jdbc.DrvObj.readResults(DrvObj.java:623)
at com.ingres.gcf.jdbc.RsltFtch.preLoad(RsltFtch.java:482)
at com.ingres.gcf.jdbc.RsltCurs.<init>(RsltCurs.java:223)
at com.ingres.gcf.jdbc.JdbcStmt.exec(JdbcStmt.java:1326)
at com.ingres.gcf.jdbc.JdbcStmt.executeQuery(JdbcStmt.java:408)
at DriverTest.retrieveCountries(DriverTest.java:115)
at DriverTest.main(DriverTest.java:56)
Remark Wen I test the same Connection with the same driver in
DBVisualizer - it all works fine. (Selecting by SQL - Command)
But in Netbeans(Versions 5.5 & 5.5.1) the same error occurs when I try
to connect to my database by defining a database connection.
My Operating System is: SuSE Linux 10.2
Ingres Version: II 9.2.0 (int.lnx/118)NPTL - locally installed
Database;
JDBC - Driver VersionI: Ingres Corporation - JDBC Driver [3.2]
Problem is solved:
I used JDBC - Driver Version 3.2 with Ingres Release 9.2.0 but this
JDBC - Version works works only with Version 9.1.0. I needed JDBC-
Driver Version 3.3 or higher. See relating Topic
http://community.ingres.com/forums/viewtopic.php?t=1663
.
- References:
- DBC Connection - Protocol error when execute Select
- From: jenser55
- DBC Connection - Protocol error when execute Select
- Prev by Date: Re: [Info-Ingres] Alter user syntax
- Next by Date: [Info-Ingres] Change your aggregate size.
- Previous by thread: Re: [Info-Ingres] Alter user syntax
- Next by thread: [Info-Ingres] Change your aggregate size.
- Index(es):
Relevant Pages
|
