bodington-developers

[Bodington-developers] Oracle Problem

[Durfee, B. <Ber...@su...>]

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 =3D job_results Field =3D
execution_time
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 =3D job_results Field =3D
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:1
80)
	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)

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

Bernard Durfee
Lead Programmer/Analyst
SUNY Systems Administration

Re: [Bodington-developers] Oracle Problem

[Adam M. <ada...@co...>]

Bernard

We have had Bodington working with Oracle although non of the main developers
actually work against it; we use the open source postgres or MS sqlserver. I
assume you are using v2.4.3?

Hopefully somebody will reply soon with a solution to your problem.

In the meantime - why not look at http://www.weblearn.ox.ac.uk/bodington/site/ -
click on the 'login as visitor' button. You will get access to the open part of
the VLE, areas requiring authentication and authorisation will not be visible.

Obviously you will not be able to get access to the administration facilities as
you must have special rights.

happy browsing.

adam

In message <EBC...@sc...>
bod...@li... writes:
> 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
> 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
> 	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:1
> 80)
> 	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)
> 
> ...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...
> 
> Bernard Durfee
> Lead Programmer/Analyst
> SUNY Systems Administration
> 
> 
> -------------------------------------------------------
> SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
> from IBM. Find simple to follow Roadmaps, straightforward articles,
> informative Webcasts and more! Get everything you need to get up to
> speed, fast. http://ads.osdn.com/?ad_idt77&alloc_id492&op=click
> _______________________________________________
> Bodington-developers mailing list
> Bod...@li...
> https://lists.sourceforge.net/lists/listinfo/bodington-developers
> 

-- 
--
Dr AC Marshall (Bodington developer) OUCS, 13, Banbury Rd. Oxford. OX2 6NN
               Cheese of the month: Smoked Wensleydale

Re: [Bodington-developers] Oracle Problem

[Paul T. <pau...@co...>]

Dear Bernard,

At 15:16 30/06/2005, you 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:
< ... >
>...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...

Great to hear about the interest.  I'll let the developers answer your 
specific setup query, but in the meantime you are welcome to look at 
WebLearn, Oxford's implementation.
http://www.weblearn.ox.ac.uk/
(Log in as visitor)

I'll also create an account so that you can take a closer look and create 
some resources.

Regards,

Paul
----
Paul Trafford
VLE Administrator
Oxford University Computing Services


>Bernard Durfee
>Lead Programmer/Analyst
>SUNY Systems Administration
>
>
>-------------------------------------------------------
>SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
>from IBM. Find simple to follow Roadmaps, straightforward articles,
>informative Webcasts and more! Get everything you need to get up to
>speed, fast. http://ads.osdn.com/?ad_idt77&alloc_id492&opick
>_______________________________________________
>Bodington-developers mailing list
>Bod...@li...
>https://lists.sourceforge.net/lists/listinfo/bodington-developers

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