Re: Anybody knows how to configure to run JDBC[tm] API Test Suite 1.3.1

[Eranda Sooriyabandara <er...@gmail.com>]

Hi Jhon,
Thanks for the quick reply. But when I configure do I only need to configure
the bin in the test suite?
Also there is no replacement for RmiJdbc.jar sljc.jar sljcx.jar now.
I configure them without them and get the result as,
Unexpected Exception:java.lang.ClassNotFoundException:
COM.cloudscape.core.RmiJdbcDriver.
This error usually indicates that your CLASSPATH is not set correctly.

I can't find the place where this configuration do. Is there any place
except test suit "bin" where I should configure.
Thanks
Eranda


On Fri, Apr 9, 2010 at 12:40 PM, John Embretsen <Jo...@sun.com>wrote:

> Eranda Sooriyabandara wrote:
> > Hi,
> > I try to test Derby JDBC using JDBC API Test Suit 1.3.1. But I don't
> > know how to configure it so that we can run it against Derby. If anybody
> > knows how to do  configuration please help me to figure it out. (It
> > doesn't need not to be Derby. Also documents at the
> > http://java.sun.com/products/jdbc/jdbctestsuite-1_3_1.html does not work
> > for me)
>
> I don't know exactly how to configure this, but I did configure and run
> the JDBC CTS (which is set up in a similar way to the JDBC API Test
> Suite) against Derby some years ago (2006).
>
> The docs at the URL you provided gives configuration examples for
> Cloudscape (Derby's ancestor). So you would need to replace all
> Cloudscape-specific config by Derby config (jar file names, JDBC driver
> names, SQL statement dialect files etc.) and try from there.
>
> Note that back in the days I was told that neither the test suite nor
> the J2EE implementation (app server) I was using fully supported the
> embedded driver, so you may want to try a client-server configuration
> first (start the Derby server separately, then try to run the tests
> using the client driver).
>
>
>
> --
> John
>
>

Re: Anybody knows how to configure to run JDBC[tm] API Test Suite 1.3.1

[John Embretsen <Jo...@Sun.COM>]

Kathey Marsden wrote:
> On 4/14/2010 7:09 AM, Bryan Pendleton wrote:
>> What is RmiJdbc? I hadn't heard of that before. I think that might
>> have been
>> a Cloudscape-specific functionality, and probably we can't test that
>> with Derby.
>>
> RmiJdbc was an ancient client/server solution that was never suitable
> for production use except for possibly pulling occasional reports
> remotely in a primarily embedded application.   I don't remember the
> details or licensing at the time, but think there was external code
> involved too and so was not part of the open source contribution.
> 
> I think probably CTS 1.3.1 is very ancient as I think that is what I was
> working with ten years ago or so when I was last working with  it.  Is
> there a newer one that comes preconfigured for Derby that Eranda can
> use?  I see Ole ran CTS for 10.5.3 and maybe can provide some guidance.
> http://wiki.apache.org/db-derby/TenFiveThreePlatformTesting

Last time I set up and ran the JDBC CTS against Derby I believe I was
using version 1.4.1, so yes there are newer versions. Probably that is
what was used against Derby 10.5.3 as well.

I remember that setting this up completely with Derby (in an automated
fashion) was a rather complex task. I also remember using a
"configuration and porting bundle" with files necessary to execute the
CTS against Sun's J2EE Application Server. From digging in my archive I
found out that I got this from a Sun-internal location. I don't know
what or which versions are available to the outside.

I was not able to find a reference to RmiJdbc in the configuration files
I used, so I'm afraid I cannot be of much help. My shot-in-the-dark
suggestion would be to try to search and find out where (config file,
test file, etc.) the cloudscape RMI class is specified and see if it can
be removed or changed to e.g. the Derby client driver.


-- 
John

Re: Anybody knows how to configure to run JDBC[tm] API Test Suite 1.3.1

[Kathey Marsden <km...@sbcglobal.net>]

On 4/14/2010 7:09 AM, Bryan Pendleton wrote:
> What is RmiJdbc? I hadn't heard of that before. I think that might 
> have been
> a Cloudscape-specific functionality, and probably we can't test that 
> with Derby.
>
RmiJdbc was an ancient client/server solution that was never suitable 
for production use except for possibly pulling occasional reports 
remotely in a primarily embedded application.   I don't remember the 
details or licensing at the time, but think there was external code 
involved too and so was not part of the open source contribution.

I think probably CTS 1.3.1 is very ancient as I think that is what I was 
working with ten years ago or so when I was last working with  it.  Is 
there a newer one that comes preconfigured for Derby that Eranda can 
use?  I see Ole ran CTS for 10.5.3 and maybe can provide some guidance.
http://wiki.apache.org/db-derby/TenFiveThreePlatformTesting

Kathey

Re: Anybody knows how to configure to run JDBC[tm] API Test Suite 1.3.1

[Bryan Pendleton <bp...@gmail.com>]

Eranda Sooriyabandara wrote:
> Also there is no replacement for RmiJdbc.jar sljc.jar sljcx.jar now.
> I configure them without them and get the result as,
> Unexpected Exception:java.lang.ClassNotFoundException: 
> COM.cloudscape.core.RmiJdbcDriver.

What is RmiJdbc? I hadn't heard of that before. I think that might have been
a Cloudscape-specific functionality, and probably we can't test that with Derby.

thanks,

bryan