[Coefficient-users] Re: Coefficient

[Thomas F. <tfo...@us...>]

On Tue, 2005-01-25 at 16:50 +0100, sebastien wrote:
> I looked in the coefficient_role table and as you mentionned it was
> empty. 
> I did drop and recreate the database. Then I restarted the server and
> tried to access the coefficient homepage. 
> 
> See attached the whole catalina logs after a tomcat restart. We can
> see inside that the tables have not been found. 
> Consequently tables have been recreated however they are still empty. 
> 
> There is obviouly a problem in inserting the original data. 

<log-extract>
java.lang.Throwable
   at com.mysql.jdbc.Connection.close(Connection.java:1123)
   at net.sf.hibernate.util.HibernateUtil.updateSchema(HibernateUtil.java:818)
</log-extract>

This happens when we try to close the connection after creating the db;
it is a non-critical exception, and is thus just swallowed. It seems,
though, that the mysql driver throws a plain Throwable here. We only
check for Exception instances (Exception extends Throwable), so this
Throwable is never caught (hence propagating right up the call stack).
As a result, the default data is never loaded.

I've uploaded a patched hibernateUtil.jar for testing here:
http://icomdmz1.csir.co.za/~tfogwill/files/hibernateUtil.jar

Please drop the db and try again with this jar (instead of the one that
ships with coefficient).

You will probably see messages like this in the log file:
Non critical exception. Will be swallowed. Exception message: ...
Non critical exception (throwable). Will be swallowed. Exception message: ...

Let me know whether this works for you. If it does, I'll update the
sourceforge release files to include this version (after removing the
debug code).


-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
MailScanner thanks transtec Computers for their support.