[Seasar-user:12510] postgressqlでのsqlファイル利用

[E-MAIL ADDRESS DELETED] [E-MAIL ADDRESS DELETED]
2008年 1月 15日 (火) 18:22:03 JST


はじめまして。坂井ともうします。
お世話になります。ひとつ質問させていただきたいのですが
Teeda+S2DAOでの学習を行っています。

sqlファイルを利用してUPDATEを行いたいのですが、
エラーが発生します。


開発環境
OS;Windows
DB:postgresql
IDE;eclipse3.2
アプリケーションサーバー:Tomcat5.5
FW:Turaproject(Teeda+S2DAO)

以下はエラー
org.seasar.framework.exception.SQLRuntimeException: 
[ESSR0072]SQLで例外(SQL=[update 
userinfo set userid = ?, password = ?], 
Message=[[ESSR0072]SQLで例外(SQL=[update 
userinfo set userid = ?, password = 
?], Message=[0], ErrorCode=07006, 
SQLState={3})が発生しました : 
[SQLで例外(Message=[Can't infer the SQL type 
to use for an instance of 
agnietec.entity.UserInfo. Use setObject() with an 
explicit Types value to 
specify the type to use.], ErrorCode=0, 
SQLState=07006)が発生しました。], [Can't 
infer the SQL type to use for an 
instance of agnietec.entity.UserInfo. Use 
setObject() with an explicit Types 
value to specify the type to use.], 
ErrorCode=0, SQLState=07006)が発生しました 

 at 

org.seasar.extension.jdbc.impl.BasicHandler.bindArgs(BasicHandler.java:195)
 at 

org.seasar.extension.jdbc.impl.BasicUpdateHandler.execute(BasicUpdateHandler.java:101)
 at 

org.seasar.extension.jdbc.impl.BasicUpdateHandler.execute(BasicUpdateHandler.java:80)
 at 

org.seasar.dao.impl.UpdateDynamicCommand.execute(UpdateDynamicCommand.java:43)
 at 

org.seasar.dao.interceptors.S2DaoInterceptor.invoke(S2DaoInterceptor.java:53)
 at 

org.seasar.dao.pager.PagerS2DaoInterceptorWrapper.invoke(PagerS2DaoInterceptorWrapper.java:71)
 at 

agnietec.dao.UserInfoDao$$EnhancedByS2AOP$$1b99628$$MethodInvocation$$updateUser8.proceed(MethodInvocationClassGenerator.java)
 at 

org.seasar.framework.aop.interceptors.TraceInterceptor.invoke(TraceInterceptor.java:73)
 at 

agnietec.dao.UserInfoDao$$EnhancedByS2AOP$$1b99628$$MethodInvocation$$updateUser8.proceed(MethodInvocationClassGenerator.java)
 at 

agnietec.dao.UserInfoDao$$EnhancedByS2AOP$$1b99628.updateUser(UserInfoDao$$EnhancedByS2AOP$$1b99628.java)
 at 
agnietec.web.login.CreateuserPage.doUpdate(CreateuserPage.java:70)
 at 

agnietec.web.login.CreateuserPage$$EnhancedByS2AOP$$116ce6e.$$doUpdate$$invokeSuperMethod$$(CreateuserPage$$EnhancedByS2AOP$$116ce6e.java)
 at 

agnietec.web.login.CreateuserPage$$EnhancedByS2AOP$$116ce6e$$MethodInvocation$$doUpdate3.proceed(MethodInvocationClassGenerator.java)
 at 

org.seasar.extension.tx.DefaultTransactionCallback.execute(DefaultTransactionCallback.java:58)
 at 

org.seasar.extension.tx.adapter.JTATransactionManagerAdapter.required(JTATransactionManagerAdapter.java:65)
 at 

org.seasar.extension.tx.RequiredInterceptor.invoke(RequiredInterceptor.java:41)
 at 

agnietec.web.login.CreateuserPage$$EnhancedByS2AOP$$116ce6e$$MethodInvocation$$doUpdate3.proceed(MethodInvocationClassGenerator.java)
 at 

org.seasar.framework.aop.interceptors.ThrowsInterceptor.invoke(ThrowsInterceptor.java:77)
 at 

agnietec.web.login.CreateuserPage$$EnhancedByS2AOP$$116ce6e$$MethodInvocation$$doUpdate3.proceed(MethodInvocationClassGenerator.java)
 at 

agnietec.web.login.CreateuserPage$$EnhancedByS2AOP$$116ce6e.doUpdate(CreateuserPage$$EnhancedByS2AOP$$116ce6e.java)
 at 
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at 
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
 at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
 at 
java.lang.reflect.Method.invoke(Unknown Source)
 at 
org.seasar.framework.util.MethodUtil.invoke(MethodUtil.java:93)
 at 

org.seasar.framework.beans.impl.BeanDescImpl.invoke(BeanDescImpl.java:213)
 at 

org.seasar.teeda.extension.html.impl.HtmlComponentInvokerImpl.invoke(HtmlComponentInvokerImpl.java:159)
 at 

org.seasar.teeda.extension.html.impl.HtmlActionListener.processAction(HtmlActionListener.java:62)
 at 
javax.faces.component.UICommand.broadcast(UICommand.java:149)
 at 

org.seasar.teeda.extension.component.html.THtmlCommandButton.broadcast(THtmlCommandButton.java:61)
 at 
javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:192)
 at 
javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:117)
 at 

org.seasar.teeda.core.lifecycle.impl.InvokeApplicationPhase.executePhase(InvokeApplicationPhase.java:29)
 at 

org.seasar.teeda.core.lifecycle.AbstractPhase.execute(AbstractPhase.java:57)
 at 

org.seasar.teeda.core.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:97)
 at 
javax.faces.webapp.FacesServlet.service(FacesServlet.java:94)
 at 

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
 at 

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
 at 

org.seasar.framework.container.hotdeploy.HotdeployFilter.doFilter(HotdeployFilter.java:63)
 at 

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
 at 

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
 at 

org.seasar.framework.container.filter.S2ContainerFilter.doFilter(S2ContainerFilter.java:77)
 at 

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
 at 

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
 at 

org.seasar.extension.filter.EncodingFilter.doFilter(EncodingFilter.java:69)
 at 

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
 at 

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
 at 

org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
 at 

org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
 at 

org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
 at 

org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
 at 

org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
 at 

org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
 at 

org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
 at 

org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
 at 

org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
 at 

org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
 at 

org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
 at 
java.lang.Thread.run(Unknown Source)
Caused by: 
org.seasar.framework.exception.SSQLException: [ESSR0072]SQLで例外(SQL=[update 

userinfo set userid = ?, password = ?], Message=[0], ErrorCode=07006, 

SQLState={3})が発生しました
 at 

org.seasar.extension.jdbc.impl.PreparedStatementWrapper.wrapException(PreparedStatementWrapper.java:72)
 at 

org.seasar.extension.jdbc.impl.PreparedStatementWrapper.wrapException(PreparedStatementWrapper.java:67)
 at 

org.seasar.extension.jdbc.impl.PreparedStatementWrapper.setObject(PreparedStatementWrapper.java:607)
 at 
org.seasar.extension.jdbc.types.ObjectType.bindValue(ObjectType.java:64)
 at 

org.seasar.extension.jdbc.impl.BasicHandler.bindArgs(BasicHandler.java:193)
 ... 
58 more
Caused by: org.postgresql.util.PSQLException: Can't infer the SQL 
type to 
use for an instance of agnietec.entity.UserInfo. Use setObject() 
with an 
explicit Types value to specify the type to use.
 at 

org.postgresql.jdbc2.AbstractJdbc2Statement.setObject(AbstractJdbc2Statement.java:1735)
 at 

org.seasar.extension.jdbc.impl.PreparedStatementWrapper.setObject(PreparedStatementWrapper.java:605)
 ... 
60 more


今日の朝から、色々試行錯誤をしてみましたが、どうにも上手くいきません。
ご教授お願いいたします。


_________________________________________________________________
「ペットの悩み、みんなにきいたら解決した。」安心のペットライフにMSN相談箱
http://questionbox.msn.co.jp/c531.html
-------------- next part --------------
HTMLの添付ファイルを保管しました...
URL: http://ml.seasar.org/archives/seasar-user/attachments/20080115/09336e53/attachment-0001.html 


Seasar-user メーリングリストの案内