Menu
▾
▴
coefficient-users — Users List
You can subscribe to this list here.
| 2003 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(1) |
Nov
|
Dec
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2004 |
Jan
|
Feb
|
Mar
(5) |
Apr
|
May
(2) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
(4) |
Dec
|
| 2005 |
Jan
(19) |
Feb
(5) |
Mar
|
Apr
|
May
|
Jun
(3) |
Jul
(19) |
Aug
(4) |
Sep
|
Oct
(1) |
Nov
(5) |
Dec
|
| 2011 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(1) |
Jun
|
Jul
|
Aug
(4) |
Sep
(2) |
Oct
|
Nov
|
Dec
|
| 2012 |
Jan
|
Feb
|
Mar
(4) |
Apr
|
May
(1) |
Jun
|
Jul
(1) |
Aug
(1) |
Sep
|
Oct
|
Nov
|
Dec
(1) |
| 2013 |
Jan
|
Feb
|
Mar
(2) |
Apr
(3) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2014 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(2) |
Jun
(1) |
Jul
(1) |
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2016 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
(1) |
Sep
|
Oct
|
Nov
|
Dec
|
| 2017 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
(1) |
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Sean R. <sra...@ae...> - 2005-07-23 22:57:47
|
Hi there, I've got coeffient running from the prepackaged binaries. I would now like to build fromt the source but can't grasp how to do so. I'm prettry au-fai with Maven, but can't work out what target(s) to call. I've read 'RELEASE_HOW_TO.TXT' but don't understand it I'm afraid: >please build web release first >then copy it to where you need it >delete build you can leave the lib dir > >then do the normal build. >then build all the individual modules >then do the release build for J2ee/jboss Any help, much appreciated. Sean |
|
From: Mike S. <mi...@sp...> - 2005-07-15 19:11:59
|
Fixed - Thanks everyone for the replies.. I renamed my datasource "CoefficientDS" (strange, I don't recall reading that in the install procedure) I hit the hibernate website and scanned other sample hibernate.properties files, here's what I ended up with: hibernate.connection.driver_class com.mysql.jdbc.Driver hibernate.connection.url jdbc:mysql://localhost/CoefficientDS hibernate.connection.username root hibernate.connection.password passwerd hibernate.dialect net.sf.hibernate.dialect.MySQLDialect hibernate.connection.pool_size 0 #hibernate.show_sql true Root Cause: User Error Code 1D10T Peace - Mike Migue Perez wrote: >I'm using JBoss, but doesn't your datasource need to be named CoefficientDS? > > >-----Original Message----- >From: coe...@li... >[mailto:coe...@li...] On Behalf Of Mike >Spisak >Sent: Friday, July 15, 2005 12:50 PM >To: coe...@li... >Subject: Re: [Coefficient-users] MySQL troubles ... > >Thanks for the reply... hhmmm, still getting that nasty "NullPointer" >exception.. >- I've upgraded to MySQL 4.1.12 standard.. >- I'm using MySQL connector v3.0.17 >- I updated my hibernate.properties file (given Hotmail's example) - >like so: >hibernate.connection.driver_class com.mysql.jdbc.Driver >hibernate.connection.url jdbc:mysql://localhost/mydatabase >hibernate.connection.username=root >hibernate.connection.password=password >hibernate.dialect net.sf.hibernate.dialect.MySQLDialect >hibernate.connection.datasource java:/mydatabase >hibernate.session_factory_name net.sf.hibernate.SessionFactory >hibernate.transaction.factory_class >net.sf.hibernate.transaction.JTATransactionFactory >hibernate.connection.pool_size 0 >#hibernate.show_sql true > >Now, just for giggles, I shutdown MySQL just to see if I'd get a >different error and I continue to get this : >java.lang.NullPointerException >at >net.sf.hibernate.util.HibernateUtil.getUniqueSession(HibernateUtil.java:179) >at net.sf.hibernate.util.HibernateUtil.find(HibernateUtil.java:365) >at >za.org.coefficient.modules.configuration.Configuration.getConfiguration(Conf >iguration.java:144) >at >za.org.coefficient.modules.configuration.Configuration.view(Configuration.ja >va:85) >at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >at >sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39 >) >at >sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl >java:25) >at java.lang.reflect.Method.invoke(Method.java:324) ><<I didn't post the whole stack trace.. but you get the idea..>> > >I'm thinking I have some kind of a "Hibernate" issue? anyone got >ideas? much thanks! > >Mike > > >Hotmail wrote: > > > >>Mike, >> >>I'm using MySQL 4.1.10a-Max version and Coefficient works find with it. >> >>I did notice that in order for Coefficient to work correctly, I had to >>create the database "coefficient" manually. Once I did that coefficient >>correctly created and populated the tables. >> >>Also, it took me a few tries to correctly configure the username and >>password properties. Here is a copy of my file which does work. >> >>hibernate.connection.datasource java:/CoefficientDS >>hibernate.connection.username=root >>hibernate.connection.password=******* >>hibernate.dialect net.sf.hibernate.dialect.MySQLDialect >>hibernate.session_factory_name net.sf.hibernate.SessionFactory >>hibernate.transaction.factory_class >>net.sf.hibernate.transaction.JTATransactionFactory >>hibernate.connection.pool_size 0 >> >> >>Good luck. >> >> >> >>----- Original Message ----- >>From: "Mike Spisak" <mi...@sp...> >>To: <coe...@li...> >>Sent: Thursday, July 14, 2005 5:39 PM >>Subject: [Coefficient-users] MySQL troubles ... >> >> >> >> >> >> >>>Hi All :: >>> >>>Coefficient seems like a VERY cool platform.. installation was going >>>really well: >>>- Tomcat 4.1.18 went in with no troubles... >>>- MySQL 3.23 was a snap... (I included the org.gjt.mm.mysql.Driver) >>>- I followed the installation procedure (hibernate.properties, >>>server.xml, etc..) smooth.. >>>- Deployed the war file.. nicey nice... >>>- tried to hit the main URL and got.. *ouch* >>>*There has been a system exception* >>> >>>java.lang.NullPointerException >>>at >>> >>> >>> >>> >>> >>net.sf.hibernate.util.HibernateUtil.getUniqueSession(HibernateUtil.java:179 >> >> >) > > >> >> >> >> >>>at net.sf.hibernate.util.HibernateUtil.find(HibernateUtil.java:365) >>>at >>> >>> >>> >>> >>> >>za.org.coefficient.modules.configuration.Configuration.getConfiguration(Con >> >> >f > > >>iguration.java:144) >> >> >> >> >>>at >>> >>> >>> >>> >>> >>za.org.coefficient.modules.configuration.Configuration.view(Configuration.j >> >> >a > > >>va:85) >> >> >> >> >>>at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>>at >>> >>> >>> >>> >>> >>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:3 >> >> >9 > > >>) >> >> >> >> >>>at >>> >>> >>> >>> >>> >>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImp >> >> >l > > >>java:25) >> >> >> >> >>>at java.lang.reflect.Method.invoke(Method.java:324) >>>. . . . . . . >>>Now I've never used Hibernate before.. so here's a snapshot of my >>>properties file - not sure if the "dialect" line is right: >>> hibernate.connection.driver_class org.gjt.mm.mysql.Driver >>> hibernate.connection.url jdbc:mysql://localhost/my_db >>> hibernate.connection.username root >>> hibernate.connection.password ***** >>> hibernate.dialect org.hibernate.dialect.MySQLDialect >>> # I also tried net.sf.hibernate.dialect.MySQLDialect >>> #hibernate.dialect net.sf.hibernate.dialect.PostgreSQLDialect >>> hibernate.connection.pool_size 0 >>> #hibernate.show_sql true >>> >>>hhmm, am I missing something? Do I need a newer version of mySQL? I've >>>lurked the user group a little and saw other problems with mySQL, should >>>I bail and get Postgre? Thanks in advance! >>> >>>Mike >>> >>>PS: system specs: >>>- SuSE Linux 9.1 >>>- J2SDK 1.4.2_06 >>>- Tomcat 4.1.18 >>>- MySQL 3.23 >>>- etc... >>> >>> >>> >>>------------------------------------------------------- >>>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_id=7477&alloc_id=16492&op=click >>>_______________________________________________ >>>Coefficient-users mailing list >>>Coe...@li... >>>https://lists.sourceforge.net/lists/listinfo/coefficient-users >>> >>> >>> >>> >>> >> >> >> >> > > > > >------------------------------------------------------- >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_id=7477&alloc_id=16492&op=click >_______________________________________________ >Coefficient-users mailing list >Coe...@li... >https://lists.sourceforge.net/lists/listinfo/coefficient-users > > >------------------------------------------------------- >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_id=7477&alloc_id=16492&op=click >_______________________________________________ >Coefficient-users mailing list >Coe...@li... >https://lists.sourceforge.net/lists/listinfo/coefficient-users > > > > |
|
From: Migue P. <mr_...@ho...> - 2005-07-15 17:12:07
|
I'm using JBoss, but doesn't your datasource need to be named CoefficientDS? -----Original Message----- From: coe...@li... [mailto:coe...@li...] On Behalf Of Mike Spisak Sent: Friday, July 15, 2005 12:50 PM To: coe...@li... Subject: Re: [Coefficient-users] MySQL troubles ... Thanks for the reply... hhmmm, still getting that nasty "NullPointer" exception.. - I've upgraded to MySQL 4.1.12 standard.. - I'm using MySQL connector v3.0.17 - I updated my hibernate.properties file (given Hotmail's example) - like so: hibernate.connection.driver_class com.mysql.jdbc.Driver hibernate.connection.url jdbc:mysql://localhost/mydatabase hibernate.connection.username=root hibernate.connection.password=password hibernate.dialect net.sf.hibernate.dialect.MySQLDialect hibernate.connection.datasource java:/mydatabase hibernate.session_factory_name net.sf.hibernate.SessionFactory hibernate.transaction.factory_class net.sf.hibernate.transaction.JTATransactionFactory hibernate.connection.pool_size 0 #hibernate.show_sql true Now, just for giggles, I shutdown MySQL just to see if I'd get a different error and I continue to get this : java.lang.NullPointerException at net.sf.hibernate.util.HibernateUtil.getUniqueSession(HibernateUtil.java:179) at net.sf.hibernate.util.HibernateUtil.find(HibernateUtil.java:365) at za.org.coefficient.modules.configuration.Configuration.getConfiguration(Conf iguration.java:144) at za.org.coefficient.modules.configuration.Configuration.view(Configuration.ja va:85) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39 ) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl java:25) at java.lang.reflect.Method.invoke(Method.java:324) <<I didn't post the whole stack trace.. but you get the idea..>> I'm thinking I have some kind of a "Hibernate" issue? anyone got ideas? much thanks! Mike Hotmail wrote: >Mike, > >I'm using MySQL 4.1.10a-Max version and Coefficient works find with it. > >I did notice that in order for Coefficient to work correctly, I had to >create the database "coefficient" manually. Once I did that coefficient >correctly created and populated the tables. > >Also, it took me a few tries to correctly configure the username and >password properties. Here is a copy of my file which does work. > >hibernate.connection.datasource java:/CoefficientDS >hibernate.connection.username=root >hibernate.connection.password=******* >hibernate.dialect net.sf.hibernate.dialect.MySQLDialect >hibernate.session_factory_name net.sf.hibernate.SessionFactory >hibernate.transaction.factory_class >net.sf.hibernate.transaction.JTATransactionFactory >hibernate.connection.pool_size 0 > > >Good luck. > > > >----- Original Message ----- >From: "Mike Spisak" <mi...@sp...> >To: <coe...@li...> >Sent: Thursday, July 14, 2005 5:39 PM >Subject: [Coefficient-users] MySQL troubles ... > > > > >>Hi All :: >> >>Coefficient seems like a VERY cool platform.. installation was going >>really well: >>- Tomcat 4.1.18 went in with no troubles... >>- MySQL 3.23 was a snap... (I included the org.gjt.mm.mysql.Driver) >>- I followed the installation procedure (hibernate.properties, >>server.xml, etc..) smooth.. >>- Deployed the war file.. nicey nice... >>- tried to hit the main URL and got.. *ouch* >>*There has been a system exception* >> >>java.lang.NullPointerException >>at >> >> >> >net.sf.hibernate.util.HibernateUtil.getUniqueSession(HibernateUtil.java:179 ) > > >>at net.sf.hibernate.util.HibernateUtil.find(HibernateUtil.java:365) >>at >> >> >> >za.org.coefficient.modules.configuration.Configuration.getConfiguration(Con f >iguration.java:144) > > >>at >> >> >> >za.org.coefficient.modules.configuration.Configuration.view(Configuration.j a >va:85) > > >>at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>at >> >> >> >sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:3 9 >) > > >>at >> >> >> >sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImp l >java:25) > > >>at java.lang.reflect.Method.invoke(Method.java:324) >>. . . . . . . >>Now I've never used Hibernate before.. so here's a snapshot of my >>properties file - not sure if the "dialect" line is right: >> hibernate.connection.driver_class org.gjt.mm.mysql.Driver >> hibernate.connection.url jdbc:mysql://localhost/my_db >> hibernate.connection.username root >> hibernate.connection.password ***** >> hibernate.dialect org.hibernate.dialect.MySQLDialect >> # I also tried net.sf.hibernate.dialect.MySQLDialect >> #hibernate.dialect net.sf.hibernate.dialect.PostgreSQLDialect >> hibernate.connection.pool_size 0 >> #hibernate.show_sql true >> >>hhmm, am I missing something? Do I need a newer version of mySQL? I've >>lurked the user group a little and saw other problems with mySQL, should >>I bail and get Postgre? Thanks in advance! >> >>Mike >> >>PS: system specs: >>- SuSE Linux 9.1 >>- J2SDK 1.4.2_06 >>- Tomcat 4.1.18 >>- MySQL 3.23 >>- etc... >> >> >> >>------------------------------------------------------- >>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_id=7477&alloc_id=16492&op=click >>_______________________________________________ >>Coefficient-users mailing list >>Coe...@li... >>https://lists.sourceforge.net/lists/listinfo/coefficient-users >> >> >> > > > > ------------------------------------------------------- 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_id=7477&alloc_id=16492&op=click _______________________________________________ Coefficient-users mailing list Coe...@li... https://lists.sourceforge.net/lists/listinfo/coefficient-users |
|
From: Mike S. <mi...@sp...> - 2005-07-15 16:50:40
|
Thanks for the reply... hhmmm, still getting that nasty "NullPointer" exception.. - I've upgraded to MySQL 4.1.12 standard.. - I'm using MySQL connector v3.0.17 - I updated my hibernate.properties file (given Hotmail's example) - like so: hibernate.connection.driver_class com.mysql.jdbc.Driver hibernate.connection.url jdbc:mysql://localhost/mydatabase hibernate.connection.username=root hibernate.connection.password=password hibernate.dialect net.sf.hibernate.dialect.MySQLDialect hibernate.connection.datasource java:/mydatabase hibernate.session_factory_name net.sf.hibernate.SessionFactory hibernate.transaction.factory_class net.sf.hibernate.transaction.JTATransactionFactory hibernate.connection.pool_size 0 #hibernate.show_sql true Now, just for giggles, I shutdown MySQL just to see if I'd get a different error and I continue to get this : java.lang.NullPointerException at net.sf.hibernate.util.HibernateUtil.getUniqueSession(HibernateUtil.java:179) at net.sf.hibernate.util.HibernateUtil.find(HibernateUtil.java:365) at za.org.coefficient.modules.configuration.Configuration.getConfiguration(Configuration.java:144) at za.org.coefficient.modules.configuration.Configuration.view(Configuration.java:85) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) <<I didn't post the whole stack trace.. but you get the idea..>> I'm thinking I have some kind of a "Hibernate" issue? anyone got ideas? much thanks! Mike Hotmail wrote: >Mike, > >I'm using MySQL 4.1.10a-Max version and Coefficient works find with it. > >I did notice that in order for Coefficient to work correctly, I had to >create the database "coefficient" manually. Once I did that coefficient >correctly created and populated the tables. > >Also, it took me a few tries to correctly configure the username and >password properties. Here is a copy of my file which does work. > >hibernate.connection.datasource java:/CoefficientDS >hibernate.connection.username=root >hibernate.connection.password=******* >hibernate.dialect net.sf.hibernate.dialect.MySQLDialect >hibernate.session_factory_name net.sf.hibernate.SessionFactory >hibernate.transaction.factory_class >net.sf.hibernate.transaction.JTATransactionFactory >hibernate.connection.pool_size 0 > > >Good luck. > > > >----- Original Message ----- >From: "Mike Spisak" <mi...@sp...> >To: <coe...@li...> >Sent: Thursday, July 14, 2005 5:39 PM >Subject: [Coefficient-users] MySQL troubles ... > > > > >>Hi All :: >> >>Coefficient seems like a VERY cool platform.. installation was going >>really well: >>- Tomcat 4.1.18 went in with no troubles... >>- MySQL 3.23 was a snap... (I included the org.gjt.mm.mysql.Driver) >>- I followed the installation procedure (hibernate.properties, >>server.xml, etc..) smooth.. >>- Deployed the war file.. nicey nice... >>- tried to hit the main URL and got.. *ouch* >>*There has been a system exception* >> >>java.lang.NullPointerException >>at >> >> >> >net.sf.hibernate.util.HibernateUtil.getUniqueSession(HibernateUtil.java:179) > > >>at net.sf.hibernate.util.HibernateUtil.find(HibernateUtil.java:365) >>at >> >> >> >za.org.coefficient.modules.configuration.Configuration.getConfiguration(Conf >iguration.java:144) > > >>at >> >> >> >za.org.coefficient.modules.configuration.Configuration.view(Configuration.ja >va:85) > > >>at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>at >> >> >> >sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39 >) > > >>at >> >> >> >sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl >java:25) > > >>at java.lang.reflect.Method.invoke(Method.java:324) >>. . . . . . . >>Now I've never used Hibernate before.. so here's a snapshot of my >>properties file - not sure if the "dialect" line is right: >> hibernate.connection.driver_class org.gjt.mm.mysql.Driver >> hibernate.connection.url jdbc:mysql://localhost/my_db >> hibernate.connection.username root >> hibernate.connection.password ***** >> hibernate.dialect org.hibernate.dialect.MySQLDialect >> # I also tried net.sf.hibernate.dialect.MySQLDialect >> #hibernate.dialect net.sf.hibernate.dialect.PostgreSQLDialect >> hibernate.connection.pool_size 0 >> #hibernate.show_sql true >> >>hhmm, am I missing something? Do I need a newer version of mySQL? I've >>lurked the user group a little and saw other problems with mySQL, should >>I bail and get Postgre? Thanks in advance! >> >>Mike >> >>PS: system specs: >>- SuSE Linux 9.1 >>- J2SDK 1.4.2_06 >>- Tomcat 4.1.18 >>- MySQL 3.23 >>- etc... >> >> >> >>------------------------------------------------------- >>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_id=7477&alloc_id=16492&op=click >>_______________________________________________ >>Coefficient-users mailing list >>Coe...@li... >>https://lists.sourceforge.net/lists/listinfo/coefficient-users >> >> >> > > > > |
|
From: Hotmail <mr_...@ho...> - 2005-07-14 23:13:44
|
Mike, I'm using MySQL 4.1.10a-Max version and Coefficient works find with it. I did notice that in order for Coefficient to work correctly, I had to create the database "coefficient" manually. Once I did that coefficient correctly created and populated the tables. Also, it took me a few tries to correctly configure the username and password properties. Here is a copy of my file which does work. hibernate.connection.datasource java:/CoefficientDS hibernate.connection.username=root hibernate.connection.password=******* hibernate.dialect net.sf.hibernate.dialect.MySQLDialect hibernate.session_factory_name net.sf.hibernate.SessionFactory hibernate.transaction.factory_class net.sf.hibernate.transaction.JTATransactionFactory hibernate.connection.pool_size 0 Good luck. ----- Original Message ----- From: "Mike Spisak" <mi...@sp...> To: <coe...@li...> Sent: Thursday, July 14, 2005 5:39 PM Subject: [Coefficient-users] MySQL troubles ... > Hi All :: > > Coefficient seems like a VERY cool platform.. installation was going > really well: > - Tomcat 4.1.18 went in with no troubles... > - MySQL 3.23 was a snap... (I included the org.gjt.mm.mysql.Driver) > - I followed the installation procedure (hibernate.properties, > server.xml, etc..) smooth.. > - Deployed the war file.. nicey nice... > - tried to hit the main URL and got.. *ouch* > *There has been a system exception* > > java.lang.NullPointerException > at > net.sf.hibernate.util.HibernateUtil.getUniqueSession(HibernateUtil.java:179) > at net.sf.hibernate.util.HibernateUtil.find(HibernateUtil.java:365) > at > za.org.coefficient.modules.configuration.Configuration.getConfiguration(Conf iguration.java:144) > at > za.org.coefficient.modules.configuration.Configuration.view(Configuration.ja va:85) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39 ) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl java:25) > at java.lang.reflect.Method.invoke(Method.java:324) > . . . . . . . > Now I've never used Hibernate before.. so here's a snapshot of my > properties file - not sure if the "dialect" line is right: > hibernate.connection.driver_class org.gjt.mm.mysql.Driver > hibernate.connection.url jdbc:mysql://localhost/my_db > hibernate.connection.username root > hibernate.connection.password ***** > hibernate.dialect org.hibernate.dialect.MySQLDialect > # I also tried net.sf.hibernate.dialect.MySQLDialect > #hibernate.dialect net.sf.hibernate.dialect.PostgreSQLDialect > hibernate.connection.pool_size 0 > #hibernate.show_sql true > > hhmm, am I missing something? Do I need a newer version of mySQL? I've > lurked the user group a little and saw other problems with mySQL, should > I bail and get Postgre? Thanks in advance! > > Mike > > PS: system specs: > - SuSE Linux 9.1 > - J2SDK 1.4.2_06 > - Tomcat 4.1.18 > - MySQL 3.23 > - etc... > > > > ------------------------------------------------------- > 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_id=7477&alloc_id=16492&op=click > _______________________________________________ > Coefficient-users mailing list > Coe...@li... > https://lists.sourceforge.net/lists/listinfo/coefficient-users > |
|
From: Mike S. <mi...@sp...> - 2005-07-14 21:40:26
|
Hi All ::
Coefficient seems like a VERY cool platform.. installation was going
really well:
- Tomcat 4.1.18 went in with no troubles...
- MySQL 3.23 was a snap... (I included the org.gjt.mm.mysql.Driver)
- I followed the installation procedure (hibernate.properties,
server.xml, etc..) smooth..
- Deployed the war file.. nicey nice...
- tried to hit the main URL and got.. *ouch*
*There has been a system exception*
java.lang.NullPointerException
at
net.sf.hibernate.util.HibernateUtil.getUniqueSession(HibernateUtil.java:179)
at net.sf.hibernate.util.HibernateUtil.find(HibernateUtil.java:365)
at
za.org.coefficient.modules.configuration.Configuration.getConfiguration(Configuration.java:144)
at
za.org.coefficient.modules.configuration.Configuration.view(Configuration.java:85)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
. . . . . . .
Now I've never used Hibernate before.. so here's a snapshot of my
properties file - not sure if the "dialect" line is right:
hibernate.connection.driver_class org.gjt.mm.mysql.Driver
hibernate.connection.url jdbc:mysql://localhost/my_db
hibernate.connection.username root
hibernate.connection.password *****
hibernate.dialect org.hibernate.dialect.MySQLDialect
# I also tried net.sf.hibernate.dialect.MySQLDialect
#hibernate.dialect net.sf.hibernate.dialect.PostgreSQLDialect
hibernate.connection.pool_size 0
#hibernate.show_sql true
hhmm, am I missing something? Do I need a newer version of mySQL? I've
lurked the user group a little and saw other problems with mySQL, should
I bail and get Postgre? Thanks in advance!
Mike
PS: system specs:
- SuSE Linux 9.1
- J2SDK 1.4.2_06
- Tomcat 4.1.18
- MySQL 3.23
- etc...
|
|
From: Pieter v. Z. <pv...@cs...> - 2005-07-13 11:06:07
|
The affected files have been updated. And the plainWhiteTheme was also added to Themes On Wed, 2005-07-13 at 11:12 +0200, Pieter van Zyl wrote: > The new files will only be uploaded during today > > -------- Forwarded Message -------- > From: Pieter van Zyl <pv...@cs...> > Reply-To: pv...@cs... > To: tfo...@us... > Cc: coefficient-users <coe...@li...>, > coefficient devel <coe...@li...> > Subject: [Coefficient-devel] Subject: Minor issue with Coefficient 0.9.6 > release files > Date: Tue, 12 Jul 2005 11:22:39 +0200 > Subject: Minor issue with Coefficient 0.9.6 release files > > There is a small issue with the recent Coefficient release (version > 0.9.6): it is configured to use the DgroupsDataLoaderUtil instead of the > default DataLoaderUtil. These DataLoader classes are used to populate > the default settings and menus. > > The data loaders are configured in the hibernate_util.properties file, > as follows: > > ## Defines the class that contains my data loading method > data_loader_class=za.org.coefficient.util.ejb.DataLoaderUtil > ##data_loader_class=za.org.coefficient.themes.dgroupsDefaultTheme.DgroupsDataLoaderUtil > > ......................................... > > We will re-release the following affected files later today: > coefficient-core-src (coefficient core source) > coefficient-ejb-all (coefficient and all the ear modules) > coeffcient-ejb-core (coefficient core only) > coefficient-war-all (coefficient war with all the modules) > > If you have already downloaded any of these files, it is possible to > patch them yourself by editing hibernate_util.properties, commenting out > the DgroupsDataLoaderUtil and replacing it with > za.org.coefficient.util.ejb.DataLoaderUtil. > > Then run updateAllPropertiesEAR.sh/bat or updateAllPropertiesWeb.sh/bat > (Note: the coefficient-ejb-core release files do not contain these > scripts, so you'll have to update your .ear yourself) > > Unless you had a previous Coefficient installation (in which case the > database already existed), you'll probably need to drop the database as > well, so that it can be recreated with the correct defaults. This is > only necessary if you did a fresh install of Coefficient and the > DgroupsDataLoader populated your (new) database with DGroups-specific > settings. > > If you where to deploy only the coefficient modules it will not find the > DgroupsDataLoaderUtil and probably break. > > We expect to have the patched files up later today. > > Sorry for the inconvenience > The Coefficient developers > > > > > On Mon, 2005-07-11 at 18:24 +0200, Thomas Fogwill wrote: > > The Coefficient team is proud to announce the release of Coefficient version 0.9.6 > > > > Coefficient is a scalable, project-based collaboration platform that > > runs in J2EE and/or Servlet containers. Currently, it provides basic > > collaboration functionality packaged as hot-deployable modules. It also > > provides a workflow engine to guide projects through their development > > cycle. > > > > Changes in this version include: > > * Aliasing of e-mail addresses in the MailForum module > > * Improved OneWorldTheme for OpenDgroups > > * MailForum settings page for the MailForum module > > * Constants.ALIAS_MAIL_HOST_ADDRESS to configure an alias domain > > * Added MAX_NUM_OF_FORUMS for OpenDgroups. > > * Added a generic event dispatch and handling system > > * More modular release structure > > > > Please see the release notes for more information. > > > > Coefficient can be downloaded from here: > > http://sourceforge.net/project/showfiles.php?group_id=90755 > > > > Regards > > The Coefficient developers > > > > > > > > ------------------------------------------------------- > This SF.Net email is sponsored by the 'Do More With Dual!' webinar happening > July 14 at 8am PDT/11am EDT. We invite you to explore the latest in dual > core and dual graphics technology at this free one hour event hosted by HP, > AMD, and NVIDIA. To register visit http://www.hp.com/go/dualwebinar > _______________________________________________ > Coefficient-devel mailing list > Coe...@li... > https://lists.sourceforge.net/lists/listinfo/coefficient-devel > > > > ------------------------------------------------------- > This SF.Net email is sponsored by the 'Do More With Dual!' webinar happening > July 14 at 8am PDT/11am EDT. We invite you to explore the latest in dual > core and dual graphics technology at this free one hour event hosted by HP, > AMD, and NVIDIA. To register visit http://www.hp.com/go/dualwebinar > _______________________________________________ > Coefficient-devel mailing list > Coe...@li... > https://lists.sourceforge.net/lists/listinfo/coefficient-devel |
|
From: Pieter v. Z. <pv...@cs...> - 2005-07-13 09:13:10
|
The new files will only be uploaded during today -------- Forwarded Message -------- From: Pieter van Zyl <pv...@cs...> Reply-To: pv...@cs... To: tfo...@us... Cc: coefficient-users <coe...@li...>, coefficient devel <coe...@li...> Subject: [Coefficient-devel] Subject: Minor issue with Coefficient 0.9.6 release files Date: Tue, 12 Jul 2005 11:22:39 +0200 Subject: Minor issue with Coefficient 0.9.6 release files There is a small issue with the recent Coefficient release (version 0.9.6): it is configured to use the DgroupsDataLoaderUtil instead of the default DataLoaderUtil. These DataLoader classes are used to populate the default settings and menus. The data loaders are configured in the hibernate_util.properties file, as follows: ## Defines the class that contains my data loading method data_loader_class=za.org.coefficient.util.ejb.DataLoaderUtil ##data_loader_class=za.org.coefficient.themes.dgroupsDefaultTheme.DgroupsDataLoaderUtil ......................................... We will re-release the following affected files later today: coefficient-core-src (coefficient core source) coefficient-ejb-all (coefficient and all the ear modules) coeffcient-ejb-core (coefficient core only) coefficient-war-all (coefficient war with all the modules) If you have already downloaded any of these files, it is possible to patch them yourself by editing hibernate_util.properties, commenting out the DgroupsDataLoaderUtil and replacing it with za.org.coefficient.util.ejb.DataLoaderUtil. Then run updateAllPropertiesEAR.sh/bat or updateAllPropertiesWeb.sh/bat (Note: the coefficient-ejb-core release files do not contain these scripts, so you'll have to update your .ear yourself) Unless you had a previous Coefficient installation (in which case the database already existed), you'll probably need to drop the database as well, so that it can be recreated with the correct defaults. This is only necessary if you did a fresh install of Coefficient and the DgroupsDataLoader populated your (new) database with DGroups-specific settings. If you where to deploy only the coefficient modules it will not find the DgroupsDataLoaderUtil and probably break. We expect to have the patched files up later today. Sorry for the inconvenience The Coefficient developers On Mon, 2005-07-11 at 18:24 +0200, Thomas Fogwill wrote: > The Coefficient team is proud to announce the release of Coefficient version 0.9.6 > > Coefficient is a scalable, project-based collaboration platform that > runs in J2EE and/or Servlet containers. Currently, it provides basic > collaboration functionality packaged as hot-deployable modules. It also > provides a workflow engine to guide projects through their development > cycle. > > Changes in this version include: > * Aliasing of e-mail addresses in the MailForum module > * Improved OneWorldTheme for OpenDgroups > * MailForum settings page for the MailForum module > * Constants.ALIAS_MAIL_HOST_ADDRESS to configure an alias domain > * Added MAX_NUM_OF_FORUMS for OpenDgroups. > * Added a generic event dispatch and handling system > * More modular release structure > > Please see the release notes for more information. > > Coefficient can be downloaded from here: > http://sourceforge.net/project/showfiles.php?group_id=90755 > > Regards > The Coefficient developers > > ------------------------------------------------------- This SF.Net email is sponsored by the 'Do More With Dual!' webinar happening July 14 at 8am PDT/11am EDT. We invite you to explore the latest in dual core and dual graphics technology at this free one hour event hosted by HP, AMD, and NVIDIA. To register visit http://www.hp.com/go/dualwebinar _______________________________________________ Coefficient-devel mailing list Coe...@li... https://lists.sourceforge.net/lists/listinfo/coefficient-devel |
|
From: Pieter v. Z. <pv...@cs...> - 2005-07-12 09:23:25
|
Subject: Minor issue with Coefficient 0.9.6 release files There is a small issue with the recent Coefficient release (version 0.9.6): it is configured to use the DgroupsDataLoaderUtil instead of the default DataLoaderUtil. These DataLoader classes are used to populate the default settings and menus. The data loaders are configured in the hibernate_util.properties file, as follows: ## Defines the class that contains my data loading method data_loader_class=za.org.coefficient.util.ejb.DataLoaderUtil ##data_loader_class=za.org.coefficient.themes.dgroupsDefaultTheme.DgroupsDataLoaderUtil ......................................... We will re-release the following affected files later today: coefficient-core-src (coefficient core source) coefficient-ejb-all (coefficient and all the ear modules) coeffcient-ejb-core (coefficient core only) coefficient-war-all (coefficient war with all the modules) If you have already downloaded any of these files, it is possible to patch them yourself by editing hibernate_util.properties, commenting out the DgroupsDataLoaderUtil and replacing it with za.org.coefficient.util.ejb.DataLoaderUtil. Then run updateAllPropertiesEAR.sh/bat or updateAllPropertiesWeb.sh/bat (Note: the coefficient-ejb-core release files do not contain these scripts, so you'll have to update your .ear yourself) Unless you had a previous Coefficient installation (in which case the database already existed), you'll probably need to drop the database as well, so that it can be recreated with the correct defaults. This is only necessary if you did a fresh install of Coefficient and the DgroupsDataLoader populated your (new) database with DGroups-specific settings. If you where to deploy only the coefficient modules it will not find the DgroupsDataLoaderUtil and probably break. We expect to have the patched files up later today. Sorry for the inconvenience The Coefficient developers On Mon, 2005-07-11 at 18:24 +0200, Thomas Fogwill wrote: > The Coefficient team is proud to announce the release of Coefficient version 0.9.6 > > Coefficient is a scalable, project-based collaboration platform that > runs in J2EE and/or Servlet containers. Currently, it provides basic > collaboration functionality packaged as hot-deployable modules. It also > provides a workflow engine to guide projects through their development > cycle. > > Changes in this version include: > * Aliasing of e-mail addresses in the MailForum module > * Improved OneWorldTheme for OpenDgroups > * MailForum settings page for the MailForum module > * Constants.ALIAS_MAIL_HOST_ADDRESS to configure an alias domain > * Added MAX_NUM_OF_FORUMS for OpenDgroups. > * Added a generic event dispatch and handling system > * More modular release structure > > Please see the release notes for more information. > > Coefficient can be downloaded from here: > http://sourceforge.net/project/showfiles.php?group_id=90755 > > Regards > The Coefficient developers > > |
|
From: Thomas F. <tfo...@us...> - 2005-07-11 16:26:30
|
The Coefficient team is proud to announce the release of Coefficient version 0.9.6 Coefficient is a scalable, project-based collaboration platform that runs in J2EE and/or Servlet containers. Currently, it provides basic collaboration functionality packaged as hot-deployable modules. It also provides a workflow engine to guide projects through their development cycle. Changes in this version include: * Aliasing of e-mail addresses in the MailForum module * Improved OneWorldTheme for OpenDgroups * MailForum settings page for the MailForum module * Constants.ALIAS_MAIL_HOST_ADDRESS to configure an alias domain * Added MAX_NUM_OF_FORUMS for OpenDgroups. * Added a generic event dispatch and handling system * More modular release structure Please see the release notes for more information. Coefficient can be downloaded from here: http://sourceforge.net/project/showfiles.php?group_id=90755 Regards The Coefficient developers -- 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. |
|
From: Thomas F. <tfo...@us...> - 2005-06-07 10:49:10
|
weird. Do you have aspectjtools.jar in your lib directory? It should contain the aspectjTaskdefs.properties file. If it does exist and contains the properties file, then there could be an incompatibility between the AspectJ ant tasks and the version of Ant you're using. The aspectjtools.jar in CVS is for AspectJ 1.1.0 (I think). If you're using a recent version of Ant, you could try using a more recent version of AspectJ? Alternatively, if you're willing to live without logging and statistics, you can edit the build.xml to use a standard javac instead of iajc (iajc is the AspectJ compiler). Everything (other than logging and statistics gathering) should still work fine. On Tue, 2005-06-07 at 19:53 +1000, Dylan & Anna Etkin wrote: > ---------- Forwarded message ---------- > From: mig <mr_...@us...> > Date: Jun 3, 2005 3:14 AM > Subject: Coefficient - help > To: de...@us... > > > Message body follows: > > Dylan, > > I'm trying to deploy a new theme. I've followed the directions > provided on "How to write a theme". I'm getting the following error > when I execute "ant clean deploy". > > org/aspectj/tools/ant/taskdefs/aspectjTaskdefs.properties. It could > not be found. > > I would appriciate any help you could provide. > > Thanks > Miguel > mr_mperez > ID 1263820 > > PS - Great product. > > -- > This message has been sent to you, a registered SourceForge.net user, > by another site user, through the SourceForge.net site. This message > has been delivered to your SourceForge.net mail alias. You may reply > to this message using the "Reply" feature of your email client, or > using the messaging facility of SourceForge.net at: > https://sourceforge.net/sendmessage.php?touser=1263820 > > > ------------------------------------------------------- > This SF.Net email is sponsored by: NEC IT Guy Games. How far can you shotput > a projector? How fast can you ride your desk chair down the office luge track? > If you want to score the big prize, get to know the little guy. > Play to win an NEC 61" plasma display: http://www.necitguy.com/?r > _______________________________________________ > Coefficient-users mailing list > Coe...@li... > https://lists.sourceforge.net/lists/listinfo/coefficient-users -- 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. |
|
From: Dylan & A. E. <dn...@gm...> - 2005-06-07 09:53:13
|
---------- Forwarded message ---------- From: mig <mr_...@us...> Date: Jun 3, 2005 3:14 AM Subject: Coefficient - help To: de...@us... Message body follows: Dylan, I'm trying to deploy a new theme. I've followed the directions provided on "How to write a theme". I'm getting the following error when I execute "ant clean deploy". org/aspectj/tools/ant/taskdefs/aspectjTaskdefs.properties. It could not be found. I would appriciate any help you could provide. Thanks Miguel mr_mperez ID 1263820 PS - Great product. -- This message has been sent to you, a registered SourceForge.net user, by another site user, through the SourceForge.net site. This message has been delivered to your SourceForge.net mail alias. You may reply to this message using the "Reply" feature of your email client, or using the messaging facility of SourceForge.net at: https://sourceforge.net/sendmessage.php?touser=3D1263820 |
|
From: Thomas F. <tfo...@us...> - 2005-06-07 08:57:30
|
On Mon, 2005-06-06 at 12:33 -0400, Enrique Nunez wrote:
> I've downloaded Coefficient, gotten it to run and started playing
> around with it.
Glad to hear it :)
> I've gone through all the documentation and noticed the "Workflow
> Howto" has yet to be written.
>
> Has anyone written down exactly how to write your own workflows?
> Also, what doctype is simpleWorkflow.xml?
I can't remember offhand (I didn't write the workflow code). What I do
remember (and what I can surmise from studying simpleworkflow.xml) is
the following:
* workflows definitions are done in an xml - see simpleWorkflow.xml (no
DTD written, as far as I know, but there may have been some effort made
defining a schema)
* Workflow definitions are uploaded via the WorkflowAdmin module
Each workflow definition has a name and description. I'm not sure about
this, but I assume the list of <module/> elements (under the root)
implies that the workflow must also declare which coefficient modules it
will use.
I have no idea what the <comparator/> element under the root does ???
The workflow engine is really more of a state transition engine, so each
workflow.xml must define a set of states, one of which must be a
starting state. It also defines one or more stop states (terminal states
for the workflow - processing end in these states). Each state has a
unique name and a description. The optional <start-state/> element sets
whether or not a state is the start state, and the <stop-state/> sets
whether it is a terminal state.
Transitions between states are defined by stipulating rules/conditions
in the xml file. Each transition is defined as:
* destination state: name of the state to which we move if the
conditions are met
* rules: a set of rules to determine whether to make the transition or
not.
If I remember correctly, given the current state, the engine scans it's
list of transitions, until it finds one whose rules are satisfied. The
first transition found is "executed". I don't think multiple transitions
and forking are supported; hence a workflow follows a single path
through a set of states.
The anatomy of the <rules> for a <state-transition> element is as
follows:
The <rules> element contains a set of <rule> elements. It also contains
a <logical-operator> element, which determines how to evaluate rules
when >1 of them are defined (i.e. when <rules> has >1 <rule> children).
<operator-name>and</operator-name><rule>...</rule><rule>...</rule>
matches if all the <rule> elements evaluate to true
<operator-name>or</operator-name><rule>...</rule><rule>...</rule>
matches if any of the <rule> element evaluate to true
etc.
Each <rule> is defined as:
* a <comparator> element, which essentially defines the
operator/operation used to evaluate . can be ==, =>, <=, etc
or it can be "boolean", which simply matches the boolean value of it's
one parameter. Not sure what else is supported?
* a list of <paramater-element> elements, which define the operands
A <paramater-element> contain one of the following:
* a <paramater> element, for specifying a simple parameter. It has a
<value> and a <type>. <type> is the Java type/classname of the
parameter. <value> is the string representation of it's value. It can
also have a <name>
* an <action> element, which wraps the return value of a method call as
a parameter. It has a <clazz> and a <method> elements, with optional
<parameter-element> elements (so you can nest actions).
* a <property> element, used to define a parameter that is the value of
some property of an object. <action> declares the method to invoke to
obtain a reference to the object, and <prop> is used to declare the
property we're interested in.
For instance,
<property>
<prop>members.size()</prop>
<name>membersSize</name>
<action>
<clazz>Project</clazz>
<method>getProject</method>
</action>
</property>
getProject() is called to get a Project instance, and then the
members.size() property is invoked (actually, the members property is
obtained via getMembers, and then size() is called on it).
A <state> also declares a <visibile-modules> element which declares
which modules are visible while in this state (and, by implication,
which are hidden).
The <state> can also declare an <entry-state-actions> element that
allows you to specify what must be done when this state is entered. In
simpleworkflow.xml, for instance, the "readme task completion phase"
updates the issue in the IssueTracker with information about the
creation of the readme file.
Similarly, one can define <exit-state-actions> for a state.
Hopefully, what I've written above is accurate, and will help you to get
going started. I should probably spend time to distill this into a
proper howto (but really don't have much time right now :)
Please contribute any corrections/additions to what I've written above
(as this thread will probably form the basis of the howto).
> This seems like a great product and I'd definitely consider it for my
> clients if I could become more proficient in its use.
Excellent, that is good news! We're hoping to release an update soon,
with some changes to the Dithaka (http://dithaka.sourceforge.net) and
email integration. Will post an announcement to the developers + users
lists when we do.
Regards
T
--
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.
|
|
From: <seb...@ph...> - 2005-02-10 14:21:26
|
Hibernate was also used in one of our developments but we didn't face the
same issue.
It might just be a hibernate configuration problem. The thing I do not
understand is that you don't have
the same behaviour on your system.
FYI
In our project we configured hibernate in order to use a connection pool
managed be the application server
itself (BEA in our case). Connection pools in weblogic have some
parameters which allow to periodically
test and reset the connection if needed. Tomcat and JBoss have probably
something equivalent.
Best regards,
Sebastien
Thomas Fogwill <tfo...@us...>
10/02/2005 14:23
Please respond to tfogwill
To: Sebastien Lemeunier/PH/Novartis@PH
cc: coefficient-users <coe...@li...>
Subject: Re: [Coefficient-users] SQL exceptions + Oracle incompatibility
Category:
On Thu, 2005-02-10 at 11:33 +0100, sebastien wrote:
> When using Coefficient with mysql I constantly get sql exception after
> a long period of inactivity (similar errors to the one I had at
> installation time before the schema was updated). After a few seconds
> clicking arround everything seems to work again. I have the feeling
> that mysql is closing connections and that there are not reset
> properly.
I agree with your diagnostic - seems like a logical conclusion. We
should definitely take a look at ways of solving the problem (although
this issue may need to be solved within hibernate itself).
> I also decided to test Coefficient with Oracle in order to find out if
> mysql was the responsible and actually I discovered that it is
> impossible to configure the database with Oracle due to
> an identifier name issue.
> ...
Yip, I've seen this. Ironic: in the last major overhaul of coefficient,
all the table names were changed to make the data model cleaner and
easier to follow. One of the things done was to prepend "COEFFICIENT_"
to many of the core tables. However, as a result of this, it seems some
of them have become too long for some RDBMS to handle. Anyone know
whether it's possible to configure the max identifier length for Oracle?
As soon as I have some spare time (and the motivation :) I'll change the
tables to use shorter names, and put up a new release.
--
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.
|
|
From: Thomas F. <tfo...@us...> - 2005-02-10 13:57:26
|
On Thu, 2005-02-10 at 11:33 +0100, sebastien wrote: > I also decided to test Coefficient with Oracle in order to find out if > mysql was the responsible ... I don't see this issue at all on postgres, so mysql is probably doing something odd (unless it's postgres that's doing something odd to make it work :) -- 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. |
|
From: Thomas F. <tfo...@us...> - 2005-02-10 13:24:43
|
On Thu, 2005-02-10 at 11:33 +0100, sebastien wrote: > When using Coefficient with mysql I constantly get sql exception after > a long period of inactivity (similar errors to the one I had at > installation time before the schema was updated). After a few seconds > clicking arround everything seems to work again. I have the feeling > that mysql is closing connections and that there are not reset > properly. I agree with your diagnostic - seems like a logical conclusion. We should definitely take a look at ways of solving the problem (although this issue may need to be solved within hibernate itself). > I also decided to test Coefficient with Oracle in order to find out if > mysql was the responsible and actually I discovered that it is > impossible to configure the database with Oracle due to > an identifier name issue. > ... Yip, I've seen this. Ironic: in the last major overhaul of coefficient, all the table names were changed to make the data model cleaner and easier to follow. One of the things done was to prepend "COEFFICIENT_" to many of the core tables. However, as a result of this, it seems some of them have become too long for some RDBMS to handle. Anyone know whether it's possible to configure the max identifier length for Oracle? As soon as I have some spare time (and the motivation :) I'll change the tables to use shorter names, and put up a new release. -- 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. |
|
From: <seb...@ph...> - 2005-02-10 10:34:09
|
When using Coefficient with mysql I constantly get sql exception after a
long period of inactivity (similar errors to the one I had at installation
time before the schema was updated). After a few seconds
clicking arround everything seems to work again. I have the feeling that
mysql is closing connections and that there are not reset properly.
I also decided to test Coefficient with Oracle in order to find out if
mysql was the responsible and actually I discovered that it is impossible
to configure the database with Oracle due to
an identifier name issue.
See extract of the logs below.
4747 [Thread-5] INFO hbm2ddl.DatabaseMetadata - table not found:
COEFFICIENT_PROJECT_ATTRIBUTES_DATA
4757 [Thread-5] INFO hbm2ddl.DatabaseMetadata - table not found:
COEFFICIENT_PROJECT
4828 [Thread-5] INFO hbm2ddl.DatabaseMetadata - table not found:
hibernate_sequence
<< key: hibernate_sequence is not sequence or table
java.sql.SQLException: ORA-00972: identifier is too long
at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
Best regards,
Sebastien |
|
From: <seb...@ph...> - 2005-02-07 11:25:03
|
The first one was the right one. Adding the java option solved the issue.
Thanks,
Sebastien
Thomas Fogwill <tfo...@us...>
28/01/2005 21:58
Please respond to tfogwill
To: Sebastien Lemeunier/PH/Novartis@PH
cc: coefficient-users <coe...@li...>
Subject: Re: Bug with project statistics
Category:
On Fri, 2005-01-28 at 14:14 +0100, sebastien wrote:
> Caused by: java.lang.NoClassDefFoundError
> at
za.org.coefficient.modules.statistics.StatisticsDisplay.generateAndSaveProjectTotalsXYLineChart(StatisticsDisplay.java:222)
mmmm... this is where a new org.jfree.chart.axis.NumberAxis instance is
created.
Three reasons I can think of for the breakage:
1 - If you are running your server in a non-graphical environment (i.e.
without a windowing environment like X), you need to start the JVM (for
Tomcat) with the -Djava.awt.headless=true property. In non-graphical
environments without this property set, JFreeChart cannot init (as it
expects to find a graphical environment). It works fine with the
property set, though.
2 - Perhaps your WEB-INF/lib/jfreechart-0.9.21.jar file is corrupt or
unreadable? It should contain the org.jfree.chart.axis.NumberAxis
classfile.
3 - (improbable) Is it possible that you have another (older) jfreechart
jar in your classpath (and that it is freaking out the 0.9.21 one)?
--
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.
|
|
From: Thomas F. <tfo...@us...> - 2005-01-28 20:59:19
|
On Fri, 2005-01-28 at 14:14 +0100, sebastien wrote: > Caused by: java.lang.NoClassDefFoundError > at za.org.coefficient.modules.statistics.StatisticsDisplay.generateAndSaveProjectTotalsXYLineChart(StatisticsDisplay.java:222) mmmm... this is where a new org.jfree.chart.axis.NumberAxis instance is created. Three reasons I can think of for the breakage: 1 - If you are running your server in a non-graphical environment (i.e. without a windowing environment like X), you need to start the JVM (for Tomcat) with the -Djava.awt.headless=true property. In non-graphical environments without this property set, JFreeChart cannot init (as it expects to find a graphical environment). It works fine with the property set, though. 2 - Perhaps your WEB-INF/lib/jfreechart-0.9.21.jar file is corrupt or unreadable? It should contain the org.jfree.chart.axis.NumberAxis classfile. 3 - (improbable) Is it possible that you have another (older) jfreechart jar in your classpath (and that it is freaking out the 0.9.21 one)? -- 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. |
|
From: <seb...@ph...> - 2005-01-28 13:15:26
|
I found a bug in the project statistics view
(java.lang.NoClassDefFoundError).
See below for the exception.
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
org.apache.commons.beanutils.MethodUtils.invokeMethod(MethodUtils.java:252)
at
org.apache.commons.beanutils.MethodUtils.invokeMethod(MethodUtils.java:198)
at
org.apache.commons.beanutils.MethodUtils.invokeMethod(MethodUtils.java:150)
at
za.org.coefficient.invokers.base.BaseInvoker.invokeOpOnModule(BaseInvoker.java:180)
at
za.org.coefficient.invokers.base.BaseInvoker.invoke(BaseInvoker.java:74)
at
za.org.coefficient.interceptors.ExecuteModuleInterceptor.handleInvoke(ExecuteModuleInterceptor.java:41)
at
za.org.coefficient.core.CoefficientInterceptor.invoke(CoefficientInterceptor.java:79)
at
za.org.coefficient.core.CoefficientInterceptor.invoke_aroundBody0(CoefficientInterceptor.java:90)
at
za.org.coefficient.core.CoefficientInterceptor$AjcClosure1.run(CoefficientInterceptor.java)
at
za.org.coefficient.aspects.logging.CoefficientLoggingAspect.ajc$around$za_org_coefficient_aspects_logging_CoefficientLoggingAspect$ecbproceed(CoefficientLoggingAspect.java)
at
za.org.coefficient.aspects.logging.CoefficientLoggingAspect.ajc$around$za_org_coefficient_aspects_logging_CoefficientLoggingAspect$ecb(CoefficientLoggingAspect.java:111)
at
za.org.coefficient.core.CoefficientInterceptor.invoke(CoefficientInterceptor.java:90)
at
za.org.coefficient.core.CoefficientInterceptor.invoke_aroundBody0(CoefficientInterceptor.java:90)
at
za.org.coefficient.core.CoefficientInterceptor$AjcClosure1.run(CoefficientInterceptor.java)
at
za.org.coefficient.aspects.logging.CoefficientLoggingAspect.ajc$around$za_org_coefficient_aspects_logging_CoefficientLoggingAspect$ecbproceed(CoefficientLoggingAspect.java)
at
za.org.coefficient.aspects.logging.CoefficientLoggingAspect.ajc$around$za_org_coefficient_aspects_logging_CoefficientLoggingAspect$ecb(CoefficientLoggingAspect.java:111)
at
za.org.coefficient.core.CoefficientInterceptor.invoke(CoefficientInterceptor.java:90)
at
za.org.coefficient.core.CoefficientInterceptor.invoke_aroundBody0(CoefficientInterceptor.java:90)
at
za.org.coefficient.core.CoefficientInterceptor$AjcClosure1.run(CoefficientInterceptor.java)
at
za.org.coefficient.aspects.logging.CoefficientLoggingAspect.ajc$around$za_org_coefficient_aspects_logging_CoefficientLoggingAspect$ecbproceed(CoefficientLoggingAspect.java)
at
za.org.coefficient.aspects.logging.CoefficientLoggingAspect.ajc$around$za_org_coefficient_aspects_logging_CoefficientLoggingAspect$ecb(CoefficientLoggingAspect.java:111)
at
za.org.coefficient.core.CoefficientInterceptor.invoke(CoefficientInterceptor.java:90)
at
za.org.coefficient.core.CoefficientInterceptor.invoke_aroundBody0(CoefficientInterceptor.java:90)
at
za.org.coefficient.core.CoefficientInterceptor$AjcClosure1.run(CoefficientInterceptor.java)
at
za.org.coefficient.aspects.logging.CoefficientLoggingAspect.ajc$around$za_org_coefficient_aspects_logging_CoefficientLoggingAspect$ecbproceed(CoefficientLoggingAspect.java)
at
za.org.coefficient.aspects.logging.CoefficientLoggingAspect.ajc$around$za_org_coefficient_aspects_logging_CoefficientLoggingAspect$ecb(CoefficientLoggingAspect.java:111)
at
za.org.coefficient.core.CoefficientInterceptor.invoke(CoefficientInterceptor.java:90)
at
za.org.coefficient.core.CoefficientInterceptor.invoke_aroundBody0(CoefficientInterceptor.java:90)
at
za.org.coefficient.core.CoefficientInterceptor$AjcClosure1.run(CoefficientInterceptor.java)
at
za.org.coefficient.aspects.logging.CoefficientLoggingAspect.ajc$around$za_org_coefficient_aspects_logging_CoefficientLoggingAspect$ecbproceed(CoefficientLoggingAspect.java)
at
za.org.coefficient.aspects.logging.CoefficientLoggingAspect.ajc$around$za_org_coefficient_aspects_logging_CoefficientLoggingAspect$ecb(CoefficientLoggingAspect.java:111)
at
za.org.coefficient.core.CoefficientInterceptor.invoke(CoefficientInterceptor.java:90)
at
za.org.coefficient.interceptors.ExceptionInterceptor.invoke(ExceptionInterceptor.java:54)
at
za.org.coefficient.servlet.CoefficientServlet.invoke_aroundBody0(CoefficientServlet.java:152)
at
za.org.coefficient.servlet.CoefficientServlet$AjcClosure1.run(CoefficientServlet.java)
at
za.org.coefficient.aspects.logging.CoefficientLoggingAspect.ajc$around$za_org_coefficient_aspects_logging_CoefficientLoggingAspect$ecbproceed(CoefficientLoggingAspect.java)
at
za.org.coefficient.aspects.logging.CoefficientLoggingAspect.ajc$around$za_org_coefficient_aspects_logging_CoefficientLoggingAspect$ecb(CoefficientLoggingAspect.java:111)
at
za.org.coefficient.servlet.CoefficientServlet.execute(CoefficientServlet.java:152)
at
za.org.coefficient.servlet.CoefficientServlet.doGet(CoefficientServlet.java:118)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:743)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:284)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:204)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:257)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
at
org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:245)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:199)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:184)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:164)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:149)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:156)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:972)
at
org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:206)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:833)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:732)
at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:619)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:688)
at java.lang.Thread.run(Thread.java:534)
Caused by: java.lang.NoClassDefFoundError
at
za.org.coefficient.modules.statistics.StatisticsDisplay.generateAndSaveProjectTotalsXYLineChart(StatisticsDisplay.java:222)
at
za.org.coefficient.modules.statistics.StatisticsDisplay.showStatistics(StatisticsDisplay.java:114)
... 69 more |
|
From: <seb...@ph...> - 2005-01-28 08:41:10
|
The patch you sent me allow the loading to continue. I now only have one
exception left and I get the first
configuration page in my browser.
Windows is not the problem because I installed a version on Solaris which
had exactly the same issue.
Thanks.
ps : I will be on holiday next week but I will be happy to help you
correcting this issue when I am back.
3455 [Thread-5] INFO hbm2ddl.DatabaseMetadata - table not found:
COEFFICIENT_PROJECT
11817 [Thread-5] WARN util.JDBCExceptionReporter - SQL Error: 0,
SQLState: 08003
11817 [Thread-5] ERROR util.JDBCExceptionReporter - No operations allowed
after connection closed.
11827 [Thread-5] WARN util.JDBCExceptionReporter - SQL Error: 0,
SQLState: 08003
11827 [Thread-5] ERROR util.JDBCExceptionReporter - No operations allowed
after connection closed.
net.sf.hibernate.exception.GenericJDBCException: Could not execute query
at
net.sf.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(ErrorCodeConverter.java:90)
at
net.sf.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:79)
at
net.sf.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:30)
at
net.sf.hibernate.impl.SessionImpl.convert(SessionImpl.java:4110)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1556)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1530)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1522)
at
net.sf.hibernate.util.HibernateUtil.find(HibernateUtil.java:354)
at za.org.coefficient.util.common.Roles.getAllRoles(Roles.java:49)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
org.apache.commons.beanutils.MethodUtils.invokeMethod(MethodUtils.java:252)
at
org.apache.commons.beanutils.MethodUtils.invokeMethod(MethodUtils.java:198)
at
za.org.coefficient.invokers.base.BaseInvoker.invokeMethodOnService(BaseInvoker.java:138)
at
za.org.coefficient.util.ejb.DataLoaderUtil.createDefaultRolesIfNeeded(DataLoaderUtil.java:162)
at
za.org.coefficient.util.ejb.DataLoaderUtil.initializeDataIfNeeded(DataLoaderUtil.java:140)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
net.sf.hibernate.util.HibernateUtil.invokeDataLoader(HibernateUtil.java:908)
at
net.sf.hibernate.util.HibernateUtil.<clinit>(HibernateUtil.java:103)
at
za.org.coefficient.modules.configuration.Configuration.getConfiguration(Configuration.java:138)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
org.apache.commons.beanutils.MethodUtils.invokeMethod(MethodUtils.java:252)
at
org.apache.commons.beanutils.MethodUtils.invokeMethod(MethodUtils.java:198)
at
za.org.coefficient.invokers.base.BaseInvoker.invokeMethodOnModule(BaseInvoker.java:114)
at
za.org.coefficient.core.BaseConfigurationBackedConstants.init(BaseConfigurationBackedConstants.java:45)
at za.org.coefficient.core.Constants.init(Constants.java:59)
at za.org.coefficient.core.Constants.<clinit>(Constants.java:55)
at
za.org.coefficient.core.CoefficientWebContext.<init>(CoefficientWebContext.java:110)
at
za.org.coefficient.servlet.CoefficientServlet.execute(CoefficientServlet.java:151)
at
za.org.coefficient.servlet.CoefficientServlet.doGet(CoefficientServlet.java:118)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at
org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:594)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:392)
at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619)
at java.lang.Thread.run(Thread.java:536)
Caused by: java.sql.SQLException: No operations allowed after connection
closed.
at com.mysql.jdbc.Connection.checkClosed(Connection.java:2647)
at
com.mysql.jdbc.Connection.prepareStatement(Connection.java:1300)
at
com.mysql.jdbc.Connection.prepareStatement(Connection.java:1281)
at
net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java:260)
at
net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java:235)
at
net.sf.hibernate.impl.BatcherImpl.prepareQueryStatement(BatcherImpl.java:66)
at
net.sf.hibernate.loader.Loader.prepareQueryStatement(Loader.java:783)
at net.sf.hibernate.loader.Loader.doQuery(Loader.java:269)
at
net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:137)
at net.sf.hibernate.loader.Loader.doList(Loader.java:1062)
at net.sf.hibernate.loader.Loader.list(Loader.java:1053)
at
net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:854)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1553)
... 64 more
12328 [Thread-5] INFO configuration.Configuration - at:
Configuration.java:147 | operation: save | on:
za.org.coefficient.core.CoefficientConfigurati
on | toString: za.org.coefficient.core.CoefficientConfiguration@167acf2
12348 [Thread-5] INFO configuration.Configuration - at:
Configuration.java:154 | operation: update | on:
za.org.coefficient.core.CoefficientConfigura
tion | object id: 1 | toString:
za.org.coefficient.core.CoefficientConfiguration@167acf2
12909 [Finalizer] WARN impl.SessionImpl - finalizing unclosed session
with closed connection
Thomas Fogwill <tfo...@us...>
27/01/2005 23:27
Please respond to tfogwill
To: Sebastien Lemeunier/PH/Novartis@PH
cc: coefficient-users <coe...@li...>
Subject: Re: Coefficient
Category:
On Thu, 2005-01-27 at 16:51 +0100, sebastien wrote:
> It makes no difference. I still get the problem.
> I also tried to upgrade the mysql-lib to same version than you without
> success.
I'll be honest, I'm baffled! What's probably happening is that the
connection is still being closed when the hibernate session gets closed,
and that this is freaking out the dataloader.
I'd like to try something else: attached is a patched DataLoader class
file. This one checks whether the roles list is null before trying to
load the data. This prevents the NullPointerException, and hopefully
will allow the data loading process to continue. Please test it by
replacing the class file you currently have (i.e.
za.org.coefficient.util.ejb.DataLoader).
Although I'd still like to get to the bottom of the problem and find a
solution, I (for the meanwhile) attach a dump of my database (newly
created by coefficient). If the abovementioned patch still doesn't work,
the dump should allow you to get the system running, so that you can at
least look at it (while we try to figure out how to fix your problem).
> INFO: Jk running ID=0 time=0/30 config=C:\Program Files\Apache Group
> \Tomcat 4.1\bin\..\conf\jk2.properties
I guess this means you're running Windows. Wonder whether there is
anything MySQL does differently on Windows, that could be causing the
problem?
I'm currently on study leave, but once I'm back at the office, I'll give
it a shot on Windows box, to see whether it also happens there.
Let me know how this goes.
Cheers
T
--
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.
|
|
From: Thomas F. <tfo...@us...> - 2005-01-27 22:29:14
|
On Thu, 2005-01-27 at 16:51 +0100, sebastien wrote: > It makes no difference. I still get the problem. > I also tried to upgrade the mysql-lib to same version than you without > success. I'll be honest, I'm baffled! What's probably happening is that the connection is still being closed when the hibernate session gets closed, and that this is freaking out the dataloader. I'd like to try something else: attached is a patched DataLoader class file. This one checks whether the roles list is null before trying to load the data. This prevents the NullPointerException, and hopefully will allow the data loading process to continue. Please test it by replacing the class file you currently have (i.e. za.org.coefficient.util.ejb.DataLoader). Although I'd still like to get to the bottom of the problem and find a solution, I (for the meanwhile) attach a dump of my database (newly created by coefficient). If the abovementioned patch still doesn't work, the dump should allow you to get the system running, so that you can at least look at it (while we try to figure out how to fix your problem). > INFO: Jk running ID=0 time=0/30 config=C:\Program Files\Apache Group > \Tomcat 4.1\bin\..\conf\jk2.properties I guess this means you're running Windows. Wonder whether there is anything MySQL does differently on Windows, that could be causing the problem? I'm currently on study leave, but once I'm back at the office, I'll give it a shot on Windows box, to see whether it also happens there. Let me know how this goes. Cheers T -- 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. |
|
From: Thomas F. <tfo...@us...> - 2005-01-27 15:35:56
|
On Thu, 2005-01-27 at 16:21 +0100, sebastien wrote: > Which driver are you using ? > I don't think it is related to the version itself but more to the > driver. > > I use the org.gjt.mm.mysql.Driver I have tried with both org.gjt.mm.mysql.Driver and com.mysql.jdbc.Driver Both work for me. -- 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. |
|
From: Thomas F. <tfo...@us...> - 2005-01-27 15:26:42
|
On Thu, 2005-01-27 at 17:00 +0200, Thomas Fogwill wrote: > So, not exactly the same version as you, but close enough, I'd think. I > will, however, try with the mysql-connector-java-3.0.16-ga-bin.jar > driver. My guess is that this is where the problem lies. mmm... still couldn't replicate your problem (I tried with 3.0.16). Anyway, let's try something else. I've created a new hibernateUtil.jar here: http://icomdmz1.csir.co.za/~tfogwill/files/hibernateUtil.jar In this one, I commented out line 816; that's the line where the connection is explicitly closed. i.e. 815: if (conn != null) { 816: //conn.close(); 817: } This is not necessarily a good idea. I don't know why he did it, but I'm sure Dylan had a good reason for explicitly closing the connection here. Nonetheless, let's try it like this for now, to see if it solves the problem for you. Failing that, I could always give you a sql dump of my initialised database. That should get you up and running, as the whole db init process won't need to happen. I'd prefer actually solving the problem, though; and for that to happen, it's better to have it breaking on your system (as I can't replicate your problem on mine). > it seems that the mysql driver "remembers" that you closed the > connection, probably by creating a new Throwable() and holding a > reference to it internally). Indeed, it does exactly that. On line 1123 of Connection.java, in method close(), this is done to remember when and where the connection was explicitly closed: this.explicitCloseLocation = new Throwable(); this.explicitCloseLocation is then obviously thrown later. -- 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. |
|
From: <seb...@ph...> - 2005-01-27 15:21:51
|
Thomas,
Which driver are you using ?
I don't think it is related to the version itself but more to the driver.
I use the org.gjt.mm.mysql.Driver
thanks,
seb
Thomas Fogwill <tfo...@us...>
27/01/2005 16:00
Please respond to tfogwill
To: Sebastien Lemeunier/PH/Novartis@PH
cc: coefficient-users <coe...@li...>
Subject: Re: Coefficient
Category:
On Thu, 2005-01-27 at 12:23 +0100,
seb...@ph... wrote:
> Building the jar with JDK 1.4.2 has solved the version issue.
> However the original problem is not solved.
I tried with mysql on my machine, and it seems to work ok (well, mostly
ok, except that the workflow user isn't added, due to not-null
constraints; that's not critical, though).
On my box:
mysql-server --> version 4.1.9-1
libmysql-java (jdbc driver) --> version 3.0.9-1
tomcat4 --> version 4.1.31-2
So, not exactly the same version as you, but close enough, I'd think. I
will, however, try with the mysql-connector-java-3.0.16-ga-bin.jar
driver. My guess is that this is where the problem lies.
I've spent some time looking at what could have gone wrong. I think I
see what's happening, but I cannot figure out why it's happening.
Here's what seems to be going on...
this is where it starts to look interesting:
> ...
>
> net.sf.hibernate.exception.GenericJDBCException: Could not execute query
> at
net.sf.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(ErrorCodeConverter.java:90)
> at
net.sf.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:79)
> at
net.sf.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:30)
> at
net.sf.hibernate.impl.SessionImpl.convert(SessionImpl.java:4110)
> at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1556)
> at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1530)
> at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1522)
> at
net.sf.hibernate.util.HibernateUtil.find(HibernateUtil.java:354)
> at
za.org.coefficient.util.common.Roles.getAllRoles(Roles.java:49)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:324)
> at
org.apache.commons.beanutils.MethodUtils.invokeMethod(MethodUtils.java:252)
> at
org.apache.commons.beanutils.MethodUtils.invokeMethod(MethodUtils.java:198)
> at
za.org.coefficient.invokers.base.BaseInvoker.invokeMethodOnService(BaseInvoker.java:138)
> at
za.org.coefficient.util.ejb.DataLoaderUtil.createDefaultRolesIfNeeded(DataLoaderUtil.java:163)
> ...
> Caused by: java.sql.SQLException: No operations allowed after connection
closed.
This occurs when the dataloader tries to load the default roles. It
first does a a "find" on the existing roles (the call to
HibernateUtil.find above).
This call, however, fails (because the connection was previously closed;
it seems that the mysql driver "remembers" that you closed the
connection, probably by creating a new Throwable() and holding a
reference to it internally).
The "find" call failing results in the roles list being null, hence the
NPE here:
> java.lang.NullPointerException
> at
za.org.coefficient.util.ejb.DataLoaderUtil.createDefaultRolesIfNeeded(DataLoaderUtil.java:165)
> at
za.org.coefficient.util.ejb.DataLoaderUtil.initializeDataIfNeeded(DataLoaderUtil.java:140)
Then, because the roles don't exist, we cannot add the default users (due
to not-null constraints):
> 10616 [Thread-5] INFO ejb.DataLoaderUtil - at: DataLoaderUtil.java:266
| operation: user registration | username: admin | fullname: Site
Administrato
> r
> 10626 [Thread-5] INFO ejb.DataLoaderUtil - at: DataLoaderUtil.java:266
| operation: save | on: za.org.coefficient.authentication.CoefficientUser
| to
> String: Site Administrator
> 10636 [Thread-5] ERROR ejb.DataLoaderUtil - at: DataLoaderUtil.java:266
| operation: persistence exception on update | exception type:
net.sf.hiberna
> te.PropertyValueException | exception message: not-null property
references a null or transient value:
za.org.coefficient.authentication.CoefficientUs
> er.systemRole
> net.sf.hibernate.PropertyValueException: not-null property references a
null or transient value:
za.org.coefficient.authentication.CoefficientUser.sys
> temRole
> at
net.sf.hibernate.impl.SessionImpl.checkNullability(SessionImpl.java:1286)
> at
net.sf.hibernate.impl.SessionImpl.doSave(SessionImpl.java:937)
However, all the other data seems to load fine:
(this I find odd. why would the roles operations fail, but these work ok?)
> 10676 [Thread-5] INFO ejb.DataLoaderUtil - at: DataLoaderUtil.java:299
| operation: save | on: za.org.coefficient.core.ProjectAttribute |
toString: z
> a.org.coefficient.core.ProjectAttribute@118abfe
> 10756 [Thread-5] INFO ejb.DataLoaderUtil - at: DataLoaderUtil.java:308
| operation: save | on: za.org.coefficient.core.ProjectAttributeData |
toStrin
> g: za.org.coefficient.core.ProjectAttributeData@94b318
> 10756 [Thread-5] INFO ejb.DataLoaderUtil - at: DataLoaderUtil.java:308
| operation: save | on: za.org.coefficient.core.ProjectAttributeData |
toStrin
> g: za.org.coefficient.core.ProjectAttributeData@f84b0a
> 10756 [Thread-5] INFO ejb.DataLoaderUtil - at: DataLoaderUtil.java:308
| operation: save | on: za.org.coefficient.core.ProjectAttributeData |
toStrin
> g: za.org.coefficient.core.ProjectAttributeData@106b56a
> 10766 [Thread-5] INFO ejb.DataLoaderUtil - at: DataLoaderUtil.java:308
| operation: save | on: za.org.coefficient.core.ProjectAttributeData |
toStrin
> g: za.org.coefficient.core.ProjectAttributeData@1705316
> 10766 [Thread-5] INFO ejb.DataLoaderUtil - at: DataLoaderUtil.java:308
| operation: save | on: za.org.coefficient.core.ProjectAttributeData |
toStrin
> ...
And here, when the system tries to run the default configuration screen,
we fail because there are no users/roles:
> java.lang.NullPointerException
> at
za.org.coefficient.modules.configuration.Configuration.canExecuteForRole(Configuration.java:68)
> at
za.org.coefficient.invokers.base.BaseInvoker.invokeOpOnModule(BaseInvoker.java:177)
> at
za.org.coefficient.interceptors.ConfigurationInterceptor.handleInvoke(ConfigurationInterceptor.java:45)
> at
za.org.coefficient.core.CoefficientInterceptor.invoke(CoefficientInterceptor.java:79)
> at
za.org.coefficient.core.CoefficientInterceptor.invoke_aroundBody0(CoefficientInterceptor.java:90)
> ...
>
As I mentioned, I'll test with the 3.0.16 driver as well, and get back
to you.
--
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.
|
21 messages has been excluded from this view by a project administrator.
