File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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
JavaRanch » Java Forums » Java » Servlets
Bookmark "wether JDBC supports UNION Queries" Watch "wether JDBC supports UNION Queries" New topic
Author

wether JDBC supports UNION Queries

Sunil Mamindla
Greenhorn

Joined: Oct 19, 2000
Posts: 8
Hai !

How will we find wether JDBC supports UNION Queries

Thank's in advance


Sunil
shailesh sonavadekar
Ranch Hand

Joined: Oct 12, 2000
Posts: 1874
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

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,
-Mohammed
Matt Midcap
Sheriff

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: http://aspose.com/file-tools
 
subject: wether JDBC supports UNION Queries