#2 Exception during setup

[Bernie Durfee]

I am using Oracle 9i 9.2.0.5.0 with the Oracle JDBC
driver version 10.1.0.4.0 and I get this exception before
setup completes.

SEVERE: Exception initialising BuildingServer:
org.bodington.server.BuildingServerException:
org.bodington.server.BuildingServerException: Exception
getting Class for database
types.org.bodington.server.JobResultorg.bodington.server
.BuildingServerException: Unsupported SQL Type.
Table = job_results Field = execution_time
org.bodington.server.BuildingServerException:
org.bodington.server.BuildingServerException: Exception
getting Class for database
types.org.bodington.server.JobResultorg.bodington.server
.BuildingServerException: Unsupported SQL Type.
Table = job_results Field = execution_time
at
org.bodington.server.BuildingServer.initDatabase
(BuildingServer.java:470)
at org.bodington.server.BuildingServer.init
(BuildingServer.java:328)
at
org.bodington.server.BuildingServer.createInstance
(BuildingServer.java:180)
at
org.bodington.servlet.SetupServlet.doDBSetup
(SetupServlet.java:2028)
at org.bodington.servlet.SetupServlet.doPost
(SetupServlet.java:426)
at javax.servlet.http.HttpServlet.service
(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service
(HttpServlet.java:802)

[Matthew Buckett]

Logged In: YES
user_id=1170350

Ok. I've got a copy of Oracle 9 installed and see this
problem happening as well.

I think this is because Bodington is attempt to create the
tables in the wrong place (in the SYS schema) and then
thinks it has a jobs table which is actually the jobs table
from the SYS schema and of course the columns don't match.

I'll have a look at fixing this and let you know how I get on.

[Matthew Buckett]

Logged In: YES
user_id=1170350

Although I was having an error about finding the correct
tables with Oracle the error reported here is the one of
Oracle timestamp columns being created as DATEs. I have
commited a fix back to CVS which should show up ni anonymous
CVS in 24 hours.

[Matthew Buckett]

Logged In: YES
user_id=1170350

I've also committed back some more fixes for Oracle when the
setup process is being run that should make things a bit
more robust.