Meaningless Drivel is fun!*
The moose likes JDBC 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 Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "SQLException: ORA-01008" Watch "SQLException: ORA-01008" New topic
Author

SQLException: ORA-01008

cris abanades
Greenhorn

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(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

Joined: Jul 09, 2001
Posts: 1879

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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: SQLException: ORA-01008
 
Similar Threads
BLOB & Oracle
SQLException: ORA-01008
not logged on?
EJB 2.0 value larger than specified precision allows for this column
Select query in Servlet doGet()