Very Computer

by **perseu** » Wed, 13 Mar 2002 21:06:28

Hi all, I've got a function like this

public double getSectionTotalManday(Connection conn, String section,
String sub_section,

GregorianCalendar ReqPeriod,
String reportsTo) throws SQLException {
StringBuffer sqlBuffer = new StringBuffer(1024);

sqlBuffer.append("SELECT * FROM EA_MR_DTL_TBL dtl ");
sqlBuffer.append("WHERE dtl.SECTION = ? ");

PreparedStatement stmt =
conn.prepareStatement(sqlBuffer.toString());
int i = 0;
stmt.setString(++i, section);

ResultSet rslt = stmt.executeQuery(sqlBuffer.toString());
return -1;
}

working with table EA_MR_DTL_TBL {
...
section VARCHAR2(5) NOT NULL,
...

Quote:}

but when I do call this in JSP , I got ORA-01008: not all variables bound .

Why's that ? Thanks .

Perseus

by **Lee Fesperma** » Thu, 14 Mar 2002 09:17:44

> Hi all, I've got a function like this

> public double getSectionTotalManday(Connection conn, String section,
> String sub_section,

> GregorianCalendar ReqPeriod,
> String reportsTo) throws SQLException {
> StringBuffer sqlBuffer = new StringBuffer(1024);

> sqlBuffer.append("SELECT * FROM EA_MR_DTL_TBL dtl ");
> sqlBuffer.append("WHERE dtl.SECTION = ? ");

> PreparedStatement stmt =
> conn.prepareStatement(sqlBuffer.toString());
> int i = 0;
> stmt.setString(++i, section);

> ResultSet rslt = stmt.executeQuery(sqlBuffer.toString());

Use instead:

ResultSet rslt = stmt.executeQuery();

Note: the prepareStatement() has already received and prepared the sql comand.

Quote:> return -1;
> }

> working with table EA_MR_DTL_TBL {
> ...
> section VARCHAR2(5) NOT NULL,
> ...
> }

> but when I do call this in JSP , I got ORA-01008: not all variables bound .

> Why's that ? Thanks .

You're using the wrong version of executeQuery().

--
Lee Fe*an, FFE Software, Inc. (http://www.veryComputer.com/)
==============================================================
* The Ultimate DBMS is here!
* FirstSQL/J Object/Relational DBMS (http://www.veryComputer.com/)

by **Avi Abram** » Thu, 14 Mar 2002 11:07:02

> Hi all, I've got a function like this

> public double getSectionTotalManday(Connection conn, String section,
> String sub_section,

> GregorianCalendar ReqPeriod,
> String reportsTo) throws SQLException {
> StringBuffer sqlBuffer = new StringBuffer(1024);

> sqlBuffer.append("SELECT * FROM EA_MR_DTL_TBL dtl ");
> sqlBuffer.append("WHERE dtl.SECTION = ? ");

> PreparedStatement stmt =
> conn.prepareStatement(sqlBuffer.toString());
> int i = 0;
> stmt.setString(++i, section);

> ResultSet rslt = stmt.executeQuery(sqlBuffer.toString());
> return -1;
> }

> working with table EA_MR_DTL_TBL {
> ...
> section VARCHAR2(5) NOT NULL,
> ...
> }

> but when I do call this in JSP , I got ORA-01008: not all variables bound .

> Why's that ? Thanks .

> Perseus

Hi Perseus,
Just a wild guess, but maybe the value of your method parameter
"section" is null?

Good Luck,
Avi.