Dear all,

I have heard many of WSAD tools that does have support of SQLJ. However my version (5.0.1) does not have tools on support on SQLJ. As a result i need to import the db2 related classes (my db2 version is 7, release 1, modification 5), i.e. sqlj.zip, db2java.zip and runtime.zip in SQLLIB. I translate it via external tool utility in WSAD, and it seems work fines. It does generate java/class file as well as ser files.

I have successfully the SQLs in application mode. However, when I run in Servlet mode, it does throw the following unexpected error:

[7/14/04 11:43:11:547 GMT+08:00] 67eebce7 ServletInstan E SRVE0100E: Did not realize init() exception thrown by servlet SampleServlet: javax.servlet.ServletException: com/hsbc/imc/core/database/DBContext.getTypeMap
at com.ibm.ws.webcontainer.servlet.PreInitializedServ letState.init(StrictLifecycleServlet.java:271)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleSer vlet.init(StrictLifecycleServlet.java:114)
at com.ibm.ws.webcontainer.servlet.ServletInstance.in it(ServletInstance.java:197)
at javax.servlet.GenericServlet.init(GenericServlet.j ava:259)
at com.ibm.ws.webcontainer.webapp.WebAppServletManage r.addServlet(WebAppServletManager.java:789)
at com.ibm.ws.webcontainer.webapp.WebAppServletManage r.loadServlet(WebAppServletManager.java:288)
at com.ibm.ws.webcontainer.webapp.WebAppServletManage r.loadAutoLoadServlets(WebAppServletManager.java:4 75)
at com.ibm.ws.webcontainer.webapp.WebApp.loadServletM anager(WebApp.java:1234)
at com.ibm.ws.webcontainer.webapp.WebApp.init(WebApp. java:290)
at com.ibm.ws.webcontainer.srt.WebGroup.loadWebApp(We bGroup.java:321)
at com.ibm.ws.webcontainer.srt.WebGroup.init(WebGroup .java:273)
at com.ibm.ws.webcontainer.WebContainer.addWebApplica tion(WebContainer.java:963)
at com.ibm.ws****ntime.component.WebContainerImpl.inst all(WebContainerImpl.java:140)
at com.ibm.ws****ntime.component.WebContainerImpl.star t(WebContainerImpl.java:363)
at com.ibm.ws****ntime.component.ApplicationMgrImpl.st art(ApplicationMgrImpl.java:410)
at com.ibm.ws****ntime.component.DeployedApplicationIm pl.fireDeployedObjectStart(DeployedApplicationImpl .java:744)
at com.ibm.ws****ntime.component.DeployedModuleImpl.st art(DeployedModuleImpl.java:349)
at com.ibm.ws****ntime.component.DeployedApplicationIm pl.start(DeployedApplicationImpl.java:551)
at com.ibm.ws****ntime.component.ApplicationMgrImpl.st artApplication(ApplicationMgrImpl.java:275)
at com.ibm.ws****ntime.component.ApplicationMgrImpl.st art(ApplicationMgrImpl.java:243)
at com.ibm.ws****ntime.component.ContainerImpl.startCo mponents(ContainerImpl.java:352)
at com.ibm.ws****ntime.component.ContainerImpl.start(C ontainerImpl.java:235)
at com.ibm.ws****ntime.component.ApplicationServerImpl .start(ApplicationServerImpl.java:131)
at com.ibm.ws****ntime.component.ContainerImpl.startCo mponents(ContainerImpl.java:352)
at com.ibm.ws****ntime.component.ContainerImpl.start(C ontainerImpl.java:235)
at com.ibm.ws****ntime.component.ServerImpl.start(Serv erImpl.java:194)
at com.ibm.ws****ntime.WsServer.start(WsServer.java:15 7)
at com.ibm.ws****ntime.WsServer.main(WsServer.java:245 )
at java.lang.reflect.Method.invoke(Native Method)
at com.ibm.ws.bootstrap.WSLauncher.main(WSLauncher.ja va:98)
at com.ibm.etools.websphere.tools****nner.api.ServerRu nnerV5$1****n(ServerRunnerV5.java:111)
at com.ibm.ws.bootstrap.WSLauncher.main(WSLauncher.ja va:98)
at com.ibm.etools.websphere.tools****nner.api.ServerRu nnerV5$1****n(ServerRunnerV5.java:111)

[7/14/04 11:43:11:594 GMT+08:00] 67eebce7 WebGroup E SRVE0020E: [Servlet Error]-[SampleServlet]: Failed to load servlet: java.lang.AbstractMethodError: com/hsbc/imc/core/database/DBContext.getTypeMap
at com.hsbc.imc.core.system.SampleServlet.init(Sample Servlet.java:65)
at javax.servlet.GenericServlet.init(GenericServlet.j ava:259)
at com.ibm.ws.webcontainer.servlet.StrictServletInsta nce.doInit(StrictServletInstance.java:101)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleSer vlet._init(StrictLifecycleServlet.java:158)
at com.ibm.ws.webcontainer.servlet.PreInitializedServ letState.init(StrictLifecycleServlet.java:271)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleSer vlet.init(StrictLifecycleServlet.java:114)
at com.ibm.ws.webcontainer.servlet.ServletInstance.in it(ServletInstance.java:197)
at javax.servlet.GenericServlet.init(GenericServlet.j ava:259)
at com.ibm.ws.webcontainer.webapp.WebAppServletManage r.addServlet(WebAppServletManager.java:789)
at com.ibm.ws.webcontainer.webapp.WebAppServletManage r.loadServlet(WebAppServletManager.java:288)
at com.ibm.ws.webcontainer.webapp.WebAppServletManage r.loadAutoLoadServlets(WebAppServletManager.java:4 75)
at com.ibm.ws.webcontainer.webapp.WebApp.loadServletM anager(WebApp.java:1234)
at com.ibm.ws.webcontainer.webapp.WebApp.init(WebApp. java:290)
at com.ibm.ws.webcontainer.srt.WebGroup.loadWebApp(We bGroup.java:321)
at com.ibm.ws.webcontainer.srt.WebGroup.init(WebGroup .java:273)
at com.ibm.ws.webcontainer.WebContainer.addWebApplica tion(WebContainer.java:963)
at com.ibm.ws****ntime.component.WebContainerImpl.inst all(WebContainerImpl.java:140)
at com.ibm.ws****ntime.component.WebContainerImpl.star t(WebContainerImpl.java:363)
at com.ibm.ws****ntime.component.ApplicationMgrImpl.st art(ApplicationMgrImpl.java:410)
at com.ibm.ws****ntime.component.DeployedApplicationIm pl.fireDeployedObjectStart(DeployedApplicationImpl .java:744)
at com.ibm.ws****ntime.component.DeployedModuleImpl.st art(DeployedModuleImpl.java:349)
at com.ibm.ws****ntime.component.DeployedApplicationIm pl.start(DeployedApplicationImpl.java:551)
at com.ibm.ws****ntime.component.ApplicationMgrImpl.st artApplication(ApplicationMgrImpl.java:275)
at com.ibm.ws****ntime.component.ApplicationMgrImpl.st art(ApplicationMgrImpl.java:243)
at com.ibm.ws****ntime.component.ContainerImpl.startCo mponents(ContainerImpl.java:352)
at com.ibm.ws****ntime.component.ContainerImpl.start(C ontainerImpl.java:235)
at com.ibm.ws****ntime.component.ApplicationServerImpl .start(ApplicationServerImpl.java:131)
at com.ibm.ws****ntime.component.ContainerImpl.startCo mponents(ContainerImpl.java:352)
at com.ibm.ws****ntime.component.ContainerImpl.start(C ontainerImpl.java:235)
at com.ibm.ws****ntime.component.ServerImpl.start(Serv erImpl.java:194)
at com.ibm.ws****ntime.WsServer.start(WsServer.java:15 7)
at com.ibm.ws****ntime.WsServer.main(WsServer.java:245 )
at java.lang.reflect.Method.invoke(Native Method)
at com.ibm.ws.bootstrap.WSLauncher.main(WSLauncher.ja va:98)
at com.ibm.etools.websphere.tools****nner.api.ServerRu nnerV5$1****n(ServerRunnerV5.java:111)
at com.ibm.ws.bootstrap.WSLauncher.main(WSLauncher.ja va:98)
at com.ibm.etools.websphere.tools****nner.api.ServerRu nnerV5$1****n(ServerRunnerV5.java:111)

My application is just simply a Java application (not a application client / EJB), i feel strange why throw such exception. Could anyone please help, thanks in advance!

This doesn't seem to be DB2 related...

It seems that your servlet code in the com.hsbc.imc.core.system.SampleServlet class's init() method calls com.hsbc.imc.core.database.DBContext's getTypeMap() method which is abstract... you can't execute an abstract method.