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.
Build: NetBeans IDE 6.5 (Build 200811100001) VM: Java HotSpot(TM) Client VM, 1.6.0_02-b06, Java(TM) SE Runtime Environment, 1.6.0_02-b06 OS: Windows XP, 5.1, x86 User Comments: caoticud: Oracle database node -> execute command issuing select command GUEST: input a "." end of table alias name. sql: select u(.)#here#name from user u graeme_m_ross: Trying to autocomplete on a field name in the database caoticud: Oracle database node -> execute command issuing select command Stacktrace: java.lang.AbstractMethodError: oracle.jdbc.driver.OracleDatabaseMetaData.getDatabaseMajorVersion()I at org.netbeans.modules.db.metadata.model.jdbc.oracle.OracleSchema.getRecycleBinTables(OracleSchema.java:105) at org.netbeans.modules.db.metadata.model.jdbc.oracle.OracleSchema.createTables(OracleSchema.java:81) at org.netbeans.modules.db.metadata.model.jdbc.JDBCSchema.initTables(JDBCSchema.java:137) at org.netbeans.modules.db.metadata.model.jdbc.JDBCSchema.getTable(JDBCSchema.java:100) at org.netbeans.modules.db.metadata.model.api.Schema.getTable(Schema.java:112) at org.netbeans.modules.db.sql.editor.completion.SQLCompletionQuery.resolveTable(SQLCompletionQuery.java:421)
Created attachment 74474 [details] stacktrace
Ah, yes, this problem. We encountered this elsewhere in the code but this is new code and we forgot to handle this case here. Do you have a workaround or is completion just not working for you?
This problem occurred when table has an alias and alias is used instead of table name. I have downloaded the latest driver from the Oracle site. This new driver do stop the exception from arising but the auto-completion is not working with the alias name. With proper table name, though functionality works fine. I have to admit the new database functionality in 6.5 is really great, caching the queries are beautiful. Great job.
Reassigned to new owner.
This issue already has 20 duplicates see http://statistics.netbeans.org/exceptions/detail.do?id=95210
It's a known bug in some Oracle JDBC drivers. It has been fixed in newest ones. The workaround for such drivers was applied in core-main/rev/1dda351f757c
Integrated into 'main-golden', will be available in build *200907290201* on http://bits.netbeans.org/dev/nightly/ (upload may still be in progress) Changeset: http://hg.netbeans.org/main-golden/rev/1dda351f757c User: Jiri Rechtacek <jrechtacek@netbeans.org> Log: #154442: workaround AbstractMethodError: oracle.jdbc.driver.OracleDatabaseMetaData.getDatabaseMajorVersion()I