[Dbedit-users] DBEdit and Oracle light connect problem

[Wissiak H. C. <Har...@au...>]

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />I've tried to use DBEdit on Oracle Light (Oracle light 40 ODBC driver)
using sun's JDBC ODBC Bridge 
with a 'Column not found' error. As a result no tables are displayed. 
I can use Instant SQL to execute SQL statements however.
 
Is there any plan to fix this or is there a work-around?
 
Thx,
Harry
 
 
Got following errors in the log after connect:
 
 Unable to retrieve schemas:
----------------------------------
dbedit.core.DataException: Column not found
at dbedit.internal.core.JdbcManager.getCatalogs(JdbcManager.java:694)
at dbedit.internal.core.Dataspace.getCatalogs(Dataspace.java:109)
at dbedit.internal.core.Database.getCatalogs(Database.java:93)
at dbedit.ui.editor.sql.SQLCompletionProcessor.getSchemas(SQLCompletionProcessor.java:1031)
at dbedit.ui.editor.sql.SQLCompletionProcessor.doGetAllProposals(SQLCompletionProcessor.java:324)
at dbedit.ui.editor.sql.SQLCompletionProcessor.access$0(SQLCompletionProcessor.java:250)
at dbedit.ui.editor.sql.SQLCompletionProcessor$1.run(SQLCompletionProcessor.java:233)
at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:101)
Reason:
java.sql.SQLException: Column not found
at sun.jdbc.odbc.JdbcOdbcResultSet.findColumn(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcResultSet.getString(Unknown Source)
at dbedit.internal.core.JdbcManager.getCatalogs(JdbcManager.java:688)
at dbedit.internal.core.Dataspace.getCatalogs(Dataspace.java:109)
at dbedit.internal.core.Database.getCatalogs(Database.java:93)
at dbedit.ui.editor.sql.SQLCompletionProcessor.getSchemas(SQLCompletionProcessor.java:1031)
at dbedit.ui.editor.sql.SQLCompletionProcessor.doGetAllProposals(SQLCompletionProcessor.java:324)
at dbedit.ui.editor.sql.SQLCompletionProcessor.access$0(SQLCompletionProcessor.java:250)
at dbedit.ui.editor.sql.SQLCompletionProcessor$1.run(SQLCompletionProcessor.java:233)
at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:101)

Column not found:
----------------------
dbedit.core.DataException: Column not found
at dbedit.internal.core.JdbcManager.getSchemas(JdbcManager.java:672)
at dbedit.internal.core.Dataspace.getSchemas(Dataspace.java:122)
at dbedit.internal.core.Database.getSchemas(Database.java:136)
at dbedit.ui.editor.sql.SQLCompletionProcessor.getTables(SQLCompletionProcessor.java:1056)
at dbedit.ui.editor.sql.SQLCompletionProcessor.getElements(SQLCompletionProcessor.java:1012)
at dbedit.ui.editor.sql.SQLCompletionProcessor.doGetAllProposals(SQLCompletionProcessor.java:331)
at dbedit.ui.editor.sql.SQLCompletionProcessor.access$0(SQLCompletionProcessor.java:250)
at dbedit.ui.editor.sql.SQLCompletionProcessor$1.run(SQLCompletionProcessor.java:233)
at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:101)
Reason:
java.sql.SQLException: Column not found
at sun.jdbc.odbc.JdbcOdbcResultSet.findColumn(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcResultSet.getString(Unknown Source)
at dbedit.internal.core.JdbcManager.getSchemas(JdbcManager.java:668)
at dbedit.internal.core.Dataspace.getSchemas(Dataspace.java:122)
at dbedit.internal.core.Database.getSchemas(Database.java:136)
at dbedit.ui.editor.sql.SQLCompletionProcessor.getTables(SQLCompletionProcessor.java:1056)
at dbedit.ui.editor.sql.SQLCompletionProcessor.getElements(SQLCompletionProcessor.java:1012)
at dbedit.ui.editor.sql.SQLCompletionProcessor.doGetAllProposals(SQLCompletionProcessor.java:331)
at dbedit.ui.editor.sql.SQLCompletionProcessor.access$0(SQLCompletionProcessor.java:250)
at dbedit.ui.editor.sql.SQLCompletionProcessor$1.run(SQLCompletionProcessor.java:233)
at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:101)

 
This message and any attachments are intended only for the use of the addressee and may contain information that is privileged and confidential. If
the reader of the message is not the intended recipient or an authorized representative of the intended recipient, you are hereby notified that any
dissemination of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail
and delete the message and any attachments from your system.