|
이경록님이 말씀하신대로인거 같습니다.
진심으로 감사드립니다.
>>이경록 님께서 쓰시길<<
::
:: >>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에서는 인식을 못한다는 군요.
|
