I have a stored procedure in MySQL version 5.1.65 running on Mac Os X, 
which is declared like so:

CREATE DEFINER=`root`@`localhost` PROCEDURE 
`sendregning`.`balance_per_claim_type`(in p_originator_id integer, 
p_recipient_id integer,
    out p_bal decimal(12,2), out p_pos decimal(12,2), out p_neg 
decimal(12,2), out p_uid decimal(12,2) )
    READS SQL DATA

As you can see, I have 4 variables declared with "out".

The generated Java code from jOOQ version 3.0.0-RC3 looks like this:

public static void balancePerClaimType(org.jooq.Configuration 
configuration, java.lang.Object in, java.lang.Integer pRecipientId, 
java.lang.Object *out*, java.lang.Object *out*, java.lang.Object *out*, 
java.lang.Object *out*) {

As you can see, this will not compile the generated code should produce 
unique identifiers, that is; either each output object should be named 
according to the SQL declaration (p_bal, p_pos etc.) or each parameter 
should have been named out1, out2 ... out*n.*
*
*
Seems like a possible bug in the code generator to me.

-- 
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.


Reply via email to