Generate JTable from a SQL Query containing UNION clause
Joined: Nov 23, 2006
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