My XPlanner wornt start/deploy Gives Unknown database 'xplanner'. The MySql is having 'xplanner' DB created
<gyanapalam-email-/[email protected]> Wed, 23 Aug 2006 14:06:41 -0700 (PDT)
| Newsgroups | gmane.comp.java.xplanner.devel |
|---|---|
| Message-ID | <[email protected]> |
Xplanner won't start. Using the latest. Problem with the Migration scripts.
[ 12957] INFO - technoetic.xplanner.SystemInfo - *********************** XPLANNER INFO ************************ Build: Version: 0.7b7 Build Date: 05/24/2006 Build Revision: 1149 Build Package: War Database: Dialect: com.technoetic.xplanner.db.hibernate.XPlannerMySQLDialect Driver:
com.mysql.jdbc.Driver Driver Version: mysql-connector-java-3.1.12 ( $Date: 2005-11-17 15:53:48 +0100 (Thu, 17 Nov 2005) $, $Revision$ ) Database Vendor: MySQL Database Version: 5.0.24-community-nt Database Name: xplanner Database Url: jdbc:mysql://localhost/xplanner Database User Name: xplanner Database User Password: ****** Database Patch Level: 0 App Server:
Application Server: Apache Tomcat/5.5.12 Servlet Version: 2.4 System: System Date: Aug 23, 2006 System Time: 3:39:41 PM Current directory: C:\apache-tomcat-5.5.12\bin Java Version: 1.5.0_04 Java Vendor: Sun Microsystems Inc. JVM Version: 1.0 JVM Vendor: Sun Microsystems Inc. JVM Implementation Version: 1.5.0_04-b05
Java Runtime: Java(TM) 2 Runtime Environment, Standard Edition Java VM: Java HotSpot(TM) Client VM User Name: spattabi User Timezone: America/Chicago Operating System: Windows XP 5.1 OS Architecture: x86 [ 12973] INFO - work.web.context.ContextLoader - Using context class [org.springframework.web.context.support.XmlWebApplicationContext] for root WebApplicationContext [ 12973] INFO -
work.web.context.ContextLoader - Root WebApplicationContext: initialization completed in 12973 ms [ 14174] INFO - til.migration.MigrationProcess - Running migration task "patch0001_0-6-0.sql [com.tacitknowledge.util.migration.jdbc.SqlScriptMigrationTask]"... [ 17791] INFO - til.migration.MigrationProcess - Finished migration task "patch0001_0-6-0.sql [com.tacitknowledge.util.migration.jdbc.SqlScriptMigrationTask]" (3617 millis.) [ 17838] INFO - til.migration.MigrationProcess - Running migration task "patch0002_bootstrap_users_and_permissions.sql [com.tacitknowledge.util.migration.jdbc.SqlScriptMigrationTask]"... [ 17853] INFO - til.migration.MigrationProcess - Finished migration task "patch0002_bootstrap_users_and_permissions.sql
[com.tacitknowledge.util.migration.jdbc.SqlScriptMigrationTask]" (15 millis.) [ 17900] INFO - til.migration.MigrationProcess - Running migration task "patch0003_0-6-1_to_0-6-2.sql [com.tacitknowledge.util.migration.jdbc.SqlScriptMigrationTask]"... [ 18041] INFO - til.migration.MigrationProcess - Finished migration task "patch0003_0-6-1_to_0-6-2.sql [com.tacitknowledge.util.migration.jdbc.SqlScriptMigrationTask]" (141 millis.) [ 18087] INFO - til.migration.MigrationProcess - Running migration task "patch0004_0-6-2_to_0-7b1_A.sql [com.tacitknowledge.util.migration.jdbc.SqlScriptMigrationTask]"... [ 18945] ERROR - on.jdbc.SqlScriptMigrationTask - patch0004_0-6-2_to_0-7b1_A.sql: Error
running SQL "/* Purge unattached notes */ CREATE temporary table tempnote AS select n.id, n.attachment_id from note n left join project p on n.attachedTo_id = p.id left join iteration i on n.attachedTo_id = i.id left join story s on n.attachedTo_id = s.id left join task t on n.attachedTo_id = t.id where p.id is null and i.id is null and s.id is null and t.id is null" java.sql.SQLException: Unknown database 'xplanner' at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571) at
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666) at com.mysql.jdbc.Connection.execSQL(Connection.java:2988) at com.mysql.jdbc.Connection.execSQL(Connection.java:2917) at com.mysql.jdbc.Statement.execute(Statement.java:529) at com.tacitknowledge.util.migration.jdbc.SqlScriptMigrationTask.migrate(SqlScriptMigrationTask.java:124) at com.tacitknowledge.util.migration.MigrationProcess.doMigrations(MigrationProcess.java:162) at com.tacitknowledge.util.migration.jdbc.JdbcMigrationLauncher.doMigrations(JdbcMigrationLauncher.java:288) at com.tacitknowledge.util.migration.jdbc.JdbcMigrationLauncher.doMigrations(JdbcMigrationLauncher.java:108)
at com.technoetic.xplanner.filters.XPlannerMigrationLauncher.contextInitialized(XPlannerMigrationLauncher.java:67) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3692) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4127) at org.jstripe.tomcat.probe.Tomcat55ContainerAdaptor.start(Tomcat55ContainerAdaptor.java:62) at org.jstripe.tomcat.probe.controllers.StartContextController.executeAction(StartContextController.java:21) at org.jstripe.tomcat.probe.controllers.NoSelfContextHandlerController.handleContext(NoSelfContextHandlerController.java:34) at
org.jstripe.tomcat.probe.controllers.ContextHandlerController.handleRequestInternal(ContextHandlerController.java:39) at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153) at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:44) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:723) at org.jstripe.tomcat.probe.ProbeServlet.doDispatch(ProbeServlet.java:48) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:663) at
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:394) at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:348) 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:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:120)
at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:514)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.cluster.tcp.ReplicationValve.invoke(ReplicationValve.java:247) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541) 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:868) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:663) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) 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(Thread.java:595) [ 19366] INFO - til.migration.MigrationProcess -
Migration failed; rollback successful [ 19397] ERROR - ters.XPlannerMigrationLauncher - java.lang.RuntimeException: Migration exception caught during migration Migration exception caught during migration java.lang.RuntimeException: Migration exception caught during migration at com.technoetic.xplanner.filters.XPlannerMigrationLauncher.contextInitialized(XPlannerMigrationLauncher.java:70) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3692) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4127) at org.jstripe.tomcat.probe.Tomcat55ContainerAdaptor.start(Tomcat55ContainerAdaptor.java:62)
at org.jstripe.tomcat.probe.controllers.StartContextController.executeAction(StartContextController.java:21) at org.jstripe.tomcat.probe.controllers.NoSelfContextHandlerController.handleContext(NoSelfContextHandlerController.java:34) at org.jstripe.tomcat.probe.controllers.ContextHandlerController.handleRequestInternal(ContextHandlerController.java:39) at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153) at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:44) at
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:723) at org.jstripe.tomcat.probe.ProbeServlet.doDispatch(ProbeServlet.java:48) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:663) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:394) at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:348) 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:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:120) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:514) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.cluster.tcp.ReplicationValve.invoke(ReplicationValve.java:247) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541) 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:868) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:663) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
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(Thread.java:595) Caused by: com.tacitknowledge.util.migration.MigrationException: patch0004_0-6-2_to_0-7b1_A.sql: Error running SQL "/* Purge unattached notes */ CREATE temporary table tempnote AS select n.id, n.attachment_id from note n left join project p on n.attachedTo_id = p.id left join iteration i on n.attachedTo_id = i.id left join story s on n.attachedTo_id = s.id
left join task t on n.attachedTo_id = t.id where p.id is null and i.id is null and s.id is null and t.id is null" at com.tacitknowledge.util.migration.jdbc.SqlScriptMigrationTask.migrate(SqlScriptMigrationTask.java:142) at com.tacitknowledge.util.migration.MigrationProcess.doMigrations(MigrationProcess.java:162) at com.tacitknowledge.util.migration.jdbc.JdbcMigrationLauncher.doMigrations(JdbcMigrationLauncher.java:288) at com.tacitknowledge.util.migration.jdbc.JdbcMigrationLauncher.doMigrations(JdbcMigrationLauncher.java:108) at
com.technoetic.xplanner.filters.XPlannerMigrationLauncher.contextInitialized(XPlannerMigrationLauncher.java:67) ... 36 more Caused by: java.sql.SQLException: Unknown database 'xplanner' at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666) at com.mysql.jdbc.Connection.execSQL(Connection.java:2988) at com.mysql.jdbc.Connection.execSQL(Connection.java:2917) at com.mysql.jdbc.Statement.execute(Statement.java:529) at com.tacitknowledge.util.migration.jdbc.SqlScriptMigrationTask.migrate(SqlScriptMigrationTask.java:124)
... 40 more Migration exception caught during migration java.lang.RuntimeException: Migration exception caught during migration at com.technoetic.xplanner.filters.XPlannerMigrationLauncher.contextInitialized(XPlannerMigrationLauncher.java:70) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3692) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4127) at org.jstripe.tomcat.probe.Tomcat55ContainerAdaptor.start(Tomcat55ContainerAdaptor.java:62) at org.jstripe.tomcat.probe.controllers.StartContextController.executeAction(StartContextController.java:21)
at org.jstripe.tomcat.probe.controllers.NoSelfContextHandlerController.handleContext(NoSelfContextHandlerController.java:34) at org.jstripe.tomcat.probe.controllers.ContextHandlerController.handleRequestInternal(ContextHandlerController.java:39) at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153) at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:44) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:723) at org.jstripe.tomcat.probe.ProbeServlet.doDispatch(ProbeServlet.java:48)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:663) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:394) at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:348) 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:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:120) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:514) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.cluster.tcp.ReplicationValve.invoke(ReplicationValve.java:247) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541) 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:868) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:663) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) 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(Thread.java:595) Caused by: com.tacitknowledge.util.migration.MigrationException: patch0004_0-6-2_to_0-7b1_A.sql: Error running SQL "/* Purge unattached notes */ CREATE temporary table tempnote AS select n.id, n.attachment_id from note n left join project p on n.attachedTo_id = p.id left join iteration i on n.attachedTo_id = i.id left join story s on n.attachedTo_id = s.id left join task t on n.attachedTo_id = t.id where p.id is null and i.id is null and s.id is null and t.id is null" at
com.tacitknowledge.util.migration.jdbc.SqlScriptMigrationTask.migrate(SqlScriptMigrationTask.java:142) at com.tacitknowledge.util.migration.MigrationProcess.doMigrations(MigrationProcess.java:162) at com.tacitknowledge.util.migration.jdbc.JdbcMigrationLauncher.doMigrations(JdbcMigrationLauncher.java:288) at com.tacitknowledge.util.migration.jdbc.JdbcMigrationLauncher.doMigrations(JdbcMigrationLauncher.java:108) at com.technoetic.xplanner.filters.XPlannerMigrationLauncher.contextInitialized(XPlannerMigrationLauncher.java:67) ... 36 more Caused by: java.sql.SQLException: Unknown database 'xplanner'
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666) at com.mysql.jdbc.Connection.execSQL(Connection.java:2988) at com.mysql.jdbc.Connection.execSQL(Connection.java:2917) at com.mysql.jdbc.Statement.execute(Statement.java:529) at com.tacitknowledge.util.migration.jdbc.SqlScriptMigrationTask.migrate(SqlScriptMigrationTask.java:124) ... 40 more Aug 23, 2006 3:39:48 PM org.apache.catalina.core.StandardContext start SEVERE: Error listenerStart Aug 23, 2006 3:39:48 PM
org.apache.catalina.core.StandardContext start SEVERE: Context [/xplanner] startup failed due to previous errors [ 19709] INFO - pport.XmlWebApplicationContext - Closing application context [Root WebApplicationContext] [ 19709] INFO - ort.DefaultListableBeanFactory - Destroying singletons in factory
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Xplanner-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/xplanner-devel