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

[Charles Hedrick]

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.
> 
>