Valiente Francoise | 2007-10-17 13:12:45.0 | |
| Hi,
I 've update datas in MS Access via JDBC with a Java TestCase. All was OK Today I try to update datas with a Struts Action and I get theses errors : Hibernate: update TVisitable set VisCanId=?, VisStaId=?, VisRef1Id=?, VisRef2Id=?, VisRef3Id=?, VisRef4Id=?, VisRef5Id=?, VisAlpha=?, VisNom=?, VisPrenom=?, VisMatricule=?, VisSitFam=?, VisCode=?, VisNumBadge=?, VisLibre1=?, VisLibre2=?, VisLibre3=?, VisLibre4=?, VisLibre5=?, VisLibre6=?, VisLibre7=?, VisLibre8=?, VisLibre9=?, VisZoneLibre=?, VisEmail=?, VisPhoto=?, VisPresence=?, VisPresPhoto=?, VisBoolLibre1=?, VisBoolLibre2=?, VisDateLibre1=?, VisDateLibre2=?, VisDateLibre3=?, VisDateModif=?, VisDateCreation=?, VisNombreBadge=?, VisDateFabBadge=?, VisRangBadge=?, VisPhotoCache=?, Visref1Id=? where VisId=? WARN - SQL Error: 393216, SQLState: 60000 ERROR - java.sql.SQLException: Failed to upgrade the access mode of TVisitable table from "r" to "rw" WARN - SQL Error: 393216, SQLState: 60000 ERROR - Failed to upgrade the access mode of TVisitable table from "r" to "rw" WARN - SQL Error: 393216, SQLState: 60000 ERROR - Failed to upgrade the access mode of Client table from "r" to "rw" WARN - SQL Error: 393216, SQLState: 60000 ERROR - java.io.FileNotFoundException: T:\Client.mdb (Acc��s refus��) ERROR - Could not synchronize database state with session org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:82) at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:70) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:181) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:226) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:137) at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:274) at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27) at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:730) at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:324) at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:86) at com.ide.bean.IdeBusinessBean.updateTVisitable(IdeBusinessBean.java:178) at com.helisim.cash.actions.BadgeCreationViewAction.execute(BadgeCreationViewAction.java:161) at org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:58) at org.apache.struts.chain.commands.AbstractExecuteAction.execute(AbstractExecuteAction.java:67) at org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51) at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190) at org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:304) at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190) at org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462) at javax.servlet.http.HttpServlet.service(HttpServlet.java:709) 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 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:524) 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:869) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) 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(Unknown Source) Caused by: java.sql.BatchUpdateException: java.sql.SQLException: Failed to upgrade the access mode of TVisitable table from "r" to "rw" at com.hxtt.sql.de.executeBatch(Unknown Source) at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:57) at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:174) ... 35 more Can you help me? Thanks. Françoise | ||
HXTT Support | 2007-10-17 18:30:58.0 | |
| >ERROR - Failed to upgrade the access mode of Client table from "r" to "rw"
>WARN - SQL Error: 393216, SQLState: 60000 >ERROR - java.io.FileNotFoundException: T:\Client.mdb (Acc��s refus��) It seems that you're using net share driver? HXTT Access failed to find t:\Client.mdb when it tried to use "rw" mode for Client.mdb file. Whether your network speed is too slow or you haven't write right on that file? | ||
valiente francoise | 2007-10-18 01:38:35.0 | |
| Thanks for your response about my access pb. In effect, It was write right on the file.
It was due to a change of server. Best Regards F. Valiente | ||