aspose file tools*
The moose likes Websphere and the fly likes Deploy EJB(CMP) on WebSphere3.5.2 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Websphere
Bookmark "Deploy EJB(CMP) on WebSphere3.5.2" Watch "Deploy EJB(CMP) on WebSphere3.5.2" New topic
Author

Deploy EJB(CMP) on WebSphere3.5.2

Christine Li
Greenhorn

Joined: Sep 25, 2001
Posts: 9
Hi, Could anyone help? I deployed my EJB on WebSphere3.5.2. But I had error whenever I want to start the application server.
22/11/01 6:06 PM : WARNING [ICT524Q/__adminServer]: ADMS0062W: Failed to initialize a server: "MilosServer" com.ibm.ejs.sm.exception.ActiveObjectInitException
----- Begin backtrace for subexception[0]
COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] CLI0119E Unexpected system failure. SQLSTATE=58004
----- Begin backtrace for subexception[1]
COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] SQL30090N Operation invalid for application execution environment. Reason code = "06". SQLSTATE=25000
Kyle Brown
author
Ranch Hand

Joined: Aug 10, 2001
Posts: 3892
    
    5
From the DB2 Information Center (which ships with DB2) you can find the following information:
SQL30090N Operation invalid for application execution environment. Reason code = "<reason-code>"
Explanation: The operation is invalid for the application execution environment. For example, an operation might be invalid for applications that have special restrictions on statements or APIs - applications such as those that operate in an XA Distributed Transaction Processing environment, such as CICS; those that operate with CONNECT type 2 connection settings; or those that use federated system functionality to update multiple heterogeneous data sources. The operation was rejected.
Possible reason codes are:
...
06 - The SET CLIENT API was issued in an XA/DTP environment.

My guess is that there's something wrong with the setup of the DataSource (and/or database driver) that you're using as the default datasource for this CMP bean.
For instance, have you set your DB2 driver as "JTA Enabled"? If so there are additional steps that you have to follow to allow your driver to successfully use JTA -- consult the WebSphere documentation for details.
BTW, most of the time you do NOT need to enable JTA -- that's only the case when you need 2-phase commit transactions crossing multiple databases or a database and MQ Series...
Kyle

------------------
Kyle Brown,
Author of Enterprise Java (tm) Programming with IBM Websphere
See my homepage at http://members.aol.com/kgb1001001 for other WebSphere information.


Kyle Brown, Author of Persistence in the Enterprise and Enterprise Java Programming with IBM Websphere, 2nd Edition
See my homepage at http://www.kyle-brown.com/ for other WebSphere information.
Christine Li
Greenhorn

Joined: Sep 25, 2001
Posts: 9
Hi, Kyle
Thank you very much for your help. I changed the setting for my datasource from JTA Enable to JTA False. Now my EJB works.
I have another question about WebSphere 3.5.2. I have WebSphere3.5.2 installed on two machines. Under the directory: websphere/appserver/lib, there are not the same number of files. On the machine, I installed there are only some jar, zip files and two .sec files. However, on the other machine, there are some xml and properties files. Could you tell me what I should have under /lib directory? The size of Xerces.jar file are different too.
I feel really confused, since I deployed the same EJB on both machines, the setting are not the same. As I mentioned on the first machine I changed JTA - false then EJB works. But on the other machine, the setting for default database is JTA-Enable. I didn't add any other additional steps. Could you tell How I can make sure the installation of WebSphere3.5.2 is correct? I do appreciate your help!
Regards,
Christine
Originally posted by Kyle Brown:
From the DB2 Information Center (which ships with DB2) you can find the following information:
[b]SQL30090N Operation invalid for application execution environment. Reason code = "<reason-code>"
Explanation: The operation is invalid for the application execution environment. For example, an operation might be invalid for applications that have special restrictions on statements or APIs - applications such as those that operate in an XA Distributed Transaction Processing environment, such as CICS; those that operate with CONNECT type 2 connection settings; or those that use federated system functionality to update multiple heterogeneous data sources. The operation was rejected.
Possible reason codes are:
...
06 - The SET CLIENT API was issued in an XA/DTP environment.

My guess is that there's something wrong with the setup of the DataSource (and/or database driver) that you're using as the default datasource for this CMP bean.
For instance, have you set your DB2 driver as "JTA Enabled"? If so there are additional steps that you have to follow to allow your driver to successfully use JTA -- consult the WebSphere documentation for details.
BTW, most of the time you do NOT need to enable JTA -- that's only the case when you need 2-phase commit transactions crossing multiple databases or a database and MQ Series...
Kyle

[/B]

pdiaz
Greenhorn

Joined: Oct 15, 2002
Posts: 2
Hi,
We are using WSAD4.03 test environment with WAS4.0 , JTA, DB2, operating system Windows 2000. We are trying to access to the database using:
javax.sql.XADataSource ds = (javax.sql.XADataSource)ctx.lookup("jdbc/myDSName")
and we get the following exception:: "java.lang.ClassCastException: com.ibm.ejs.cm.JDBC1PhaseRF"
In WSAD4.03 we have added a new driver with the class com.ibm.db2.jdbc.DB2XADatasource and we have defined a datasource with JTA option enabled. We have also checkec we use JDBC2.0.
Any help would be really apreciated
Thanks!
Paula
Kyle Brown
author
Ranch Hand

Joined: Aug 10, 2001
Posts: 3892
    
    5
Originally posted by pdiaz:
Hi,
We are using WSAD4.03 test environment with WAS4.0 , JTA, DB2, operating system Windows 2000. We are trying to access to the database using:
javax.sql.XADataSource ds = (javax.sql.XADataSource)ctx.lookup("jdbc/myDSName")
and we get the following exception:: "java.lang.ClassCastException: com.ibm.ejs.cm.JDBC1PhaseRF"
In WSAD4.03 we have added a new driver with the class com.ibm.db2.jdbc.DB2XADatasource and we have defined a datasource with JTA option enabled. We have also checkec we use JDBC2.0.
Any help would be really apreciated
Thanks!
Paula


Don't use javax.sql.XADataSource. Just cast the class to javax.sql.DataSource.
Kyle
Ashima_Java
Greenhorn

Joined: Sep 18, 2003
Posts: 7
Sir!

My CMP bean deployent is been deployed. My question is where to Enter Table specific information. For ex I'm using com.titan.cabin example from orielly.
I'm bit confused where to enter the table specific information CABIN as WAS 3.5 doesn't gimme me option to choose table from the selected DSN. Thats why it always creates a new table CABInEJBTBL. I'm using DB2 and tbl gets created in EJB schema.

Vijay
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Deploy EJB(CMP) on WebSphere3.5.2