Hi Shyam, I still don't understand the purpose of your POC to 100%. As I've mentioned on another thread, SQL Server local temporary tables (and scala variables) are very useful in a pure T-SQL context. I don't see how they could be that useful in a JDBC context, and as I've mentioned before, I don't even think it is possible to keep T-SQL temporary tables alive between subsequent JDBC calls...
jOOQ supports all plain SQL (but not typesafe) DDL statements that are supported by the underlying JDBC driver. Ask yourself: How would you resolve this with JDBC? Cheers Lukas 2014-01-27 Sha <[email protected]> > Hi Lukas, > As part of my POC . For some of my stored procedures , I need to create > and store some valid rows in temporary tables to fasten the execution. > > So me trying to do a sample of create a temporary table using JOOQ. > > But unfortunately it does not create a temp table. > > Below is the what I have done. > > DSLContext ctx = DSL.using(connection, SQLDialect.SQLSERVER2008); > // Use your favourite tool to construct SQL strings: > String sql = "CREATE TABLE #LocalTempTable( " + > " UserID int, " + > " UserName varchar(50), " + > " UserAddress varchar(150)) "; > int status = ctx.execute(sql); > System.out.println(" status : " + status); > > But unfortunately it does not work. > I read one of your previous replies in this group , stating that DDL > statement support is not there in JOOQ. > > Do we have any alternative approaches you think of handling these > scenarios? if so can you specify some. > > whole ideas is to make my stored procedure unit testable as part of my > java code. > Any suggestions and recommendations please. > > Thank you. > ~Shyam > > -- > 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.
