This should be easy to fix in jOOQ. jOOQ should allow settings where schema names are omitted through renderSchema or renderMapping. These settings should work for tables and views, but be ignored for procedures and functions in SQL Server.
I have registered #2569 for this: https://github.com/jOOQ/jOOQ/issues/2569 2013/6/29 Lukas Eder <[email protected]> > Some background info: > http://stackoverflow.com/q/6303484/521799 > > > 2013/6/29 Lukas Eder <[email protected]> > >> 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.
