This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 159219 - java.sql.SQLException: [DataDirect][ODBC SequeLink driver]�HY000��Informix�Found a quote for which there is no matching quote.
Summary: java.sql.SQLException: [DataDirect][ODBC SequeLink driver]�HY000��Informix�Fo...
Status: RESOLVED WORKSFORME
Alias: None
Product: db
Classification: Unclassified
Component: Code (show other bugs)
Version: 6.x
Hardware: All All
: P3 blocker (vote)
Assignee: Jiri Rechtacek
URL: http://statistics.netbeans.org/except...
Keywords:
Depends on:
Blocks:
 
Reported: 2009-02-26 13:56 UTC by cloeffler
Modified: 2010-04-01 13:25 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Exception Reporter: 132529

Attachments
stacktrace (1.40 KB, text/plain)
2009-02-26 13:56 UTC, cloeffler 		Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description cloeffler 2009-02-26 13:56:55 UTC 
Build: NetBeans IDE 6.5 (Build 200811100001)
VM: Java HotSpot(TM) Client VM, 10.0-b23, Java(TM) SE Runtime Environment, 1.6.0_07-b06
OS: Windows XP, 5.1, x86

User Comments:
bartvdc: deleting records

bartvdc: execute query

cloeffler: added a where clause to a SELECT, then sent it

bartvdc: execute sql

GUEST: - Right click a table
- View table data
- Exception occurs, even if data is visible.

bartvdc: execute sql



Stacktrace: 
java.sql.SQLException: [DataDirect][ODBC SequeLink driver]�HY000��Informix�Found a quote for which there is no matching quote.
        at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6957)
        at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7114)
        at sun.jdbc.odbc.JdbcOdbc.SQLForeignKeys(JdbcOdbc.java:3312)
        at sun.jdbc.odbc.JdbcOdbcDatabaseMetaData.getImportedKeys(JdbcOdbcDatabaseMetaData.java:3059)
        at org.netbeans.modules.db.dataview.meta.DBMetaDataFactory.getForeignKeys(DBMetaDataFactory.java:175)
        at org.netbeans.modules.db.dataview.meta.DBMetaDataFactory.checkForeignKeys(DBMetaDataFactory.java:342)
Comment 1 cloeffler 2009-02-26 13:57:00 UTC 
Created attachment 77408 [details]
stacktrace
Comment 2 Jiri Rechtacek 2009-07-01 07:44:16 UTC 
NB6.7 was released already - http://www.netbeans.org/community/releases/67/
Postpone fixing this issue on the next release.
Comment 3 Jiri Rechtacek 2010-04-01 13:25:16 UTC 
A few fixed in this area was made in NB6.9, it should work now.