Hi Venkat, Nice catch, that code is quite wrong. Not only does it make a wrong assumption on the int -> boolean conversion, it will also throw an exception for SQL Server 2008, which doesn't have the INFORMATION_SCHEMA.SEQUENCES table. While the exception is caught later on, leading to the correct behaviour for SQL Server 2008, for SQL Server 2012, jOOQ sequences support is not really functional.
I have registered #2624 for this: https://github.com/jOOQ/jOOQ/issues/2624 This issue is fixed for 3.2.0 and contained in the latest 3.2.0-SNAPSHOT version. It will be merged to 3.1.1 Cheers Lukas 2013/7/9 Venkat Sadasivam <[email protected]> > The below code in SQLServerDatabase.java seems to be incorrect. If I have > more than one sequence then it fails. > > > private boolean is2012() { > if (is2012 == null) { > is2012 = create().selectCount() > .from(SEQUENCES) > *.fetchOne(0, boolean.class);* > } > return is2012; > } > > -- > You received this message because you are subscribed to the Google Groups > "jOOQ User Group" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
