Dgl0394a Error In Drivermanager.getconnection No Suitable Driver
Contents |
FacebookdeveloperWorks on TwitterdeveloperWorks on LinkedIndeveloperWorks on YouTubedeveloperWorks on Google+
(FAQ) This document applies only to the following language version(s): English Question Exception in thread "main" com.ibm.mm.sdk.common.DKDatabaseLogonFailure: DGL0394 A: Error in ::DriverManager.getConnection; No suitable driver (STATE) : ; [SERVER = cmas400c, USERID = qicmconct, SQL RC = 0, SQL STATE = 08001] at com.ibm.mm.sdk.server.DKDatastoreICM.connect(DKDatastoreICM.java:3066 Cause The library (JAR) containing the JDBC driver is not located by the classpath. With V8.1, V8.2, and V8.3, the required library is db2java.zip and is https://www.ibm.com/developerworks/community/forums/html/topic?id=77777777-0000-0000-0000-000013865580 installed in the DB2 runtime client installation folder. With V8.4 the required libraries are db2jcc.jar, db2jcc_license_cisuz.jar, and db2jcc_license.cu.jar and are installed in the IBM Content Manager installation folder. For V8.1, V8.2, and V8.3, on Windows machines where DB2 is installed in the default location: C:\Program Files\IBM\SQLLIB, this problem can occur in one following scenarios: http://www-01.ibm.com/support/docview.wss?uid=swg21212406 When you don't have db2java.zip in the CLASSPATH. When you have db2java.zip in the CLASSPATH as C:\Program Files\IBM\SQLLIB\db2java.zip. This can cause certain Windows machines to truncate the CLASSPATH value as C:\Program. For V8.4, on Windows machines where IBM Content Manager is installed in the default location: C:\Program Files\IBM\db2cmv8, this problem can occur in one following scenarios: When you don't have db2jcc.jar, db2jcc_license_cisuz.jar, and db2jcc_license.cu.jar in the CLASSPATH. When you have the db2jcc.jar, db2jcc_license_cisuz.jar, or db2jcc_license.cu.jar in the CLASSPATH as C:\Program Files\IBM\db2cmv8\db2jcc.jar. This can cause certain Windows machines to truncate the CLASSPATH value as C:\Program. Answer For V8.1, V8.2, or V8.3, add db2java.zip to the CLASSPATH as C:\Progra~1\IBM\SQLLIB\db2java.zip (adjust to fit your DB2 installation folder), using short names instead of spaces. For V8.4, add db2jcc.jar, db2jcc_license_cisuz.jar, or db2jcc_license.cu.jar to the CLASSPATH as C:\Progra~1\IBM\db2cmv8\db2jcc.jar; C:\Progra~1\IBM\db2cmv8\db2jcc_license_cisuz.jar; C:\Progra~1\IBM\db2cmv8\db2jcc_license_cu.jar (adjust to fit your DB2 installation folder), using short names instead of spaces. Cross reference information Segment Product Component Platform Version Edition Enterprise
Sign in Pricing Blog Support Search GitHub This repository Watch https://github.com/brianfrankcooper/YCSB/issues/229 158 Star 1,345 Fork 902 brianfrankcooper/YCSB Code Issues 92 http://java.ittoolbox.com/groups/technical-functional/java-l/error-in-connecting-to-ibm-db2-content-manager-2471050 Pull requests 35 Projects 0 Wiki Pulse Graphs New issue Error in database operation: java.sql.SQLException: No suitable driver found #229 Closed rsaiprashanth opened this Issue Apr 25, 2015 · 4 comments Projects None yet Labels no suitable None yet Milestone No milestone Assignees No one assigned 2 participants rsaiprashanth commented Apr 25, 2015 Hello, I am using mysql-connector-java-5.1.35 to use MySql with JDBC. I have placed mysql-connector-java-5.1.35-bin.jar in the jdbc/src/main/java/com/yahoo/ycsb/db directory of YCSB. I have changed db.properties file under conf as no suitable driver jdbc.driver=com.mysql.jdbc.Driver db.url=jdbc:mysql://localhost:3306/dbname db.user=root db.passwd= I have also placed mysql-connector-java-5.1.35-bin.jar in the CLASSPATH I have run the below command and I have Driver not found Error. Can anyone help me Command line: -db com.yahoo.ycsb.db.JdbcDBClient -threads 2 -p recordcount=500000 -P workloads/workloada -s -load Loading workload... Starting test. Adding shard node URL: Adding shard node URL: Error in database operation: java.sql.SQLException: No suitable driver found for com.yahoo.ycsb.DBException: java.sql.SQLException: No suitable driver found for at com.yahoo.ycsb.db.JdbcDBClient.init(JdbcDBClient.java:221) at com.yahoo.ycsb.DBWrapper.init(DBWrapper.java:63) at com.yahoo.ycsb.ClientThread.run(Client.java:197) Caused by: java.sql.SQLException: No suitable driver found for at java.sql.DriverManager.getConnection(DriverManager.java:596) at java.sql.DriverManager.getConnection(DriverManager.java:215) at com.yahoo.ycsb.db.JdbcDBClient.init(JdbcDBClient.java:201) ... 2 more com.yahoo.ycsb.DBException: java.sql.SQLException: No suitable driver found for at com.yahoo.ycsb.db.JdbcDBClient.init(JdbcDBClient.java:221) at com.yahoo.ycsb.DBWrapper.init(DBWrapper.java:63) at com.yahoo.ycsb.ClientThread.run(Client.java:197) Caused by: java.sql.SQLException: No suitable driver found for Error in database operation: java.sql.SQLException: No suitable driver found for com.yahoo.ycsb.DBException: java.sql.SQLException: No suitable driver found for at com.yahoo.ycsb.db.JdbcDBClient.init(JdbcDBClient.java:221) at com.yahoo.ycsb.DBWrapper
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management SAP SCM Security Siebel Storage UNIX Visual Basic Web Design and Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant MarkDeVries DACREE Inside-ERP MacProTX VoIP_News Inside-CRM PCMag maxwellarnold I_am_the_dragon Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker JoeTorre bracke Locutus Ramnath.Awate Craig Borysowich DukeGanote Dennis Stevenson Richard mircea_luca Nikki Klein AbhaiTripathi knowscognosdoi Clinton Jones blrvenkat Iqbalyk bluesguyAZ59 COMPANIES Webroot Dell Software Oracle Service Max View All Topics View All Members View All Companies Toolbox for IT Topics Java Groups Ask a New Question Java The Java group is your premier resource for objective technical discussion and peer-to-peer support on the Java programming language. Home | Invite Peers | More Java Groups Your account is ready. You're now being signed in. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. Error in connecting to IBM DB2 Content Manager Mathangi Shankar asked Nov 26, 2008 | Replies (3) Hi, When i try to connect to Content Manager through the following code : DKDatastoreICM dkDICM=null; dkDICM=new DKDatastoreICM(); dkDICM.connect("ICMNLSDB","user","pass","SCHEM A=ICMNLSDB"); i am getting the error as: com.ibm.mm.sdk.common.DKDatabaseLogonFailure: DGL0394A: Error in ::DriverManager.getConnection; No suitable driver (STATE) : ; [SERVER = DBM8, USERID = user, SQL RC = 0, SQL STATE = 08001] at com.ibm.mm.sdk.server.DKDatastoreICM.connect(DKData storeICM.java:3124) i am trying to deploy mine module on a WAS6.1 ins