aspose file tools*
The moose likes Servlets and the fly likes Servlet, JSP and access violation 0xc 0000005 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 » Java » Servlets
Bookmark "Servlet, JSP and access violation 0xc 0000005" Watch "Servlet, JSP and access violation 0xc 0000005" New topic
Author

Servlet, JSP and access violation 0xc 0000005

Anonymous
Ranch Hand

Joined: Nov 22, 2008
Posts: 18944
I am designing a shopping cart using servlets, jsp pages and jdbc. I am conducting test on a windows NT server with Tomcat and an Access database.
Each time I succeed to write a new field in the tables 'sysgen' and 'client', it generates an error with java.exe:
Exception: access violation Oxc 0000005
Address: 0x1f43b3f0
Could you help me?
Here is my code:
public class CheckOut extends HttpServlet {
private String databaseUrl;
private Connection connection;

public void init(ServletConfig config) throws ServletException {
super.init(config);
databaseUrl = "jdbc dbc:testlit";
connection = null;
try
{
String driverName = "sun.jdbc.odbc.JdbcOdbcDriver";
Class.forName(driverName).newInstance();
}
catch ( Exception e )
{
throw new ServletException("Failed to load driver" + e.getMessage());
}
}

public void doGet(HttpServletRequest request,
HttpServletResponse response)
throws ServletException, IOException {
HttpSession session = request.getSession(true);
ShoppingCart cart;
ResultSet result;
long itemID;
long oiTable;
long oiClient;
// String updateTemplate = "INSERT into literature (oi, itemid, description, numitems) VALUES (?, ?, ?, ?)";
synchronized(session) {
cart = (ShoppingCart)session.getValue("shoppingCart");
Vector itemsOrdered = cart.getItemsOrdered();
if (itemsOrdered.size() == 0) {
System.out.println("No items in your cart...");
} else {
// If there is at least one item in cart, save it into the database
ItemOrder order;
try
{
connection = DriverManager.getConnection(databaseUrl, "", "");
// connection.setAutoCommit(false);
Statement oiStatement = connection.createStatement();
result = oiStatement.executeQuery("SELECT litId FROM sysgen");
if (!result.next()) {
throw new ServletException("Failed to generate id.");
}
oiTable = result.getLong(1);
oiTable++;
result.next();
oiClient = result.getLong(1);
oiClient++;
oiStatement.close();
String titre = request.getParameter("titre");
titre = replaceIfMissing(titre, "not entered");
String prenom = request.getParameter("prenom");
prenom = replaceIfMissing(prenom, "not entered");
String nom = request.getParameter("nom");
nom = replaceIfMissing(nom, "not entered");
String address = request.getParameter("address");
address = replaceIfMissing(address, "not entered");
String city = request.getParameter("city");
city = replaceIfMissing(city, "not entered");
String zip = request.getParameter("zip");
zip = replaceIfMissing(zip, "not entered");
String country = request.getParameter("country");
country = replaceIfMissing(country, "not entered");
String states = request.getParameter("states");
states = replaceIfMissing(states, "not entered");
String phonenumber = request.getParameter("phonenumber");
phonenumber = replaceIfMissing(phonenumber, "not entered");
String faxnumber = request.getParameter("faxnumber");
faxnumber = replaceIfMissing(faxnumber, "not entered");
String email = request.getParameter("email");
email = replaceIfMissing(email, "not entered");
Statement clstmt = connection.createStatement();
clstmt.executeUpdate("INSERT into client " +
"(idclient, titre, prenom, nom, address, city, zip, country, states, phonenumber, faxnumber, email) " +
"VALUES (" + oiClient +", '" + titre +
"', '" + prenom +
"', '" + nom +
"', '" + address +
"', '" + city +
"', '" + zip +
"', '" + country +
"', '" + states +
"', '" + phonenumber +
"', '" + faxnumber +
"', '" + email + "')");
clstmt.close();
Statement pmt = connection.createStatement();
pmt.executeUpdate("UPDATE sysgen SET litId = " + oiClient +" WHERE sysId = 2");
pmt.close();
Statement stamt = connection.createStatement();
for(int i=0; i<itemsOrdered.size(); i++) {
order = (ItemOrder)itemsOrdered.elementAt(i);
itemID = Long.parseLong(order.getItemID());
stamt.executeUpdate("INSERT into literature " +
"(oi, itemid, description, numitems, idclient) " +
"VALUES (" + oiTable +"," + itemID +", '" +
order.getShortDescription() +"'," + order.getNumItems() +"," + oiClient +")");
oiTable++;
}

stamt.close();
Statement stmt = connection.createStatement();
stmt.executeUpdate("UPDATE sysgen SET litId = " + oiTable +" WHERE sysId = 1");
stmt.close();
connection.close();
}
catch ( SQLException e )
{
System.out.println("Error executing statement");
}
}
}
gotoPage("/merci.jsp", request, response);
}
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Servlet, JSP and access violation 0xc 0000005
 
Similar Threads
passing hidden forms problem
I know what to do but don't know how to implement it..
Storing of Data
session tracking remove item (urgent)
How To Convert a Servlet File to a JSP File