Geek Answers Handbook

How to set up concurrent calls in Oracle 10g Java VM

If someone can explain to me how to properly configure the plsql java shell when different database users refer to the same procedure in order to ensure proper parallel processing of access to resources.

DBMS and JAVA: Oracle 10g, Internal JavaVM 1.4.2

I have a MyDatabse with 1 shema owner and 10 db users provided to connect to it:
DBOWNER
DBUSER01
DBUSER02
...
DBUSER10

I have a PL / SQL wrapper procedure: my_package.getUser () that wraps UserHandler.getUser ()

I have a UserHandler Java class loaded into MyDatabase using loadjava:

public class UserHandler {
    private static final int MAX_USER_COUNT = 10;
    private static final String USERNAME_TEMPLATE = "EIS_ORA_20";
    private static int currentUserSeed = 0;
    /**
    * Generates EIS user according to pattern agreed by EIS developers. It
    * circles user pool with round-robin method ensuring concurrent calls.
    * 
    * @return valid EIS USERNAME
    */
    synchronized public static String getUser() {
        String newUser = USERNAME_TEMPLATE + currentUserSeed;    
        currentUserSeed++;    
        currentUserSeed = currentUserSeed % MAX_USER_COUNT;    
        return newUser;    
    }    
}

DBUSERS, MyDatabase Oracle Forms Client.

, , 5 my_package.getUser(), :

DBUSER01 - my_package.getUser() EIS_ORA_200
DBUSER02 - my_package.getUser() EIS_ORA_200
DBUSER03 - my_package.getUser() EIS_ORA_200
DBUSER04 - my_package.getUser() EIS_ORA_200
DBUSER05 - my_package.getUser() EIS_ORA_200

, DBUSER ( JUnit, UserHandler.getUser()). , plsql 2- :

  • Java DBUSERS
  • DBUSER

, UserHandler DBUSER , .

MyDatabase, my_package.getUser() java DBUSER?

!

+5
1

, - Oracle JVM . Java 10g:

JVM Oracle

Java , , Java- JVM...

, - . Oracle 1, maxvalue 10 . Java-.

1 10. , .

+2

More articles:


All Articles