Thanks, that worked.
Although I'm not sure why my method didn't work, when it worked in
prior releases of Glassfish derby...
-roger
Shelly.McGowan_at_Sun.COM wrote:
>Roger,
>
>Here's what I do:
>
>cd $J2EE_HOME/javadb/lib
>java org.apache.derby.tools.ij
>ij version 10.1
>
>ij> DRIVER 'org.apache.derby.jdbc.ClientDriver';
>ij> CONNECT 'jdbc:derby://willow:1527/derbyDB' USER 'cts1' PASSWORD 'cts1';
>
>
>where derbyDB should be changed to sun-appserv-samples
>
>Shelly
>
>
>
>Roger Kitain wrote On 10/12/06 13:55,:
>
>
>
>>Hello Mitesh,
>>
>>I'm not sure if you are the right person to ask... but here goes...
>>
>>1.I just downloaded and installed:
>> glassfish v1 ur1 b14
>>
>>2. I started the database:
>> asadmin start-database
>>
>>3. I set my CLASSPATH:
>>
>>CLASSPATH=/home/rogerk/work/glassfish/javadb/lib/derbyclient.jar:/home/rogerk/work/glassfish/javadb/lib/derbytools.jar:/home/rogerk/work/glassfish/javadb/lib/derby.jar:.
>>
>>4. Get into ij:
>>java -Dij.driver='org.apache.derby.jdbc.ClientDriver'
>>org.apache.derby.tools.ij
>>
>>5. I'm at the ij prompt:
>> ij>connect
>>'jdbc:derby://localhost:1527///home/work/glassfish/bin/sun-appserv-samples';
>>ERROR 08001: No suitable driver
>>
>>
>>Any ideas? the jars are specified correctly in the CLASSPATH,
>>ClientDriver.class exists
>>in /home/rogerk/work/glassfish/javadb/lib/derbyclient.jar ....
>>
>>-roger
>>
>>
>>
>>
>>
>>
>>
>>
>
>
>