aspose file tools*
The moose likes JDBC and the fly likes Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
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: 106
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
internet detective

Joined: May 26, 2003
Posts: 29219

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.

[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
I agree. Here's the link:
subject: "show parameter fixed_date" in JDBC
Similar Threads
Making Connection with database
DataSource invalid
can any one help me how to solve th problem with jdbc driver for DB2
how to use Scrollable ResultSet on WebSphere 4.0
DataSource invalid: "java.sql.SQLException: No suitable driver"