« Return to Thread: Problem in Sonar 1.11

Re: Problem in Sonar 1.11

by Freddy Mallet :: Rate this Message:

Hi Rogerio,

Could you launch a new analysis with the option "-e" to get a full stack trace ?

Thanks for your help
Freddy

On Fri, Oct 9, 2009 at 7:20 PM, Rogerio Baldini das Neves <rogerio.baldini@...> wrote:

Ok Jim, I understand the problem.

But I was working fine in version 1.10.1, using some project and same oracle…

So, it’s a new bug in Sonar, even with this bug in Hibernate+Oracle.

Thanks,

Rogerio.

De: Jim Sellers [mailto:jim.sellers@...]
Enviada em: sexta-feira, 9 de outubro de 2009 12:21
Para: user@...
Assunto: Re: [sonar-user] Problem in Sonar 1.11

Looks like you're running into the issue when there are more than 1000 items in an IN sql statement. eg. select * from table_name where blah IN('thing1', 'thing2')

This is a very old hibernate bug. When ever I'd seen stuff about this, the hibernate guys usually say something along the lines of "we're not changing hibernate because oracle is stupid. Don't use oracle".
http://opensource.atlassian.com/projects/hibernate/browse/HHH-1123

Best of luck.
Jim

On Fri, Oct 9, 2009 at 10:36 AM, Rogerio Baldini das Neves <rogerio.baldini@...> wrote:

Hi Guys

I’ve updated to Sonar 1.11 and I am getting this error when trying to run sonar goal:

[INFO] Execute decorators...

[INFO] ANALYSIS SUCCESSFUL, you can browse http://192.168.1.32:9000

[INFO] Purging database...

[WARN] SQL Error: 1795, SQLState: 42000

[ERROR] ORA-01795: maximum number of expressions in a list is 1000

[INFO] ------------------------------------------------------------------------

[ERROR] BUILD ERROR

[INFO] ------------------------------------------------------------------------

[INFO] Can not execute Sonar

Embedded error: org.hibernate.exception.SQLGrammarException: could not execute query

ORA-01795: maximum number of expressions in a list is 1000

[INFO] ------------------------------------------------------------------------

[INFO] For more information, run Maven with the -e switch

[INFO] ------------------------------------------------------------------------

Thanks,

Rogerio.

No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.5.421 / Virus Database: 270.14.8/2425 - Release Date: 10/09/09 08:10:00

« Return to Thread: Problem in Sonar 1.11