Stefan Forner

I want to connect to a DB2 OS/390 V6 database through DB2Connect V8. I get a connection, but in the ControlCenter I cannot see the tables. In the CommandCenter I can get the tables via a "Select-Statements". Also I can`t get the Tables in WSAD 5.0. So is there a problem with DB2 OS/390 V6 and DB2 Connect V8? Or do I make a mistake. I have the rights and the connection, but I can`t see the tables.
In WSAD I create a Data Connection, there I get the Connection with the COM.ibm.jdbc.app.DB2Driver
but I can`t see tables, views, etc. only the db.
Can anyone help me??

I want to connect to a DB2 OS/390 V6 database through DB2Connect V8. I get a connection, but in the ControlCenter I cannot see the tables. In the CommandCenter I can get the tables via a "Select-Statements". Also I can`t get the Tables in WSAD 5.0. So is there a problem with DB2 OS/390 V6 and DB2 Connect V8? Or do I make a mistake. I have the rights and the connection, but I can`t see the tables.
In WSAD I create a Data Connection, there I get the Connection with the COM.ibm.jdbc.app.DB2Driver
but I can`t see tables, views, etc. only the db.
Can anyone help me??

I have a problem with a LocalInterface.
My EJB 2.0 CMP-Bean has a finder Method to get a Collection of Objects.
When I execute the finderMethod in my Home Interface I get a Collection of LocalObjects.
I can get the PrimaryKey from them. but I can't call the getEJBLocalHome(). The method crashes with an Exception with the message "null".
So I think my LocalInterfaces don't have a LocalHome or is there another possibility?
How can I fix this error?

I have a problem with a LocalInterface.
My EJB 2.0 CMP-Bean has a finder Method to get a Collection of Objects.
When I execute the finderMethod in my Home Interface I get a Collection of LocalObjects.
I can get the PrimaryKey from them. but I can't call the getEJBLocalHome(). The method crashes with an Exception with the message "null".
So I think my LocalInterfaces don't have a LocalHome or is there another possibility?
How can I fix this error?

I haven't figured out how i can turn this on in DB2. My problem is the bean throws an sql-exception, but i cannot find an error in the descriptor.

Hi!
I can't figure out how you can enable the logging of the sql statements in a managed datasource connection?
Can anyone help me?
My file:
<?xml version="1.0" encoding="UTF-8"?>
<!-- ==================================================================== -->
<!-- ConnectionManager setup for K3 Frontend using default IBM DB2 -->
<!-- Build jmx-api (build/build.sh all) and view for config documentation -->
<!-- ==================================================================== -->
<server>
<mbean code="org.jboss.resource.connectionmanager.LocalTxConnectionManager" name="jboss.jca:service=LocalTxCM,name=FEK3DS">
<!-- Include a login module configuration named DB2DbRealm.
Update your login-conf.xml, here is an example for a
ConfiguredIdentityLoginModule:
<application-policy name = "DB2DbRealm">
<authentication>
<login-module code = "org.jboss.resource.security.ConfiguredIdentityLoginModule" flag = "required">
<module-option name = "principal">yourprincipal</module-option>
<module-option name = "userName">yourusername</module-option>
<module-option name = "password">yourpassword</module-option>
<module-option name = "managedConnectionFactoryName">jboss.jca:service=LocalTxCM,name=FEK3DS</module-option>
</login-module>
</authentication>
</application-policy>
NOTE: the application-policy name attribute must match SecurityDomainJndiName, and the
module-option name = "managedConnectionFactoryName"
must match the object name of the ConnectionManager you are configuring here.
-->
<!--uncomment out this line if you are using the DB2DbRealm above
<attribute name="SecurityDomainJndiName">DB2DbRealm</attribute>
-->
<depends optional-attribute-name="ManagedConnectionFactoryName">
<!--embedded mbean-->
<mbean code="org.jboss.resource.connectionmanager.RARDeployment" name="jboss.jca:service=LocalTxDS,name=FEK3DS">
<attribute name="JndiName">jdbc/FEK3DS</attribute>
<attribute name="ManagedConnectionFactoryProperties">
<properties>
<config-property name="ConnectionURL" type="java.lang.String">jdbc b2//192.168.0.1:6789/FEK3_KIS</config-property>
<config-property name="DriverClass" type="java.lang.String">COM.ibm.db2.jdbc.net.DB2Driver</config-property>
<!--set these only if you want only default logins, not through JAAS -->
<config-property name="UserName" type="java.lang.String">db2admin</config-property>
<config-property name="Password" type="java.lang.String">db2admin</config-property>
</properties>
</attribute>
<!--Below here are advanced properties -->
<!--hack-->
<depends optional-attribute-name="OldRarDeployment">jboss.jca:service=RARDeployment,name=JBoss LocalTransaction JDBC Wrapper</depends>
</mbean>
</depends>
<depends optional-attribute-name="ManagedConnectionPool">
<!--embedded mbean-->
<mbean code="org.jboss.resource.connectionmanager.JBossManagedConnectionPool" name="jboss.jca:service=LocalTxPool,name=FEK3DS">
<attribute name="MinSize">0</attribute>
<attribute name="MaxSize">50</attribute>
<attribute name="BlockingTimeoutMillis">5000</attribute>
<attribute name="IdleTimeoutMinutes">15</attribute>
<!--
criteria indicates if Subject (from security domain) or app supplied
parameters (such as from getConnection(user, pw)) are used to distinguish
connections in the pool. Choices are
ByContainerAndApplication (use both),
ByContainer (use Subject),
ByApplication (use app supplied params only),
ByNothing (all connections are equivalent, usually if adapter supports
reauthentication)-->
<attribute name="Criteria">ByContainer</attribute>
</mbean>
</depends>
<depends optional-attribute-name="CachedConnectionManager">jboss.jca:service=CachedConnectionManager</depends>
<depends optional-attribute-name="JaasSecurityManagerService">jboss.security:service=JaasSecurityManager</depends>
<attribute name="TransactionManager">java:/TransactionManager</attribute>
<!--make the rar deploy! hack till better deployment-->
<depends>jboss.jca:service=RARDeployer</depends>
</mbean>
</server>

Thanks for the answer, but I doesn`t know, where to look, because I haven`t changed anything. It�s a clean Installation and the error occured when I started the Adminserver the first time.
(I have 2 Network Card in the server and my localhost is one of this. Is this correct or do I have to change that?)

I resolved the problem by adding com.ibm.CORBA.LocalHost to my Admin.config File.
But now I get a new error:
[15.10.02 10:44:54:065 CEST] 68ea9bc6 ResourceBinde I WSVR0049I: SM_DATASOURCE wird als jdbc/SM_Datasource gebunden
[15.10.02 10:44:55:808 CEST] 68ea9bc6 EJBEngine I WSVR0037I: EJB-Jar-Datei wird gestartet: Name Service
[15.10.02 10:44:59:173 CEST] 68ea9bc6 EJBEngine I WSVR0037I: EJB-Jar-Datei wird gestartet: Secure CosNaming
[15.10.02 10:45:41:383 CEST] 68ea9bc6 WsnInitCtxFac W NMSV0602E: Namensservice nicht verf?gbar. Ein ?bertragungsfehler ist aufge
eten.
[15.10.02 10:45:41:483 CEST] 68ea9bc6 EJBEngine F WSVR0036E: Fehler beim Abrufen des urspr�nglichen Namenskontexts:
[15.10.02 10:45:41:704 CEST] 68ea9bc6 SystemOut U WSVR0036E: Fehler beim Abrufen des urspr�nglichen Namenskontexts:
java.lang.Throwable
at com.ibm.ejs.ras.TraceEventGeneratorImpl.fireTraceEvent(Tr.java:1543)
at com.ibm.ejs.ras.TraceEventGeneratorImpl.fireTraceEvent(Tr.java:1428)
at com.ibm.ejs.ras.Tr.fatal(Tr.java:906)
at com.ibm.ws.runtime.EJBEngine.getContext(EJBEngine.java:299)
at com.ibm.ws.runtime.EJBEngine.addEjbModule(EJBEngine.java:400)
at com.ibm.ws.runtime.Server.startModule(Server.java:607)
at com.ibm.ejs.sm.active.ActiveModule.startModule(ActiveModule.java:511)
at com.ibm.ejs.sm.active.ActiveModule.startAction(ActiveModule.java:355)
at com.ibm.ejs.sm.active.ActiveObject.startObject(ActiveObject.java:709)
at com.ibm.ejs.sm.active.ActiveObject.start(ActiveObject.java:131)
at com.ibm.ejs.sm.active.ActiveObject.operateOnContainedObjects(ActiveObject.java:609)
at com.ibm.ejs.sm.active.ActiveEJBServer.startAction(ActiveEJBServer.java:731)
at com.ibm.ejs.sm.active.ActiveObject.startObject(ActiveObject.java:709)
at com.ibm.ejs.sm.active.ActiveObject.start(ActiveObject.java:131)
at java.lang.reflect.Method.invoke(Native Method)
at com.ibm.ejs.sm.agent.AdminAgentImpl.activeObjectInvocation(AdminAgentImpl.java:93)
at com.ibm.ejs.sm.agent.AdminAgentImpl.invokeActiveObject(AdminAgentImpl.java:62)
at com.ibm.ejs.sm.server.AdminServer.startContainers(AdminServer.java:1407)
at com.ibm.ejs.sm.server.AdminServer.initializeRuntime0(AdminServer.java:1129)
at com.ibm.ws.runtime.Server.initializeRuntime(Server.java:884)
at com.ibm.ejs.sm.server.AdminServer.main(AdminServer.java:392)
at java.lang.reflect.Method.invoke(Native Method)
at com.ibm.ws.bootstrap.WSLauncher.main(WSLauncher.java:158)

