Re: [Bodington-developers] Oracle Problem

[Matthew B. <mat...@co...>]

Durfee, Bernard wrote:
> I get the following exception during setup, I am running Tomcat 5.5.7
> with Oracle 9i and the latest Oracle JDBC drivers...
> 
> SEVERE: Exception initialising BuildingServer:
> org.bodington.server.BuildingServerException:
> org.bodington.server.BuildingServerException: Exception getting Class
> for database
> types.org.bodington.server.JobResultorg.bodington.server.BuildingServerE
> xception: Unsupported SQL Type.  Table = job_results Field =
> execution_time

execution_time is of type TIMESTAMP in the installation which should get 
translated into a DATE for Oracle installs.

Is your Oracle driver oracle.jdbc.driver.OracleDriver? This should be 
set the file WEB-INF/bodington.properties on a line starting with 
sqldatabase.driver.

Could you output the table structure for jobs_results that the installer 
created (DESC jobs_results)?

I am guessing that this is because the JDBC driver is saying execution 
time is of type date (java.sql.Types.DATE) and the object relational 
mapper in Bodington currently only knows how to deal with timestamps 
(java.sql.Types.TIMESTAMP).

> ...I'm very anxious to evaluate Bodington for a possible solution to our
> need for an LMS to serve New York state universities. Is there a demo
> site somewhere that I can use for evaluation? Thanks...

If you are wanting to have a quick try of Bodington there is a 
quickstart WAR file:

http://users.ox.ac.uk/~buckett/quickstart.war

However this is a quickstart for the Oxford version of Bodington 
(WebLearn) and so is slightly different to Bodington. However you should 
be able to just drop this WAR into tomcat as it comes complete with a 
database (HSQLDB) and just visit:

http://tomcathost/quickstart/site/

You shouldn't need to run the setup as it come preconfigured. The 
quickstart feature should be appearing in Bodington 2.6.

-- 
+--Matthew Buckett-----------------------------------------+
| VLE Developer, Learning Technologies Group               |
| Tel: +44 (0) 1865 283660 http://www.oucs.ox.ac.uk/       |
+------------Computing Services, University of Oxford------+