Note, I can reproduce this issue when using DSL.using(getConnection(), new Settings().withRenderSchema(false)) .select(Routines.fNumber(3333)) .fetchAny();
It seems that the schema name ([dbo] in my case) is relevant when rendering stored procedures and functions Cheers Lukas 2013/6/29 Lukas Eder <[email protected]> > What SQL Server version is this? > Can you post the T-SQL function signature of [f_FolderName]? > How did you create the DSLContext (e.g. any particular Settings)? > > > 2013/6/28 Venkat Sadasivam <[email protected]> > >> The below code gives error. >> Record record = >> transaction.getContext().select(Routines.fFoldername(3333)).fetchAny(); >> >> org.jooq.exception.DataAccessException: SQL [select [f_FolderName](?)]; >> Incorrect syntax near '@P0'. >> at org.jooq.impl.Utils.translate(Utils.java:1021) >> at >> org.jooq.impl.DefaultExecuteContext.sqlException(DefaultExecuteContext.java:462) >> at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:287) >> at >> org.jooq.impl.AbstractResultQuery.fetchLazy(AbstractResultQuery.java:329) >> at >> org.jooq.impl.AbstractResultQuery.fetchLazy(AbstractResultQuery.java:320) >> at >> org.jooq.impl.AbstractResultQuery.fetchAny(AbstractResultQuery.java:453) >> at org.jooq.impl.SelectImpl.fetchAny(SelectImpl.java:1073) >> >> Any help? >> >> -- >> 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.
