Hi Koen, Thank you very much for reporting this issue. There have been various fixes for the jOOQ AQ integration as of https://github.com/jOOQ/jOOQ/issues/4782
A fix for this issue is committed for jOOQ 3.8 and will be backported to 3.7, 3.6, and 3.5 in the next weeks. If you're interested, I can send you a fixed version of the OracleDSL class via private message... Best Regards, Lukas 2016-02-11 14:39 GMT+01:00 Koen Roevens <[email protected]>: > Hi, > > When I do : > > OracleDSL.DBMS_AQ.ENQUEUE_OPTIONS_T options = new > OracleDSL.DBMS_AQ.ENQUEUE_OPTIONS_T(); > OracleDSL.DBMS_AQ.MESSAGE_PROPERTIES_T properties = new > OracleDSL.DBMS_AQ.MESSAGE_PROPERTIES_T(); > properties.attempts(2); > OracleDSL.DBMS_AQ.enqueue(context.configuration(), Queues.AQ$TASKS, new > Tp$queueTasksRecord(taskId, "ARES"), options, properties); > > > , I do get the following exception: > ... > [main] DEBUG org.jooq.tools.LoggerListener - -> with bind values : > DECLARE > v_msgid RAW(16); > v_enqueue_options DBMS_AQ.enqueue_options_t; > v_message_properties DBMS_AQ.message_properties_t; > BEGIN > v_message_properties.attempts := 2 > DBMS_AQ.ENQUEUE( > queue_name => 'AQ$TASKS', > enqueue_options => v_enqueue_options, > message_properties => v_message_properties, > payload => [UDT], > msgid => v_msgid > ); > END; > [main] DEBUG org.jooq.tools.StopWatch - Exception : Total: > 84.191ms > ... > org.jooq.exception.DataAccessException: SQL [DECLARE > v_msgid RAW(16); > v_enqueue_options DBMS_AQ.enqueue_options_t; > v_message_properties DBMS_AQ.message_properties_t; > BEGIN > v_message_properties.attempts := ? > DBMS_AQ.ENQUEUE( > queue_name => ?, > enqueue_options => v_enqueue_options, > message_properties => v_message_properties, > payload => ?, > msgid => v_msgid > ); > END;]; ORA-06550: line 7, column 3: > PLS-00103: Encountered the symbol "DBMS_AQ" when expecting one of the > following: > > . ( * @ % & = - + ; > ... > > > > It seems to me there is a missing semicolon in the generated SQL statement. > Am I doing something wrong or is it a bug? > > I' m using JOOQ Pro 3.5.3. > > p.s: > Please take notice, I can run > OracleDSL.DBMS_AQ.enqueue(context.configuration(), > Queues.AQ$TASKS, new Tp$queueTasksRecord(taskId, "ARES"); without any > problem. > > -- > 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/d/optout. > -- 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/d/optout.
