Ошибка сервлета при детализации

[Phantomas]

Никак понять не могу, из-за чего ошибка сервлета, когда пытаюсь
получить подробную статистику. Хотя все остальное работает нормально.

Выдает стандартную 500 ошибку:
500 Servlet Exception


[show] java.lang.NullPointerException

java.lang.NullPointerException
at _jsp._report__list__jsp._jspService(report.list.jsp:119)
at com.caucho.jsp.JavaPage.service(JavaPage.java:61)
at com.caucho.jsp.Page.pageservice(Page.java:578)
at
com.caucho.server.dispatch.PageFilterChain.doFilter(PageFilterChain.java:
195)
at
com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:
187)
at
com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:
266)
at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:
270)
at com.caucho.server.port.TcpConnection.run(TcpConnection.java:678)
at com.caucho.util.ThreadPool$Item.runTasks(ThreadPool.java:721)
at com.caucho.util.ThreadPool$Item.run(ThreadPool.java:643)
at java.lang.Thread.run(Thread.java:595)

[Phantomas]

Забыл упомянуть: cake 1.0.1

[Anatoly Shipitsin]

2008/9/24 Phantomas <limy...@gmail.com>

Забыл упомянуть: cake 1.0.1

Для начала надо привести лог resin. Все jsp & servlets  сервера выводят ошибки себе в логи.

[Phantomas]

Вот что в логах:
select * from cake.users order by login
select sum(svolume)/(1024^2) as sumv, date_trunc('day',
s_begin) as day, to_char(date_trunc('day', s_begin),
'DD.MM.YYYY') as daystr from cake.session where
date_trunc('day', s_begin)::date >= to_date('01.9.2008',
'DD.MM.YYYY')::date and date_trunc('day', s_begin)::date <=
to_date('25.09.2008', 'DD.MM.YYYY')::date group by day order by day
limit 1000;
select sum(svolume)/(1024^2) as sumv from cake.session
where date_trunc('day', s_begin)::date >= to_date('01.9.2008',
'DD.MM.YYYY')::date
and date_trunc('day', s_begin)::date <= to_date('25.09.2008',
'DD.MM.YYYY')::date
select sum(diff_out)/(1024^2) as ksum, date_trunc('hour', kdatetime)
as kh
from cake.keepalive
where
cake.keepalive.id_session = cake.session.id
and kdatetime >= to_timestamp('25.09.2008 00:00', 'DD.MM.YYYY
HH:MI')::timestamp
and kdatetime <= to_timestamp('25.09.2008 24:00', 'DD.MM.YYYY
HH:MI')::timestamp
group by kh
order by kh
;
org.postgresql.util.PSQLException: ERROR: ??????????? ?????? ?
FROM-????????? ??? ??????? "session"

at
org.postgresql.util.PSQLException.parseServerError(PSQLException.java:
139)
at org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:
152)
at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:100)
at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43)
at
org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:
517)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:
50)
at
org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statement.java:
233)
at
org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statement.java:
221)
at local.datamodule.sql(datamodule.java:186)
at _jsp._report__list__jsp._jspService(_report__list__jsp.java:117)

at com.caucho.jsp.JavaPage.service(JavaPage.java:61)
at com.caucho.jsp.Page.pageservice(Page.java:578)
at
com.caucho.server.dispatch.PageFilterChain.doFilter(PageFilterChain.java:
195)
at
com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:
187)
at
com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:
266)
at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:
270)
at com.caucho.server.port.TcpConnection.run(TcpConnection.java:678)
at com.caucho.util.ThreadPool$Item.runTasks(ThreadPool.java:721)
at com.caucho.util.ThreadPool$Item.run(ThreadPool.java:643)
at java.lang.Thread.run(Thread.java:595)

org.postgresql.util.PSQLException: ERROR: ??????????? ?????? ?
FROM-????????? ??? ??????? "session"

Datamodule init.. [ok!]
[18:51:39.418] {http--8080-8} java.lang.NullPointerException
[18:51:39.418] {http--8080-8} at
_jsp._report__list__jsp._jspService(_report__list__jsp.java:127)
[18:51:39.418] {http--8080-8} at
com.caucho.jsp.JavaPage.service(JavaPage.java:61)
[18:51:39.418] {http--8080-8} at
com.caucho.jsp.Page.pageservice(Page.java:578)
[18:51:39.418] {http--8080-8} at
com.caucho.server.dispatch.PageFilterChain.doFilter(PageFilterChain.java:
195)
[18:51:39.418] {http--8080-8} at
com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:
187)
[18:51:39.418] {http--8080-8} at
com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:
266)
[18:51:39.418] {http--8080-8} at
com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:270)
[18:51:39.418] {http--8080-8} at
com.caucho.server.port.TcpConnection.run(TcpConnection.java:678)
[18:51:39.418] {http--8080-8} at com.caucho.util.ThreadPool
$Item.runTasks(ThreadPool.java:721)
[18:51:39.418] {http--8080-8} at com.caucho.util.ThreadPool
$Item.run(ThreadPool.java:643)
[18:51:39.418] {http--8080-8} at java.lang.Thread.run(Thread.java:
595)

И хрен поймешь, что за вопросами скрыто...

On 24 сент, 21:01, "Anatoly Shipitsin" <norguh...@gmail.com> wrote:
> 2008/9/24 Phantomas <limyev...@gmail.com>

[Anatoly Shipitsin]

И хрен поймешь, что за вопросами скрыто...

Переключите локаль сообщений сервера на английскую или в его логах посмотрите.