• 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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic