File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes BEA/Weblogic and the fly likes SQLException: ORA-01008 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » BEA/Weblogic
Bookmark "SQLException: ORA-01008" Watch "SQLException: ORA-01008" New topic

SQLException: ORA-01008

cris abanades

Joined: Aug 30, 2001
Posts: 10
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(
at oracle.jdbc.ttc7.TTIoer.processError(
at oracle.jdbc.ttc7.Oall7.receive(
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(
at oracle.jdbc.driver.OracleStatement.executeQuery(
at weblogic.jdbc.pool.Statement.executeQuery(
at weblogic.jdbc.rmi.internal.StatementImpl.executeQuery(
at weblogic.jdbc.rmi.SerialStatement.executeQuery(
at src.ges_dbc.User.exists(
at src.servlet.mainServlet.redireccion(
at src.servlet.mainServlet.doGet(
at javax.servlet.http.HttpServlet.service(
at javax.servlet.http.HttpServlet.service(
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(
at weblogic.servlet.internal.ServletRequestImpl.execute(
at weblogic.kernel.ExecuteThread.execute(

Marcos Maia
Ranch Hand

Joined: Jan 06, 2001
Posts: 977
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.
[This message has been edited by Marcos Maia (edited November 21, 2001).]
Vijay Shrivastava
Ranch Hand

Joined: Nov 15, 2001
Posts: 64
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.

Vijay shrivastava
I agree. Here's the link:
subject: SQLException: ORA-01008
It's not a secret anymore!