DBC Connection - Protocol error when execute Select

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jenser55@googlemail.com - 13 Dec 2007 15:50 GMT

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]

Reply to this Message

Laframboise André - 13 Dec 2007 16:26 GMT

Hi Guys,

I need to add a privileges to over 3000 users.

I can do an 'alter user USERNAME add privileges (privs)'

But I need to add privileges to DEFAULT_PRIVILEGES.

1> alter user blabla add default_privileges =(trace)

E_US0EF2 line 1, Syntax error on 'default_privileges'. The correct syntax
is:
ALTER USER <user_name>
[ADD|DROP PRIVILEGES ( priv {,priv})]
[WITH
[ PRIVILEGES = (<priv> {,<priv>}) | NOPRIVILEGES]
[, GROUP = <group> | NOGROUP]
[, DEFAULT_PRIVILEGES = (<priv> {,<priv>}) | ALL |
NODEFAULT_PRIVILEGES]
---------------------------------------------------------------------------

Is the a special way to add a priv to DEFAULT_PRIVILEGES ?

If I use 'WITH' it wipes out existing privs..

Thanks

Reply to this Message

Roy Hann - 13 Dec 2007 17:56 GMT

> Hi Guys,
>
[quoted text clipped - 3 lines]
>
> But I need to add privileges to DEFAULT_PRIVILEGES.

Try ALTER DEFAULT PROFILE...

Roy

Reply to this Message

jenser55@googlemail.com - 14 Dec 2007 08:43 GMT

On 13 Dez., 16:50, jense...@googlemail.com 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
[quoted text clipped - 24 lines]
> 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

Reply to this Message