Results 1 to 7 of 7
  1. #1
    Join Date
    Mar 2013
    Posts
    10

    Unanswered: DB2Driver: No suitable driver

    Hi!

    I'm working on
    DB2 9.7
    RHEL 5.2
    IBM WCS 7

    I'm trying to create instance for WebSphere Commerce 7, in that process I'm facing the issue with JDBC drivers connection. DB2 is working fine. I'm able to create database, update and so.

    But while in the creation process its trying to get JDBC connection throwing error. Here are the details:

    Code:
    UpdateUserCreationTime:
         [copy] Copying 1 file to /opt/IBM/WebSphere/CommerceServer70/schema/xml
     [Massload] Massloading /opt/IBM/WebSphere/CommerceServer70/schema/xml/wcs.keys.xml
     [Massload] -dbname pcc_cmp -dbuser DB2INST1 -dbpwd ****** -infile /opt/IBM/WebSphere/CommerceServer70/schema/xml/wcs.keys.xml -method sqlimport -commitcount 1000 -maxerror 1 -customizer  -schemaname DB2INST1 
     [Massload] No suitable driver
     [Massload] Error in MassLoading, please check logs for details.
    
    BUILD FAILED
    /opt/IBM/WebSphere/CommerceServer70/config/deployment/xml/createInstance.xml:55: The following error occurred while executing this line:
    /opt/IBM/WebSphere/CommerceServer70/config/deployment/xml/configureDatabase.xml:223: The following error occurred while executing this line:
    /opt/IBM/WebSphere/CommerceServer70/config/deployment/xml/configureDatabase.xml:230: The following error occurred while executing this line:
    /opt/IBM/WebSphere/CommerceServer70/config/deployment/xml/createBaseSchema.xml:218: Error in massloading

    Error Message:
    Code:
    > 2013-03-26 11:35:27.105, <Thread-7>, com.ibm.wca.dbconnect.DbConnectionImpl::initializeDriverManager, S1
    	The JDBC driver not found : com.ibm.db2.jcc.DB2Driver
    
    > 2013-03-26 11:35:27.108, <Thread-7>, com.ibm.wca.MassLoader.MassLoad::main, S1
    	Exception Message: java.sql.SQLException: No suitable driver : No suitable driver
    I checked all the files in "db2java.zip" all files are present and "db2jcc.jar" is also there.

    CLASSPATH
    Code:
     echo $CLASSPATH
    /home/db2inst1/sqllib/java/db2java.zip:/home/db2inst1/sqllib/java/db2jcc.jar:/home/db2inst1/sqllib/function:/home/db2inst1/sqllib/java/db2jcc_license_cu.jar:.
    java version check error:
    Code:
    java com.ibm.db2.jcc.DB2Driver -version
    Exception in thread "main" java.lang.NoSuchMethodError: main
    and
    Code:
    java com.ibm.db2.jccDB2Jcc -version
    Exception in thread "main" java.lang.NoClassDefFoundError: com/ibm/db2/jccDB2Jcc
    Caused by: java.lang.ClassNotFoundException: com.ibm.db2.jccDB2Jcc
            at java.net.URLClassLoader$1****n(URLClassLoader.java:217)
            at java.security.AccessController.doPrivileged(Native Method)
            at java.net.URLClassLoader.findClass(URLClassLoader.java:205)
            at java.lang.ClassLoader.loadClass(ClassLoader.java:319)
            at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:294)
            at java.lang.ClassLoader.loadClass(ClassLoader.java:264)
            at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:332)
    I need serious help here. Please help me to solve and understand.
    P.S. I'm a newbie

    Thanks

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    what is the connection string being used for this connection in WSC
    is the db accessible from local/remote client without this software in between
    verify that the classpath is propagated to WSC.. I have seen environments where something is running in background and does not get the classpath from profile.
    sometimes it is needed to hard-code the classpath is specific scripts of this middleware
    check the doc for this product and how to setup a connection
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Mar 2013
    Posts
    10
    Quote Originally Posted by przytula_guy View Post
    what is the connection string being used for this connection in WSC
    is the db accessible from local/remote client without this software in between
    verify that the classpath is propagated to WSC.. I have seen environments where something is running in background and does not get the classpath from profile.
    sometimes it is needed to hard-code the classpath is specific scripts of this middleware
    check the doc for this product and how to setup a connection
    can you please help with the url to look forward.

  4. #4
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    even a newbie should be able to execute a google search as this
    Let me google that for you
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  5. #5
    Join Date
    Mar 2013
    Posts
    10
    Quote Originally Posted by przytula_guy View Post
    even a newbie should be able to execute a google search as this
    Let me google that for you
    ha ha ..i hv checked it already...lots of googling done before coming here...couldn't found something.
    BTW i learn something more "they site u used to google and showing to me" good one...

    now i'm able to connect to this db without using WSC. while connecting its providing me errors. even directly db2 is working fine. Can you point out where to hard code it?

  6. #6
    Join Date
    Mar 2013
    Posts
    10
    anybody have any idea??

  7. #7
    Join Date
    Mar 2013
    Posts
    10
    ok somehow last error got solved...now the new one. i'm sure its related to db2 only.

    Error:
    Code:
     [Massload] Massloading /opt/IBM/WebSphere/CommerceServer70/components/foundation/xml/wcs.fep1.bootstrap_foundation_fr_FR.xml
     [Massload] -dbname pcc_cmp -dbuser DB2INST1 -dbpwd ****** -infile /opt/IBM/WebSphere/CommerceServer70/components/foundation/xml/wcs.fep1.bootstrap_foundation_fr_FR.xml -method sqlimport -commitcount 1000 -maxerror 1 -customizer  -schemaname DB2INST1
     [Massload] Massloading /opt/IBM/WebSphere/CommerceServer70/components/foundation/xml/wcs.fep1.bootstrap_foundation_it_IT.xml
     [Massload] -dbname pcc_cmp -dbuser DB2INST1 -dbpwd ****** -infile /opt/IBM/WebSphere/CommerceServer70/components/foundation/xml/wcs.fep1.bootstrap_foundation_it_IT.xml -method sqlimport -commitcount 1000 -maxerror 1 -customizer  -schemaname DB2INST1
     [Massload] Massloading /opt/IBM/WebSphere/CommerceServer70/components/foundation/xml/wcs.fep1.bootstrap_foundation_ja_JP.xml
     [Massload] -dbname pcc_cmp -dbuser DB2INST1 -dbpwd ****** -infile /opt/IBM/WebSphere/CommerceServer70/components/foundation/xml/wcs.fep1.bootstrap_foundation_ja_JP.xml -method sqlimport -commitcount 1000 -maxerror 1 -customizer  -schemaname DB2INST1
     [Massload] Massloading /opt/IBM/WebSphere/CommerceServer70/components/foundation/xml/wcs.fep1.bootstrap_foundation_ko_KR.xml
     [Massload] -dbname pcc_cmp -dbuser DB2INST1 -dbpwd ****** -infile /opt/IBM/WebSphere/CommerceServer70/components/foundation/xml/wcs.fep1.bootstrap_foundation_ko_KR.xml -method sqlimport -commitcount 1000 -maxerror 1 -customizer  -schemaname DB2INST1
     [Massload] Massloading /opt/IBM/WebSphere/CommerceServer70/components/foundation/xml/wcs.fep1.bootstrap_foundation_pl_PL.xml
     [Massload] -dbname pcc_cmp -dbuser DB2INST1 -dbpwd ****** -infile /opt/IBM/WebSphere/CommerceServer70/components/foundation/xml/wcs.fep1.bootstrap_foundation_pl_PL.xml -method sqlimport -commitcount 1000 -maxerror 1 -customizer  -schemaname DB2INST1
     [Massload] Massloading /opt/IBM/WebSphere/CommerceServer70/components/foundation/xml/wcs.fep1.bootstrap_foundation_pt_BR.xml
     [Massload] -dbname pcc_cmp -dbuser DB2INST1 -dbpwd ****** -infile /opt/IBM/WebSphere/CommerceServer70/components/foundation/xml/wcs.fep1.bootstrap_foundation_pt_BR.xml -method sqlimport -commitcount 1000 -maxerror 1 -customizer  -schemaname DB2INST1
     [Massload] Massloading /opt/IBM/WebSphere/CommerceServer70/components/foundation/xml/wcs.fep1.bootstrap_foundation_ro_RO.xml
     [Massload] -dbname pcc_cmp -dbuser DB2INST1 -dbpwd ****** -infile /opt/IBM/WebSphere/CommerceServer70/components/foundation/xml/wcs.fep1.bootstrap_foundation_ro_RO.xml -method sqlimport -commitcount 1000 -maxerror 1 -customizer  -schemaname DB2INST1
     [Massload] Massloading /opt/IBM/WebSphere/CommerceServer70/components/foundation/xml/wcs.fep1.bootstrap_foundation_ru_RU.xml
     [Massload] -dbname pcc_cmp -dbuser DB2INST1 -dbpwd ****** -infile /opt/IBM/WebSphere/CommerceServer70/components/foundation/xml/wcs.fep1.bootstrap_foundation_ru_RU.xml -method sqlimport -commitcount 1000 -maxerror 1 -customizer  -schemaname DB2INST1
     [Massload] Massloading /opt/IBM/WebSphere/CommerceServer70/components/foundation/xml/wcs.fep1.bootstrap_foundation_zh_CN.xml
     [Massload] -dbname pcc_cmp -dbuser DB2INST1 -dbpwd ****** -infile /opt/IBM/WebSphere/CommerceServer70/components/foundation/xml/wcs.fep1.bootstrap_foundation_zh_CN.xml -method sqlimport -commitcount 1000 -maxerror 1 -customizer  -schemaname DB2INST1
     [Massload] Massloading /opt/IBM/WebSphere/CommerceServer70/components/foundation/xml/wcs.fep1.bootstrap_foundation_zh_TW.xml
     [Massload] -dbname pcc_cmp -dbuser DB2INST1 -dbpwd ****** -infile /opt/IBM/WebSphere/CommerceServer70/components/foundation/xml/wcs.fep1.bootstrap_foundation_zh_TW.xml -method sqlimport -commitcount 1000 -maxerror 1 -customizer  -schemaname DB2INST1
    [forEachTask] fepLevel: fep2
    
    loadBootstrapDataForFEPLevel:
     [Massload] Massloading /opt/IBM/WebSphere/CommerceServer70/components/foundation/xml/wcs.fep2.bootstrap_foundation.xml
     [Massload] -dbname pcc_cmp -dbuser DB2INST1 -dbpwd ****** -infile /opt/IBM/WebSphere/CommerceServer70/components/foundation/xml/wcs.fep2.bootstrap_foundation.xml -method sqlimport -commitcount 1000 -maxerror 1 -customizer  -schemaname DB2INST1
     [Massload] Massloading /opt/IBM/WebSphere/CommerceServer70/components/foundation/xml/wcs.fep2.bootstrap_foundation_en_US.xml
     [Massload] -dbname pcc_cmp -dbuser DB2INST1 -dbpwd ****** -infile /opt/IBM/WebSphere/CommerceServer70/components/foundation/xml/wcs.fep2.bootstrap_foundation_en_US.xml -method sqlimport -commitcount 1000 -maxerror 1 -customizer  -schemaname DB2INST1
     [Massload] Massloading /opt/IBM/WebSphere/CommerceServer70/components/foundation/xml/wcs.fep2.bootstrap_foundation_pricerule.xml
     [Massload] -dbname pcc_cmp -dbuser DB2INST1 -dbpwd ****** -infile /opt/IBM/WebSphere/CommerceServer70/components/foundation/xml/wcs.fep2.bootstrap_foundation_pricerule.xml -method sqlimport -commitcount 1000 -maxerror 1 -customizer  -schemaname DB2INST1
    [forEachTask] fepLevel: fep3
    
    loadBootstrapDataForFEPLevel:
     [Massload] Massloading /opt/IBM/WebSphere/CommerceServer70/components/foundation/xml/wcs.fep3.bootstrap_foundation.xml
     [Massload] -dbname pcc_cmp -dbuser DB2INST1 -dbpwd ****** -infile /opt/IBM/WebSphere/CommerceServer70/components/foundation/xml/wcs.fep3.bootstrap_foundation.xml -method sqlimport -commitcount 1000 -maxerror 1 -customizer  -schemaname DB2INST1
     [Massload] Massloading /opt/IBM/WebSphere/CommerceServer70/components/foundation/xml/wcs.fep3.bootstrap_foundation_de_DE.xml
     [Massload] -dbname pcc_cmp -dbuser DB2INST1 -dbpwd ****** -infile /opt/IBM/WebSphere/CommerceServer70/components/foundation/xml/wcs.fep3.bootstrap_foundation_de_DE.xml -method sqlimport -commitcount 1000 -maxerror 1 -customizer  -schemaname DB2INST1
    Unhandled exception
    Type=Segmentation error vmState=0x00000000
    J9Generic_Signal_Number=00000004 Signal_Number=0000000b Error_Value=00000000 Signal_Code=00000001
    Handler1=00002AAAAACE7200 Handler2=00002AAAAB06F720 InaccessibleAddress=000000000000012C
    RDI=0000000019623D00 RSI=0000000000000006 RAX=0000000000000000 RBX=0000000000000000
    RCX=00002AAAAAE47860 RDX=00002AAAAAE46B40 R8=0000000040D8DC98 R9=0000000040D8D5F8
    R10=0000000000000020 R11=00002AAAB9C74266 R12=0000000000000000 R13=00002AAABE5052A8
    R14=000000001955AE08 R15=0000000000000000
    RIP=00002AAAB9C736D6 GS=0000 FS=0000 RSP=0000000040D8D880
    EFlags=0000000000210246 CS=0033 RBP=0000000019623D00 ERR=0000000000000004
    TRAPNO=000000000000000E OLDMASK=0000000000000000 CR2=000000000000012C
    xmm0 0000000000000000 (f: 0.000000, d: 0.000000e+00)
    xmm1 0000000000000000 (f: 0.000000, d: 0.000000e+00)
    xmm2 0000000000000000 (f: 0.000000, d: 0.000000e+00)
    xmm3 0000000000000000 (f: 0.000000, d: 0.000000e+00)
    xmm4 0000000000000000 (f: 0.000000, d: 0.000000e+00)
    xmm5 0000000000000000 (f: 0.000000, d: 0.000000e+00)
    xmm6 00002aaaaae4a100 (f: 2867110144.000000, d: 2.317785e-310)
    xmm7 00000000194d2f18 (f: 424488736.000000, d: 2.097253e-315)
    xmm8 0000000100000000 (f: 0.000000, d: 2.121996e-314)
    xmm9 0000000100000001 (f: 1.000000, d: 2.121996e-314)
    xmm10 0000000000000000 (f: 0.000000, d: 0.000000e+00)
    xmm11 0000000000000000 (f: 0.000000, d: 0.000000e+00)
    xmm12 0000000000000000 (f: 0.000000, d: 0.000000e+00)
    xmm13 0000000000000000 (f: 0.000000, d: 0.000000e+00)
    xmm14 0000000000000000 (f: 0.000000, d: 0.000000e+00)
    xmm15 0000000000000000 (f: 0.000000, d: 0.000000e+00)
    Module=/opt/IBM/db2/V9.5/lib64/libdb2jcct2.so
    Module_base_address=00002AAAB9C6B000 Symbol=Java_com_ibm_db2_jcc_uw_UWAdministrator_nativeGetCataloguedDatabases
    Symbol_address=00002AAAB9C7334A
    Target=2_40_20090612_037149_LHdSMr (Linux 2.6.18-194.el5)
    CPU=amd64 (2 logical CPUs) (0x1f2fb9000 RAM)
    ----------- Stack Backtrace -----------
    /opt/IBM/WebSphere/AppServer/java/jre/lib/amd64/default/libj9prt24.so [0x2aaaab067d33]
    /opt/IBM/WebSphere/AppServer/java/jre/lib/amd64/default/libj9vm24.so [0x2aaaaace7cad]
    /opt/IBM/WebSphere/AppServer/java/jre/lib/amd64/default/libj9vm24.so [0x2aaaaace7b5f]
    /opt/IBM/WebSphere/AppServer/java/jre/lib/amd64/default/libj9prt24.so [0x2aaaab06ee21]
    /opt/IBM/WebSphere/AppServer/java/jre/lib/amd64/default/libj9vm24.so [0x2aaaaace728b]
    /opt/IBM/WebSphere/AppServer/java/jre/lib/amd64/default/libj9prt24.so [0x2aaaab06f891]
    /lib64/libc.so.6 [0x3b7aa302d0]
    /opt/IBM/db2/V9.5/lib64/libdb2jcct2.so(Java_com_ibm_db2_jcc_uw_UWAdministrator_nativeGetCataloguedDatabases+0x38c) [0x2aaab9c736d6]
    [0x2aaab8342f5a]
    ---------------------------------------
    JVMDUMP006I Processing dump event "gpf", detail "" - please wait.
    JVMDUMP032I JVM requested System dump using '/opt/IBM/WebSphere/CommerceServer70/bin/core.20130327.185113.11893.0001.dmp' in response to an event
    JVMDUMP010I System dump written to /opt/IBM/WebSphere/CommerceServer70/bin/core.20130327.185113.11893.0001.dmp
    JVMDUMP032I JVM requested Snap dump using '/opt/IBM/WebSphere/CommerceServer70/bin/Snap.20130327.185113.11893.0002.trc' in response to an event
    JVMDUMP010I Snap dump written to /opt/IBM/WebSphere/CommerceServer70/bin/Snap.20130327.185113.11893.0002.trc
    JVMDUMP032I JVM requested Java dump using '/opt/IBM/WebSphere/CommerceServer70/bin/javacore.20130327.185113.11893.0003.txt' in response to an event
    JVMDUMP010I Java dump written to /opt/IBM/WebSphere/CommerceServer70/bin/javacore.20130327.185113.11893.0003.txt
    JVMDUMP013I Processed dump event "gpf", detail "".
    The log file may contain more details about the failure.  See <WC_InstallDir>/instances/<instance_name>/logs/
    \n
    Troubleshooting help is available in the WebSphere Commerce Information Center
    http://publib.boulder.ibm.com/infocenter/wchelp/v7r0m0/topic/com.ibm.commerce.admin.doc/concepts/covtroubleshooting.htm

    Its kinda related to some hardware ...showing some weird hex error code.
    Please help me to understand.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •