On Mon, Nov 19, 2012 at 2:33 PM, Rick Curtis <curti...@gmail.com> wrote: > 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?
That's why I said "sick and wrong" - yeah wow. I just wanted to get some traction even though I knew I would have to back track on that crazy idea. >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. It turns out, I finally got it working!! Of, course I completely removed the HashSet subclass stuff. Next, so that I could try to "divide and conquer", I decided to try just persisting one of the entities, so I commented out the other calls to persist(), specifically the m2m HashSets, and voilà! It all got persisted! I totally forgot about transitive persistence, which is the same behavior in Hibernate, so I should have known, but it's been over a year since I dealt with any ORM. Well, I *did* send my main code a few messages ago (which showed the erroneous calls to persist() on the HashSets) - but in any case, sorry about the noise from me. Thanks again, -Chris > > 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*