The moose likes Servlets and the fly likes wether JDBC supports UNION Queries Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Java » Servlets
Bookmark "wether JDBC supports UNION Queries" Watch "wether JDBC supports UNION Queries" New topic

wether JDBC supports UNION Queries

Sunil Mamindla

Joined: Oct 19, 2000
Posts: 8
Hai !

How will we find wether JDBC supports UNION Queries

Thank's in advance

shailesh sonavadekar
Ranch Hand

Joined: Oct 12, 2000
Posts: 1874
please go to & 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.

Joined: Jan 22, 2000
Posts: 20
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,
Matt Midcap

Joined: Jan 07, 1999
Posts: 440
I'm moving this to the "JDBC" forum.

Best Regards,<br />Matt Midcap
I agree. Here's the link:
subject: wether JDBC supports UNION Queries
It's not a secret anymore!