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

[Charles Hedrick]

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.