For help with installation, bugs reports or feature requests, please head over to our new forums.
Genuitec Community on GitHub
- This topic has 9 replies, 4 voices, and was last updated 18 years, 11 months ago by
.
-
Posts
-
– System Setup ——————————-
Operating System and version: Windows XP SP2
Eclipse version: 3.1M6
Eclipse build id: I20050401-1645
Fresh Eclipse install (y/n): y
If not, was it upgraded to its current version using the update manager?
Other installed external plugins:
Number of plugins in the <eclipse>/plugins directory that begin with org.eclipse.pde.*: 8
MyEclipse version: 3.8.4_3.1M6
Eclipse JDK version: jdk1.5.0_01
Application Server JDK version: j2sdk1.4.2_08 (also tried jdk1.5.0_01, same issue)
Are there any exceptions in the Eclipse log file? NoIf this is a DB related question please answer the following:
RDBMS vendor and version: IBM DB2 v8.1.7
JDBC driver vendor and version, and access type (thin, type-2, etc): ?, Using DB2 8.1.7 driver COM.ibm.db2.jdbc.app.DB2Driver
Connection URL: jdbc:db2:DB2RLSE
Eclipse error logs related to com.genuitec.eclipse.sqlexplorer packages:– Message Body ——————————-
I am encountering some errors while starting up OC4J in MyEclipse (that I do not encounter while starting it from the command line). Basically it seems to not pick up the classpath entries I’ve added since it cannot find the DB2 driver.MyEclipse Oracle 9i/AS Application Server configuration
Optional Program Arguments: -userThreads
Optional Java VM Arguments: -Doracle.cts.useCtsFlags=false -Doracle.jdbc.J2EE13Compliant=false
Jars append to classpath: C:\opt\oc4j10.1.2\j2ee\home\lib\db2java.zip
Dirs append to classpath: C:\opt\oc4j10.1.2\j2ee\homeThe output I get when I start the app server in MyEclipse is:
05/04/28 11:46:00 Error initializing data-source ‘jdbc/workbrain’: DriverManagerDataSource driver ‘COM.ibm.db2.jdbc.app.DB2Driver’ not found
05/04/28 11:46:05 Log4j>> Unknown error configuring Log4j.
05/04/28 11:46:05 Log4j>> Logging will not be available.
05/04/28 11:46:05 java.sql.SQLException: No suitable driver
05/04/28 11:46:05 at java.sql.DriverManager.getConnection(DriverManager.java:545)
05/04/28 11:46:05 at java.sql.DriverManager.getConnection(DriverManager.java:140)
05/04/28 11:46:05 at com.evermind.sql.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:213)
05/04/28 11:46:05 at com.evermind.sql.DriverManagerConnectionPoolDataSource.getPooledConnection(DriverManagerConnectionPoolDataSource.java:36)
05/04/28 11:46:05 at com.evermind.sql.OrionPooledDataSource.getPooledConnection(OrionPooledDataSource.java:582)
05/04/28 11:46:05 at com.evermind.sql.PooledConnectionUsage.getPooledConnection(PooledConnectionUsage.java:22)
05/04/28 11:46:05 at com.evermind.sql.OrionPooledDataSource.getConnection(OrionPooledDataSource.java:346)
05/04/28 11:46:05 at com.evermind.sql.OrionCMTConnection.setConnection(OrionCMTConnection.java:191)
05/04/28 11:46:05 at com.evermind.sql.OrionCMTConnection.intercept(OrionCMTConnection.java:141)
05/04/28 11:46:05 at com.evermind.sql.OrionCMTConnection.setAutoCommit(OrionCMTConnection.java:479)
05/04/28 11:46:05 at com.workbrain.server.sql.ConnectionManager.getConnection(ConnectionManager.java:276)
05/04/28 11:46:05 at com.workbrain.server.sql.ConnectionManager.getConnection(ConnectionManager.java:69)
05/04/28 11:46:05 at com.workbrain.util.log4j.Log4jHelper.getProperties(Log4jHelper.java:43)
05/04/28 11:46:05 at com.workbrain.util.log4j.Log4jHelper.configure(Log4jHelper.java:24)
05/04/28 11:46:05 at com.workbrain.util.startup.StartupServlet.init(StartupServlet.java:24)
05/04/28 11:46:05 at javax.servlet.GenericServlet.init(GenericServlet.java:258)
05/04/28 11:46:05 at com.evermind.server.http.HttpApplication.loadServlet(HttpApplication.java:2141)
05/04/28 11:46:05 at com.evermind.server.http.HttpApplication.findServlet(HttpApplication.java:4582)
05/04/28 11:46:05 at com.evermind.server.http.HttpApplication.initPreloadServlets(HttpApplication.java:4676)
05/04/28 11:46:05 at com.evermind.server.http.HttpApplication.initDynamic(HttpApplication.java:820)
05/04/28 11:46:05 at com.evermind.server.http.HttpApplication.<init>(HttpApplication.java:542)
05/04/28 11:46:05 at com.evermind.server.Application.getHttpApplication(Application.java:889)
05/04/28 11:46:05 at com.evermind.server.http.HttpServer.getHttpApplication(HttpServer.java:690)
05/04/28 11:46:05 at com.evermind.server.http.HttpSite.initApplications(HttpSite.java:561)
05/04/28 11:46:05 at com.evermind.server.http.HttpSite.setConfig(HttpSite.java:263)
05/04/28 11:46:05 at com.evermind.server.http.HttpServer.setSites(HttpServer.java:261)
05/04/28 11:46:05 at com.evermind.server.http.HttpServer.setConfig(HttpServer.java:162)
05/04/28 11:46:05 at com.evermind.server.ApplicationServer.initializeHttp(ApplicationServer.java:2385)
05/04/28 11:46:05 at com.evermind.server.ApplicationServer.setConfig(ApplicationServer.java:1542)
05/04/28 11:46:05 at com.evermind.server.ApplicationServerLauncher.run(ApplicationServerLauncher.java:92)
05/04/28 11:46:05 at java.lang.Thread.run(Thread.java:595)
05/04/28 11:46:05 log4j:WARN No appenders could be found for logger (com.workbrain.util.startup.StartupServlet).
05/04/28 11:46:05 log4j:WARN Please initialize the log4j system properly.
05/04/28 11:46:12 Oracle Application Server Containers for J2EE 10g (10.1.2.0.0) initializedI am having the exact same issue. I tried to prepend or append the driver on the connector settings and paths, with no luck.
I also appended the directories SQLLIB/LIB, SQLLIB/BIN and SQLLIB/FUNCTION to the library path.
Any hint appreciated, thanks.lzoso,
Are you having *exactly* the same problem, or a similar problem? Maybe your exception will shed some light on what is going wrong specifically with your setup.Thanks for getting into this. Here’s the details:
MyEclipse 5.0.1 GA. Build id: 20060810-5.0.1-GA
Eclipse version 3.2
Application Server JDK version: j2sdk1.4.2_02
RDBMS vendor and version: IBM DB2 v8.2
JDBC driver vendor and version, and access type (thin, type-2, etc): ? Using DB2 8.2 driver COM.ibm.db2.jdbc.app.DB2Driver
Connection URL: jdbc:db2:jdbc:db2:RD50FP4Stack trace:
06/09/21 11:13:55 Error initializing data-source ‘jdbc/workbrain’: DriverManagerDataSource driver ‘COM.ibm.db2.jdbc.app.DB2Driver’ not found
06/09/21 11:13:59 Log4j>> Unknown error configuring Log4j.
06/09/21 11:13:59 Log4j>> Logging will not be available.
06/09/21 11:13:59 java.sql.SQLException: No suitable driver
06/09/21 11:13:59 at java.sql.DriverManager.getConnection(DriverManager.java:532)
06/09/21 11:13:59 at java.sql.DriverManager.getConnection(DriverManager.java:140)
06/09/21 11:13:59 at com.evermind.sql.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:213)
06/09/21 11:13:59 at com.evermind.sql.DriverManagerConnectionPoolDataSource.getPooledConnection(DriverManagerConnectionPoolDataSource.java:36)
06/09/21 11:13:59 at com.evermind.sql.OrionPooledDataSource.getPooledConnection(OrionPooledDataSource.java:582)
06/09/21 11:13:59 at com.evermind.sql.PooledConnectionUsage.getPooledConnection(PooledConnectionUsage.java:22)
06/09/21 11:13:59 at com.evermind.sql.OrionPooledDataSource.getConnection(OrionPooledDataSource.java:346)
06/09/21 11:13:59 at com.evermind.sql.OrionCMTConnection.setConnection(OrionCMTConnection.java:191)
06/09/21 11:13:59 at com.evermind.sql.OrionCMTConnection.intercept(OrionCMTConnection.java:141)
06/09/21 11:13:59 at com.evermind.sql.OrionCMTConnection.setAutoCommit(OrionCMTConnection.java:479)
06/09/21 11:13:59 at com.workbrain.server.sql.ConnectionManager.getConnection(ConnectionManager.java:256)
06/09/21 11:13:59 at com.workbrain.server.sql.ConnectionManager.getConnection(ConnectionManager.java:63)
06/09/21 11:13:59 at com.workbrain.util.log4j.Log4jHelper.getProperties(Log4jHelper.java:104)
06/09/21 11:13:59 at com.workbrain.util.log4j.Log4jHelper.configure(Log4jHelper.java:42)
06/09/21 11:13:59 at com.workbrain.util.startup.StartupServlet.init(StartupServlet.java:32)
06/09/21 11:13:59 at javax.servlet.GenericServlet.init(GenericServlet.java:258)
06/09/21 11:13:59 at com.evermind.server.http.HttpApplication.loadServlet(HttpApplication.java:2141)
06/09/21 11:13:59 at com.evermind.server.http.HttpApplication.findServlet(HttpApplication.java:4582)
06/09/21 11:13:59 at com.evermind.server.http.HttpApplication.initPreloadServlets(HttpApplication.java:4676)
06/09/21 11:13:59 at com.evermind.server.http.HttpApplication.initDynamic(HttpApplication.java:820)
06/09/21 11:13:59 at com.evermind.server.http.HttpApplication.<init>(HttpApplication.java:542)
06/09/21 11:13:59 at com.evermind.server.Application.getHttpApplication(Application.java:889)
06/09/21 11:13:59 at com.evermind.server.http.HttpServer.getHttpApplication(HttpServer.java:690)
06/09/21 11:13:59 at com.evermind.server.http.HttpSite.initApplications(HttpSite.java:561)
06/09/21 11:13:59 at com.evermind.server.http.HttpSite.setConfig(HttpSite.java:263)
06/09/21 11:13:59 at com.evermind.server.http.HttpServer.setSites(HttpServer.java:261)
06/09/21 11:13:59 at com.evermind.server.http.HttpServer.setConfig(HttpServer.java:162)
06/09/21 11:13:59 at com.evermind.server.ApplicationServer.initializeHttp(ApplicationServer.java:2385)
06/09/21 11:13:59 at com.evermind.server.ApplicationServer.setConfig(ApplicationServer.java:1542)
06/09/21 11:13:59 at com.evermind.server.ApplicationServerLauncher.run(ApplicationServerLauncher.java:92)Ok and for the app server you made sure to go to the connector settings, under Paths and append to classpath the DB2 JARs?
yes. I tried prepending the db2java.zip and also tried appending it to the classpath. In addition, I appended the directories SQLLIB/LIB, SQLLIB/BIN and SQLLIB/FUNCTION to the library path.
lzoso ,
Connection URL: jdbc:db2:jdbc:db2:RD50FP4
is not good URL for db2 type2
Correct url is Connection URL: jdbc:db2:RD50FP4
Best
Peco‘no suitable driver’ mean that you type bad URL or you haven’t added jars
If you set correct URL then you have to add jars – try add db2jcc.jar and db2jcc_license_cu.jar
I propose using db2 uiversal driver and type 4 if it is possible – Universal driver is same for type4 and typ2 and different is in URL only .You can download this on IBM site
Best
Peco
