File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Displaying Oracle Data in a JTable Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Head First Android this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Displaying Oracle Data in a JTable" Watch "Displaying Oracle Data in a JTable" New topic

Displaying Oracle Data in a JTable

Michael Hildner
Ranch Hand

Joined: Oct 13, 2000
Posts: 297
I've been struggling for the past three days with this task. It seems like it should be a standard thing to do, but I find examples hard to come by.
I want to display/edit/create information using a JTable where Oracle is the data source. Been trying to use the JDBCAdapter class that ships with Java, but it gives some errors I can't track down when trying to perform the update (I can display the data just fine):
Exception occurred during event dispatching:
at oracle.jdbc.driver.OracleResultSetMetaData.getValidColumnIndex(
at Oracle.jdbc.driver.OracleResultSetMetaData.getColumnType(
at JDBCAdapter.getColumnClass(
Does anyone know of good resources/examples to accomplish this.
Any help is appreciated.
Shekhar Sahay

Joined: Oct 30, 2000
Posts: 2
Hi Michael
Are you trying to edit and insert data from the JTable? I have a working code, but here I just view the data. Let me know if this is what you are looking for and I'll email it to you.
Michael Hildner
Ranch Hand

Joined: Oct 13, 2000
Posts: 297
Dear Shekhar,
I'd really appreciate that. Eventually I'll have to update/insert, but I'll take it one step at a time. Thank you.
My email is
But if anyone knows of some working code that will allow update/insert with JTable and Oracle, I could use it - it's driving me crazy trying to figure it out.
[This message has been edited by Michael Hildner (edited November 07, 2000).]
I agree. Here's the link:
subject: Displaying Oracle Data in a JTable
jQuery in Action, 3rd edition