multi-user "adds" into db won't work

[sweetp]

I have an Access 2000 database on an NT server running iPlanet Server and using JSP. My web app (designed in Dreamweaver) lets users add a conference room reservation, delete, and view existing reservations.

When 2 users attempt to click Submit at the same time (to add a room reservation), the database dies.

I have record-locking in Access checked and also Default Record Locking set to: Edit Records.

Is there something with JSP and/or the ODBC driver that I need to do to have the database process multiple requests without crashing?

 

[Hattusas]

"When 2 users attempt to click Submit at the same time (to add a room reservation), the database dies"
What are the symptoms? Do you get a SQLException?or
nothing happens? Error code 500 in your browser?

Also do you commit your database record changes?

Salih Sipahi
Software Engineer.
City of Istanbul Turkey
s.sipahi@sahinlerholding.com.tr

 

[sedj]

How are you handling your Connection objects ? Are you trying to commit multiple Statements on a single Connection ?

 

[sweetp]

Yes, I'm getting an SQLException and then it says General Error.

 

[sedj]

And the answer to the other questions ...

and also a stack trace ...

 

[sweetp]

I'm not sure I understand what you are asking, by "committing multiple statements on a single connection".

The search page has an applet and the page sends a date and a time to the results page, which has 2 recordsets.

The results page shows the user that they requested a certain date and time and the SQL statement for recordset rsAvailableRooms searches the database to find all rooms that are not already taken at that time and filters them out and a drop-down box shows the available rooms to choose from (recordset 1). Then there's another drop-down box for them to select their name (recordset 2).

Also, I don't know how to do a stack trace.

Thanks for your help!

The search page (that passes the requested day and time) is an html page and doesn't open any connections. The results page opens 1 connection.

However, if the submit button on the search page is pressed simultaneously by 2 different people, that will cause the error.

Does this make any sense to you?