This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
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

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
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
Similar Threads
Select query in Servlet doGet()
SQLException: ORA-01008
EJB 2.0 value larger than specified precision allows for this column
BLOB & Oracle
not logged on?