[Coefficient-users] MySQL troubles ...

[Mike S. <mi...@sp...>]

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