wood burning stoves 2.0*
The moose likes JDBC and the fly likes j2ee and AS400 Problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Reply locked New topic
Author

j2ee and AS400 Problem

Mercurio Savedra
Greenhorn

Joined: Dec 04, 2005
Posts: 25
Hi Friends

I write in this opportunity in order to explain my problem. I am working right now
in a J2EE application with a Web Tier (Struts ) and Ejb Tier (using BMP). The application is deployed in WAS 5.1 and the Database is DB2 over AS400.

Well I deployed the app in WAS and tested it with a single user and no problem everything was ok. Then I ran a Stress Test with 100 users and in System Err appear several times the following error

Row or object SPVPER in CPLAFVAC type *FILE in use

I am aware that the tables or rows are locked but I would like to obtain your feedback because I don�t know what could be the best practice here to avoid this problem, maybe some adjustment in the database or in the EJBs and This could be activities for the java developers or should be done for db2 DBA

Thanks lot friends
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3704
    
    5

Duplicate Post: http://www.coderanch.com/t/320077/EJB-JEE/java/ee-AS


My Blog: Down Home Country Coding with Scott Selikoff
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: j2ee and AS400 Problem