File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

"show parameter fixed_date" in JDBC

 
Steve Jiang
Ranch Hand
Posts: 124
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 " ?

Thanks,





 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 33696
316
Eclipse IDE Java VI Editor
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Steve,
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.
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic