Hi Rakesh, With version 1.6.2, I can reproduce compilation errors in these artefacts:
- RewardsReport (stored procedure, 3 error lines) - CustomerList (table, 1 error line) - StaffList (table, 1 error line) - CustomerListRecord (table record, 2 error lines) - StaffListRecord (table record, 2 error lines) Can you confirm, this is what you have experienced? I usually consider compilation errors in generated source code as major bugs, which will be fixed with high priority. Thanks for reporting this. In the mean time, you can fix these errors manually for your testing purposes. Compilation errors in generated source code if table fields contain spaces https://sourceforge.net/apps/trac/jooq/ticket/737 Compilation errors in generated source code if procedure parameter type contains two arguments (like DECIMAL(10,2)) https://sourceforge.net/apps/trac/jooq/ticket/738 Cheers Lukas 2011/7/15 Lukas Eder <[email protected]>: > Hello, > > Thank you for providing me with these test cases. I will run code > generation against that schema and tell you ASAP. Did you use the > latest version of jOOQ (1.6.2) ? > > Cheers > Lukas > > 2011/7/15 Rakesh Waghela <[email protected]>: >> MySQL has a reference DB Script testing all the features of MySQL. >> http://dev.mysql.com/doc/sakila/en/sakila.html >> >> Available for download here, >> http://dev.mysql.com/doc/index-other.html Sakila database (requires MySQL >> 5.0 or later) [ TGZ | Zip ] >> When I installed MySQL with above SQL Model and tried to generate code form >> JOOQ Command line tool, It gave syntactic error at several >> artifacts including one of the generated procedure. >> Please use Sakila SQL with MySQL to recreate the problem.. >> And see if it has anything to do with potential bug in code generator of >> JOOQ. >
