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.
