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
