Hi,

I am new to working with Oracle and Java, although I have been a Java
programmer for some time now.
I am trying to find out if it is possible to put custom Java class
libraries into Oracle without having to publish each class.

To explain: We are using Oracle9i. There is an open source suite of
Java classes that we want to use in our database. There are lots of
classes in this library (GeoTools) and I'd hate to have to publish
them as stored procedures one at a time, since a normal user of the
database will never need to use these classes. Is there some way to
drop this suite of classes into Oracle as a library and write stored
procedures that import this library and so use it? Users of the
database do *not* need to have direct access to these classes- my own
stored procedures will use them. I suspect that there might be a way
using the resolvers, but I am quite confused about those and how to
set something up.

On the other hand, are there alternatives to putting these classes in
the database? It does not look like there are any ways to get at Java
classes from the Oracle side unless it resides in the database itself.


Any help at all would be greatly appreciated.

thanks,
pati