Unexpected Exception
Posted by: Chris Täubler
Date: December 03, 2004 07:29AM

Hello i have a problem with mySQL ( 3.23.58. and 4.0.20) JDBC 3.14 and JDBC 3.16

i use preparedStatements to Update, ... the db, but since today the questionmark seems to be errounous????

has anyone got an exception like this???? (my own exception handling outputs the Statement like you can see):


dbTool.exception.DbSqlException: SQL error [SQL error [executeNonQuery (): [UPDATE ImmoObjekt SET idImmoObjekt=?,Sauna=?,Pool=?,FkHaus=?,CD=?,MD=?,DK=?,Balkon=?,Loggia=?,Garten=?,Terrasse=?,Miettyp=?,Groesse=?,AnzahlZimmer=?,BezugsfertigAb=?,MietKosten=?,Titel=?,Beschreibung=?,Stockwerk=? WHERE idImmoObjekt = 20]Syntax error or access violation, message from server: "You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '?,Sauna=?,Pool=?,FkHaus=?,CD=?,MD=?,DK=?,Balkon=?,Loggia=?,Gart"] state [42000]] state [42000] at dbTool.base.BaseTableObject.update(BaseTableObject.java:445) at util.HPDbController.setImmo(HPDbController.java:242) at hp.HPAbfrageServlet.doPostSetImmo(HPAbfrageServlet.java:408) at hp.HPAbfrageServlet.doPost(HPAbfrageServlet.java:217) at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:260) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext

Options: ReplyQuote


Subject
Written By
Posted
Unexpected Exception
December 03, 2004 07:29AM
December 03, 2004 09:56AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.