DLOG4J 新增重要特性
2004年11月28日(Sunday) 15点00分
作者: 本站原创 天气:
心情: 一般
DLOG4J新增一项重要的功能——数据迁移。 利用数据迁移功能可以方便的在不同数据库之间迁移日记数据，迁移的数据包括注册用户、日记分类、日记、评论信息、站内消息、网站链接、参数、访问记录等。 下面是数据迁移的界面：
目前该功能在我机器上测试了从SQL SERVER导出数据到Access，大约有五百多注册用户、五百多篇日记以及一千多篇评论。最新的代码已经更新到SourceForge的CVS服务器上，可从上面获取最新的代码，涉及到的更改内容请见 {dlog4j}/doc/changelog.txt 文件。各位在使用中如发现任何问题或者一些建议请不吝赐教。 关于CVS的配置请参见 http://dlog4j.sourceforge.net/cvs.htm [Edit on 2004-12-08 11:26:24 By ld] [Edit on 2005-01-02 10:58:50 By ld]
关于DLOG4J数据库的说明： DLOG4J默认使用的是HSQLDB，这是一个嵌入式的数据库引擎，如果你不想使用HSQLDB的话，请将web.xml中关于HSQLEngine小服务程序的配置注释以关闭该引擎。如下 <!--
与此同时，日记编辑器在何义 的努力下已经可以上传其他非图片和动画（在编辑器中显示为文件名的链接）。目前这两个功能都已上传到CVS上，涉及的要修改的文件请见项目中的 doc/changelog.txt 文件.
DLOG4J现在可以使用ANT进行编译了：） Thatway的杰作
目前还没测试过MySQL5，不过只要驱动OK，其他肯定没问题的。另外1.4版本的发行包中，mysql的脚本有些问题，修正的脚本请在下面地址中找，或者可以到CVS上下载最新1.5版本的源码，其中会包含更正过的脚本 http://www.javayou.com/search.do?query=mysql&cat_id=-2&x=26&y=7
求助！我从CVS上面下载了最新的代码，但现在出现如下问题：
1。在HSQLB下，管理中没有数据迁移，而是参数管理。
2。使用MySQL时，按以前的评论把所有设置都做好，test.jsp测试通过，但是出现如下问题： Tomcat出错信息如下： 警告: SQL Error: 0, SQLState: S1009 2004-12-30 9:16:51 net.sf.hibernate.util.JDBCExceptionReporter logExceptions 严重: Cannot convert value '0000-00-00 00:00:00' from column 12 to TIMESTAMP. 2004-12-30 9:16:51 net.sf.hibernate.util.JDBCExceptionReporter logExceptions 警告: SQL Error: 0, SQLState: S1009 2004-12-30 9:16:51 net.sf.hibernate.util.JDBCExceptionReporter logExceptions 严重: Cannot convert value '0000-00-00 00:00:00' from column 12 to TIMESTAMP. 2004-12-30 9:16:51 net.sf.hibernate.JDBCException 严重: SQLException occurred java.sql.SQLException: Cannot convert value '0000-00-00 00:00:00' from column 12 to TIMESTAMP. at com.mysql.jdbc.ResultSet.getTimestampFromString(ResultSet.java:6362) at com.mysql.jdbc.ResultSet.getTimestampInternal(ResultSet.java:6387) at com.mysql.jdbc.ResultSet.getTimestamp(ResultSet.java:2263) at com.mysql.jdbc.ResultSet.getTimestamp(ResultSet.java:2295) at org.apache.commons.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:229) at net.sf.hibernate.type.TimestampType.get(TimestampType.java:24) at net.sf.hibernate.type.NullableType.nullSafeGet(NullableType.java:62) at net.sf.hibernate.type.NullableType.nullSafeGet(NullableType.java:53) at net.sf.hibernate.type.AbstractType.hydrate(AbstractType.java:66) at net.sf.hibernate.loader.Loader.hydrate(Loader.java:686) at net.sf.hibernate.loader.Loader.loadFromResultSet(Loader.java:627) at net.sf.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:586) at net.sf.hibernate.loader.Loader.getRow(Loader.java:501) at net.sf.hibernate.loader.Loader.getRowFromResultSet(Loader.java:213) at net.sf.hibernate.loader.Loader.doQuery(Loader.java:281) at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:133) at net.sf.hibernate.loader.Loader.doList(Loader.java:1033) at net.sf.hibernate.loader.Loader.list(Loader.java:1024) at net.sf.hibernate.loader.CriteriaLoader.list(CriteriaLoader.java:118) at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:3613) at net.sf.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:238) at dlog4j.UserManager.listUsers(UserManager.java:170) at dlog4j.tags.MemberTag.doStartTag(MemberTag.java:87) at org.apache.jsp.WEB_002dINF.jsp.pages.last_005fmembers_jsp._jspService(org.apache.jsp.WEB_002dINF.jsp.pages.last_005fmembers_jsp:135) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:99) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:325) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:245) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:674) at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:576) at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:501) at org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:966) at org.apache.jasper.runtime.PageContextImpl.include(PageContextImpl.java:601) at web.layout.LayoutTag.doEndTag(LayoutTag.java:70) at org.apache.jsp.WEB_002dINF.jsp.layout.html_005fcontainer_jsp._jspx_meth_dlog4j_layout_0(org.apache.jsp.WEB_002dINF.jsp.layout.html_005fcontainer_jsp:221) at org.apache.jsp.WEB_002dINF.jsp.layout.html_005fcontainer_jsp._jspService(org.apache.jsp.WEB_002dINF.jsp.layout.html_005fcontainer_jsp:110) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:99) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:325) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:245) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:674) at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:576) at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:501) at dlog4j.EmbedPageServlet.doGet(EmbedPageServlet.java:128) at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at dlog4j.UnicodeFilter.doFilter(UnicodeFilter.java:72) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:825) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:731) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:526) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Unknown Source) 2004-12-30 9:16:51 org.apache.catalina.core.ApplicationDispatcher invoke 严重: Servlet.service() for servlet jsp threw exception net.sf.hibernate.JDBCException: SQLException occurred at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:3616) at net.sf.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:238) at dlog4j.UserManager.listUsers(UserManager.java:170) at dlog4j.tags.MemberTag.doStartTag(MemberTag.java:87) at org.apache.jsp.WEB_002dINF.jsp.pages.last_005fmembers_jsp._jspService(org.apache.jsp.WEB_002dINF.jsp.pages.last_005fmembers_jsp:135) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:99) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:325) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:245) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:674) at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:576) at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:501) at org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:966) at org.apache.jasper.runtime.PageContextImpl.include(PageContextImpl.java:601) at web.layout.LayoutTag.doEndTag(LayoutTag.java:70) at org.apache.jsp.WEB_002dINF.jsp.layout.html_005fcontainer_jsp._jspx_meth_dlog4j_layout_0(org.apache.jsp.WEB_002dINF.jsp.layout.html_005fcontainer_jsp:221) at org.apache.jsp.WEB_002dINF.jsp.layout.html_005fcontainer_jsp._jspService(org.apache.jsp.WEB_002dINF.jsp.layout.html_005fcontainer_jsp:110) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:99) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:325) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:245) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:674) at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:576) at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:501) at dlog4j.EmbedPageServlet.doGet(EmbedPageServlet.java:128) at javax.servlet.http
从异常来看,检查一下你的dlog_user表吧,具体什么原来我也说不上来. 可以跟文档中附带的access表进行比较看看. 这个表在查询的时候出错,肯定有问题.
查过了，没有问题，连带其他的也都差了一遍，数据库导入正常，连接也正常
注册没问题，但拥护列表出不来，也不能登陆
这个是忘记密码抛出的错误：
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
javax.servlet.ServletException: javax.servlet.jsp.JspException: SQLException occurred
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:841)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:778)
org.apache.jsp.fetchpwd_jsp._jspService(org.apache.jsp.fetchpwd_jsp:355)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:99)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:325)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:245)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause
net.sf.hibernate.JDBCException: SQLException occurred
net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:3616)
net.sf.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:238)
dlog4j.UserManager.getUser(UserManager.java:145)
dlog4j.tags.UserTag.doStartTag(UserTag.java:47)
org.apache.jsp.fetchpwd_jsp._jspService(org.apache.jsp.fetchpwd_jsp:143)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:99)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:325)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:245)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
用户表的问题,所有涉及到用户资料获取的操作都失败!
请问，数据迁移时发生此错误，该怎样解决？ 导出数据失败，详细信息是: |
