I was reading the ODBC programming using Apache Derby, on the web page
http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0409kartha/, test the ODBC driver with derby.
It has the error, ERROR 08001: No suitable driver when trying to connect to the derby network server with ij.bat.
I have the window DB2 Run-time client lite version installed on my window XP system.
Following the steps in the ODBC programming using Apache Derby.
1. Start the Derby NetWork Server
(from a DOS prompt)
Server is ready to accept connections on port 1527.
Connection number: 1.
2. Connect to the Derby Network Server using the 'ij' tool to create the database
(from another DOS prompt)
C:\>rem set DERBY_INSTALL=
C:\>java -Dij.driver=org.apache.derby.jdbc.ClientDriver -Dij.protocol=jdbc:derby://localhost:1527/ -Dij.user=A
PP -Dij.password=APP org.apache.derby.tools.ij
ij version 10.1
ij> connect 'jdbc:derby:net://localhost:1527/SAMPLE;create=true:user=app;password=app;';
ERROR 08001: No suitable driver
How to solve this problem?
This topic has been locked.
3 replies Latest Post - 2007-09-10T17:41:39Z by Stan
Pinned topic ERROR 08001: No suitable driver
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2007-09-10T17:41:39Z at 2007-09-10T17:41:39Z by Stan
Stan 120000HAGM267 PostsACCEPTED ANSWER
Re: ERROR 08001: No suitable driver2006-03-15T18:28:38Z in response to SystemAdminHi -
You are using DB2 Universal client URL syntax (subprotocol of ':derby:net:' as well as DB2 client attributes) but specify the Derby Client driver. The subprotocol you are specifying tries to load the DB2 Universal Driver (ij.driver=com.ibm.db2.jcc.DB2Driver) giving 'driver not found'. A correct ij command line and formatted Derby Client URL would be:
java -Dij.driver=org.apache.derby.jdbc.ClientDriver org.apache.derby.tools.ij
ij version 10.1
ij> connect 'jdbc:derby://localhost:1527/SAMPLE;create=true';
http://NOTE specifying driver on the IJ command line is good form but not required. IJ knows from the URL format which driver to load
SystemAdmin 110000D4XK1525 Posts
Stan 120000HAGM267 Posts