Prev: nmeo.exe
Next: -1555-ORA-01555: snapshot too old: rollback segment number 7 with name "_SYSSMU7$" too small
From: Lionel on 5 Jul 2006 13:11
Hi !!

I found this in the logs of my application server:
org.hibernate.util.JDBCExceptionReporter SQL Warning: 17110, SQLState: null
org.hibernate.util.JDBCExceptionReporter Warning: execution completed with
warning

How can I find the detail of the warnings in oracle ?

I think I found the sql request that raises the warning, but it seems
correct.

thanks.


From: Anthony on 5 Jul 2006 14:27
Can you cut and paste the sql statement and run it directly under
SQL*PLUS and then
post both the query and result?


Lionel wrote:
> Hi !!
>
> I found this in the logs of my application server:
> org.hibernate.util.JDBCExceptionReporter SQL Warning: 17110, SQLState: null
> org.hibernate.util.JDBCExceptionReporter Warning: execution completed with
> warning
>
> How can I find the detail of the warnings in oracle ?
>
> I think I found the sql request that raises the warning, but it seems
> correct.
>
> thanks.

From: Lionel on 6 Jul 2006 06:23
Anthony wrote:
> Can you cut and paste the sql statement and run it directly under
> SQL*PLUS and then
> post both the query and result?

The sql statement looks like this:

select a.column1, count(distinct b.id) as nb_b
from table1 a, table2 b
where a.id = b.a_id (+)

If I remove the outer join or the sum, the warning disapears...
nb_b is sometimes null because of the outer join, but the shouldn't be a
warning for that.


From: DA Morgan on 6 Jul 2006 15:01
Lionel wrote:

> The sql statement looks like this:
>
> select a.column1, count(distinct b.id) as nb_b
> from table1 a, table2 b
> where a.id = b.a_id (+)

Lets see one non-aggregated column
One aggregated column ... COUNT(...)
No GROUP BY clause

I wonder what could be the problem. ;-)
--
Daniel A. Morgan
University of Washington
damorgan(a)x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
From: Anthony on 6 Jul 2006 16:01
Thanks, Daniel. You are ahead of me. Please add a group by.

DA Morgan wrote:
> Lionel wrote:
>
> > The sql statement looks like this:
> >
> > select a.column1, count(distinct b.id) as nb_b
> > from table1 a, table2 b
> > where a.id = b.a_id (+)
>
> Lets see one non-aggregated column
> One aggregated column ... COUNT(...)
> No GROUP BY clause
>
> I wonder what could be the problem. ;-)
> --
> Daniel A. Morgan
> University of Washington
> damorgan(a)x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Group
> www.psoug.org

 |  Next  |  Last
Pages: 1 2
Prev: nmeo.exe
Next: -1555-ORA-01555: snapshot too old: rollback segment number 7 with name "_SYSSMU7$" too small