[Building Sakai] Which version of OJDBC do we support?

[Charles Severance]

On Jul 22, 2013, at 6:23 PM, Seth Theriault <slt at columbia.edu> wrote:

> On Mon, Jul 22, 2013 at 5:27 PM, Charles Severance <csev at umich.edu> wrote:
>> In particular are folks using Oracle 11 OJDBC jars like this version or similar?
>> 
>> ojdbc-11.1.0.6.0.jar
> 
> I am currently using the 11g Release 2 (11.2.0.2.0) ojdbc6.jar from this page:
> 
> http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html
> 
> but you should probably up that to the more recent 11.2.3 one.
> 
> Seth

Thanks - It turns out that  the "Oracle BUG-6396242"  in these OJDBC connector versions:

ojdbc6-11.1.0.6.0.jar - Fails
ojdbc6-11.1.0.7.0.jar - Fails

Makes LTI inserting code fail because my pattern is to ask for the created primary key on insert (which we rarely do in Sakai).   It is a bug in the OJDBC deliver and documented here:

https://jira.sakaiproject.org/browse/BLTI-250

These work:

ojdbc14-10.2.0.4.0.jar - Works
ojdbc6-11.2.0.3.jar - Works

Those were the ones I tested.

I figured I would share in case people are picking their OJDBC versions for September rollouts.  Avoid the 11.1.0.[6,7] - at a minimum.

/Chuck
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130724/33261ffc/attachment.html