2014-01-29 Sha <[email protected]> > Hi Lukas, > Does JOOQ code generator not have capability to convert temporary tables > like normal tables ? > > As show in the attached file. > I have create a temporary table in SQLServer DB. > After i generate the files using code generator , I dont find the files > related to Temporary tables. > > 1) Does the JOOQ has capability to handle temporary table as it has with > normal tables? >
No. Again, because T-SQL temporary tables have no meaning outside of a T-SQL context. You can keep trying this as many times as you want, but I've been trying to tell you that you cannot use a T-SQL temporary table outside of the very connection / session that has created it. This means that they're not available to JDBC nor to jOOQ, specifically not to the code generator. This is not a jOOQ problem, but a T-SQL limitation. T-SQL temporary tables aren't as powerful as Oracle's. You'll find plenty of resources on the web, e.g. http://stackoverflow.com/q/12595709/521799 -- 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.
