• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • paul wheaton
  • Jeanne Boyarsky
  • Ron McLeod
Sheriffs:
  • Paul Clapham
  • Liutauras Vilda
  • Devaka Cooray
Saloon Keepers:
  • Tim Holloway
  • Roland Mueller
Bartenders:

Deploy EJB(CMP) on WebSphere3.5.2

 
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
author
Posts: 3892
5
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.
 
Christine Li
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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]


 
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Posts: 3892
5
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

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
 
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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 have a knack for fixing things like this ... um ... sorry ... here is a consilitory tiny ad:
We need your help - Coderanch server fundraiser
https://coderanch.com/wiki/782867/Coderanch-server-fundraiser
reply
    Bookmark Topic Watch Topic
  • New Topic