السلام عليكم ورحمة الله وبركاته الى جميع مبرمجي لغة JSP
انا الان اطور برنامج يستخدم الاجاكس في عملية ادخال البيانات الى قاعدة البيانات :-
function salvaVeicolo()
{
var req = new XMLHttpRequest();
var handlerFunction = getReadyStateHandler(req, saveResult);
req.onreadystatechange = handlerFunction;
req.open("POST", "../DettaglioVeicoloServlet.do", true);
req.setRequestHeader("Content-Type","application/x-www-form-urlencoded");
req.send("action=save&xml="+getXMLVeicolo());
}
علما بان الامر في الاعلى هو الكود الذي يستدعي ملف الاكسمل الذي يقوم بأخذ البيانات من الشاشه ومن ثم نعمل بارسنج للكمل فايل
var xml ="<root>";
xml+=" <targa>"+document.getElementById("anaTarga").value+"</targa>";
xml+=" <anagrafica>";
الخ ...................................
الان وعند عملية ادخال البيانات بالعربي يتم ظهور هذا الخطاء ما المشكله لا اعلم علما بانني استخدم برنامج eclipse
وفي حال تغير خصائص البرنامج الى ان تقبل بيئته بشكل عام UTF-8 فان عملية ادخال البيانات تنجح ولكن عن عملية انشاء ملف
WAR
واقوم بتشغيل برنامج catalina form DOS
فأن عملية الادخال تفشل الا ان عملية استرجاع البيانات تنجح بشكل رائع وحتى لو كانت عربي
لكن المشكله في ادخال البيانات بالعربي
يرجى المساعده
الخطا
com.sun.org.apache.xerces.internal.impl.io.MalformedByteSequenceException: Invalid byte 1 of 1-byte UTF-8 sequence.
at com.sun.org.apache.xerces.internal.impl.io.UTF8Reader.invalidByte(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.io.UTF8Reader.read(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLEntityScanner.load(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLEntityScanner.skipChar(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocum
ent(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.DOMParser.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderImpl.parse(Unknown Source)
at javax.xml.parsers.DocumentBuilder.parse(Unknown Source)
at geflo.data.application.servlet.DettaglioVeicoloServlet.parse(DettaglioVeicoloSer
vlet.java:74)
at geflo.data.application.servlet.DettaglioVeicoloServlet.doPost(DettaglioVeicoloSe
rvlet.java:53)
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(ApplicationFilt
erChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.
java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:2
13)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:1
78)
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:868)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:663)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:52
7)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorker
Thread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Unknown Source)
Insert SQL 1 : INSERT INTO veicoli
java.sql.SQLException: 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 '' at line 1"
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1905)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1109)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1203)
at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1164)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2087)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2037)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1252)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1198)
at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeUpdate(DelegatingStatemen
t.java:225)
at geflo.data.database.dao.DAOVeicoli.insertVO(DAOVeicoli.java:673)
at geflo.data.application.dao.BOVeicoli.salvaVeicolo(BOVeicoli.java:24)
at geflo.data.application.servlet.DettaglioVeicoloServlet.doPost(DettaglioVeicoloSe
rvlet.java:53)
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(ApplicationFilt
erChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.
java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:2
13)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:1
78)
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:868)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:663)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:52
7)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorker
Thread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Unknown Source)
