This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes Processing None-SQL query via JDBC Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Processing None-SQL query via JDBC" Watch "Processing None-SQL query via JDBC" New topic

Processing None-SQL query via JDBC

Amit Kumar Das

Joined: Feb 26, 2011
Posts: 2

I was just building my own query processor. I found a problem in dealing with vendor-specific commands.
for Ex: if i want to run "DESC <Table Name>", It result in an Exception, which is quite obvious as it is not an SQL command.
Now if I want to access Table Metadata, I need to develop my own method.
What could be the possible ways for doing that??

Amit Kumar Das, ASE @ TCS Kolkata, India
Jan Cumps

Joined: Dec 20, 2006
Posts: 2491

desc <tablename> is not a database command. It is an sql*plus command. The database does not understand it (as you have noticed by the exceprion).
java.sql.ResultSet.getMetaData() can help you.

OCUP UML fundamental and ITIL foundation
youtube channel
I agree. Here's the link:
subject: Processing None-SQL query via JDBC
Similar Threads
from two columns get one based on the value of another column passed in hibernate
How to use Bind Variable with FROM and UPDATE clauses in PreparedStatement???
export query from table column to text file
Seeking help on a complex SQL I reckon, wish get a simple one from answer