Prepares Statement : Shared Memory error

[vikram nalagampalli]

Hi all
i am trying to use the following Prepared statement for an Update statement. when i am executing this, SQL server 2000 gives me an error saying some shared memory.
The question is is it possible to use update query with prepared statement.
My code is as follows
<%@ page import="java.sql.*" %>
<%@ page import="java.util.*" %>
<%@ page import="java.lang.*" %>
<%@ page import="java.lang.String" %>
<%@ page import="java.io.*" %>
<%@ page import="resume1.Resume" %>
<%@ page session="true"%>
<jsp:useBean id="r"
class="resume1.Resume" scope="request"/>

<%String driver =
"sun.jdbc.odbc.JdbcOdbcDriver";
String url = "jdbc dbc:Resume";
String userId =
(String)session.getAttribute("Ssn");
Class.forName(driver);
Connection con=null;
try{
con=DriverManager.getConnection(url);


String st= "UPDATE resume SET
StreetAddress=?,City=?,State=?,Zip=?,Coun
try=?,Email=?,Phone=?,Fax=?,Objective=?,S
chool1=?,City1=?,State1=?,GraduationYear1
=?,Major1=?,Gpa1=?,School2=?,City2=?,Stat
e2=?,GraduationYear2=?,Major2=?,Gpa2=?,Em
ployerName1=?,JobTitle1=?,JobDescription1
=?,From1=?,To1=?,EmployerName2=?,JobTitle
2=?,JobDescription2=?,From2=?,To2=?,Emplo
yerName3=?,JobTitle3=?,JobDescription3=?,
From3=?,To3=?,platforms=?,programming=?,d
atabaseSkills=?,other=?,Activities=?,Achi
evements=?,Languages=?,Name1=?,Title1=?,C
ompanyName1=?,Address1=?,Phone1=?,Name2=?
,Title2=?,CompanyName2=?,Address2=?,Phone
2=?,Name3=?,Title3=?,CompanyName3=?,Addre
ss3=?,Phone3=? WHERE Ssn="+userId;

PreparedStatement
pstmt=con.prepareStatement(st);

pstmt.setString(1,r.getStreetAddress());
pstmt.setString(2,r.getCity());
pstmt.setString(3,r.getState());
pstmt.setString(4,r.getZip());
pstmt.setString(5,r.getCountry());
pstmt.setString(6,r.getEmail());
pstmt.setString(7,r.getPhone());
pstmt.setString(8,r.getFax());
pstmt.setString(9,r.getObjective());
pstmt.setString(10,r.getSchool1());
pstmt.setString(11,r.getCity1());
pstmt.setString(12,r.getState1() );
pstmt.setString(13,r.getGraduationYear1()
);
pstmt.setString(14,r.getMajor1() );
pstmt.setString(15,r.getGpa1() );
pstmt.setString(16,r.getSchool2());
pstmt.setString(17,r.getCity2() );
pstmt.setString(18,r.getState2() );
pstmt.setString(19,r.getGraduationYear2()
);
pstmt.setString(20,r.getMajor2() );
pstmt.setString(21,r.getGpa2() );

pstmt.setString(22,r.getEmployerName1()
);
pstmt.setString(23,r.getJobTitle1() );
pstmt.setString(24,r.getJobDescription1()
);
pstmt.setString(25,r.getFrom1() );
pstmt.setString(26,r.getTo1() );
pstmt.setString(27,r.getEmployerName2()
);
pstmt.setString(28,r.getJobTitle2() );
pstmt.setString(29,r.getJobDescription2()
);
pstmt.setString(30,r.getFrom2() );
pstmt.setString(31,r.getTo2() );
pstmt.setString(32,r.getEmployerName3()
);
pstmt.setString(33,r.getJobTitle3() );
pstmt.setString(34,r.getJobDescription3()
);
pstmt.setString(35,r.getFrom3() );
pstmt.setString(36,r.getTo3() );
pstmt.setString(37,r.getPlatforms() );
pstmt.setString(38,r.getProgramming() );
pstmt.setString(39,r.getDatabaseSkills()
);
pstmt.setString(40,r.getOther() );
pstmt.setString(41,r.getActivities() );
pstmt.setString(42,r.getAchievements() );
pstmt.setString(43,r.getLanguages() );
pstmt.setString(44,r.getName1() );
pstmt.setString(45,r.getTitle1() );
pstmt.setString(46,r.getCompanyName1() );
pstmt.setString(47,r.getAddress1() );
pstmt.setString(48,r.getPhone1() );

pstmt.setString(49,r.getName2() );
pstmt.setString(50,r.getTitle2() );
pstmt.setString(51,r.getCompanyName2() );
pstmt.setString(52,r.getAddress2() );
pstmt.setString(53,r.getPhone2() );

pstmt.setString(54,r.getName3() );
pstmt.setString(55,r.getTitle3() );
pstmt.setString(56,r.getCompanyName3() );
pstmt.setString(57,r.getAddress3() );
pstmt.setString(58,r.getPhone3() );
pstmt.executeUpdate();

pstmt.close();
pstmt=null;
}finally {

if(con!=null) {
con.close();
}
}
%>
<jsp:forward page="Welcome1.jsp"/>