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
|
>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?
|
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
|
Main
webmaster@hxtt.com