File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

SQLException: ORA-01008

 
cris abanades
Greenhorn
Posts: 10
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm using Weblogic 6.1 and when I'm going to connect to the database throws this exception:
java.sql.SQLException: ORA-01008: not all variables bound
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:643)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:1674)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1870)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:538)
at weblogic.jdbc.pool.Statement.executeQuery(Statement.java:850)
at weblogic.jdbc.rmi.internal.StatementImpl.executeQuery(StatementImpl.java:79)
at weblogic.jdbc.rmi.SerialStatement.executeQuery(SerialStatement.java:80)
at src.ges_dbc.User.exists(User.java:526)
at src.servlet.mainServlet.redireccion(mainServlet.java:239)
at src.servlet.mainServlet.doGet(mainServlet.java:102)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:263)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:200)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:2390)
at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:1959)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:137)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120)

 
Marcos Maia
Ranch Hand
Posts: 977
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
Looks like you�re not providing some parameter your statement requires, something like your query requires 5 parameters and you�re only providing 4 parameters from your servlet.
If you don�t find the error, you may post the code so we can provide you a better help.
regards.
[This message has been edited by Marcos Maia (edited November 21, 2001).]
 
Vijay Shrivastava
Ranch Hand
Posts: 64
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The answer posted by Marcos Maia looks right if you are tring to execute some statement or stored procedure.
Could you explain what do you mean by
I'm using Weblogic 6.1 and when I'm going to connect to the database throws this exception:
Are you trying to get connection if so are you using ConnectionPool and Data sources?
I could not agree any more Marcos Maia please provide more input to get help.

------------------
Vijay shrivastava
Consultant - ObjectNetTechnologies ,Atlanta USA.
SCJP2, SCJEA (Part I)
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic