[Building Sakai] can't get sakai to start on oracle

[Matthew Jones]

FYI: The ojdbc14.jar is intended to just be used with Java 1.4 and
1.5. The ojdbc16.jar (from the 11g set on the download page) is for
Java 1.6 and it fixed some errors with us locally, even though we're
still only running a 10g database.

Java 1.6 has been the preferred version for Sakai since 2.7. [1]

https://confluence.sakaiproject.org/display/DOC/Sakai+2.7

On Thu, May 5, 2011 at 11:43 AM, Charles Hedrick <hedrick at rutgers.edu> wrote:
> I updated ojdbc14.jar to the newest version and the problem went away.
>
> On May 5, 2011, at 11:26 AM, Charles Hedrick wrote:
>
>> I need to fix an oracle-specific problem with lesson builder. To do that I need an installation running on oracle.
>>
>> I installed oracle express on windows 7. I pointed a copy of 2.8.0 binary (the 2.8.0 source doesn't compile) at the server, and it gets fairly far along. But then I started getting thing failing with errors like this:
>>
>> 2011-05-05 11:20:02,108 ERROR main org.hibernate.event.def.AbstractFlushingEventListener - Could not synchronize database state with session
>> org.hibernate.exception.GenericJDBCException: could not insert: [org.sakaiproject.emailtemplateservice.model.EmailTemplate]
>>       at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
>>       at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
>>
>> …..
>>       at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
>> Caused by: java.sql.SQLException: operation not allowed: streams type cannot be used in batching
>>       at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
>>       at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
>>
>>
>> Any idea what is going wrong?
>>
>> If we want indie tools to support oracle, we need instructions for developers to set up sakai on oracle.
>>
>>
>
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"
>