cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Joe Baldwin <>
Subject Re: Odd error
Date Sun, 05 Feb 2012 23:48:14 GMT

Is there a webhost server setting that might account for this?  (I googled this problem and
the first results appears to point to webhost settings.   I, presumably, set account privileges
for the user, but this was through a 3rd party manager interface - which is always a bit unsettling
because you can't verify it.)

Here is the current error (which is really odd because it is working just fine on my dev server)

com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or
update a child row: a foreign key constraint fails (`eagle1_om28`.`product`, CONSTRAINT `product_ibfk_2`
FOREIGN KEY (`packageTypeOid`) REFERENCES `packagetype` (`oid`))


On Feb 5, 2012, at 2:29 AM, Andrus Adamchik wrote:

> While I don't know what the cause of the error is, my recommendation would be to put
all Cayenne files in CLASSPATH (e.g. WEB-INF/classes or in a jar under WEB-INF/lib). This
is much more portable across any Java environments.
> Andrus
> On Feb 4, 2012, at 7:40 PM, Joe Baldwin wrote:
>> Here is more research on my "odd error".  
>> Production Server Env
>> 	Tomcat, linux, MySQL 5.1, Java 1.6
>> 	I only have control of tomcat config files & start/stop operations
>> 	**** I am using a *temp* configuration for installation and only have an IP which
I aliased to "" in my hosts file (a standard trick)
>> Symptoms & Research:
>> It appears that tomcat has logged a Cayenne configuration exception
>> 	Caused by: org.apache.cayenne.ConfigurationException: [v.3.0.1 Aug 25 2010 19:42:04]
Can't open config file URL: jndi:/
>> Which seems to be accurate because that is not were I put the cayenne.xml file. 
Here is my web.xml entry for the app
>> 	<!-- Cayenne ORM -->
>> 	<context-param>
>> 		<param-name>cayenne.configuration.path</param-name>
>> 		<param-value>/WEB-INF/config/cayenne-files</param-value>
>> 	</context-param>
>> 	<filter>
>> 		<filter-name>CayenneFilter</filter-name>
>> 		<filter-class>org.apache.cayenne.conf.WebApplicationContextFilter</filter-class>
>> 	</filter>
>> 	<filter-mapping>
>> 		<filter-name>CayenneFilter</filter-name>
>> 		<url-pattern>/*</url-pattern>
>> 	</filter-mapping>
>> Questions:
>> 1. I have no understanding of why Cayenne would be looking for the xml file in a
path that included "store". Could this be a result of it getting confused by the alias ""?
>> 2. I have a demo working on the same webhost, but as a subdomain. It is using, I
believe, the identical web.xml excerpt.  This same web.xml file is working on my development
server.  Is there a way to configure cayenne or the temp installation to make this work correctly
>> 3. Or, am I completely on the wrong track? :)
>> On Feb 3, 2012, at 2:35 PM, Joe Baldwin wrote:
>>> I am manually mirroring a test app (successfully tested on my dev tomcat), onto
a remote server.  I am getting an odd error and am having trouble tracking it down. (an excerpt
is listed below)
>>> While it is possible that I have made a mistake in my coding, it is not likely
since the associated code has been working for a while.  I have also been fighting some tomcat
caching problems, which I have resolved by deleting the tomcat cache for this app each time
I reload it.
>>> I have tried standard debugging on my dev server, but the error is not showing
up.  Also, it this error shows up mostly when I am adding the parent to which it is referring,
however, it also has just shown up at random when I make a simple query via cayenne.
>>> Is it possible that I have missed some configuration parameter in loading my
cayenne map? It is acting so odd that I am fairly convinced that this error message may not
be pointing to the actual error.  
>>> Totally confused. :)
>>> Thanks,
>>> Joe
>>> com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot
add or update a child row: a foreign key constraint fails 

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message