>>javahead 님께서 쓰시길<<

:: ===========================

:: 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)

query문을 안올려 주셔서 잘은 모르겠지만 select ~~~~ from 의 ~~~~부분에 또 다른 select 문이 들어가있으면 oracle8에서는 인식을 못한다는 군요.