[seasar-dotnet:1229] Re: Quill：QuillTestCaseでのエクセルデータの投入について質問
小林貴生
[E-MAIL ADDRESS DELETED]
2008年 12月 18日 (木) 15:01:20 JST
いつもお世話になっております。
小林（質問者）です。
> 小谷です。
>
> > [Seasar.Framework.Unit.S2FrameworkTestCaseRunner] DEBUG 2008-12-17 16:11:37,016 [10] 例外が発生しました。理由はSystem.Reflection.TargetInvocationException: 呼び出しのターゲットが例外をスローしました。 ---> System.NullReferenceException: オブジェクト参照がオブジェクト インスタンスに設定されていません。
> > 場所 Seasar.Extension.Unit.S2TestCase.get_CommandFactory()
> > 場所 Seasar.Extension.Unit.S2TestCase.WriteDb(DataSet dataSet)
>
> S2Containerが設定されていない状態でQuillTestCaseで動かした場合も
> それを使ってDBへの書き込みを行おうとしていたためNullReferenceExceptionが
> 発生していました。
>
> 暫定的な対応になりますがQuillTestCaseを修正しました。
> お手数ですがSubversionで最新のソースコード（revision:1084〜)を取得し、
> コンパイルしたDLLを使ってご確認いただけないでしょうか。
ご対応ありがとうございました。
一応、期待通りに動作することを確認しました。
（うちのプロキシが多分Subversionに対応していなく、手でセコセコ直した結果ですけど．．．。）
ログの出方が変わったように見えたのですが、ログだけの問題ですよね？。
[S2の方でエクセル取り込んだとき]
Seasar.Framework.Util.DataSourceUtil: DEBUG 2008-12-18 14:45:56,310 [10] 論理的なコネクションを取得しました
Seasar.Extension.Tx.Impl.TransactionContext: DEBUG 2008-12-18 14:45:56,310 [10] トランザクションを開始しました
'MbUnit.GUI.exe' (マネージ型): 'C:\WINDOWS\assembly\GAC_32\System.EnterpriseServices\2.0.0.0__b03f5f7f11d50a3a\System.EnterpriseServices.Wrapper.dll' が読み込まれました
Seasar.Extension.ADO.Impl.BasicUpdateHandler: DEBUG 2008-12-18 14:45:56,580 [10] DELETE FROM D_ACHIEVE
Seasar.Extension.ADO.Impl.BasicUpdateHandler: DEBUG 2008-12-18 14:45:56,781 [10] INSERT INTO D_ACHIEVE (ACHIEVE_ID, RATING, RESEARCH_DATE, RESEARCH_DB, ACHIEVE_DATE, SALES_AMOUNT, ORDINARY_PROFIT, ALLOTMENT, COMPANY_ID) VALUES ('64', '4', '20080101', '5', '200803 ', '1', '2', '3', '78')
Seasar.Extension.ADO.Impl.BasicUpdateHandler: DEBUG 2008-12-18 14:45:56,781 [10] INSERT INTO D_ACHIEVE (ACHIEVE_ID, RATING, RESEARCH_DATE, RESEARCH_DB, ACHIEVE_DATE, SALES_AMOUNT, ORDINARY_PROFIT, ALLOTMENT, COMPANY_ID) VALUES ('65', '0', ' ', ' ', '200804 ', ' ', ' ', ' ', '78')
Seasar.Extension.ADO.Impl.BasicUpdateHandler: DEBUG 2008-12-18 14:45:56,781 [10] INSERT INTO D_ACHIEVE (ACHIEVE_ID, RATING, RESEARCH_DATE, RESEARCH_DB, ACHIEVE_DATE, SALES_AMOUNT, ORDINARY_PROFIT, ALLOTMENT, COMPANY_ID) VALUES ('62', '0', '20080703', ' ', '200808 ', ' ', ' ', ' ', '105')
Seasar.Extension.ADO.Impl.BasicUpdateHandler: DEBUG 2008-12-18 14:45:56,791 [10] INSERT INTO D_ACHIEVE (ACHIEVE_ID, RATING, RESEARCH_DATE, RESEARCH_DB, ACHIEVE_DATE, SALES_AMOUNT, ORDINARY_PROFIT, ALLOTMENT, COMPANY_ID) VALUES ('81', '6', ' ', ' ', '200805 ', ' ', ' ', ' ', '78')
Seasar.Extension.ADO.Impl.BasicUpdateHandler: DEBUG 2008-12-18 14:45:56,791 [10] INSERT INTO D_ACHIEVE (ACHIEVE_ID, RATING, RESEARCH_DATE, RESEARCH_DB, ACHIEVE_DATE, SALES_AMOUNT, ORDINARY_PROFIT, ALLOTMENT, COMPANY_ID) VALUES ('1', '77', '20080401', '帝国データバング', '20080501', '3000', '3000', '12', '2')
Seasar.Extension.ADO.Impl.BasicUpdateHandler: DEBUG 2008-12-18 14:45:56,791 [10] INSERT INTO D_ACHIEVE (ACHIEVE_ID, RATING, RESEARCH_DATE, RESEARCH_DB, ACHIEVE_DATE, SALES_AMOUNT, ORDINARY_PROFIT, ALLOTMENT, COMPANY_ID) VALUES ('281', '0', ' ', ' ', '200806 ', '100', ' ', ' ', '181')
Seasar.Extension.ADO.Impl.BasicUpdateHandler: DEBUG 2008-12-18 14:45:56,801 [10] INSERT INTO D_ACHIEVE (ACHIEVE_ID, RATING, RESEARCH_DATE, RESEARCH_DB, ACHIEVE_DATE, SALES_AMOUNT, ORDINARY_PROFIT, ALLOTMENT, COMPANY_ID) VALUES ('282', '0', ' ', ' ', '200808 ', '400', ' ', ' ', '181')
Seasar.Extension.ADO.Impl.BasicUpdateHandler: DEBUG 2008-12-18 14:45:56,801 [10] INSERT INTO D_ACHIEVE (ACHIEVE_ID, RATING, RESEARCH_DATE, RESEARCH_DB, ACHIEVE_DATE, SALES_AMOUNT, ORDINARY_PROFIT, ALLOTMENT, COMPANY_ID) VALUES ('301', '0', ' ', ' ', '200901 ', ' ', ' ', ' ', '166')
Seasar.Extension.ADO.Impl.BasicUpdateHandler: DEBUG 2008-12-18 14:45:56,801 [10] INSERT INTO D_ACHIEVE (ACHIEVE_ID, RATING, RESEARCH_DATE, RESEARCH_DB, ACHIEVE_DATE, SALES_AMOUNT, ORDINARY_PROFIT, ALLOTMENT, COMPANY_ID) VALUES ('302', '0', ' ', ' ', '201001 ', ' ', ' ', ' ', '166')
[Quillの方でエクセル取り込んだとき]
Seasar.Framework.Util.DataSourceUtil: DEBUG 2008-12-18 14:44:14,384 [10] 論理的なコネクションを取得しました
Seasar.Extension.Tx.Impl.TransactionContext: DEBUG 2008-12-18 14:44:14,394 [10] トランザクションを開始しました
'MbUnit.GUI.exe' (マネージ型): 'C:\WINDOWS\assembly\GAC_32\System.EnterpriseServices\2.0.0.0__b03f5f7f11d50a3a\System.EnterpriseServices.Wrapper.dll' が読み込まれました
Seasar.Extension.ADO.Impl.BasicUpdateHandler: DEBUG 2008-12-18 14:44:14,644 [10] DELETE FROM D_ACHIEVE
Seasar.Quill.Database.DataSource.Impl.SelectableDataSourceProxyWithDictionary: DEBUG 2008-12-18 14:44:14,644 [10] DataSourceName=[TESTDB]
Seasar.Quill.Database.DataSource.Impl.SelectableDataSourceProxyWithDictionary: DEBUG 2008-12-18 14:44:14,644 [10] DataSourceName=[TESTDB]
Seasar.Quill.Database.DataSource.Impl.SelectableDataSourceProxyWithDictionary: DEBUG 2008-12-18 14:44:14,654 [10] DataSourceName=[TESTDB]
Seasar.Quill.Database.DataSource.Impl.SelectableDataSourceProxyWithDictionary: DEBUG 2008-12-18 14:44:14,654 [10] DataSourceName=[TESTDB]
Seasar.Quill.Database.DataSource.Impl.SelectableDataSourceProxyWithDictionary: DEBUG 2008-12-18 14:44:14,654 [10] DataSourceName=[TESTDB]
Seasar.Quill.Database.DataSource.Impl.SelectableDataSourceProxyWithDictionary: DEBUG 2008-12-18 14:44:14,654 [10] DataSourceName=[TESTDB]
Seasar.Quill.Database.DataSource.Impl.SelectableDataSourceProxyWithDictionary: DEBUG 2008-12-18 14:44:14,664 [10] DataSourceName=[TESTDB]
Seasar.Quill.Database.DataSource.Impl.SelectableDataSourceProxyWithDictionary: DEBUG 2008-12-18 14:44:14,674 [10] DataSourceName=[TESTDB]
Seasar.Quill.Database.DataSource.Impl.SelectableDataSourceProxyWithDictionary: DEBUG 2008-12-18 14:44:14,814 [10] DataSourceName=[TESTDB]
Seasar.Extension.ADO.Impl.BasicUpdateHandler: DEBUG 2008-12-18 14:44:14,834 [10] INSERT INTO D_ACHIEVE (ACHIEVE_ID, RATING, RESEARCH_DATE, RESEARCH_DB, ACHIEVE_DATE, SALES_AMOUNT, ORDINARY_PROFIT, ALLOTMENT, COMPANY_ID) VALUES ('64', '4', '20080101', '5', '200803 ', '1', '2', '3', '78')
Seasar.Quill.Database.DataSource.Impl.SelectableDataSourceProxyWithDictionary: DEBUG 2008-12-18 14:44:14,834 [10] DataSourceName=[TESTDB]
Seasar.Quill.Database.DataSource.Impl.SelectableDataSourceProxyWithDictionary: DEBUG 2008-12-18 14:44:14,834 [10] DataSourceName=[TESTDB]
Seasar.Quill.Database.DataSource.Impl.SelectableDataSourceProxyWithDictionary: DEBUG 2008-12-18 14:44:14,844 [10] DataSourceName=[TESTDB]
Seasar.Extension.ADO.Impl.BasicUpdateHandler: DEBUG 2008-12-18 14:44:14,844 [10] INSERT INTO D_ACHIEVE (ACHIEVE_ID, RATING, RESEARCH_DATE, RESEARCH_DB, ACHIEVE_DATE, SALES_AMOUNT, ORDINARY_PROFIT, ALLOTMENT, COMPANY_ID) VALUES ('65', '0', ' ', ' ', '200804 ', ' ', ' ', ' ', '78')
Seasar.Quill.Database.DataSource.Impl.SelectableDataSourceProxyWithDictionary: DEBUG 2008-12-18 14:44:14,844 [10] DataSourceName=[TESTDB]
Seasar.Quill.Database.DataSource.Impl.SelectableDataSourceProxyWithDictionary: DEBUG 2008-12-18 14:44:14,844 [10] DataSourceName=[TESTDB]
Seasar.Quill.Database.DataSource.Impl.SelectableDataSourceProxyWithDictionary: DEBUG 2008-12-18 14:44:14,844 [10] DataSourceName=[TESTDB]
Seasar.Extension.ADO.Impl.BasicUpdateHandler: DEBUG 2008-12-18 14:44:14,844 [10] INSERT INTO D_ACHIEVE (ACHIEVE_ID, RATING, RESEARCH_DATE, RESEARCH_DB, ACHIEVE_DATE, SALES_AMOUNT, ORDINARY_PROFIT, ALLOTMENT, COMPANY_ID) VALUES ('62', '0', '20080703', ' ', '200808 ', ' ', ' ', ' ', '105')
Seasar.Quill.Database.DataSource.Impl.SelectableDataSourceProxyWithDictionary: DEBUG 2008-12-18 14:44:14,844 [10] DataSourceName=[TESTDB]
Seasar.Quill.Database.DataSource.Impl.SelectableDataSourceProxyWithDictionary: DEBUG 2008-12-18 14:44:14,844 [10] DataSourceName=[TESTDB]
Seasar.Quill.Database.DataSource.Impl.SelectableDataSourceProxyWithDictionary: DEBUG 2008-12-18 14:44:14,854 [10] DataSourceName=[TESTDB]
Seasar.Extension.ADO.Impl.BasicUpdateHandler: DEBUG 2008-12-18 14:44:14,854 [10] INSERT INTO D_ACHIEVE (ACHIEVE_ID, RATING, RESEARCH_DATE, RESEARCH_DB, ACHIEVE_DATE, SALES_AMOUNT, ORDINARY_PROFIT, ALLOTMENT, COMPANY_ID) VALUES ('81', '6', ' ', ' ', '200805 ', ' ', ' ', ' ', '78')
Seasar.Quill.Database.DataSource.Impl.SelectableDataSourceProxyWithDictionary: DEBUG 2008-12-18 14:44:14,854 [10] DataSourceName=[TESTDB]
Seasar.Quill.Database.DataSource.Impl.SelectableDataSourceProxyWithDictionary: DEBUG 2008-12-18 14:44:14,854 [10] DataSourceName=[TESTDB]
Seasar.Quill.Database.DataSource.Impl.SelectableDataSourceProxyWithDictionary: DEBUG 2008-12-18 14:44:14,854 [10] DataSourceName=[TESTDB]
Seasar.Extension.ADO.Impl.BasicUpdateHandler: DEBUG 2008-12-18 14:44:14,854 [10] INSERT INTO D_ACHIEVE (ACHIEVE_ID, RATING, RESEARCH_DATE, RESEARCH_DB, ACHIEVE_DATE, SALES_AMOUNT, ORDINARY_PROFIT, ALLOTMENT, COMPANY_ID) VALUES ('1', '77', '20080401', '帝国データバング', '20080501', '3000', '3000', '12', '2')
Seasar.Quill.Database.DataSource.Impl.SelectableDataSourceProxyWithDictionary: DEBUG 2008-12-18 14:44:14,854 [10] DataSourceName=[TESTDB]
Seasar.Quill.Database.DataSource.Impl.SelectableDataSourceProxyWithDictionary: DEBUG 2008-12-18 14:44:14,854 [10] DataSourceName=[TESTDB]
Seasar.Quill.Database.DataSource.Impl.SelectableDataSourceProxyWithDictionary: DEBUG 2008-12-18 14:44:14,854 [10] DataSourceName=[TESTDB]
Seasar.Extension.ADO.Impl.BasicUpdateHandler: DEBUG 2008-12-18 14:44:14,864 [10] INSERT INTO D_ACHIEVE (ACHIEVE_ID, RATING, RESEARCH_DATE, RESEARCH_DB, ACHIEVE_DATE, SALES_AMOUNT, ORDINARY_PROFIT, ALLOTMENT, COMPANY_ID) VALUES ('281', '0', ' ', ' ', '200806 ', '100', ' ', ' ', '181')
Seasar.Quill.Database.DataSource.Impl.SelectableDataSourceProxyWithDictionary: DEBUG 2008-12-18 14:44:14,864 [10] DataSourceName=[TESTDB]
Seasar.Quill.Database.DataSource.Impl.SelectableDataSourceProxyWithDictionary: DEBUG 2008-12-18 14:44:14,864 [10] DataSourceName=[TESTDB]
Seasar.Quill.Database.DataSource.Impl.SelectableDataSourceProxyWithDictionary: DEBUG 2008-12-18 14:44:14,864 [10] DataSourceName=[TESTDB]
Seasar.Extension.ADO.Impl.BasicUpdateHandler: DEBUG 2008-12-18 14:44:14,864 [10] INSERT INTO D_ACHIEVE (ACHIEVE_ID, RATING, RESEARCH_DATE, RESEARCH_DB, ACHIEVE_DATE, SALES_AMOUNT, ORDINARY_PROFIT, ALLOTMENT, COMPANY_ID) VALUES ('282', '0', ' ', ' ', '200808 ', '400', ' ', ' ', '181')
Seasar.Quill.Database.DataSource.Impl.SelectableDataSourceProxyWithDictionary: DEBUG 2008-12-18 14:44:14,864 [10] DataSourceName=[TESTDB]
Seasar.Quill.Database.DataSource.Impl.SelectableDataSourceProxyWithDictionary: DEBUG 2008-12-18 14:44:14,864 [10] DataSourceName=[TESTDB]
Seasar.Quill.Database.DataSource.Impl.SelectableDataSourceProxyWithDictionary: DEBUG 2008-12-18 14:44:14,864 [10] DataSourceName=[TESTDB]
Seasar.Extension.ADO.Impl.BasicUpdateHandler: DEBUG 2008-12-18 14:44:14,874 [10] INSERT INTO D_ACHIEVE (ACHIEVE_ID, RATING, RESEARCH_DATE, RESEARCH_DB, ACHIEVE_DATE, SALES_AMOUNT, ORDINARY_PROFIT, ALLOTMENT, COMPANY_ID) VALUES ('301', '0', ' ', ' ', '200901 ', ' ', ' ', ' ', '166')
Seasar.Quill.Database.DataSource.Impl.SelectableDataSourceProxyWithDictionary: DEBUG 2008-12-18 14:44:14,874 [10] DataSourceName=[TESTDB]
Seasar.Quill.Database.DataSource.Impl.SelectableDataSourceProxyWithDictionary: DEBUG 2008-12-18 14:44:14,874 [10] DataSourceName=[TESTDB]
Seasar.Quill.Database.DataSource.Impl.SelectableDataSourceProxyWithDictionary: DEBUG 2008-12-18 14:44:14,874 [10] DataSourceName=[TESTDB]
Seasar.Extension.ADO.Impl.BasicUpdateHandler: DEBUG 2008-12-18 14:44:14,874 [10] INSERT INTO D_ACHIEVE (ACHIEVE_ID, RATING, RESEARCH_DATE, RESEARCH_DB, ACHIEVE_DATE, SALES_AMOUNT, ORDINARY_PROFIT, ALLOTMENT, COMPANY_ID) VALUES ('302', '0', ' ', ' ', '201001 ', ' ', ' ', ' ', '166')
Seasar.Quill.Database.DataSource.Impl.SelectableDataSourceProxyWithDictionary: DEBUG 2008-12-18 14:44:14,874 [10] DataSourceName=[TESTDB]
Seasar.Quill.Database.DataSource.Impl.SelectableDataSourceProxyWithDictionary: DEBUG 2008-12-18 14:44:14,874 [10] DataSourceName=[TESTDB]
Seasar.Quill.Database.DataSource.Impl.SelectableDataSourceProxyWithDictionary: DEBUG 2008-12-18 14:44:14,874 [10] DataSourceName=[TESTDB]
以上、よろしくお願いいたします。
小林
seasar-dotnet メーリングリストの案内