Is this error still an issue: >>> Caused by: org.apache.cayenne.ConfigurationException: [v.3.0.1 Aug 25 2010 >>> 19:42:04] Can't open config file URL: >>> jndi:/om28.com/store/WEB-INF/config/cayenne-files/cayenne.xml
? If so, please follow my advise about the location of Cayenne files and then your Tomcat settings should not matter anymore. Andrus On Feb 6, 2012, at 2:48 AM, Joe Baldwin wrote: > Andrus, > > 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`)) > > Thanks > Joe > > > > 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 "om28.com" 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:/om28.com/store/WEB-INF/config/cayenne-files/cayenne.xml >>> >>> 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 "om28.com"? >>> 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 >>>> >>>> >>> >> >
