Hi, Please go through the following test case :
*drop table if exists testcase;* * * *create table testcase (id int, name varchar(255),dob date);* * * *insert into testcase values * * (1, 'ABC','2001-01-01'),* * (2, 'XYZ','1998-10-15'); * * * * * *select * from (* * select * from testcase where name in (* * select name from testcase where dob in (* * select dob from testcase where dob<?* * )* * )* * );* * * I am getting Sql Type:12 (using: PreparedStatement.getParameterMetaData().getParameterType(index)) for the DOB Parameter, when I execute the above Select Statement. However When I execute the following query I get Sql Type:91 : * select * from testcase where name in (* * select name from testcase where dob in (* * select dob from testcase where dob<?* * )* * );* * * any ideas? regards Akshay -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
