This week's book giveaway is in the General Computing forum. We're giving away four copies of Arduino in Action and have Martin Evans, Joshua Noble, and Jordan Hochenbaum on-line! See this thread for details.
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
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
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
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: 3879
posted
0
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
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://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to
run our stuff on 16 servers instead of 3.
0
