[tugboat-gtd:34] Re: スタート時に例外
Shuji Aono
[E-MAIL ADDRESS DELETED]
2007年 8月 10日 (金) 11:22:15 JST
青野です。
「WEB-INF/classes/org/seasar/tugboat/gtd/contents/task/dao/」の中は以下のファイルが存在しております。
TagsDao.class
TaskRelationsDao_findByClassId_derby.sql
TagsDao_findById_postgre.sql
TaskRelationsDao_findByClassId_postgre.sql
TagsDao_findByKeyword_derby.sql TaskRelationsDao_findByHasTags.sql
TagsDao_findByKeyword_postgre.sql
TaskRelationsDao_findByQueryParams.sql
TagsDao_findByValue.sql
TaskRelationsDao_findByTaskId_derby.sql
TagsDao_insert.sql
TaskRelationsDao_findByTaskId_postgre.sql
TaskBodiesDao.class TaskRelationsDao_findByUserId.sql
TaskBodiesDao_delete.sql
TaskRelationsDao_findTaskByDiscussionId.sql
TaskBodiesDao_insert.sql
TaskRelationsDao_getCountByActivityId.sql
TaskBodiesDao_update.sql
TaskRelationsDao_getDefaultFolderTasks.sql
TaskBrowserActivitiesDao.class
TaskRelationsDao_getRowsByHasTags.sql
TaskBrowserActivitiesDao_delete.sql
TaskRelationsDao_getRowsByQueryParams.sql
TaskBrowserActivitiesDao_findByUserId.sql TaskRelationsDao_insert.sql
TaskBrowserActivitiesDao_insert.sql TaskRelationsDao_update.sql
TaskBrowserClassificationsDao.class
TaskRelationsDao_updateClassification.sql
TaskBrowserClassificationsDao_delete.sql TaskSelectTagsDao.class
TaskBrowserClassificationsDao_insert.sql TaskSelectTagsDao_delete.sql
TaskBrowserPersonsDao.class TaskSelectTagsDao_findByUserId.sql
TaskBrowserPersonsDao_delete.sql TaskSelectTagsDao_insert.sql
TaskBrowserPersonsDao_findByUserId.sql TaskSelectViewsDao.class
TaskBrowserPersonsDao_insert.sql TaskSelectViewsDao_findByUserId.sql
TaskBrowserStatusesDao.class TaskSelectViewsDao_insert.sql
TaskBrowserStatusesDao_delete.sql TaskSelectViewsDao_update.sql
TaskBrowserStatusesDao_findByUserId.sql TaskTagsDao.class
TaskBrowserStatusesDao_insert.sql TaskTagsDao_delete.sql
TaskCommentBodiesDao.class
TaskTagsDao_findByTaskIdAndUserId.sql
TaskCommentBodiesDao_delete.sql
TaskTagsDao_findByTaskIdsAndUserId.sql
TaskCommentBodiesDao_insert.sql TaskTagsDao_findByUserId.sql
TaskCommentBodiesDao_update.sql
TaskTagsDao_getTaskIdsByTagIdsAndUserId.sql
TaskCommentRelatiosDao.class TaskTagsDao_getTaskIdsByUserId.sql
TaskCommentRelatiosDao_findByCommentId.sql TaskTagsDao_insert_derby.sql
TaskCommentsDao.class TaskTagsDao_insert_postgre.sql
TaskCommentsDao_findById.sql TaskToTasksDao.class
TaskCommentsDao_findByTaskId.sql TaskToTasksDao_delete.sql
TaskCommentsDao_findByUserId.sql
TaskToTasksDao_findTaskToTasksByTaskId.sql
TaskCommentsDao_insert_derby.sql TaskToTasksDao_insert.sql
TaskCommentsDao_insert_postgre.sql TasksDao.class
TaskCommentsDao_selectNewCommentId.sql TasksDao_getNewTaskId.sql
TaskHistoriesDao.class TasksDao_getUpdateTargetByDate.sql
TaskHistoriesDao_findByTaskId.sql TasksDao_insert_derby.sql
TaskHistoriesDao_insert_derby.sql TasksDao_insert_postgre.sql
TaskHistoriesDao_insert_postgre.sql TasksDao_update.sql
TaskMemberRolesDao_findByTaskId_derby.sql TasksDao_updateDeleteFlag.sql
TaskMemberRolesDao_insert_derby.sql
TasksDao_updateDeleteFlagByUserId.sql
TaskRelationsDao.class
07/08/10 に HARA, Yosuke<[E-MAIL ADDRESS DELETED]> さんは書きました:
> はらです。
>
> さきほど、JDK6に変更してテストを行いましたが、問題ございませんでした。あ
> と考えられるのは、SQLファイルが存在しないように思われます。（今回の実装
> では、SQLの自動実行は使っておりません）
>
> 「WEB-INF/classes/org/seasar/tugboat/gtd/contents/task/dao/」の中にSQL
> ファイルが存在するかの確認をお願いいたします。
>
> > エラーメッセージ見間違いしておりました。「dateカラムがtask_relationsテー
> > ブルに存在しない」というエラーですね。環境を見ますと JDK6.0をお使いのよ
> > うですが、まだJDK6.0でのテストは実施しておりません。申訳ございませんが、
> > JDK5.0にダウングレードして再度お試しいただけますでしょうか。よろしくお願
> > いいたします。
> >
> >
> >
> >> ＞Column(date) of Table(task_relations)not found
> >> 確認しましたとこ「task_relations」テーブルは存在しております。
> >> 但し、カラム「date」は存在しておりません。
> >>
> >> 以上、よろしくお願いいたします。
> >>
> >>
> >> 07/08/09 に HARA, Yosuke<[E-MAIL ADDRESS DELETED]> さんは書きました:
> >>
> >>
> >>> はらです。こんにちは。
> >>>
> >>> 下記のエラーから「task_relations」が存在しないと思われます。psqlコマン
> >>> ド、またはpgadminでテーブルの確認をお願いします。
> >>>
> >>>
> >>>> Column(date) of Table(task_relations)not found
> >>>>
> >>>>
> >>>
> >>>
> >>>> tagboatスタート時に以下の例外が発生しております。
> >>>> ------------------------------------------------
> >>>> SEVERE: Exception sending context initialized event to listener
> >>>> instance of class org.seasar.teeda.core.webapp.TeedaConfigureListener
> >>>> org.seasar.extension.jdbc.ColumnNotFoundRuntimeException:
> >>>> [ESSR0068]Column(date) of Table(task_relations)not found
> >>>> at org.seasar.dao.impl.BeanMetaDataImpl.convertFullColumnName(BeanMetaDataImpl.java:260)
> >>>> at org.seasar.dao.impl.DaoMetaDataImpl.createAutoSelectSql(DaoMetaDataImpl.java:650)
> >>>> at org.seasar.dao.impl.DaoMetaDataImpl.setupSelectMethodByAuto(DaoMetaDataImpl.java:574)
> >>>> at org.seasar.dao.impl.DaoMetaDataImpl.setupMethodByAuto(DaoMetaDataImpl.java:343)
> >>>> at org.seasar.dao.impl.DaoMetaDataImpl.setupMethod(DaoMetaDataImpl.java:237)
> >>>> at org.seasar.dao.impl.DaoMetaDataImpl.setupMethod(DaoMetaDataImpl.java:218)
> >>>> at org.seasar.dao.impl.DaoMetaDataImpl.setupSqlCommand(DaoMetaDataImpl.java:212)
> >>>> at org.seasar.dao.impl.DaoMetaDataImpl.initialize(DaoMetaDataImpl.java:203)
> >>>> at org.seasar.dao.impl.DaoMetaDataFactoryImpl.createDaoMetaData(DaoMetaDataFactoryImpl.java:123)
> >>>> at org.seasar.dao.impl.DaoMetaDataFactoryImpl.getDaoMetaData(DaoMetaDataFactoryImpl.java:95)
> >>>> at org.seasar.dao.interceptors.S2DaoInterceptor.invoke(S2DaoInterceptor.java:51)
> >>>> at org.seasar.dao.pager.PagerS2DaoInterceptorWrapper.invoke(PagerS2DaoInterceptorWrapper.java:64)
> >>>> at org.seasar.tugboat.gtd.contents.task.dao.TaskRelationsDao$$EnhancedByS2AOP$$3449a8$$MethodInvocation$$getUpdateTargetByDate
> >>>> ForMoveToArchive12.proceed(MethodInvocationClassGenerator.java)
> >>>> at org.seasar.framework.aop.interceptors.TraceInterceptor.invoke(TraceInterceptor.java:59)
> >>>> at org.seasar.tugboat.gtd.contents.task.dao.TaskRelationsDao$$EnhancedByS2AOP$$3449a8$$MethodInvocation$$getUpdateTargetByDate
> >>>> ForMoveToArchive12.proceed(MethodInvocationClassGenerator.java)
> >>>> at org.seasar.tugboat.gtd.contents.task.dao.TaskRelationsDao$$EnhancedByS2AOP$$3449a8.getUpdateTargetByDateForMoveToArchive(Ta
> >>>> skRelationsDao$$EnhancedByS2AOP$$3449a8.java)
> >>>> at org.seasar.tugboat.gtd.contents.task.service.impl.TaskTransferSchedulerImpl.updateTaskClassification(TaskTransferSchedulerI
> >>>> mpl.java:96)
> >>>> at org.seasar.tugboat.gtd.contents.task.service.impl.TaskTransferSchedulerImpl.init(TaskTransferSchedulerImpl.java:73)
> >>>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> >>>> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> >>>> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> >>>> at java.lang.reflect.Method.invoke(Method.java:597)
> >>>> at org.seasar.framework.util.MethodUtil.invoke(MethodUtil.java:49)
> >>>> at org.seasar.framework.container.assembler.AbstractMethodAssembler.invoke(AbstractMethodAssembler.java:82)
> >>>> at org.seasar.framework.container.assembler.DefaultInitMethodAssembler.assemble(DefaultInitMethodAssembler.java:47)
> >>>> at org.seasar.framework.container.deployer.SingletonComponentDeployer.assemble(SingletonComponentDeployer.java:64)
> >>>> at org.seasar.framework.container.deployer.SingletonComponentDeployer.deploy(SingletonComponentDeployer.java:43)
> >>>> at org.seasar.framework.container.deployer.SingletonComponentDeployer.init(SingletonComponentDeployer.java:71)
> >>>> at org.seasar.framework.container.impl.ComponentDefImpl.init(ComponentDefImpl.java:299)
> >>>> at org.seasar.framework.container.impl.S2ContainerImpl.init(S2ContainerImpl.java:499)
> >>>> at org.seasar.framework.container.impl.S2ContainerImpl.init(S2ContainerImpl.java:496)
> >>>> at org.seasar.framework.container.impl.S2ContainerImpl.init(S2ContainerImpl.java:496)
> >>>> at org.seasar.framework.container.impl.S2ContainerImpl.init(S2ContainerImpl.java:496)
> >>>> at org.seasar.framework.container.factory.SingletonS2ContainerFactory.init(SingletonS2ContainerFactory.java:81)
> >>>> at org.seasar.framework.container.servlet.SingletonS2ContainerInitializer.initialize(SingletonS2ContainerInitializer.java:50)
> >>>> at org.seasar.framework.container.servlet.S2ContainerListener.initializeContainer(S2ContainerListener.java:39)
> >>>> at org.seasar.framework.container.servlet.S2ContainerListener.contextInitialized(S2ContainerListener.java:46)
> >>>> at org.seasar.teeda.core.webapp.TeedaConfigureListener.contextInitialized(TeedaConfigureListener.java:40)
> >>>> at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3827)
> >>>> at org.apache.catalina.core.StandardContext.start(StandardContext.java:4334)
> >>>> at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
> >>>> at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
> >>>> at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
> >>>> at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:825)
> >>>> at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:714)
> >>>> at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490)
> >>>> at org.apache.catalina.startup.HostConfig.check(HostConfig.java:1206)
> >>>> at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:293)
> >>>> at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
> >>>> at org.apache.catalina.core.ContainerBase.backgroundProcess(ContainerBase.java:1337)
> >>>> at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processChildren(ContainerBase.java:1601)
> >>>> at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processChildren(ContainerBase.java:1610)
> >>>> at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.run(ContainerBase.java:1590)
> >>>> at java.lang.Thread.run(Thread.java:619)
> >>>> -----------------------------------------------------------------------------
> >>>> tugboat : tugboat-gtd-src-0.8.0-1.tar.gz
> >>>> OS : Ubuntu 7.04
> >>>> JVM : 1.6.0-b105
> >>>> Tomcat : 6.0.13
> >>>> Postgres : 8.2.4
> >>>>
> >>>>
> > _______________________________________________
> > tugboat-gtd mailing list
> > [E-MAIL ADDRESS DELETED]
> > https://ml.seasar.org/mailman/listinfo/tugboat-gtd
> >
> >
>
> _______________________________________________
> tugboat-gtd mailing list
> [E-MAIL ADDRESS DELETED]
> https://ml.seasar.org/mailman/listinfo/tugboat-gtd
>
tugboat-gtd メーリングリストの案内