I fixed it in Branch_3_2. Now the row-locking-template is used instead of hardcoded FOR UPDATE OF.
Please, help me test it, so that you won't be disappointed with the next release.
Thanks.


Rafal Kedziorski wrote:

hi,

At 14:49 12.12.2003, you wrote:

Sorry, this is my fault. row-locking = "true" and on-find will now spit out SQL that is SELECT


no problem.

...blah.... FOR UPDATE. If the platform doesn't support FOR UPDATE then you are screwed. I'll be fixing this for 3.2.4.

I'm guessing you're working with a DB other than Oracle, PostgreSQL, MySQL. Probably MS SQLServer?


No, woth MySQL with InnoDB-Tables. We habe the problem, that the generated Queries has wrong syntax. This is the SELECT statement for MySQL:

SELECT [STRAIGHT_JOIN]
       [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT]
       [SQL_CACHE | SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS] [HIGH_PRIORITY]
       [DISTINCT | DISTINCTROW | ALL]
    select_expression,...
    [INTO {OUTFILE | DUMPFILE} 'file_name' export_options]
    [FROM table_references
      [WHERE where_definition]
      [GROUP BY {unsigned_integer | col_name | formula} [ASC | DESC], ...
        [WITH ROLLUP]]
      [HAVING where_definition]
      [ORDER BY {unsigned_integer | col_name | formula} [ASC | DESC] ,...]
      [LIMIT [offset,] row_count | row_count OFFSET offset]
      [PROCEDURE procedure_name(argument_list)]
      [FOR UPDATE | LOCK IN SHARE MODE]]

And the generated query has listed columns after FOR UPDATE ... . I get today with the actual sources from CVS (last update yesterday). This I posted today:

http://sourceforge.net/tracker/index.php?func=detail&aid=858828&group_id=22866&atid=376685



Regards,
Rafal


Bill

Rafal Kedziorski wrote:

At 12:08 12.12.2003, [EMAIL PROTECTED] wrote:

What is buggy about 3.2.3?


we have a problem with on-find strategy and row-locking = "true". with on-load it's working without any problem.

Rafal

Regards,

Harm de Laat
Informatiefabriek
The Netherlands




Rafal Kedziorski <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 12/12/2003 11:53 AM Please respond to [EMAIL PROTECTED]


To [EMAIL PROTECTED] cc

Subject
Re: [JBoss-user] JBoss 3.2.4 ...






At 11:31 12.12.2003, Thomas Hentschel Lund wrote:


>hehe
>
>3.2.3 was just released 1-2 days ago. Talk about being impatient ;-)

no, but I will not work with buggy JBoss 3.2.3.

:) JBoss 3.2.2 was released on 1st december (I'm looking on ftp for
download), but I found some bugs, which is impossible for me to switch to
this version.



/rk


>/Thomas
>
>fre, 2003-12-12 kl. 11:18 skrev Rafal Kedziorski:
> > Hi,
> >
> > when will be JBoss 3.2.4 released?
> >
> >
> > Regards,
> > Rafal
> >
> >
> >
> > -------------------------------------------------------
> > This SF.net email is sponsored by: IBM Linux Tutorials.
> > Become an expert in LINUX or just sharpen your skills. Sign up for
IBM's
> > Free Linux Tutorials. Learn everything from the bash shell to sys
admin.
> > Click now! http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click
> > _______________________________________________
> > JBoss-user mailing list
> > [EMAIL PROTECTED]
> > https://lists.sourceforge.net/lists/listinfo/jboss-user
>
>
>
>-------------------------------------------------------
>This SF.net email is sponsored by: IBM Linux Tutorials.
>Become an expert in LINUX or just sharpen your skills. Sign up for IBM's
>Free Linux Tutorials. Learn everything from the bash shell to sys admin.
>Click now! http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click
>_______________________________________________
>JBoss-user mailing list
>[EMAIL PROTECTED]
>https://lists.sourceforge.net/lists/listinfo/jboss-user




-------------------------------------------------------
This SF.net email is sponsored by: IBM Linux Tutorials.
Become an expert in LINUX or just sharpen your skills. Sign up for IBM's
Free Linux Tutorials. Learn everything from the bash shell to sys admin.
Click now! http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user





-------------------------------------------------------
This SF.net email is sponsored by: IBM Linux Tutorials.
Become an expert in LINUX or just sharpen your skills. Sign up for IBM's
Free Linux Tutorials. Learn everything from the bash shell to sys admin.
Click now! http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user



-------------------------------------------------------
This SF.net email is sponsored by: IBM Linux Tutorials.
Become an expert in LINUX or just sharpen your skills. Sign up for IBM's
Free Linux Tutorials. Learn everything from the bash shell to sys admin.
Click now! http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


--
================
Bill Burke
Chief Architect
JBoss Group LLC.
================



-------------------------------------------------------
This SF.net email is sponsored by: IBM Linux Tutorials.
Become an expert in LINUX or just sharpen your skills.  Sign up for IBM's
Free Linux Tutorials.  Learn everything from the bash shell to sys admin.
Click now! http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user




-------------------------------------------------------
This SF.net email is sponsored by: IBM Linux Tutorials.
Become an expert in LINUX or just sharpen your skills.  Sign up for IBM's
Free Linux Tutorials.  Learn everything from the bash shell to sys admin.
Click now! http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user





------------------------------------------------------- This SF.net email is sponsored by: IBM Linux Tutorials. Become an expert in LINUX or just sharpen your skills. Sign up for IBM's Free Linux Tutorials. Learn everything from the bash shell to sys admin. Click now! http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to