[#IDEA-17619] Data Source: JDBC operation failed

IDEA: Feedback

Data Source: JDBC operation failed

Created: 03 Apr 08 09:24 Updated: 05 Apr 08 23:01

Component/s:

IDE Configuration

Environment:

Windows

Build:

7,782

Description

« Hide

i get this message if i use
Class: sun.jdbc.odbc.JdbcOdbcDriver
URL: jdbc:odbc:INGRES

Ingres Driver: INTERSOLV Ingres 6.4/04 ODBC Driver

Test Connection is OK, but Refresh Tables throw an exception

JDBC operation failed
java.sql.SQLException: [INTERSOLV][ODBC INGRES driver]The qualifier 'INGRES' was larger than SQL_MAX_QUALIFIER_LEN from SQLGetInfo (0).
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6957)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7114)
at sun.jdbc.odbc.JdbcOdbc.SQLTables(JdbcOdbc.java:5518)
at sun.jdbc.odbc.JdbcOdbcDatabaseMetaData.getTables(JdbcOdbcDatabaseMetaData.java:2395)

All

Comments

Work Log

Change History

Sort Order:

[ Permlink | « Hide ]

Gregory Shrago - 03 Apr 08 16:40

JdbcOdbc bridge itself can be the source of the problem.
It's better to use DBMS-specific JDBC driver.

I need all the DataSource settings and DBMS name to locate the problem.

[ Permlink | « Hide ]

M. Maraun - 03 Apr 08 18:30

No DBMS specific JDBC avaible

ODBC file:
IVING409.DLL version 2.12.0.0 description:INTERSOLV Ingres 6.4/04 ODBC Driver

ODBC Settings:
Database:ingres
Drive: c:\windows\system\IVING409.dll
LogonID: user
ServerName: server04
RepeatedCacheSize: 0
RepeatedSelects: 0
ValueReplacement: 0
YieldProc: 2

[ Permlink | « Hide ]

Gregory Shrago - 04 Apr 08 14:30

These links might be of some help
http://www.ingres.com/downloads/prod-download-drivers.php
http://community.ingres.com/forums/viewtopic.php?p=6901

[ Permlink | « Hide ]

M. Maraun - 05 Apr 08 23:01

Thanks, but no JDBC/DAS are running/avaible