You need to use a Callable statement when invoking a stored procedure.
Raj
Joe Oh Heekyu wrote:
> Hi, everyone (or whom may it concern).
> I'm using one servlet that connect to DB SQL Server7.0.
> Inside that servlet, I'm calling several Stored procedures.
> At the specific stored procedure(getTest), I keep getting the following
> error messages:
>
> SQL State(By getSQLState() method) : null
> Message(By getMessage() method) : I/O Exception while talking to the server,
> java.io.EOFException: TdsInputStream.readByte
> Vendor(By getErrorCode()method) : 0
>
> The below is my code:
> ========================================
> try
> {
> int nCountEmail = 0;
> String sTest = "";
> Statement st = dbConn.createStatement();
> String sql = "execute getValidEmail '" + sReplyEmail + "'";
> //<-- it's working
> trace(sql);
> rs = st.executeQuery(sql);
>
> boolean bValidEmail = (rs != null && rs.next());
>
> if (bValidEmail)
> nCountEmail = rs.getInt(1);
>
> st.close();
> st = null;
>
> if (nCountEmail != 1)
> response.sendRedirect(sPrevURL);
> else
> {
> st = dbConn.createStatement();
> sql = "execute getTest '" + sReplyEmail + "'"; //<-- The
> error message occurs here!!!
> rs = st.executeQuery(sql);
>
> boolean bValid = (rs != null && rs.next());
>
> if (bValid)
> sTest = rs.getString("FirstName");
>
> st.close();
> st = null;
>
> out.println("sTest : " + sTest );
> }
> catch(SQLException sqle)
> {
> processSQLException(sqle);
> }
> ========================================
>
> My Environment:
> OS : Microsoft Windows NT Server
> Web Server : IIS with ServletExec2.2 (from New Atlanta)
> DB Server : MS SQL Server7.0
> DB driver class : WebLogic licensed DB driver
>
> Please help.
> Thanks.
>
> Joe Oh Heekyu
>
> ___________________________________________________________________________
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
