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 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark ""show parameter fixed_date"  in JDBC " Watch ""show parameter fixed_date"  in JDBC " New topic

"show parameter fixed_date" in JDBC

Steve Jiang
Ranch Hand

Joined: May 17, 2004
Posts: 124
I need to get the paramter of FIXED_DATE for Database, and I tried to use Statement or PRepareStatment, but both get the error message,"java.sql.SQLException: ORA-00900: invalid SQL statement " or " java.sql.SQLException: SQL string is not Query"

What JDBC function should we use to check the statement "show parameter " ?


Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 32818

As 'show parameter" is not SQL, you aren't going to be able to run it through JDBC. The only thing I can think of is to run it through a command line via Runtime.exec.

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
I agree. Here's the link:
subject: "show parameter fixed_date" in JDBC
jQuery in Action, 3rd edition