Wow, I'm pretty confused here. Chris, did you subclass j.u.HashSet in an attempt to get around the "Attempt to cast instance xxxx[j.u.HashSet] message? If so, don't do that! Lets start off by getting rid of that subclassing, and rid of the following properties from your persistence.xml. Also, to remove a couple more variables, change the generation type for the IDs to AUTO[2]. Once things are working, we can work on resolving the generator issues.
Thanks, Rick [1]<mapping-file>META-INF/orm.xml</mapping-file> <property name="openjpa.RuntimeUnenhancedClasses" value="supported"/> <property name="openjpa.MetaDataFactory" value="jpa(Types=java.util. ArrayList)"/> [2] @Id @GeneratedValue(strategy=GenerationType.AUTO) On Mon, Nov 19, 2012 at 12:27 PM, Chris Wolf <cwolf.a...@gmail.com> wrote: > Rick, > > I know this is sick and wrong - but I sub-classed java.util.HashSet > such that I was able to enhance that subclass > and used it for my concrete collection field instances. > > Basically, I just did this: > > @Entity > public class ORMHashSet<E> extends HashSet<E> {/* constructors */} > > I finally got rid of that annoying "Attempt to cast instance xxx > [java.util.HashSet]" to PersistenceCapable failed." error, > but now - a new problem (at least it's getting as far as calling > comit() on the EntityManager) > > Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: > ORA-00942: table or view does not exist > {prepstmnt 617013740 SELECT SEQUENCE_VALUE FROM > OPENJPA_SEQUENCE_TABLE WHERE ID = ? FOR UPDATE [params=?]} [code=942, > state=42000] > > > Note that my two entities have specifically named @SequenceGenerator, > so this error should not be related to those. > > I guess my hack of annotating ORMHashSet as an Entity provoked > generation of some default sequence generator? > > I just thought I'd try a few last desperate things before resorting to > going back to using Hibernate... ;) > > On Mon, Nov 19, 2012 at 10:34 AM, Rick Curtis <curti...@gmail.com> wrote: > > Chris - > > > > Please post your persistence.xml file also. > > > > Thanks, > > Rick > > > > > > On Mon, Nov 19, 2012 at 9:28 AM, Chris Wolf <cwolf.a...@gmail.com> > wrote: > > > >> José, > >> > >> The plugin doc says you can have a comma-delimited list of classes, > >> however, since > >> enhancement on collection classes doesn't seem to work anyway - per > >> your suggestion, > >> I removed "java.util.ArrayList" and re-ran the "mvn openjpa:enhance" > >> command. > >> > >> The result, as ever, is still: > >> > >> 771 openjpa INFO [main] openjpa.Enhance - Creating subclass and > >> redefining methods for > >> "[class java.util.ArrayList]". This means that your application will > >> be less efficient than it would > >> if you ran the OpenJPA enhancer. > >> Exception in thread "main" <openjpa-2.2.0-r422266:1244990 fatal user > error> > >> org.apache.openjpa.persistence.ArgumentException: No registered > >> metadata for type > >> "class java.util.ArrayList". This can happen if this class has not > >> been annotated as a > >> persistent entity or specified in the persistence unit (ex: in the > >> orm.xml). > >> > >> I wonder if anyone knows of a working example of many-to-many ORM using > >> OpenJPA? > >> > >> Thanks, > >> > >> -Chris > >> > >> > >> On Mon, Nov 19, 2012 at 10:19 AM, José Luis Cetina < > maxtorz...@gmail.com> > >> wrote: > >> > And I think you don't have to set arraylist class or any java "native" > >> > class as enhance class. Only your entities have to be enhancement. > >> > El 19/11/2012 09:12, "José Luis Cetina" <maxtorz...@gmail.com> > escribió: > >> > > >> >> I'm not sure if the include tag accept more than 1 class. > >> >> > >> >> You have: > >> >> <includes>**/entities/*.class,java.util.ArrayList.class</includes> > >> >> > >> >> Try to remove java.util.ArrayList. > >> >> El 19/11/2012 09:05, "Chris Wolf" <cwolf.a...@gmail.com> escribió: > >> >> > >> >>> José, > >> >>> > >> >>> Thanks - I sent the two entities to John (this list). The pom.xml > is > >> >>> attached... > >> >>> > >> >>> -Chris > >> >>> > >> >>> > >> >>> > >> >>> On Mon, Nov 19, 2012 at 9:54 AM, José Luis Cetina < > >> maxtorz...@gmail.com> > >> >>> wrote: > >> >>> > Please send your 2 entities and your pom configuration whit the > >> enhance > >> >>> > plugin. > >> >>> > El 19/11/2012 08:46, "Chris Wolf" <cwolf.a...@gmail.com> > escribió: > >> >>> > > >> >>> >> José, > >> >>> >> > >> >>> >> I tried List/ArrayList - same error. Thanks.... > >> >>> >> > >> >>> >> -Chris > >> >>> >> > >> >>> >> On Sun, Nov 18, 2012 at 9:47 PM, José Luis Cetina < > >> >>> maxtorz...@gmail.com> > >> >>> >> wrote: > >> >>> >> > Of course I'm using 1-M relationships but I use them with List > not > >> >>> >> hashset, > >> >>> >> > why you dont give a try to list only for look if the problem is > >> with > >> >>> >> > hashset. > >> >>> >> > El 18/11/2012 19:59, "Chris Wolf" <cwolf.a...@gmail.com> > >> escribió: > >> >>> >> > > >> >>> >> >> José, > >> >>> >> >> > >> >>> >> >> Thanks for your reply. My pom.xml setup is very similar to > yours > >> >>> and > >> >>> >> >> the "enhance" goal runs without error, but, as I mentioned, > >> >>> >> >> I still get the error on "casting java.util.HashSet". Are > you > >> able > >> >>> >> >> to persist entities with 1-M or M-M relationships? > >> >>> >> >> > >> >>> >> >> BTW, I changed my code to temporarily change JPA provider from > >> >>> OpenJPA > >> >>> >> >> to the Hibernate JPA provider > >> >>> >> >> and, once again, Hibernate's JPA reports: > >> >>> >> >> > >> >>> >> >> Exception in thread "main" java.lang.IllegalArgumentException: > >> >>> Unknown > >> >>> >> >> entity: java.util.HashSet > >> >>> >> >> at > >> >>> >> >> > >> >>> >> > >> >>> > >> > org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:671) > >> >>> >> >> > >> >>> >> >> Well, at least both JPA implementations are complaining about > the > >> >>> same > >> >>> >> >> issue - I just wish I knew > >> >>> >> >> what I was doing! I know I can get this to work in an > instant > >> by > >> >>> >> >> reverting to Hibernate-only > >> >>> >> >> solution, but I was hoping the byte-code weaving of JPA would > be > >> a > >> >>> >> >> performance advantage over > >> >>> >> >> Hibernate's reflection/proxy pattern. > >> >>> >> >> > >> >>> >> >> Thanks again, > >> >>> >> >> > >> >>> >> >> -Chris > >> >>> >> >> > >> >>> >> >> On Sun, Nov 18, 2012 at 1:26 PM, José Luis Cetina < > >> >>> maxtorz...@gmail.com > >> >>> >> > > >> >>> >> >> wrote: > >> >>> >> >> > I have this in my pom.xml for ENHANCMENT and works: > >> >>> >> >> > > >> >>> >> >> > <!--OPENJPA ENHANCMENT--> > >> >>> >> >> > <plugin> > >> >>> >> >> > <groupId>org.apache.openjpa</groupId> > >> >>> >> >> > > <artifactId>openjpa-maven-plugin</artifactId> > >> >>> >> >> > <version>2.2.0</version> > >> >>> >> >> > <configuration> > >> >>> >> >> > > >> <includes>mypackage/model/*.class</includes> > >> >>> >> >> > > >> >>> >> <addDefaultConstructor>true</addDefaultConstructor> > >> >>> >> >> > > >> >>> >> >> > > <enforcePropertyRestrictions>true</enforcePropertyRestrictions> > >> >>> >> >> > > >> >>> >> >> > > >> <connectionDriverName>com.mysql.jdbc.Driver</connectionDriverName> > >> >>> >> >> > <connectionProperties> > >> >>> >> >> > driverClass=${database.driver.name > }, > >> >>> >> >> > jdbcUrl=${database.connection.url}, > >> >>> >> >> > user=${database.user}, > >> >>> >> >> > password=${database.password}, > >> >>> >> >> > minPoolSize=5, > >> >>> >> >> > acquireRetryAttempts=3, > >> >>> >> >> > maxPoolSize=20 > >> >>> >> >> > </connectionProperties> > >> >>> >> >> > </configuration> > >> >>> >> >> > <executions> > >> >>> >> >> > <execution> > >> >>> >> >> > <id>enhancer</id> > >> >>> >> >> > <phase>process-classes</phase> > >> >>> >> >> > <goals> > >> >>> >> >> > <goal>enhance</goal> > >> >>> >> >> > </goals> > >> >>> >> >> > </execution> > >> >>> >> >> > </executions> > >> >>> >> >> > <dependencies> > >> >>> >> >> > <dependency> > >> >>> >> >> > > <groupId>org.apache.openjpa</groupId> > >> >>> >> >> > <artifactId>openjpa</artifactId> > >> >>> >> >> > <version>2.2.0</version> > >> >>> >> >> > </dependency> > >> >>> >> >> > </dependencies> > >> >>> >> >> > </plugin> > >> >>> >> >> > > >> >>> >> >> > In my persistence.xml i have: > >> >>> >> >> > > >> >>> >> >> > <property name="openjpa.ConnectionUserName" > >> >>> >> value="${db.username}"/> > >> >>> >> >> > <property name="openjpa.ConnectionPassword" > >> >>> >> >> value="${db.password}"/> > >> >>> >> >> > <property name="openjpa.ConnectionURL" > >> value="${db.url}"/> > >> >>> >> >> > <property name="openjpa.ConnectionDriverName" > >> >>> >> >> > value="${db.driver.class}"/> > >> >>> >> >> > > >> >>> >> >> > You can replace the database properties in persistence.xml > with > >> >>> your > >> >>> >> own > >> >>> >> >> > values > >> >>> (${db.username},${db.password},${db.url},${db.driver.class}). > >> >>> >> >> > > >> >>> >> >> > > >> >>> >> >> > I use this configuration for my JEE Projects. > >> >>> >> >> > > >> >>> >> >> > Maybe this can help you. > >> >>> >> >> > > >> >>> >> >> > Regards. > >> >>> >> >> > > >> >>> >> >> > SCJA. JL Cetina > >> >>> >> >> > > >> >>> >> >> > > >> >>> >> >> > 2012/11/18 Chris Wolf <cwolf.a...@gmail.com> > >> >>> >> >> > > >> >>> >> >> >> I wrote a shell script to directly invoke PCEnhancer on > class > >> >>> >> >> >> java.util.HashSet, > >> >>> >> >> >> and even that didn't work: > >> >>> >> >> >> > >> >>> >> >> >> $ ./enhance.sh > >> >>> >> >> >> 52 openjpa INFO [main] openjpa.Tool - Enhancer running > on > >> >>> type > >> >>> >> >> >> "java.util.HashSet". > >> >>> >> >> >> Exception in thread "main" java.lang.RuntimeException: > >> >>> >> >> >> java.io.FileNotFoundExcep > >> >>> >> >> >> tion: > file:\C:\opt\jdk\jre\lib\rt.jar!\java\util\HashSet.class > >> >>> (The > >> >>> >> >> >> filename, directory name, or volume label syntax is > incorrect) > >> >>> >> >> >> at > >> >>> >> >> >> > >> >>> >> >> > >> >>> >> > >> >>> > >> > org.apache.openjpa.lib.conf.Configurations.launchRunnable(Configurations.java:744) > >> >>> >> >> >> > >> >>> >> >> >> On Sun, Nov 18, 2012 at 10:37 AM, Chris Wolf < > >> >>> cwolf.a...@gmail.com> > >> >>> >> >> wrote: > >> >>> >> >> >> > Hello, > >> >>> >> >> >> > > >> >>> >> >> >> > This is my first posting and first attempt to use > OpenJPA. > >> I > >> >>> put > >> >>> >> >> >> > together a quick demo and can persist > >> >>> >> >> >> > individual, unrelated entities. However, when I try to > >> persist > >> >>> >> >> >> > related entities to two tables via a link table, i.e. > >> >>> many-2-many, > >> >>> >> >> >> > it keeps complaining about "casting to > PersistenceCapable", > >> in > >> >>> >> >> >> > particular the class "java.util.HashSet". > >> >>> >> >> >> > > >> >>> >> >> >> > First, I am using the Eclipse JPA plugin (called "Dali" > or > >> >>> >> >> >> > "EclipseLink"). Of course, I have OpenJPA configured > >> >>> >> >> >> > as my JPA provider, I am in a plain Java SE environment > with > >> >>> >> >> >> > LOCAL_RESOURCE via JDBC connection > >> >>> >> >> >> > properties in the persistence.xml. I am using Sun/Oracle > >> 64bit > >> >>> >> >> >> > JDK-1.6 and OpenJPA-2.2.0. > >> >>> >> >> >> > > >> >>> >> >> >> > I am using the Eclipse JPA plugin to generate the entity > >> >>> classes > >> >>> >> from > >> >>> >> >> >> > already-exiting database schema objects, > >> >>> >> >> >> > and that code looks like (just pasting the relationship > >> code), > >> >>> this > >> >>> >> >> >> > action also adds these classes to persistence.xml > >> >>> >> >> >> > via persistence-unit/class elements. > >> >>> >> >> >> > > >> >>> >> >> >> > First M2M entity, "MarketData": > >> >>> >> >> >> > > >> >>> >> >> >> > //bi-directional many-to-many association to > >> RiskFactor > >> >>> >> >> >> > @ManyToMany(mappedBy="marketData") > >> >>> >> >> >> > public Set<RiskFactor> getRiskFactors() { > >> >>> >> >> >> > return this.riskFactors; > >> >>> >> >> >> > } > >> >>> >> >> >> > > >> >>> >> >> >> > Second M2M entity "RiskFactor": > >> >>> >> >> >> > > >> >>> >> >> >> > //bi-directional many-to-many association to > >> MarketData > >> >>> >> >> >> > @ManyToMany > >> >>> >> >> >> > @JoinTable( > >> >>> >> >> >> > name="MARKET_DATA__RISK_FACTOR" > >> >>> >> >> >> > , joinColumns={ > >> >>> >> >> >> > > @JoinColumn(name="RISK_FACTOR_ID", > >> >>> >> >> >> nullable=false) > >> >>> >> >> >> > } > >> >>> >> >> >> > , inverseJoinColumns={ > >> >>> >> >> >> > > @JoinColumn(name="MARKET_DATA_ID", > >> >>> >> >> >> nullable=false) > >> >>> >> >> >> > } > >> >>> >> >> >> > ) > >> >>> >> >> >> > public Set<MarketData> getMarketData() { > >> >>> >> >> >> > return this.marketData; > >> >>> >> >> >> > } > >> >>> >> >> >> > > >> >>> >> >> >> > When I run the code, the log indicates implicit runtime > >> >>> enhacement, > >> >>> >> >> >> > yet it is complaining: > >> >>> >> >> >> > > >> >>> >> >> >> > "[persistdemo.ojpa.entities.RiskFactor@61578aab] > >> >>> >> [java.util.HashSet]" > >> >>> >> >> >> > to PersistenceCapable failed. Ensure that it has been > >> >>> enhanced." > >> >>> >> >> >> > > >> >>> >> >> >> > ...when it says, "Ensure that it has been enhanced." - > >> which is > >> >>> >> "it" > >> >>> >> >> >> > referring to? The entity "RiskFactor" or the field > >> >>> relationship > >> >>> >> >> >> > field's class, "java.util.HashSet"? > >> >>> >> >> >> > > >> >>> >> >> >> > > >> >>> >> >> >> > 186 openjpa INFO [main] openjpa.Runtime - OpenJPA > >> >>> dynamically > >> >>> >> >> >> > loaded the class enhancer. Any classes that were not > >> enhanced > >> >>> at > >> >>> >> build > >> >>> >> >> >> > time will be enhanced when they are loaded by the JVM. > >> >>> >> >> >> > SLF4J: Failed to load class > >> >>> "org.slf4j.impl.StaticLoggerBinder". > >> >>> >> >> >> > SLF4J: Defaulting to no-operation (NOP) logger > >> implementation > >> >>> >> >> >> > SLF4J: See > >> http://www.slf4j.org/codes.html#StaticLoggerBinderfor > >> >>> >> >> >> > further details. > >> >>> >> >> >> > 243 openjpa INFO [main] openjpa.Runtime - OpenJPA > >> >>> dynamically > >> >>> >> >> >> > loaded a validation provider. > >> >>> >> >> >> > 596 openjpa INFO [main] openjpa.Runtime - Starting > >> OpenJPA > >> >>> >> 2.2.0 > >> >>> >> >> >> > 630 openjpa INFO [main] openjpa.jdbc.JDBC - Using > >> >>> dictionary > >> >>> >> class > >> >>> >> >> >> > "org.apache.openjpa.jdbc.sql.OracleDictionary". > >> >>> >> >> >> > Exception in thread "main" <openjpa-2.2.0-r422266:1244990 > >> >>> nonfatal > >> >>> >> >> >> > user error> > >> org.apache.openjpa.persistence.ArgumentException: > >> >>> >> Attempt > >> >>> >> >> >> > to cast instance > >> >>> "[persistdemo.ojpa.entities.RiskFactor@61578aab] > >> >>> >> >> >> > [java.util.HashSet]" to PersistenceCapable failed. > Ensure > >> >>> that it > >> >>> >> has > >> >>> >> >> >> > been enhanced. > >> >>> >> >> >> > > >> >>> >> >> >> > Maybe because "java.util.HashSet" was loaded before the > >> dynamic > >> >>> >> >> >> > enhancer could get to it? > >> >>> >> >> >> > > >> >>> >> >> >> > Next, I tried performing build-time enhancement via > Maven, > >> per > >> >>> this > >> >>> >> >> doc: > >> >>> >> >> >> > http://openjpa.apache.org/enhancement-with-maven.html > >> >>> >> >> >> > > >> >>> >> >> >> > When I ran "mvn openjpa:enhance", it finished with > success, > >> but > >> >>> >> none > >> >>> >> >> >> > of the classes in target/classes seemed to have be > changed > >> >>> >> >> >> > (last-modified date same as compile-time). and > re-running > >> >>> results > >> >>> >> in > >> >>> >> >> >> > the same error and stack-trace. > >> >>> >> >> >> > > >> >>> >> >> >> > My openjpa:enhance configuration was: > >> >>> >> >> >> > <configuration> > >> >>> >> >> >> > > >> <includes>**/entities/*.class,java.util.HashSet</includes> > >> >>> >> >> >> > <addDefaultConstructor>true</addDefaultConstructor> > >> >>> >> >> >> > > >> >>> >> <enforcePropertyRestrictions>true</enforcePropertyRestrictions> > >> >>> >> >> >> > </configuration> > >> >>> >> >> >> > > >> >>> >> >> >> > > >> >>> >> >> >> > Next, I tried invoking with: > >> >>> >> >> >> > > >> >>> >> >> >> > > -javaagent:/opt/apache-openjpa-2.2.0/openjpa-all-2.2.0.jar > >> >>> >> >> >> > > >> >>> >> >> >> > Same error - same stack trace. > >> >>> >> >> >> > > >> >>> >> >> >> > Then, I tried setting this property: > >> >>> >> >> >> > openjpa.RuntimeUnenhancedClasses=supported > >> >>> >> >> >> > > >> >>> >> >> >> > Same error - same stack trace. > >> >>> >> >> >> > > >> >>> >> >> >> > > >> >>> >> >> >> > Then, following a suggestion I found here: > >> >>> >> >> >> > > >> >>> >> >> >> > >> >>> >> >> > >> >>> >> > >> >>> > >> > http://openjpa.208410.n2.nabble.com/JPA-adding-entities-to-EntityManagerFactory-programmatically-td210697.html > >> >>> >> >> >> > > >> >>> >> >> >> > I tried setting both: > >> >>> >> >> >> > openjpa.RuntimeUnenhancedClasses=supported > >> >>> >> >> >> > openjpa.MetaDataFactory=jpa(Types=java.util.HashSet) > >> >>> >> >> >> > > >> >>> >> >> >> > BTW, this is a dead link > >> >>> >> >> >> > "User's Guide on Enhancement" / > >> >>> >> >> >> > > >> >>> >> >> >> > >> >>> >> >> > >> >>> >> > >> >>> > >> > http://openjpa.apache.org/builds/latest/docs/manual/manual.html#ref_guide_pc_enhance > >> >>> >> >> >> > (from page: > >> http://openjpa.apache.org/entity-enhancement.html) > >> >>> >> >> >> > > >> >>> >> >> >> > So is there any way to use OpenJPA to persist objects > >> related > >> >>> via a > >> >>> >> >> >> > link table? (there obviously must be, > >> >>> >> >> >> > but it's a total mystery to me) I can't believe it's > this > >> >>> >> difficult, > >> >>> >> >> >> > I must be doing something really dumb. > >> >>> >> >> >> > > >> >>> >> >> >> > Regards, > >> >>> >> >> >> > > >> >>> >> >> >> > CW > >> >>> >> >> >> > >> >>> >> >> > > >> >>> >> >> > > >> >>> >> >> > > >> >>> >> >> > -- > >> >>> >> >> > > >> >>> ------------------------------------------------------------------- > >> >>> >> >> > *SCJA. José Luis Cetina* > >> >>> >> >> > > >> >>> ------------------------------------------------------------------- > >> >>> >> >> > >> >>> >> > >> >>> > >> >> > >> > > > > > > > > -- > > *Rick Curtis* > -- *Rick Curtis*