Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

SQLException: ORA-01008

 
cris abanades
Greenhorn
Posts: 10
  • 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)
 
Jamie Robertson
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
sounds like you may not have set all your variables in a prepareStatement:
If you have a query with 2 ?'s like "select id, name from emp where age = ? and address = ?" and you only set one ? then not all variables will be bound. So check to make sure that substitution variables have been substituted (setString(), setInt() etc) for all your ? in your query
Jamie
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic