aspose file tools*
The moose likes JDBC and the fly likes oracle-jdbc problem and a dbms question Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "oracle-jdbc problem and a dbms question" Watch "oracle-jdbc problem and a dbms question" New topic
Author

oracle-jdbc problem and a dbms question

bo shen
Greenhorn

Joined: Jul 17, 2002
Posts: 4
Hiya, can anyone recommand a few dbms programs like dbartisan for oracle database? Basically I just want a nice gui that shows me all the tables and store procedures a particule database has. I tried to search the net but not quite sure what to look for. And DBArtisan is too expensive.
On another note I keep getting-"sql.SQLEXCEPTION: Use executeUpdate instead of executeQuery"
The general code is
....
CallableStatement cs = con.prepareCall("{call SOME_FUNCTION(?)}");
cs.setString(1,"USER_ID");
ResultSet rs = cs.executeQuery();
....

When I run the SOME_FUNCTION('USER_ID') in a simple msquery it returns 5 columns with about 100 rows of data. So i dont see why it's not a query. It doesnt store the USER_ID or modify the database in any way. And I dont know how to look at the store procedure codes, hence the reason i am looking for a dbms
Any help will be greatly appreciated, thank you!
Bo
 
jQuery in Action, 2nd edition
 
subject: oracle-jdbc problem and a dbms question