java.lang.ClassNotFoundException: javax.sql.rowset.CachedRowSet

[Baron Roberts]

Hi Folks,

I am developing a Fisheye plugin that uses its own instance of an H2 database. All interaction with the database is via JDBC and the Spring JDBC template support. When I altas-run and have my plugin reference the database I get a ClassNotFoundException for the javax.sql.rowset.ChachedRowSet class. I have tried adding that class using the DynamicImport-Package facility in my plugin description but that does not fix the problem. Is there some class loader limitation imposed on this class by Fisheye? Below is a portio of the stack trace that has been thinking along those lines.

[INFO] Caused by: java.lang.ClassNotFoundException: javax.sql.rowset.CachedRowSet
[INFO] at org.apache.felix.framework.ModuleImpl.findClassOrResourceByDelegation(ModuleImpl.java:772)
[INFO] at org.apache.felix.framework.ModuleImpl.access$200(ModuleImpl.java:73)
[INFO] at org.apache.felix.framework.ModuleImpl$ModuleClassLoader.loadClass(ModuleImpl.java:1690)
[INFO] at java.lang.ClassLoader.loadClass(ClassLoader.java:248)
[INFO] ... 10 more

Atlassian SDK: 3.3.4
Plugin version: 2

Thanks for any help.

Baron

[Colin Goudie · Accepted solution]

That's a good question. It seems fisheye 2.6.x comes with SAL 2.5 so if you can use 2.6 I think you will be ok. Try bump up the fisheye version in your pom.xml, often the SDK docs are just lagging in terms of documenting what versions they support.

[Baron Roberts]

Thanks for the tip Colin! Here's what I did to get Active Objects going with the 3.3.4 SDK:

- Raised my fecru versions to 2.6.1-20110621071349 (found the exact versions at the Atlassian Maven repo)
- That got me SAL 2.5.0, AUI 3.3.1 and plugin framework 2.7.2
- Followed the documentation to add the Active Objects plugin. Note that for Fisheye the ao.version is 0.15 and the SPI is activeobjects-fecru-spi (Atlassian Maven repo help here as well).

I am pretty excited to offload the DB management to Fisheye so this should be a pleasant exploration.

Cheers,
Baron

[Colin Goudie]

Awesome Baron. Hope AO is fun to use. I haven't used it yet, but it looks nice

[Baron Roberts]

Regarding Active Objects it appears from the documentation that Active Objects depends on SAL 2.4.1. The latest Plugin SDK ships with Fisheye 2.5.2 which provides SAL 2.2.1. Does that mean that Fisheye does not currently support Active Objects?

[Baron Roberts]

Thanks Colin for the fast response!

So if the javax.sql.rowset package isn't exported, sounds like I have two choices. Choice one is just use classes from java.sql. Choice two is adopt Active Objects.

Here is the dependency section of my plugin POM:

<project xmlns="http://maven.apache.org/POM/4.0.0"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd"><br< a=""> />
...

<dependencies>
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>servlet-api</artifactId>
<scope>provided</scope>
</dependency>
<dependency>
<groupId>com.atlassian.fisheye</groupId>
<artifactId>atlassian-fisheye-api</artifactId>
<version>${fecru.version}</version>
<scope>provided</scope>
</dependency>
<dependency>
<groupId>com.atlassian.crucible</groupId>
...

[Colin Goudie]

Can you post your pom.xml? If an Import-Package isn't working I would guess that the package isn't exported by fisheye, which probably is the case as it's not a common use case to hit the database as you are doing

On another note, have you looked into the new Active Objects plugin by Atlassian? This would allow you to do your own business objects and map them to tables (however they'd be in the fisheye database), but may suit your need and is something that Atlassian support