Win a copy of Design for the Mind this week in the Design 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)

 
Marcos Maia
Ranch Hand
Posts: 977
  • 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
  • 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)
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic