aspose file tools*
The moose likes EJB and other Java EE Technologies and the fly likes Urgent !!! Entity bean JDBC connection Problem !!! Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "Urgent !!! Entity bean JDBC connection Problem !!!" Watch "Urgent !!! Entity bean JDBC connection Problem !!!" New topic
Author

Urgent !!! Entity bean JDBC connection Problem !!!

Shanmugam Muthukumarasamy
Ranch Hand

Joined: Jan 11, 2003
Posts: 83
Hi All,
While Starting my EJB application on WSAD 5.0 / WAS 4.0, I am getting the following error:
2/1/03 15:57:12:715 EST] 40c9cb3c ResourceBinde I WSVR0049I: Binding CERTSD1 as jdbc/CERTSD1
[2/1/03 15:57:26:605 EST] 40c9cb3c EJBEngine I WSVR0037I: Starting EJB jar: wcc
[2/1/03 15:57:38:091 EST] 40c9cb3c ConnectionPoo X CONM6009E: Failed to get connection to the database from datasource (CERTSD1).
[2/1/03 15:57:38:141 EST] 40c9cb3c JDBCPersister W CNTR0031W: Error starting CMP bean: CERTS#CERTSEJB.jar#Document
[2/1/03 15:57:38:362 EST] 40c9cb3c JDBCPersister W CNTR0032W: Error creating CMP persister using datasource: local:jdbc/jdbc/CERTSD1
[2/1/03 15:57:38:372 EST] 40c9cb3c EJBEngine X WSVR0062E: Failed to start EJB, CERTS#CERTSEJB.jar#Document: ORA-01017: invalid username/password; logon denied
[2/1/03 15:57:39:423 EST] 40c9cb3c ConnectionPoo X CONM6009E: Failed to get connection to the database from datasource (CERTSD1).
[2/1/03 15:57:39:433 EST] 40c9cb3c JDBCPersister W CNTR0031W: Error starting CMP bean: CERTS#CERTSEJB.jar#DocumentGroupPermission
[2/1/03 15:57:39:433 EST] 40c9cb3c JDBCPersister W CNTR0032W: Error creating CMP persister using datasource: local:jdbc/jdbc/CERTSD1
[2/1/03 15:57:39:443 EST] 40c9cb3c EJBEngine X WSVR0062E: Failed to start EJB, CERTS#CERTSEJB.jar#DocumentGroupPermission: ORA-01017: invalid username/password; logon denied
[2/1/03 15:57:42:077 EST] 40c9cb3c EJBEngine X WSVR0040E: addEjbModule failed for com.ibm.ejs.models.base.config.applicationserver.impl.EJBModuleRefImpl (desiredExecutionState: START) (uri: CERTSEJB.jar)
java.lang.NoClassDefFoundError: sso/BUIDNotFoundException
at java.lang.Class.newInstance0(Native Method)
at java.lang.Class.newInstance(Class.java:262)
at com.ibm.ejs.container.EJSContainer.loadBeanMetaData(EJSContainer.java:873)
at com.ibm.ejs.container.EJSContainer.getHomeInstance(EJSContainer.java:565)
at com.ibm.ejs.container.EJSContainer.startBean(EJSContainer.java:529)
at com.ibm.ws.runtime.BeanHelper.startBean(BeanHelper.java:154)
at com.ibm.ws.runtime.EJBEngine.addEjbModule(EJBEngine.java:438)
at com.ibm.ws.runtime.Server.startModule(Server.java:607)
at com.ibm.ws.runtime.StandardServer.initializeModules(StandardServer.java:321)
at com.ibm.ws.runtime.StandardServer.initializeRuntime0(StandardServer.java:349)
at com.ibm.ws.runtime.Server.initializeRuntime(Server.java:884)
at com.ibm.ws.runtime.StandardServer.main(StandardServer.java:519)
at java.lang.reflect.Method.invoke(Native Method)
at com.ibm.ws.bootstrap.WSLauncher.main(WSLauncher.java:158)
at com.ibm.etools.websphere.tools.runner.api.ServerRunnerV4$1.run(ServerRunnerV4.java:56)
Please anybody knows please let me know immediately. This is very urgent.
Thanks in advance,
Shanmugam.


SJCP 1.4<br />SCWCD 1.4<br />SCEA
Avi Abrami
Ranch Hand

Joined: Oct 11, 2000
Posts: 1129

Hi Shanmugam,
It looks to me like this line is showing the cause of your problem:
[2/1/03 15:57:38:372 EST] 40c9cb3c EJBEngine X WSVR0062E: Failed to start EJB, CERTS#CERTSEJB.jar#Document: ORA-01017: invalid username/password; logon denied

It seems that the database login name that your CMP entity EJB uses to login to the Oracle database is incorrect. I suggest you check your configuration.
I'm afraid I don't use WSAD or WAS, so I can't point you to any specific configuration files.
Hope this helps.
Good Luck,
Avi.
Vikalp Singh
Ranch Hand

Joined: Dec 29, 2002
Posts: 50
it seems to be error in the db password in the connection poll created by the Server.
better to check your connection pool is created properly or not ?
Shanmugam Muthukumarasamy
Ranch Hand

Joined: Jan 11, 2003
Posts: 83
Hi Avi & Vikalp Singh ,
Thanks for your replies. Actually I resolved that problem, still I am getting one more problem. The problem is :
[2/2/03 14:50:50:506 EST] 403cec3d Server U Version : 4.0.3
[2/2/03 14:50:50:516 EST] 403cec3d Server U Edition: Advanced Single Server Edition for Multiplatforms
[2/2/03 14:50:50:516 EST] 403cec3d Server U Build date: Sun Apr 28 00:00:00 EDT 2002
[2/2/03 14:50:50:516 EST] 403cec3d Server U Build number: ptf30217.01
[2/2/03 14:50:55:473 EST] 403cec3d DrAdminServer I WSVR0053I: DrAdmin available on port 7000
[2/2/03 14:50:55:633 EST] 403cec3d ResourceBinde I WSVR0049I: Binding Session Persistence datasource as jdbc/Session
[2/2/03 14:50:56:244 EST] 403cec3d ResourceBinde I WSVR0049I: Binding CERTSD1 as jdbc/CERTSD1
[2/2/03 14:51:08:081 EST] 403cec3d EJBEngine I WSVR0037I: Starting EJB jar: wcc
[2/2/03 14:51:19:187 EST] 403cec3d ServletEngine A SRVE0161I: IBM WebSphere Application Server - Web Container. Copyright IBM Corp. 1998-2001
[2/2/03 14:51:19:247 EST] 403cec3d ServletEngine A SRVE0162I: Servlet Specification Level: 2.2
[2/2/03 14:51:19:247 EST] 403cec3d ServletEngine A SRVE0163I: Supported JSP Specification Level: 1.1
[2/2/03 14:51:19:548 EST] 403cec3d ServletEngine A SRVE0167I: Session Manager is Configured - Initializing...
[2/2/03 14:51:19:798 EST] 403cec3d CacheManager A DYNA0011E: Servlet cache file dynacache.xml not found; caching is disabled
[2/2/03 14:51:20:008 EST] 403cec3d ServletEngine A SRVE0169I: Loading Web Module: IBM Universal Test Client.
[2/2/03 14:51:20:900 EST] 403cec3d WebGroup I SRVE0091I: [Servlet LOG]: JSP 1.1 Processor: init
[2/2/03 14:51:20:970 EST] 403cec3d WebGroup I SRVE0091I: [Servlet LOG]: SimpleFileServlet: init
[2/2/03 14:51:21:060 EST] 403cec3d ServletEngine A SRVE0169I: Loading Web Module: CERTSWeb.
[2/2/03 14:51:21:520 EST] 403cec3d WebGroup I SRVE0091I: [Servlet LOG]: JSP 1.1 Processor: init
[2/2/03 14:51:21:540 EST] 403cec3d WebGroup I SRVE0091I: [Servlet LOG]: SimpleFileServlet: init
[2/2/03 14:51:21:601 EST] 403cec3d WebGroup I SRVE0091I: [Servlet LOG]: InvokerServlet: init
[2/2/03 14:51:21:631 EST] 403cec3d WebGroup X Servlet Error-[CNCController]: Failed to load servlet: java.lang.NoClassDefFoundError: javax/servlet/http/HttpServlet
at java.lang.ClassLoader.defineClass0(Native Method)
at java.lang.ClassLoader.defineClass(ClassLoader.java(Compiled Code))
at java.security.SecureClassLoader.defineClass(SecureClassLoader.java(Compiled Code))
at java.net.URLClassLoader.defineClass(URLClassLoader.java(Compiled Code))
at java.net.URLClassLoader$ClassFinder.run(URLClassLoader.java(Compiled Code))
at java.net.URLClassLoader$ClassFinder.run(URLClassLoader.java(Compiled Code))
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java(Compiled Code))
at java.lang.ClassLoader.loadClass(ClassLoader.java(Compiled Code))
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:441)
at java.lang.ClassLoader.loadClass(ClassLoader.java(Compiled Code))
at java.lang.ClassLoader.defineClass0(Native Method)
at java.lang.ClassLoader.defineClass(ClassLoader.java(Compiled Code))
at java.security.SecureClassLoader.defineClass(SecureClassLoader.java(Compiled Code))
at java.net.URLClassLoader.defineClass(URLClassLoader.java(Compiled Code))
at java.net.URLClassLoader$ClassFinder.run(URLClassLoader.java(Compiled Code))
at java.net.URLClassLoader$ClassFinder.run(URLClassLoader.java(Compiled Code))
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java(Compiled Code))
at java.lang.ClassLoader.loadClass(ClassLoader.java(Compiled Code))
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:441)
at java.lang.ClassLoader.loadClass(ClassLoader.java(Compiled Code))
at java.lang.ClassLoader.defineClass0(Native Method)
at java.lang.ClassLoader.defineClass(ClassLoader.java(Compiled Code))
at java.security.SecureClassLoader.defineClass(SecureClassLoader.java(Compiled Code))
at java.net.URLClassLoader.defineClass(URLClassLoader.java(Compiled Code))
at java.net.URLClassLoader$ClassFinder.run(URLClassLoader.java(Compiled Code))
at java.net.URLClassLoader$ClassFinder.run(URLClassLoader.java(Compiled Code))
at java.security.AccessController.doPrivileged(Native Method)
at java.lang.ClassLoader.loadClass(ClassLoader.java(Compiled Code))
at java.lang.ClassLoader.loadClass(ClassLoader.java(Compiled Code))
at java.lang.ClassLoader.loadClass(ClassLoader.java(Compiled Code))
at java.lang.ClassLoader.loadClass(ClassLoader.java(Compiled Code))
at java.lang.ClassLoader.loadClass(ClassLoader.java(Compiled Code))
at com.ibm.ws.classloader.CompoundClassLoader.loadClass(CompoundClassLoader.java:261)
at java.lang.ClassLoader.loadClass(ClassLoader.java(Compiled Code))
at com.ibm.ws.classloader.CompoundClassLoader.loadClass(CompoundClassLoader.java:245)
at java.lang.ClassLoader.loadC
Even in the Classpath j2ee.jar has been added, that is having the HttpServlet.class. I don't know why it is failing, can you guys tell me what could be the problem..?
Thanks in advance,
Shanmugam.
Kyle Brown
author
Ranch Hand

Joined: Aug 10, 2001
Posts: 3892
    
    5
OK, are you telling me you explicitly added j2ee.jar to the classpath? If so take it off! You do not include it in the EAR file (and it will cause problems if you do) because WebSphere already includes it in its own classpath. (That is, in WSAD it is included in the build path by default, but you do not include it in a runtime classpath).
Kyle


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.
Shanmugam Muthukumarasamy
Ranch Hand

Joined: Jan 11, 2003
Posts: 83
Hi Kyle,
Yes I removed it from the classpath...but still I am getting the same problem. It is still saying NoClassFoundDefError for HttpServlet. Do you have any idea...
Thanks,
shanmugam
Kyle Brown
author
Ranch Hand

Joined: Aug 10, 2001
Posts: 3892
    
    5
OK, there is a file in your Web project called ".classpath". Would you mind copying the contents here? IT shoudl contain an entry for j2ee.jar, but there should be no other references to j2ee.jar (e.g. you should not explicitly include it in your EAR file as an import). This information should help me figure out what's going on.
Kyle
Shanmugam Muthukumarasamy
Ranch Hand

Joined: Jan 11, 2003
Posts: 83
Hi Kyle,
I checked the .classpath under my web project. It is showing the following details:
<?xml version="1.0" encoding="UTF-8"?>
<classpath>
<classpathentry exported="true" kind="var" path="WAS_PLUGINDIR/lib/j2ee.jar"/>
<classpathentry exported="true" kind="var" path="WAS_PLUGINDIR/lib/webcontainer.jar"/>
<classpathentry exported="true" kind="var" path="WAS_PLUGINDIR/lib/ivjejb35.jar"/>
<classpathentry exported="true" kind="var" path="WAS_PLUGINDIR/lib/websphere.jar"/>
<classpathentry exported="true" kind="var"
path="SERVERJDK_PLUGINDIR/jre/lib/rt.jar"
rootpath="SERVERJDK_SRCROOT" sourcepath="SERVERJDK_PLUGINDIR/src.jar"/>
<classpathentry kind="src" path="Java Source"/>
<classpathentry exported="true" kind="lib" path="C:/Contract-And-Certificates/PruSSO.jar"/>
<classpathentry exported="true" kind="lib" path="C:/Contract-And-Certificates/OracleJDBC.jar"/>
<classpathentry exported="true" kind="lib" path="C:/Contract-And-Certificates/xalan.jar"/>
<classpathentry exported="true" kind="lib" path="C:/Contract-And-Certificates/xerces.jar"/>
<classpathentry exported="true" kind="lib" path="C:/Contract-And-Certificates/xml4j.jar"/>
<classpathentry exported="true" kind="src" path="/CERTSEJB"/>
<classpathentry exported="true" kind="lib" path="C:/Program Files/IBM/WebSphere Studio/runtimes/aes_v4/lib/jsp.jar"/>
<classpathentry exported="true" kind="lib" path="C:/Program Files/IBM/WebSphere Studio/runtimes/aes_v4/lib/cm.jar"/>
<classpathentry kind="output" path="Web Content\WEB-INF\classes"/>
</classpath>

I don't know, I tried all the possibilities like,
I have added the HttpServlet in "servlet" section of the web deployment descriptor, even i got the same error, then I removed that entry.
Please can you look on to the above .classpath and tell me what else you want..I will give you the detail...Thanks very much for your help.
Shanmugam.
Kyle Brown
author
Ranch Hand

Joined: Aug 10, 2001
Posts: 3892
    
    5
Can you post the web.xml file too?
Kyle
Shanmugam Muthukumarasamy
Ranch Hand

Joined: Jan 11, 2003
Posts: 83
Hi Kyle,
I have copied the content of the web.xml here:

Thanks,
Shanmugam.

====
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE web-app PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.2//EN" "http://java.sun.com/j2ee/dtds/web-app_2_2.dtd">
<web-app id="WebApp">
<display-name>CERTSWeb</display-name>
<servlet>
<servlet-name>CNCController</servlet-name>
<display-name>CNCController</display-name>
<servlet-class>com.pru.gi.cnc.controllers.CNCController</servlet-class>
<init-param>
<param-name>frmXmlFile</param-name>
<param-value>C:\wsad\workspace\CERTSWeb\Web Content\servlets\frm.xml</param-value>
</init-param>
<init-param>
<param-name>appXmlFile</param-name>
<param-value>C:\wsad\workspace\CERTSWeb\Web Content\servlets\app.xml</param-value>
</init-param>
<load-on-startup>-1</load-on-startup>
</servlet>
<servlet>
<servlet-name>PasswordResetter</servlet-name>
<display-name>PasswordResetter</display-name>
<servlet-class>com.pru.gi.cnc.controllers.PasswordResetter</servlet-class>
<init-param>
<param-name>frmXmlFile</param-name>
<param-value>C:\wsad\workspace\CERTSWeb\Web Content\servlets\frm.xml</param-value>
</init-param>
<init-param>
<param-name>appXmlFile</param-name>
<param-value>C:\wsad\workspace\CERTSWeb\Web Content\servlets\app.xml</param-value>
</init-param>
<load-on-startup>-1</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>CNCController</servlet-name>
<url-pattern>/CNCController/login</url-pattern>
</servlet-mapping>
<welcome-file-list>
<welcome-file>index.html</welcome-file>
<welcome-file>index.htm</welcome-file>
<welcome-file>index.jsp</welcome-file>
<welcome-file>default.html</welcome-file>
<welcome-file>default.htm</welcome-file>
<welcome-file>default.jsp</welcome-file>
</welcome-file-list>
</web-app>
Kyle Brown
author
Ranch Hand

Joined: Aug 10, 2001
Posts: 3892
    
    5
Two possibilities come to mind. First, note that your "load-on-startup" value is negative -- that means something in tomcat (load on first call) but in fact it's outside the spec what it can mean to the container. I would change that to "1" if I were you. I don't know that this is a problem, but let's eliminate it anyway.
Second, is there ANY possibility that the class com.pru.gi.cnc.controllers.CNCController is on your classpath twice? That could explain the class not found error.
Kyle
Shanmugam Muthukumarasamy
Ranch Hand

Joined: Jan 11, 2003
Posts: 83
Yes Kyle,
CNCController is in 2 places. we are using MVC model to call the application. All the Controllers are servlets, Handlers are java objects. What happend is when I import the web project, it has created all the corresponding classes for controllers and handlers under WEB-INF\classes. But that time the application could not able to load all the handlers, so I thought the web application is not visible to the Test server. Then I created one executatble jar file with all controllers and handlers, that I added in the "ws.ext.dirs" of the server. Then it can able to load all the handlers, I hope it is not the proper way. But I don't know why it is failing to load the handlers.
Actually "CNCController" and the "PasswordResetter" are the 2 controllers which are started at the time to starting up the server. I will try to change the load on start up to "1". Actually I am not setting that -1 value for load on start up, if we click on the load on start up check box automatically, it is putting -1.
And also I am giving two XML files for the as the property file to initialize these 2 servlets. In app.xml I have mentioned all the handler which has to be loaded while starting the applicaiton.
For your refernece:
app.xml:
<?xml version="1.0" encoding="UTF-8"?>
<application>
<properties>
<property>
<key>bypassSSO</key>
<value>true</value>
</property>
<property>
<key>ccc.adminId</key>
<value>cccccc</value>
</property>
<property>
<key>SSO.adPass</key>
<value>vvvvvv</value>
</property>
<property>
<key>activityReportXsl</key>
<value>/wasapp/cncapp/classes/activityreport.xsl</value>
</property>
<property>
<key>slaReportXsl</key>
<value>/wasapp/cncapp/classes/slareport.xsl</value>
</property>
<property>
<key>login.url</key>
<value>index.html</value>
</property>
<property>
<key>sla.npv</key>
<value>40</value>
</property>
<property>
<key>sla.pwo</key>
<value>21</value>
</property>
<property>
<key>sla.pvw</key>
<value>21</value>
</property>
<property>
<key>logout.url</key>
<value>https://ccc.com LOCALE=cnc_en_US</value>
</property>
<property>
<key>pru.rock.url</key>
<value>http://www.ccc.com</value>
</property>
<property>
<key>gi.home.url</key>
<value>http://www.ccc.com/gi</value>
</property>
<property>
<key>gi.employees.url</key>
<value>http://www.ccc.com/giemployee</value>
</property>
<property>
<key>gi.employers.url</key>
<value>http://www.ccc.com/giemployer</value>
</property>
<property>
<key>gi.producers.url</key>
<value>http://www.ccc.com/giproducer</value>
</property>
</properties>
<messages>
<message>
<key>CNCERR00002</key>
<value>Session timed out.</value>
</message>
<message>
<key>CNCERR00003</key>
<value>Communication failure: The application could not contact the EJB.<br>
Please call the technical help desk for assistance.</value>
</message>
<message>
<key>CNCERR00004</key>
<value>Could not determine if user is a Case Installer.<br>
Please call the technical help desk for assistance.</value>
</message>
<message>
<key>CNCERR00005</key>
<value>Required parameter [%1] is misssing</value>
</message>
<message>
<key>CNCERR00006</key>
<value>[%1] Parameter is not valid</value>
</message>
<message>
<key>CNCERR00007</key>
<value>Generic SQL Error [%1]</value>
</message>
<message>
<key>CNCERR00008</key>
<value>You do not have permissions set at this time. Please contact your ccc Representative for assistance.</value>
</message>
<message>
<key>CNCERR00010</key>
<value>Error: rollback database transaction.</value>
</message>
<message>
<key>CNCERR00101</key>
<value>Error retrieving document content. Please try again.</value>
</message>
<message>
<key>CNCERR00102</key>
<value>Error uploading document content. Please try again.</value>
</message>
<message>
<key>CNCERR00103</key>
<value>The file selected does not appear to be a PDF.<br>
Please check the file and try again.</value>
</message>
<message>
<key>CNCERR00104</key>
<value>The file selected is either empty or does not exist.<br>
Please check your entry and try again.</value>
</message>
<message>
<key>CNCERR00110</key>
<value>Posted content type isn't multipart/form-data.</value>
</message>
<message>
<key>CNCERR00113</key>
<value>An error (no separation boundary defined) occurred while uploading the file.<br>
Please try uploading the file again.</value>
</message>
<message>
<key>CNCERR00114</key>
<value>An error (no leading boundary defined) occurred while uploading the file.<br>
Please try uploading the file again.</value>
</message>
<message>
<key>CNCERR00121</key>
<value>An error occurred while uploading the file.<br>
Please try again.</value>
</message>
<message>
<key>CNCERR00131</key>
<value>An error occurred while trying to open the file.<br>
Please try again.</value>
</message>
<message>
<key>CNCERR00151</key>
<value>Employee is not found.<br>
Please check your entry and try again.</value>
</message>
<message>
<key>CNCERR00152</key>
<value>Error: Multiple target control numbers.</value>
</message>
<message>
<key>CNCERR00153</key>
<value>The case you are looking for has not yet been estbalished within the system, please verify the control number and try again. If the case still can not be found please contact your ccc Account Representative.
</value>
</message>
<message>
<key>CNCERR00202</key>
<value>The case you are looking for has not yet been established within the system, please verify the control number and try again. If the case still can not be found please contact your ccc Account Representative.
</value>
</message>
<message>
<key>CNCERR00301</key>
<value>The document you selected could not be deleted.<br>
It may have already been deleted by another user.</value>
</message>
<message>
<key>CNCERR00401</key>
<value>The user '%1' was not found in the application database</value>
</message>
<message>
<key>CNCERR00402</key>
<value>The user '%1' is marked as disabled</value>
</message>
<message>
<key>CNCERR00501</key>
<value>The case was not successfully installed.<br>
Please try again.</value>
</message>
<message>
<key>CNCERR00502</key>
<value>The control number of the case you are trying to install already exists.</value>
</message>
<message>
<key>CNCERR00503</key>
<value>The case was not successfully modified.<br>
Please try again.</value>
</message>
<message>
<key>CNCERR00550</key>
<value>The end date is before the start date.</value>
</message>
<message>
<key>CNCERR00601</key>
<value>Error creating new user.</value>
</message>
<message>
<key>CNCERR00602</key>
<value>The user id [%1] already exists.<br>
Please use a different id.</value>
</message>
<message>
<key>CNCERR00603</key>
<value>The user id [%1] already exists in SSO.</value>
</message>
<message>
<key>CNCERR00701</key>
<value>Error: modifying existing user.</value>
</message>
<message>
<key>CNCERR00702</key>
<value>Error: There is more than one permission record for this user.<br>
You are now in a parallel universe.</value>
</message>
<message>
<key>CNCERR00751</key>
<value>The user '%1' was not deleted.<br>
Please try again.</value>
</message>
<message>
<key>CNCERR00761</key>
<value>There was a problem removing the user from the SSO database.<br>
Please try again.</value>
</message>
<message>
<key>CNCERR00800</key>
<value>The user id '%1' was not found in the SSO database</value>
</message>
<message>
<key>CNCERR00801</key>
<value>The SSOAdmin username and/or password failed.</value>
</message>
<message>
<key>CNCERR00802</key>
<value>SSO appears to be down.<br>
Please try back in a few minutes.</value>
</message>
<message>
<key>CNCERR00901</key>
<value>Error: deleting case.</value>
</message>
<message>
<key>CNCERR00903</key>
<value>Error: Can not delete Pru magic case.</value>
</message>
<message>
<key>CNCERR99999</key>
<value>An application error has occurred.<br>
Please call the technical help desk for assistance and give the operator the following information:<br>
[%1].</value>
</message>
</messages>
<handlers>
<handler>
<key>LoginHandler</key>
<value>com.pru.gi.cnc.handlers.LoginHandler</value>
</handler>
<handler>
<key>DownloadContentHandler</key>
<value>com.pru.gi.cnc.handlers.DownloadContentHandler</value>
</handler>
<handler>
<key>UploadContentHandler</key>
<value>com.pru.gi.cnc.handlers.UploadContentHandler</value>
</handler>
<handler>
<key>SwitchCaseHandler</key>
<value>com.pru.gi.cnc.handlers.SwitchCaseHandler</value>
</handler>
<!--<handler>
<key>FolderHandler</key>
<value>com.pru.gi.cnc.handlers.FolderHandler</value>
</handler> -->
<handler>
<key>DeleteContentHandler</key>
<value>com.pru.gi.cnc.handlers.DeleteContentHandler</value>
</handler>
<handler>
<key>ShowUserHandler</key>
<value>com.pru.gi.cnc.handlers.ShowUserHandler</value>
</handler>
<handler>
<key>AcceptAgreementHandler</key>
<value>com.pru.gi.cnc.handlers.AcceptAgreementHandler</value>
</handler>
<handler>
<key>CaseDetailHandler</key>
<value>com.pru.gi.cnc.handlers.CaseDetailHandler</value>
</handler>
<handler>
<key>CaseInstallHandler</key>
<value>com.pru.gi.cnc.handlers.CaseInstallHandler</value>
</handler>
<handler>
<key>SetupUserHandler</key>
<value>com.pru.gi.cnc.handlers.SetupUserHandler</value>
</handler>
<handler>
<key>InstallUserHandler</key>
<value>com.pru.gi.cnc.handlers.InstallUserHandler</value>
</handler>
<handler>
<key>ModifyUserHandler</key>
<value>com.pru.gi.cnc.handlers.ModifyUserHandler</value>
</handler>
<handler>
<key>ResetUserHandler</key>
<value>com.pru.gi.cnc.handlers.ResetUserHandler</value>
</handler>
<handler>
<key>RemoveUserHandler</key>
<value>com.pru.gi.cnc.handlers.RemoveUserHandler</value>
</handler>
<handler>
<key>SSOLoginHandler</key>
<value>com.pru.gi.cnc.handlers.SSOLoginHandler</value>
</handler>
<handler>
<key>RevokeUsersHandler</key>
<value>com.pru.gi.cnc.handlers.RevokeUsersHandler</value>
</handler>
<handler>
<key>ReportHandler</key>
<value>com.pru.gi.cnc.handlers.ReportHandler</value>
</handler>
<handler>
<key>ModCaseHandler</key>
<value>com.pru.gi.cnc.handlers.ModCaseHandler</value>
</handler>
</handlers>
<database>
<pool name="CNC">
<lookupName>jdbc/ccc</lookupName>
<userId>Wcc</userId>
<password>cccc</password>
</pool>
</database>
</application>
I removed that application.jar from the "ws.ext.dirs" of the server and I changed the load on start up to "1", now I am getting NoClassDefFoundError for all the 19 handlers.
Here I have mentioned only one handler's Exception, others are getting the same exception:
[Tid={Thread-1} Ts={Tuesday, February 4, 2003 9:07:59 AM EST} Cli={CERTSWeb}]
java.lang.ClassNotFoundException: com.pru.gi.cnc.handlers.SwitchCaseHandler
at java.net.URLClassLoader.findClass(URLClassLoader.java(Compiled Code))
at java.lang.ClassLoader.loadClass(ClassLoader.java(Compiled Code))
at java.lang.ClassLoader.loadClass(ClassLoader.java(Compiled Code))
at java.lang.Class.forName1(Native Method)
at java.lang.Class.forName(Class.java:142)
at framework.lite.type.HandlerBundle.loadHandler(HandlerBundle.java:63)
at framework.lite.type.HandlerBundle.loadHandlers(HandlerBundle.java:79)
at framework.lite.runtime.Application.postInit(Application.java:505)
at com.pru.gi.cnc.controllers.CNCController.postInit(CNCController.java:778)
at framework.lite.runtime.Controller.init(Controller.java:106)
at com.ibm.servlet.engine.webapp.StrictServletInstance.doInit(ServletManager.java:802)
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet._init(StrictLifecycleServlet.java:141)
at com.ibm.servlet.engine.webapp.PreInitializedServletState.init(StrictLifecycleServlet.java:254)
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet.init(StrictLifecycleServlet.java:107)
at com.ibm.servlet.engine.webapp.ServletInstance.init(ServletManager.java:388)
at javax.servlet.GenericServlet.init(GenericServlet.java:258)
at com.ibm.servlet.engine.webapp.ServletManager.addServlet(ServletManager.java:84)
at com.ibm.servlet.engine.webapp.WebAppServletManager.loadServlet(WebAppServletManager.java:225)
at com.ibm.servlet.engine.webapp.WebAppServletManager.loadAutoLoadServlets(WebAppServletManager.java:357)
at com.ibm.servlet.engine.webapp.WebApp.loadServletManager(WebApp.java:1172)
at com.ibm.servlet.engine.webapp.WebApp.init(WebApp.java:141)
at com.ibm.servlet.engine.srt.WebGroup.loadWebApp(WebGroup.java:235)
at com.ibm.servlet.engine.srt.WebGroup.init(WebGroup.java:144)
at com.ibm.servlet.engine.ServletEngine.addWebApplication(ServletEngine.java:652)
at com.ibm.ws.runtime.WebContainer.install(WebContainer.java:36)
at com.ibm.ws.runtime.Server.startModule(Server.java:617)
at com.ibm.ws.runtime.StandardServer.initializeModules(StandardServer.java:333)
at com.ibm.ws.runtime.StandardServer.initializeRuntime0(StandardServer.java:349)
at com.ibm.ws.runtime.Server.initializeRuntime(Server.java:884)
at com.ibm.ws.runtime.StandardServer.main(StandardServer.java:519)
at java.lang.reflect.Method.invoke(Native Method)
at com.ibm.ws.bootstrap.WSLauncher.main(WSLauncher.java:158)
at com.ibm.etools.websphere.tools.runner.api.ServerRunnerV4$1.run(ServerRunnerV4.java:56)
Let me know if you have any idea.
Thank you so much,
Shanmugam.
Kyle Brown
author
Ranch Hand

Joined: Aug 10, 2001
Posts: 3892
    
    5
That sounds like the problem... when you said
Then I created one executatble jar file with all controllers and handlers, that I added in the "ws.ext.dirs" of the server.

This is part of what is causing your grief. Take that jar OUT of the ws.ext.dirs directory. All of the classes for the web application should be managed by WSAD and (thus) placed in the WEB-INF/classes directory.
Once that's done, we'll take a look at the problems you encounter there. As for the -1 thing, it's a red herring. Ignore it.
Kyle
Shanmugam Muthukumarasamy
Ranch Hand

Joined: Jan 11, 2003
Posts: 83
Hi Kyle,
I have one question, we are using one application called "framework" which is defining the MVC model. This project has been used by both web- application as well as ejb application. In that case, if add the framework.jar as the project utility jar undre Application deployment descriptor(for enterprise project you know there are three modules, application, ejb and web) then it is visible to the web-application and not visible to the EJB application. Then if I want to make framework visible to EJB application, then I am adding that framework.jar under server instance
"ws.ext.dirs", In this case EJB server started succesfully, but because of 2 references of the same framework(Under appication deployment descriptor and ws.ext.dirs). It is not able to find all the handlers ( last time you have mentioned I should not give two references of same classes in 2 places). Now it is a kind of deadlock situation.
If I remove the framwork.jar from "ws.ext.dirs" the EJB server is not getting started.
If I remove the framework.jar from "Project utility jar" of Application deployment descriptor, it is failing to load all the handlers.
Do you have any idea to handle this situation..
Thanks,
Shanmugam.
Shanmugam Muthukumarasamy
Ranch Hand

Joined: Jan 11, 2003
Posts: 83
Hi Avi Abrami, Vikalp Singh and Kyle Brown !!!
Thanks for your useful advices !!!, Finally I found the way to solve the above problem. Actually if two modules of the same application is using the common utility(jar, class). In that case that should not be packaged as part of each module. In this case, that common utility can be created as a separate project and then that can be included to the modules in the "Java JAR dependencies" of WSAD. Or otherwise, if we want to include as a JAR file then it can be included in the "Project -> Properties -> Java Build path -> Add External jars " as well as in the "Test Server -> paths -> ws.ext.dirs -> Add External jars" this is the global classpath. Then the next important this is, we need to set one environment property in the Test server end. For that
"TestServer -> Environment -> System Properties ->
set "false" to followin property:
"com.ibm.ws.classloader.J2eeApplicationMode". This means, all the environment related references will be taken in the applicaiton level, not as module level.
Thanks once again to all of you guys !!!
Shanmugam.
jose barros
Greenhorn

Joined: Feb 13, 2003
Posts: 2
This lines shows what is happening:
[2/1/03 15:57:38:372 EST] 40c9cb3c EJBEngine X WSVR0062E: Failed to start EJB, CERTS#CERTSEJB.jar#Document: ORA-01017: invalid username/password; logon denied
[2/1/03 15:57:39:423 EST] 40c9cb3c ConnectionPoo X CONM6009E: Failed to get connection to the database from datasource (CERTSD1).
[2/1/03 15:57:39:433 EST] 40c9cb3c JDBCPersister W CNTR0031W: Error starting CMP bean: CERTS#CERTSEJB.jar#DocumentGroupPermission
[2/1/03 15:57:39:433 EST] 40c9cb3c JDBCPersister W CNTR0032W: Error creating CMP persister using datasource: local:jdbc/jdbc/CERTSD1
[2/1/03 15:57:39:443 EST] 40c9cb3c EJBEngine X WSVR0062E: Failed to start EJB, CERTS#CERTSEJB.jar#DocumentGroupPermission: ORA-01017: invalid username/password; logon denied
Reconfigure at container EJB the username and password for connection. Suggestion if your EJB is EMP: make try catch blocks at Enterprise Bean with System.out.println commands to gives you an idea of the target problematic line. Case your bean is CMP, then check the JNDI configuration, username and password.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Urgent !!! Entity bean JDBC connection Problem !!!