Meyyappan Meyyappan

I got an application with EJBs and Servlets, I got some entity and session bean.
I am getting often the below mentioned two exception and which stop the functioning of the application.
Let me explain the environment, we have WASv3.5.2, IBM Http Server v1.3.12 and oracle 8i database,
The exception is thrown at servlet level when calling a session bean method, the Transaction Attribute for the Session Bean is
TX_NOT_SUPPORTED and ISOLATION LEVEL IS TRANSACTION REPEATEABLE READ, for all other session beans we had TX_REQUIRED and ISOLATION LEVEL AS TRANSACTION_REPEATABLE READ those beans doesn't have any problem.
1)
java.rmi.ServerException: RemoteException occurred in server thread; nested exception is:
com.ibm.ejs.persistence.EJSPersistenceException: java.sql.SQLException: ORA-08177: can't serialize access for this transaction
; nested exception is:
java.sql.SQLException: ORA-08177: can't serialize access for this transaction

2)
javax.transaction.TransactionRolledbackException: CORBA TRANSACTION_ROLLEDBACK 0 No; nested exception is:
org.omg.CORBA.TRANSACTION_ROLLEDBACK: com.ibm.websphere.csi.CSITransactionRolledbackException:
I FOUND IN DOCUMENT, FOR ORACLE DATABASE Websphere won't support TRANSACTION REPEATABLE READ, can any one give solution for this problem, the application functions well when one user is accessing,when multiple user access the application then it gives problem after sometime that too not immediately.

I created all entity bean with a userid id USER1, and tested when I moved my code to another application server in different box, I am not able to deploy the bean and having a problem saying the userid not exist the reason is , the application server is pointing to different database with different user id saying USER2, how to do mapping of my entity to that USER2 instead of USER1.

Thanks Brown, I did copying of entire ide directory from other machine and renamed the prev. one as ide.old, My VAJ for java opened, but unfortunately I failed to save the project as version, But I managed with the directory copy of my project.
Any how thanks again for your help.

I am having 512 MB RAM

Hello I developed Lot Of Beans using VAJ, suddenly VAJ v3.5 got closed and its not opening and I am getting an Error as follows
Error 12 - Not Enough Memory
I am not able to open VAJ.
Is there any way to sort the problem or atleast get back my work in case of doing reinstallation work.
Thanks in Advance....

was v3.5

Hello,
In My custom finder I am trying to find entities based on some criteria. I want to order by clause in my where condition that I am specifying in finderhelper class, though I am specifying order by clause in where condition, my enumeration contains the objects in the same order in which it is present in Database.
Can any body help me out.....
My Custom findby static variable in FinderHelperClass is as follows...

public static final String findAllServicesQueryString = "SELECT * FROM CUSTOMER T1 WHERE 1 = 1 order by T1.SEQUENCENO"
Thanks in Advance

Hi,
Can any one help me to solve the below two problems in custom finder methods in WAS,
1. I want to specify the where clause query with two conditions, for eg.
Where T1.Value1=? and T1.Value2=?
say my table is having composite primary key, what will be the solution.
2. In ordinary custom finder to get all possible values I had given the condition like this
Where 1=1, which is fetching all beans as enumeration, but I want that enumeration in some specific order
for e.g like this "where 1=1 order by Customer_ID"
i had given like that but again my enumeration is having values in the actual order as in my table.
Thanks in advance

I am sorry Guy its not tools->workspace-> websphereTestenvironment menu
its actually workspace->tools-> websphereTestenvironment
sorry for the mistake....

Hi,
Add Your EJB Group to Server. Then Select the EJB Group and open the properties window, in that specify Data Source, Database Driver, User Id, Password.
For Oracle
Data Source: jdbc racle:thin:@YOURMACHINENAME:1521 rcl
Database Driver:
oracle.jdbc.driver.OracleDriver
if your using DB2 use correponding driver
After this Choose Tools->Workspace->Webspher Test Environment, WTE Window will open in that Choose Persistent Name Server, specify the above information in corresponding textboxes on right side, click apply and Click START NAME SERVER, minimize the current window and then go back to EJB Server Configuration Window, Choose your EJB Server and click run icon, now your EJB Server will be running, which is indicated by a run icon on the EJB Server.

Any problem still post it I will try to answer....