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 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 and Relational Databases
Bookmark "oracle-jdbc problem and a dbms question" Watch "oracle-jdbc problem and a dbms question" New topic

oracle-jdbc problem and a dbms question

bo shen

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(?)}");
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!
I agree. Here's the link:
subject: oracle-jdbc problem and a dbms question
It's not a secret anymore!