===========================
OS : win2000 professional =
oracle for nt 8.0.5 =
========================= =
win2000pro에서 게시판을 돌리고, 리눅스에 설치된 (오라클8i)로 연동을 하면 게시판이 잘 돌아갑니다.
그런데, 같은 컴에 깔려있는 오라클(8.0.5)와 JSP를 연동해서 시험을 하면 게시판이 아래와 같은 에러 메세지가 뜹니다.
리눅스와 연동해서 사용하던거라 분명 에러코드는 없다고 장담할 수 있습니다.
jdbc드라이브도 classes12.zip를 사용하고 있습니다.
ORA-00936 <== 메세지는 어떨때 나타는 것인지요? 꼭 부탁드립니다. 오늘로써 3일째 헤매고 있습니다.. ㅠㅠ
=============================================================================
java.sql.SQLException: ORA-00936: 식이 없습니다
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:542)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1311)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:738
)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.ja
va:1313)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.jav
a:1232)
at oracle.jdbc.driver.OracleStatement.doExecuteWithBatch(OracleStatement
.java:1353)
at oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.java:176
0)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
nt.java:1805)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePrepar
edStatement.java:320)
at PDatabase.runUpdate(PDatabase.java:89)
at basicboard._0002fbasicboard_0002fboardReplyEnd_0002ejspboardReplyEnd_
jsp_0._jspService(_0002fbasicboard_0002fboardReplyEnd_0002ejspboardReplyEnd_jsp_
0.java:227)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspSer
vlet.java:177)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:2
96)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:369)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:3
68)
at org.apache.tomcat.core.Handler.service(Handler.java:261)
at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:356
)
at org.apache.tomcat.core.ContextManager.internalService(ContextManager.
java:720)
at org.apache.tomcat.core.ContextManager.service(ContextManager.java:666
)
at org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processCon
nection(Ajp12ConnectionHandler.java:166)
at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:
403)
at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java
:498)
at java.lang.Thread.run(Unknown Source)
|