[OAI-implementers] Stored procedures references in oaicat.properties

Young,Jeff (OR) jyoung at oclc.org
Mon Oct 27 13:51:46 EDT 2008


The JDBCOAICatalog class uses the java.sql.Statement class. I believe
that stored procedures require the java.sql.CallableStatement class
instead. Sorry.

In principle, though, you could write a knockoff of this class to call
stored procedures instead of SQL queries. This new class can be
configured by changing the AbstractCatalog.oaiCatalogClassName entry in
the oaicat.properties file. 

Some clues about customization can be found here:


> -----Original Message-----
> From: oai-implementers-bounces at openarchives.org
> bounces at openarchives.org] On Behalf Of OAI-Neturity
> Sent: Saturday, October 18, 2008 6:51 AM
> To: oai-implementers at openarchives.org
> Subject: [OAI-implementers] Stored procedures references in
> oaicat.properties
> Hi to all!
> I'm quite new to OAI and to this list, so pardon me if the topic has
> addressed before.
> The question is:
> - Is it possible to include references to stored procedures, instead
> plain SQL queries, in the corresponding JDBCOAICatalog entries in
> oaicat.properties?
> We're using a rather complex Oracle database (it's a bibliographic
> information repository based on ONIX for Books) and I would prefer to
> create
> a more "OAI-like" shell by using stored procedures and views, than to
> develop Java classes for data access and metadata transformations.
> Thanks a lot in advance.
> JPeraita
> _______________________________________________
> OAI-implementers mailing list
> List information, archives, preferences and to unsubscribe:
> http://www.openarchives.org/mailman/listinfo/oai-implementers

More information about the OAI-implementers mailing list