• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Generate JTable from a SQL Query containing UNION clause

 
Vaibhav Pingle
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello Friends...

Following is the code that i write to convert the Data returned from the ResultSet of an SQL query, to be filled into a JTable.

This code works fine for the normal query....but in the case of a SQL query containing a UNION clause For eg. :

SELECT * FROM Table_1
UNION
SELECT * FROM Table_2


it only returns the results of the first part of the above query..i.e. for

SELECT * FROM Table_1




Please tell me if there are any changes required in this above code OR if there is any SQL driver problem...If its a driver problem, then please tell me what i am suppose to do (I am using MS Access as my database)

Also i wanted to know, how to detect what type of data each column of the ResultSet is returning, and thus display type-specific data in the JTable, especially the Date.
The above code by default displays the date in 2006-11-28 hr:min:sec format, but i want it as dd/MM/yyyy
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic