Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (asf.osuosl.org: domain of gcaddu-derby-user@m.gmane.org
 designates 80.91.229.2 as permitted sender)
To: derby-user@db.apache.org
From: Kostas Karadamoglou <karadamoglou_k@yahoo.gr>
Subject: Re: Problems with Derby 10.1.1 and derbyclient.jar [SQLException:
   No suitable driver]
Date: Sat, 13 Aug 2005 18:16:31 +0100
Lines: 58
Message-ID: <42FE2AEE.5020501@yahoo.gr>
References: <ddkfvq$cgu$1@sea.gmane.org> <42FE1A03.2090103@gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-7; format=flowed
Content-Transfer-Encoding: 7bit
User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716)
In-Reply-To: <42FE1A03.2090103@gmail.com>
Sender: news <news@sea.gmane.org>

Hello Sunitha,

Yes I was using com.ibm.db2.jcc.DB2Driver. I did a mistake!

I have an database that was being operated by Derby 10.0. What I changed 
  was the derby.jar and derbynet.jar at the server and the 
derbyclient.jar at the client. However I kept the database url same. So 
I tried to use this 
"jdbc:derby:net://localhost:1527/sampleDb:user=u1;password=p1;" url 
scheme with the org.apache.derby.jdbc.ClientDriver driver.

I quess that is my mistake. Isn't it true?

thank you in advance, Kostas

Sunitha Kambhampati wrote:
> Kostas Karadamoglou wrote:
> 
>> Hi all,
>>
>> I was using Derby 10.0 with db2cc.jar and db2_licensecc.jar in network 
>> mode. The driver was called com.ibm.db2.jdbcDriver. Everything was 
>> working fine :)
>>
>> But now I changed to 10.1.1. The driver jar is derbyclient.jar and the 
>> driver org.apache.derby.jdbc.ClientDriver. Whenever I load the driver 
>> at the DriverManager and try to use getConnection I get the following 
>> exception:
>>
>> java.sql.SQLException: No suitable driver
>>         at java.sql.DriverManager.getConnection(DriverManager.java:545)
>>
>> Do you know how I can solve this problem?
>>
>> Thank you in advance, Kostas
>>
>>
> Actually the JCC driver is com.ibm.db2.jcc.DB2Driver.  Can you check 
> your connection url  again.
> 
> So when using the client driver , the connection url is of the form  
> jdbc:derby://</server/>[:</port/>]/ </databaseName/>[;<URL 
> attribute>=<value> [;...]]
> Ex , assuming server is running on localhost at port 1527. To connect 
> via client driver, the url would be    
> jdbc:derby://localhost:1527/sampleDb;user=u1;password=p1
> 
> To connect via JCC driver, the connection url would be
> jdbc:derby:net://localhost:1527/sampleDb:user=u1;password=p1;
> 
> 
> Hope this helps, if not please feel free to post again, and also include 
> the connection url you are using.
> 
> Sunitha.
> 
> 
>