RE: [Oreka-user] JDBCConnectionException

Hi Brian,
 
Most likely, Oreka did not have the appropriate codec for your traffic. Can
you find entries looking like the following in orkaudio.log ?
 
Could not find decoder for RTP payload type:xx
 
Henri

  _____  

From: Brian West [mailto:br...@gm...] 
Sent: 13 April 2006 12:40
To: Henri Herscher; ore...@li...
Subject: Re: [Oreka-user] JDBCConnectionException


Thank you Henri,
 
Everything looks good now, except playing of the audio files.
 
I have them outputting to \webapps\root but each call is producing a 1KB wav
file and a larger "mcf.orig" file.
 
I have looked in the documentation for this and did not find much.
 
My format is:  <StorageAudioFormat>pcmwav</StorageAudioFormat>
 
Thank you,
 
Brian

----- Original Message ----- 
From: Henri Herscher <mailto:he...@or...>  
To: 'Brian West' <mailto:br...@gm...>  ;
ore...@li... 
Sent: Thursday, April 13, 2006 11:16 AM
Subject: RE: [Oreka-user] JDBCConnectionException

Hi Brian,
 
Don't use the database called "mysql". This is the administrative database
that mysql is using for managing privileged access and such.
 
Just do:
 
mysql> create database oreka
 
and edit both mysql.hbm.xml to reflect this.
 
Cheers
Henri

  _____  

From: ore...@li...
[mailto:ore...@li...] On Behalf Of Brian West
Sent: 13 April 2006 10:26
To: ore...@li...
Subject: Re: [Oreka-user] JDBCConnectionException


I think the service was called "oreka", but the db name was "mysql". I
changed mysql.hbm.xml to reflect "mysql".
 
I turned on sql tracing in log4j.properties, restarted tomcat and received
this...
 
 
10:13:50,156 root  INFO - ========================================
10:13:50,156 root  INFO - orkweb starting ...
10:13:50,687 org.hibernate.SQL DEBUG - select user0_.id as id26_0_,
user0_.disabled as disabled26_0_, user0_.email as email26_0_,
user0_.firstname as firstname26_0_, user0_.lastname as lastname26_0_,
user0_.dateCreated as dateCrea6_26_0_, user0_.dateDeleted as
dateDele7_26_0_, user0_.dateDisabled as dateDisa8_26_0_, user0_.deleted as
deleted26_0_, user0_.password as password26_0_ from User user0_ where
user0_.id=?
10:13:50,703 org.hibernate.SQL DEBUG - insert into User (disabled, email,
firstname, lastname, dateCreated, dateDeleted, dateDisabled, deleted,
password) values (?, ?, ?, ?, ?, ?, ?, ?, ?)
10:13:50,703 net.sf.oreka.HibernateManager ERROR - Hibernate
error:org.hibernate.exception.ConstraintViolationException
10:13:54,875 org.apache.tapestry.ApplicationServlet  INFO - Initialized
application servlet 'orkweb': 1,797 millis to create HiveMind Registry,
4,141 millis overall.
 
 
----- Original Message ----- 

From: Henri Herscher <mailto:he...@or...>  
To: 'Brian West' <mailto:br...@gm...>  ;
ore...@li... 
Sent: Thursday, April 13, 2006 9:43 AM
Subject: RE: [Oreka-user] JDBCConnectionException

Hi Brian,
 
You need to create the oreka database manually if you haven't already done
so. Can you make sure that the db is accessible by doing the following
directly on the Tomcat+mySQL box:
 
# mysql -u root -pbwest
# use oreka
 
Henri

  _____  

From: ore...@li...
[mailto:ore...@li...] On Behalf Of Brian West
Sent: 13 April 2006 09:02
To: ore...@li...
Subject: [Oreka-user] JDBCConnectionException


Every time I start tomcat, I get a JDBCConnectionException.
 
- My db name is oreka.
- Db username password is as below.
- DB is set to port 3306. No software firewall on my server. Port 3306 is
opened up on the router.
- Tomcat and mysql reside on the same machine.
 
 
Is there something wrong with my ="hibernate.connection.url" ?
 
My connection settings:
 <property
name="hibernate.connection.url">jdbc:mysql://localhost/oreka</property>
 <property name="hibernate.connection.password">bwest</property>
 <property name="hibernate.connection.username">root</property>
 
 
Error Text:
 
 
08:54:57,015 root  INFO - ========================================
08:54:57,015 root  INFO - orkweb starting ...
08:54:57,687 net.sf.oreka.HibernateManager ERROR - Hibernate
error:org.hibernate.exception.JDBCConnectionException
 
Brian