I get the following error while starting the WebSphere Admin Server:
Current trace specification = *=all=disabled
************* End Display Current Environment *************
[15.10.02 10:36:54:426 CEST] 68ea9af5 Server U Version : 4.0.3
[15.10.02 10:36:54:436 CEST] 68ea9af5 Server U Edition: Advanced Edition for Multiplatforms with Enterprise
Edition Services
[15.10.02 10:36:54:456 CEST] 68ea9af5 Server U Build date: Sun Apr 28 00:00:00 CEST 2002
[15.10.02 10:36:54:456 CEST] 68ea9af5 Server U Build number: ptf30217.01
[15.10.02 10:36:56:218 CEST] 68ea9af5 ORBRas W com.ibm.CORBA.iiop.Util Util P=14786 =0:CT JORB0012: Als Referenz �bergeb
wurde auf folgenden Wert eingestellt: true (NoLocalCopies = true)
[15.10.02 10:37:45:159 CEST] 68ea9af5 DrAdminServer I WSVR0053I: DrAdmin verf�gbar an Port 3165
[15.10.02 10:37:45:179 CEST] 68ea9af5 AdminServer I ADMS0008I: WebSphere-Administrationsserver wird initialisiert
[15.10.02 10:37:55:994 CEST] 68ea9af5 ResourceBinde I WSVR0049I: SM_DATASOURCE wird als jdbc/SM_Datasource gebunden
[15.10.02 10:37:58:037 CEST] 68ea9af5 EJBEngine I WSVR0037I: EJB-Jar-Datei wird gestartet: Name Service
[15.10.02 10:38:02:383 CEST] 68ea9af5 EJBEngine I WSVR0037I: EJB-Jar-Datei wird gestartet: Secure CosNaming
[15.10.02 10:38:44:554 CEST] 68ea9af5 WsnInitCtxFac W NMSV0602E: Namensservice nicht verf?gbar. Ein ?bertragungsfehler ist aufge
eten.
[15.10.02 10:38:44:624 CEST] 68ea9af5 EJBEngine F WSVR0036E: Fehler beim Abrufen des urspr�nglichen Namenskontexts:
[15.10.02 10:38:44:824 CEST] 68ea9af5 SystemOut U WSVR0036E: Fehler beim Abrufen des urspr�nglichen Namenskontexts:
java.lang.Throwable
at com.ibm.ejs.ras.TraceEventGeneratorImpl.fireTraceEvent(Tr.java:1543)
at com.ibm.ejs.ras.TraceEventGeneratorImpl.fireTraceEvent(Tr.java:1428)
at com.ibm.ejs.ras.Tr.fatal(Tr.java:906)
at com.ibm.ws.runtime.EJBEngine.getContext(EJBEngine.java:299)
at com.ibm.ws.runtime.EJBEngine.addEjbModule(EJBEngine.java:400)
at com.ibm.ws.runtime.Server.startModule(Server.java:607)
at com.ibm.ejs.sm.active.ActiveModule.startModule(ActiveModule.java:511)
at com.ibm.ejs.sm.active.ActiveModule.startAction(ActiveModule.java:355)
at com.ibm.ejs.sm.active.ActiveObject.startObject(ActiveObject.java:709)
at com.ibm.ejs.sm.active.ActiveObject.start(ActiveObject.java:131)
at com.ibm.ejs.sm.active.ActiveObject.operateOnContainedObjects(ActiveObject.java:609)
at com.ibm.ejs.sm.active.ActiveEJBServer.startAction(ActiveEJBServer.java:731)
at com.ibm.ejs.sm.active.ActiveObject.startObject(ActiveObject.java:709)
at com.ibm.ejs.sm.active.ActiveObject.start(ActiveObject.java:131)
at java.lang.reflect.Method.invoke(Native Method)
at com.ibm.ejs.sm.agent.AdminAgentImpl.activeObjectInvocation(AdminAgentImpl.java:93)
at com.ibm.ejs.sm.agent.AdminAgentImpl.invokeActiveObject(AdminAgentImpl.java:62)
at com.ibm.ejs.sm.server.AdminServer.startContainers(AdminServer.java:1407)
at com.ibm.ejs.sm.server.AdminServer.initializeRuntime0(AdminServer.java:1129)
at com.ibm.ws.runtime.Server.initializeRuntime(Server.java:884)
at com.ibm.ejs.sm.server.AdminServer.main(AdminServer.java:392)
at java.lang.reflect.Method.invoke(Native Method)
at com.ibm.ws.bootstrap.WSLauncher.main(WSLauncher.java:158)
I don`t know what to do. I think it must be something with the JNDI Naming Service, but I cannot resolve the problem. Can anybody help me?

Hi I got this tracefile, when I�m starting the Websphere Adminserver (4.03 Advanced Server with 4.1 Enterprise Edition usind DB2 UDB 7.2 with JDBC 2.0):
************ Start Display Current Environment ************
WebSphere AE 4.0.1 a0131.07 running with process name STUSV101/__adminServer and process id 2840
Host Operating System is Windows 2000, version 5.0
Java version = J2RE 1.3.0 IBM build cn130-20010609 (JIT enabled: jitc), Java Compiler = jitc
server.root = D:\WebSphere\AppServer
Java Home = D:\WebSphere\AppServer\java\jre
ws.ext.dirs = D:/WebSphere/AppServer/java/lib;D:/WebSphere/AppServer/classes;D:/WebSphere/AppServer/lib;D:/WebSphere/AppServer/lib/ext;D:/db2/SQLLIB/java/db2java.zip
Classpath = D:/WebSphere/AppServer/properties;D:/WebSphere/AppServer/lib/bootstrap.jar
Java Library path = D:\WebSphere\AppServer\java\bin;.;C:\WINNT\System32;C:\WINNT;D:\\WebSphere\\AppServer\\bin;D:\\db2\\SQLLIB\\bin;D:\\db2\\SQLLIB\\function;D:\\WebSphere\\AppServer\\java\\bin;D:\IBMDebug\bin;D:\Program Files\ibm\gsk5\lib;C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\Wbem;c:\program files\cvs for nt;C:\WINNT\system32\nls;C:\WINNT\system32\nls\ENGLISH;C:\Inoculan;D:\db2\SQLLIB\BIN;D:\db2\SQLLIB\FUNCTION;D:\db2\SQLLIB\SAMPLES\REPL;D:\db2\SQLLIB\HELP;D:\db2\IBM\IMNNQ;D:\WebSphere\AppServer\bin;
Current trace specification =
************* End Display Current Environment *************
[02.09.25 16:16:03:804 GMT+02:00] 154861b4 Server U Version : 4.0.1
[02.09.25 16:16:04:285 GMT+02:00] 154861b4 Server U Edition: Advanced Edition for Multiplatforms
[02.09.25 16:16:04:295 GMT+02:00] 154861b4 Server U Build date: Thu Aug 09 00:00:00 GMT+02:00 2001
[02.09.25 16:16:04:295 GMT+02:00] 154861b4 Server U Build number: a0131.07
[02.09.25 16:16:06:017 GMT+02:00] 154861b4 ORBRas W com.ibm.CORBA.iiop.Util Util P=364725 =0:CT JORB0012: Als Referenz �bergeben wurde auf folgenden Wert eingestellt: true (NoLocalCopies = true)
[02.09.25 16:16:48:839 GMT+02:00] 154861b4 AdminServer X WSVR0009E: Fehler beim Start
java.lang.RuntimeException: com.ibm.ejs.EJSException: Could not register with Location Service Daemon; nested exception is:
java.lang.ClassCastException
at com.ibm.ws.runtime.Server.initializeOrb(Server.java:1440)
at com.ibm.ws.runtime.Server.initializeRuntime0(Server.java:939)
at com.ibm.ejs.sm.server.ManagedServer.initializeRuntime0(ManagedServer.java:407)
at com.ibm.ejs.sm.server.AdminServer.initializeRuntime0(AdminServer.java:1104)
at com.ibm.ws.runtime.Server.initializeRuntime(Server.java:882)
at com.ibm.ejs.sm.server.AdminServer.main(AdminServer.java:391)
at java.lang.reflect.Method.invoke(Native Method)
at com.ibm.ws.bootstrap.WSLauncher.main(WSLauncher.java:158)
[02.09.25 16:16:48:929 GMT+02:00] 154861b4 AdminServer F WSVR0067E: WebSphere-Administrationsserver konnte nicht initialisiert werden
java.lang.Throwable
at com.ibm.ejs.ras.TraceLogger.fatalEvent(TraceLogger.java:219)
at com.ibm.ejs.ras.TraceEventGeneratorImpl.fireTraceEvent(Tr.java:1402)
at com.ibm.ejs.ras.TraceEventGeneratorImpl.fireTraceEvent(Tr.java:1346)
at com.ibm.ejs.ras.Tr.fatal(Tr.java:828)
at com.ibm.ejs.sm.server.AdminServer.main(AdminServer.java:405)
at java.lang.reflect.Method.invoke(Native Method)
at com.ibm.ws.bootstrap.WSLauncher.main(WSLauncher.java:158)
[ September 30, 2002: Message edited by: Stefan Forner ]
[ September 30, 2002: Message edited by: Stefan Forner ]

How can I debug a class that is used by a JSP running on a Weblogic 5.1 Server with Visual Caf� 4.1. I`ve only found a solution to debug EJB. Pleas help me.

I want to excute the jsp`s in tomcat and handle ejb's in weblogic, because it's easier and faster to do that this way. We only use this for development.

How can I integrate tomcat in weblogic? Is there a plugin?
Please help me.

How can I integrate tomcat in Weblogic??? Is there a plugin?