forum.bitel.ru
http://forum.bitel.ru/

Ошибка. Помогите разобраться
http://forum.bitel.ru/viewtopic.php?f=22&t=79		 Страница 1 из 1
Автор:  alt_ctrl_del [ 06 фев 2007, 23:05 ]
Заголовок сообщения:  Ошибка. Помогите разобраться
Сервер запускается нормально без ошибок, но стоит запустить клиента и залогиниться, то появляются ошибки.

server.out
java.sql.SQLException: Value '0000-00-00' can not be represented as java.sql.Timestamp
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
at com.mysql.jdbc.ResultSet.getNativeTimestamp(ResultSet.java:4524)
at com.mysql.jdbc.ResultSet.getTimestampInternal(ResultSet.java:6282)
at com.mysql.jdbc.ResultSet.getTimestamp(ResultSet.java:5898)
at com.mysql.jdbc.ResultSet.getTimestamp(ResultSet.java:5936)
at org.apache.commons.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:229)
at bitel.billing.server.admin.bean.UserManager.loadUserFromRS(UserManager.java:241)
at bitel.billing.server.admin.bean.UserManager.getUserList(UserManager.java:127)
at bitel.billing.server.admin.bgsecure.bean.PermitionChecker.loadUserActions(PermitionChecker.java:93)
at bitel.billing.server.admin.bgsecure.bean.PermitionChecker.reload(PermitionChecker.java:38)
at bitel.billing.server.admin.bgsecure.bean.PermitionChecker.<init>(PermitionChecker.java:28)
at bitel.billing.server.Executer.init(Executer.java:34)
at javax.servlet.GenericServlet.init(GenericServlet.java:168)
at org.mortbay.jetty.servlet.ServletHolder.initServlet(ServletHolder.java:383)
at org.mortbay.jetty.servlet.ServletHolder.getServlet(ServletHolder.java:329)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:405)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:822)
at bitel.billing.server.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:32)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:813)
at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:494)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:569)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1482)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1434)
at org.mortbay.http.HttpServer.service(HttpServer.java:896)
at org.mortbay.http.HttpConnection.service(HttpConnection.java:814)
at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:981)
at org.mortbay.http.HttpConnection.handle(HttpConnection.java:831)
at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244)
at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:366)
at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)
java.sql.SQLException: Value '0000-00-00' can not be represented as java.sql.Timestamp
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
at com.mysql.jdbc.ResultSet.getNativeTimestamp(ResultSet.java:4524)
at com.mysql.jdbc.ResultSet.getTimestampInternal(ResultSet.java:6282)
at com.mysql.jdbc.ResultSet.getTimestamp(ResultSet.java:5898)
at com.mysql.jdbc.ResultSet.getTimestamp(ResultSet.java:5936)
at org.apache.commons.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:229)
at bitel.billing.server.admin.bean.UserManager.loadUserFromRS(UserManager.java:241)
at bitel.billing.server.admin.bean.UserManager.getUserByLogin(UserManager.java:34)
at bitel.billing.server.Executer.checkUser(Executer.java:414)
at bitel.billing.server.Executer.doPost(Executer.java:116)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:615)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:427)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:822)
at bitel.billing.server.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:32)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:813)
at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:494)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:569)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1482)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1434)
at org.mortbay.http.HttpServer.service(HttpServer.java:896)
at org.mortbay.http.HttpConnection.service(HttpConnection.java:814)
at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:981)
at org.mortbay.http.HttpConnection.handle(HttpConnection.java:831)
at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244)
at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:366)
at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)
Автор:  Администратор [ 07 фев 2007, 12:14 ]
Заголовок сообщения: 
Проверьте в data.properties что URL подключения к БД такого вида:
Код:
db.url=jdbc:mysql://127.0.0.1/bgbilling?useUnicode=true&characterEncoding=Cp1251&allowUrlInLocalInfile=true&zeroDateTimeBehavior=convertToNull&jdbcCompliantTruncation=false

Если нет - добавьте параметры в URL.
Автор:  alt_ctrl_del [ 08 фев 2007, 23:07 ]
Заголовок сообщения: 
Спасибо помогло)
Страница 1 из 1 Часовой пояс: UTC + 5 часов [ Летнее время ]
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/