Win a copy of Five Lines of Code this week in the OO, Patterns, UML and Refactoring forum!
  • 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 all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Bear Bibeault
  • Ron McLeod
  • Jeanne Boyarsky
  • Paul Clapham
Sheriffs:
  • Tim Cooke
  • Liutauras Vilda
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • fred rosenberger
  • salvin francis
Bartenders:
  • Piet Souris
  • Frits Walraven
  • Carey Brown

DB2 DataSource

 
Greenhorn
Posts: 10
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
*** Starting the server ***
************ Start Display Current Environment ************
WebSphere Platform 5.0 [BASE 5.0.0 s0245.03] running with process name localhost\localhost\server1 and process id 3832
Host Operating System is Windows XP, version 5.1
Java version = J2RE 1.3.1 IBM Windows 32 build cn131-20021107 (JIT enabled: jitc), Java Compiler = jitc, Java VM name = Classic VM
was.install.root = C:\Program Files\IBM\WebSphere Studio\runtimes\base_v5
user.install.root = C:\Program Files\IBM\WebSphere Studio\runtimes\base_v5
Java Home = C:\Program Files\IBM\WebSphere Studio\runtimes\base_v5\java\jre
ws.ext.dirs = C:\Program Files\IBM\WebSphere Studio\runtimes\base_v5/java/lib;C:\Program Files\IBM\WebSphere Studio\runtimes\base_v5/classes;C:\Program Files\IBM\WebSphere Studio\runtimes\base_v5/classes;C:\Program Files\IBM\WebSphere Studio\runtimes\base_v5/lib;C:\Program Files\IBM\WebSphere Studio\runtimes\base_v5/lib/ext;C:\Program Files\IBM\WebSphere Studio\runtimes\base_v5/web/help;C:\Program Files\IBM\WebSphere Studio\runtimes\base_v5/deploytool/itp/plugins/com.ibm.etools.ejbdeploy/runtime;C:/SQLLIB/java/db2java.zip;C:/Program Files/IBM/WebSphere Studio/wstools/eclipse/plugins/com.ibm.etools.webservice_5.0.1/runtime/worf.jar
Classpath = C:\Program Files\IBM\WebSphere Studio\runtimes\base_v5/properties;C:\Program Files\IBM\WebSphere Studio\runtimes\base_v5/properties;C:\Program Files\IBM\WebSphere Studio\runtimes\base_v5/lib/bootstrap.jar;C:\Program Files\IBM\WebSphere Studio\runtimes\base_v5/lib/j2ee.jar;C:\Program Files\IBM\WebSphere Studio\runtimes\base_v5/lib/lmproxy.jar;C:/Program Files/IBM/WebSphere Studio/wstools/eclipse/plugins/com.ibm.etools.websphere.tools.common_5.0.1.1/runtime/wteServers.jar;C:/Program Files/IBM/WebSphere Studio/wstools/eclipse/plugins/com.ibm.etools.websphere.tools.common_5.0.1.1/runtime/wasToolsCommon.jar
Java Library path = C:\Program Files\IBM\WebSphere Studio\runtimes\base_v5/bin;C:\Program Files\IBM\WebSphere Studio\runtimes\base_v5/java/bin;C:\Program Files\IBM\WebSphere Studio\runtimes\base_v5/java/jre/bin;C:\Program Files\IBM\WebSphere Studio\eclipse\jre\bin;.;C:\WINDOWS\System32;C:\WINDOWS;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\IBM\IBM CICS Transaction Gateway\BIN;C:\Program Files\IBM\WebSphere Studio\runtimes\base_v5\java\bin;C:\IBM\IMNNQ;C:\j2sdk1.4.2_06\bin;C:\SQLLIB\BIN;C:\SQLLIB\FUNCTION;C:\SQLLIB\SAMPLES\REPL;C:\SQLLIB\HELP
************* End Display Current Environment *************
[12/22/04 20:27:09:156 CST] 5fa07e47 ManagerAdmin I TRAS0017I: The startup trace state is *=all=disabled.
[12/22/04 20:27:09:844 CST] 5fa07e47 AdminInitiali A ADMN0015I: AdminService initialized
[12/22/04 20:27:10:672 CST] 5fa07e47 Configuration A SECJ0215I: Successfully set JAAS login provider configuration class to com.ibm.ws.security.auth.login.Configuration.
[12/22/04 20:27:10:734 CST] 5fa07e47 SecurityDM I SECJ0231I: The Security component's FFDC Diagnostic Module com.ibm.ws.security.core.SecurityDM registered successfully: true.
[12/22/04 20:27:11:078 CST] 5fa07e47 SecurityCompo I SECJ0309I: Java 2 Security is disabled.
[12/22/04 20:27:11:109 CST] 5fa07e47 SecurityCompo I SECJ0212I: WCCM JAAS configuration information successfully pushed to login provider class.
[12/22/04 20:27:11:188 CST] 5fa07e47 SecurityCompo I SECJ0240I: Security service initialization completed successfully
[12/22/04 20:27:11:203 CST] 5fa07e47 JMSRegistrati A MSGS0602I: WebSphere Embedded Messaging Client only has been installed
[12/22/04 20:27:16:578 CST] 5fa07e47 JMXSoapAdapte A ADMC0013I: SOAP connector available at port 8880
[12/22/04 20:27:16:641 CST] 5fa07e47 SecurityCompo I SECJ0243I: Security service started successfully
[12/22/04 20:27:16:641 CST] 5fa07e47 SecurityCompo I SECJ0210I: Security enabled false
[12/22/04 20:27:19:422 CST] 5fa07e47 ResourceMgrIm I WSVR0049I: Binding WETSADB as jdbc/WETSADB
[12/22/04 20:27:25:672 CST] 5fa07e47 CacheServiceI I DYNA0048I: WebSphere Dynamic Cache initialized successfully.
[12/22/04 20:27:26:094 CST] 5fa07e47 FileBeanStore W CNTR0023W: Directory "C:\Program Files\IBM\WebSphere Studio\runtimes\base_v5/temp" does not exist. The EJB Container will use the current directory for passivating beans.
[12/22/04 20:27:29:578 CST] 5fa07e47 ApplicationMg A WSVR0200I: Starting application: IBMUTC
[12/22/04 20:27:29:812 CST] 5fa07e47 WebContainer A SRVE0161I: IBM WebSphere Application Server - Web Container. Copyright IBM Corp. 1998-2002
[12/22/04 20:27:30:000 CST] 5fa07e47 WebContainer A SRVE0162I: Servlet Specification Level: 2.3
[12/22/04 20:27:30:000 CST] 5fa07e47 WebContainer A SRVE0163I: Supported JSP Specification Level: 1.2
[12/22/04 20:27:30:438 CST] 5fa07e47 WebContainer A SRVE0169I: Loading Web Module: IBM Universal Test Client.
[12/22/04 20:27:30:891 CST] 5fa07e47 WebGroup I SRVE0180I: [IBM Universal Test Client] [/UTC] [Servlet.LOG]: JSP 1.2 Processor: init
[12/22/04 20:27:31:375 CST] 5fa07e47 WebGroup I SRVE0180I: [IBM Universal Test Client] [/UTC] [Servlet.LOG]: SimpleFileServlet: init
[12/22/04 20:27:31:578 CST] 5fa07e47 ApplicationMg A WSVR0221I: Application started: IBMUTC
[12/22/04 20:27:31:578 CST] 5fa07e47 ApplicationMg A WSVR0200I: Starting application: adminconsole
[12/22/04 20:27:36:984 CST] 5fa07e47 WebContainer A SRVE0169I: Loading Web Module: adminconsole.
[12/22/04 20:27:37:062 CST] 5fa07e47 WebGroup I SRVE0180I: [adminconsole] [/admin] [Servlet.LOG]: JSP 1.2 Processor: init
[12/22/04 20:27:37:625 CST] 5fa07e47 WebGroup I SRVE0180I: [adminconsole] [/admin] [Servlet.LOG]: SimpleFileServlet: init
[12/22/04 20:27:37:641 CST] 5fa07e47 WebGroup I SRVE0180I: [adminconsole] [/admin] [Servlet.LOG]: InvokerServlet: init
[12/22/04 20:27:37:703 CST] 5fa07e47 WebGroup I SRVE0180I: [adminconsole] [/admin] [Servlet.LOG]: validator: init
[12/22/04 20:27:38:406 CST] 5fa07e47 WebGroup I SRVE0180I: [adminconsole] [/admin] [Servlet.LOG]: EventInitializer: init
[12/22/04 20:27:38:594 CST] 5fa07e47 WebGroup I SRVE0180I: [adminconsole] [/admin] [Servlet.LOG]: action: init
[12/22/04 20:27:40:234 CST] 5fa07e47 WebGroup I SRVE0180I: [adminconsole] [/admin] [Servlet.LOG]: action: Tiles definition factory loaded
[12/22/04 20:27:40:234 CST] 5fa07e47 WebGroup I SRVE0180I: [adminconsole] [/admin] [Servlet.LOG]: SecureCleanup: init
[12/22/04 20:27:40:281 CST] 5fa07e47 ApplicationMg A WSVR0221I: Application started: adminconsole
[12/22/04 20:27:40:297 CST] 5fa07e47 ApplicationMg A WSVR0200I: Starting application: wetsa_app
[12/22/04 20:27:40:344 CST] 5fa07e47 WebContainer A SRVE0169I: Loading Web Module: wetsa_appWeb.
[12/22/04 20:27:40:359 CST] 5fa07e47 WebGroup I SRVE0180I: [wetsa_appWeb] [/wetsa_appWeb] [Servlet.LOG]: JSP 1.2 Processor: init
[12/22/04 20:27:40:422 CST] 5fa07e47 WebGroup I SRVE0180I: [wetsa_appWeb] [/wetsa_appWeb] [Servlet.LOG]: SimpleFileServlet: init
[12/22/04 20:27:40:438 CST] 5fa07e47 WebGroup I SRVE0180I: [wetsa_appWeb] [/wetsa_appWeb] [Servlet.LOG]: InvokerServlet: init
[12/22/04 20:27:40:438 CST] 5fa07e47 ApplicationMg A WSVR0221I: Application started: wetsa_app
[12/22/04 20:27:40:469 CST] 5fa07e47 HttpTransport A SRVE0171I: Transport http is listening on port 9,080.
[12/22/04 20:27:43:453 CST] 5fa07e47 HttpTransport A SRVE0171I: Transport https is listening on port 9,443.
[12/22/04 20:27:43:469 CST] 5fa07e47 HttpTransport A SRVE0171I: Transport http is listening on port 9,090.
[12/22/04 20:27:43:625 CST] 5fa07e47 HttpTransport A SRVE0171I: Transport https is listening on port 9,043.
[12/22/04 20:27:43:688 CST] 5fa07e47 RMIConnectorC A ADMC0026I: RMI Connector available at port 2809
[12/22/04 20:27:43:828 CST] 5fa07e47 WsServer A WSVR0001I: Server server1 open for e-business
[12/22/04 20:27:45:188 CST] 393a3e4d WebGroup I SRVE0180I: [wetsa_appWeb] [/wetsa_appWeb] [Servlet.LOG]: /index.jsp: init
[12/22/04 20:27:45:609 CST] 393a3e4d WebGroup I SRVE0180I: [wetsa_appWeb] [/wetsa_appWeb] [Servlet.LOG]: /Header.jsp: init
[12/22/04 20:27:45:672 CST] 393a3e4d WebGroup I SRVE0180I: [wetsa_appWeb] [/wetsa_appWeb] [Servlet.LOG]: /WetsaHeader.jsp: init
[12/22/04 20:27:45:766 CST] 393a3e4d WebGroup I SRVE0180I: [wetsa_appWeb] [/wetsa_appWeb] [Servlet.LOG]: /Copyright.jsp: init
[12/22/04 20:28:48:344 CST] 393a3e4d WebGroup I SRVE0180I: [wetsa_appWeb] [/wetsa_appWeb] [Servlet.LOG]: /ProviderList.jsp: init
[12/22/04 20:28:53:469 CST] 393a3e4d WebGroup I SRVE0180I: [wetsa_appWeb] [/wetsa_appWeb] [Servlet.LOG]: ProviderListServlet: init
[12/22/04 20:28:53:516 CST] 393a3e4d SystemOut O US.IL.state.cms.wetsa.Servlet.ProviderListServlet@761be57:BaseServlet init():today date is Wed Dec 22 20:28:53 CST 2004
[12/22/04 20:28:53:516 CST] 393a3e4d SystemOut O US.IL.state.cms.wetsa.Servlet.ProviderListServlet@761be57:BaseServlet init():Store context factory successful
[12/22/04 20:28:53:516 CST] 393a3e4d SystemOut O US.IL.state.cms.wetsa.Servlet.ProviderListServlet@761be57:BaseServlet init():Create naming context successful
[12/22/04 20:28:53:953 CST] 393a3e4d ConnectionFac E J2CA0036E: An exception occurred while invoking method setDataSourceProperties on com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl used by resource jdbc/WETSADB : java.lang.reflect.InvocationTargetException: com.ibm.ws.exception.WsException: DSRA0023E: The DataSource implementation class "COM.ibm.db2.jdbc.DB2ConnectionPoolDataSource" could not be found.
at com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException.<init>(DataStoreAdapterException.java:251)
at com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException.<init>(DataStoreAdapterException.java:172)
at com.ibm.ws.rsadapter.AdapterUtil.createDataStoreAdapterException(AdapterUtil.java:182)
at com.ibm.ws.rsadapter.DSConfigurationHelper.createDataSource(DSConfigurationHelper.java:507)
at com.ibm.ws.rsadapter.spi.WSRdbDataSource$1.run(WSRdbDataSource.java:441)
at java.security.AccessController.doPrivileged(Native Method)
at com.ibm.ws.rsadapter.spi.WSRdbDataSource.createNewDataSource(WSRdbDataSource.java:437)
at com.ibm.ws.rsadapter.spi.WSRdbDataSource.<init>(WSRdbDataSource.java:169)
at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.setDataSourceProperties(WSManagedConnectionFactoryImpl.java:724)
at java.lang.reflect.Method.invoke(Native Method)
at com.ibm.ejs.j2c.ConnectionFactoryBuilderImpl.createCFD_Common(ConnectionFactoryBuilderImpl.java:550)
at com.ibm.ejs.j2c.ConnectionFactoryBuilderImpl.createConnectionFactoryDetails(ConnectionFactoryBuilderImpl.java:403)
at com.ibm.ejs.j2c.ConnectionFactoryBuilderImpl.getObjectInstance(ConnectionFactoryBuilderImpl.java:1280)
at javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:313)
 
Dong Hoang
Greenhorn
Posts: 10
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Does anyone knows why I am getting this message? Am I missing a package in my path?

COM.ibm.db2.jdbc.DB2ConnectionPoolDataSource not found

Thanks
 
Ranch Hand
Posts: 118
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi.

I think you're missing the db2java.zip file in your classpath for the JDBC Provider.

Which type of connection are you trying? jdbc type 2 or type 4?

/Peter
 
Ranch Hand
Posts: 57
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I had a similar issue with Web Projects trying to use db2jcc.jar. It wouldn't work if I added it as an 'External Jar' to the 'Build Path'. I had to copy it into each Web Project's WEB-INF/lib folder.
 
Wait for it ... wait .... wait .... NOW! Pafiffle! A perfect tiny ad!
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
    Bookmark Topic Watch Topic
  • New Topic