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

[Young,Jeff (OR)]

JPeraita,

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:
http://alcme.oclc.org/wikid/CollectionOaiCat:CustomizationNotes.

Jeff


> -----Original Message-----
> From: oai-implementers-bounces at openarchives.org
[mailto:oai-implementers-
> 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
been
> addressed before.
> 
> The question is:
> - Is it possible to include references to stored procedures, instead
of
> 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
>