Missing sun-javadb-client dependency for DerbyPool connection pool

[Rescate]

Binary package hint: glassfishv2

OS: Ubuntu 8.04
Package version for glassfishv2: 2.0.1-0ubuntu5

Glassfish has a connection pool named DerbyPool that attempts to connect to the JavaDB database included with the Glassfish installation. Many people use the DerbyPool connection pool since it is the connection pool used by the jdbc/__default JDBC resource.

The DerbyPool connection pool uses org.apache.derby.jdbc.ClientDataSource from derbyclient.jar as its datasource class. This class is in the sun-javadb-client package. However, the glassfishv2 package only specifies sun-javadb-core as a dependency, which does not install any of the client jars. To get derbyclient.jar, the sun-javadb-client package must also be a dependency of glassfishv2.

To reproduce:

(from command line)
apt-get install sun-java6-jdk (needed because of reported OpenJDK problem)
apt-get install glassfishv2
/usr/share/glassfishv2/bin/asadmin start-database

(...then, via admin interface at localhost:4848)
go to Resources/JDBC/Connection Pools/DerbyPool
click "Ping" button
Result: An error has occurred -- Class name is wrong or classpath is not set for : org.apache.derby.jdbc.ClientDataSource

(...then, from command line)
apt-get install sun-javadb-client
/usr/share/glassfishv2/bin/asadmin stop-domain domain1
/usr/share/glassfishv2/bin/asadmin start-domain domain1

(...back at admin interface)
go to Resources/JDBC/Connection Pools/DerbyPool
click "Ping" button
Result: Ping Succeeded

[Jens (jens.timmerman)]

I can confirm this bug still exists in 8.10

[Thomas Hotz (thotz-deactivatedaccount)]

Marking as confirmed.