Unexpected Exception
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