Sure Thomas, will do!
On Nov 7, 5:20 pm, Thomas Mueller <[email protected]>
wrote:
> Hi,
>
> You are using version 1.0.71 (the version is part of the the error
> code which is [*-71]). Could you try with a more recent version of H2?
>
> Regards,
> Thomas
>
> On Wed, Nov 4, 2009 at 6:10 PM, Philipp Kursawe <[email protected]>
> wrote:
>
> > Hello,
>
> > I am running into the the NPE mentioned above:
> > Internal Exception: org.h2.jdbc.JdbcSQLException: Allgemeiner Fehler:
> > java.lang.NullPointerException
> > General error: java.lang.NullPointerException [50000-71]
> > Error Code: 50000
> > Call: SELECT order_no, SHORTFALLS, SHORTFALLS_PERCENT, DONE_PERCENT
> > FROM pbv_order_details WHERE (order_no = ?)
> > bind => [12]
>
> > while the view is defined like this:
> > CREATE VIEW pbv_order_details (order_no, done_percent,
> > shortfalls_percent, shortfalls) AS
> > select
> > o.order_no as order_no,
> > 100 * (select count(*) from pbv_order_items where
> > order_no=o.order_no and state!=1) / count(*) as done_percent,
> > 100 * (select count(*) from pbv_order_items where
> > order_no=o.order_no and state=6) / count(*) as shortfalls_percent,
> > (select count(*) from pbv_order_items where
> > order_no=o.order_no and state=6) as shortfalls
> > from
> > pbv_order_items p, pbv_orders o where p.order_no =
> > o.order_no
> > group by o.order_no
>
> > I wonder why the select can even cause a NPE in the first place?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en
-~----------~----~----~----~------~----~------~--~---
