Here are the files (other than manifest-related files) which are shared
across our code jars (derby.jar, derbyclient.jar, derbynet.jar,
derbytools.jar):
org/apache/derby/iapi/services/info/JVMInfo$1.class
org/apache/derby/iapi/services/info/JVMInfo$2.class
org/apache/derby/iapi/services/info/JVMInfo.class
org/apache/derby/iapi/services/info/ProductVersionHolder.class
org/apache/derby/iapi/tools/i18n/LocalizedInput.class
org/apache/derby/iapi/tools/i18n/LocalizedOutput.class
org/apache/derby/iapi/tools/i18n/LocalizedResource.class
org/apache/derby/impl/tools/sysinfo/Main$1.class
org/apache/derby/impl/tools/sysinfo/Main$2.class
org/apache/derby/impl/tools/sysinfo/Main$3.class
org/apache/derby/impl/tools/sysinfo/Main$4.class
org/apache/derby/impl/tools/sysinfo/Main$5.class
org/apache/derby/impl/tools/sysinfo/Main$6.class
org/apache/derby/impl/tools/sysinfo/Main$7.class
org/apache/derby/impl/tools/sysinfo/Main$8.class
org/apache/derby/impl/tools/sysinfo/Main.class
org/apache/derby/impl/tools/sysinfo/ZipInfoProperties.class
org/apache/derby/loc/sysinfoMessages.properties
org/apache/derby/loc/toolsmessages.properties
org/apache/derby/shared/common/sanity/AssertFailure$1.class
org/apache/derby/shared/common/sanity/AssertFailure.class
org/apache/derby/shared/common/sanity/SanityManager.class
org/apache/derby/shared/common/sanity/ThreadDump.class
org/apache/derby/tools/sysinfo.class
I produced this report using the following script plus the sample code
which accompanies the white paper on Java DB Table Functions
(http://db.apache.org/derby/blogs/index.html#features):
connect 'jdbc:derby:memory:db;create=true';
create function zipFile
( fileName varchar( 32672 ) )
returns table
(
name varchar( 40 ),
directory varchar( 40 ),
comment varchar( 1000 ),
compressed_size bigint,
crc bigint,
size bigint,
modification_time bigint
)
language java
parameter style DERBY_JDBC_RESULT_SET
no sql
external name 'sun.javadb.vti.example.ZipFileTableFunction.zipFile'
;
create table t
(
jarName varchar( 20 ),
name varchar( 40 ),
directory varchar( 40 )
);
insert into t( jarName, name, directory )
select 'derby.jar', name, directory from table( zipfile(
'/Users/rh161140/derby/mainline/trunk/jars/sane/derby.jar' ) ) s;
insert into t( jarName, name, directory )
select 'derbyclient.jar', name, directory from table( zipfile(
'/Users/rh161140/derby/mainline/trunk/jars/sane/derbyclient.jar' ) ) s;
insert into t( jarName, name, directory )
select 'derbytools.jar', name, directory from table( zipfile(
'/Users/rh161140/derby/mainline/trunk/jars/sane/derbytools.jar' ) ) s;
insert into t( jarName, name, directory )
select 'derbynet.jar', name, directory from table( zipfile(
'/Users/rh161140/derby/mainline/trunk/jars/sane/derbynet.jar' ) ) s;
select distinct r.directory || '/' || r.name
from t r, t l
where r.name = l.name
and r.directory = l.directory
and r.jarName != l.jarName
and r.directory not like 'META-INF%'
;
Hope this is useful,
-Rick
