Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

wether JDBC supports UNION Queries

 
Sunil Mamindla
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hai !

How will we find wether JDBC supports UNION Queries

Thank's in advance
 
shailesh sonavadekar
Ranch Hand
Posts: 1874
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
please go to java.sun.com & there are various types of jdbc drivers . You will get all the information about them on that site & bprobably in those documents only you will get the answer for union querries suppported by jdbc.
i hope this is useful.
 
MSD
Greenhorn
Posts: 20
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Sunil,
UNION queries are defined as standard SQL syntax and are hence defined by all ASNI SQL compliant databases. So u shouldn' thave a problem with UNION.
If however u do want to check, i would suggest firing a UNIONquery and checking for an SQLException. It's not very clean, but i guess JDBC drivers do not allow u to access their properties.
Hope it helps,
-Mohammed
 
Matt Midcap
Sheriff
Posts: 440
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm moving this to the "JDBC" forum.
 
Frank Carver
Sheriff
Posts: 6920
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I think there may be some confusion here. Most JDBC drivers simply pass the SQL to the appropriate database, and whether any particular SQL features are supported depends entirely on the database. I have happily used UNION in queries to Oracle 7 through the Oracle 7 thin driver.
What database are you using?
 
Sandeep Jain
Ranch Hand
Posts: 124
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi
You can make use of the of the builtin fuction called supportsUnion() which returns a boolean value . This method is available in DatabaseMetaData interface.

------------------
Sandeep Jain
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic