Re: Oracle Blob Exception with 11.1 jdbc driver

2009-01-30 Thread ericp56
FYI, I unit tested with: OpenEJB 3.1 ojdbc14.jar and ojdbc5.jar Open JPA Versions 1.2 and 1.0.3 (using Geronimo 2.1.3). -- View this message in context: http://n2.nabble.com/Oracle-Blob-Exception-with-11.1-jdbc-driver-tp2242185p2244588.html Sent from the OpenJPA Users mailing list archive at

Re: Oracle Blob Exception with 11.1 jdbc driver

2009-01-30 Thread ericp56
I set MaxEmbeddedBlobSize to -1 and it worked fine. -- View this message in context: http://n2.nabble.com/Oracle-Blob-Exception-with-11.1-jdbc-driver-tp2242185p2244553.html Sent from the OpenJPA Users mailing list archive at Nabble.com.

Oracle Blob Exception with 11.1 jdbc driver

2009-01-29 Thread ericp56
I'm using the jdbc client included with instantclient 11.1 I am trying to persist a Blob (annotated with Lob, etc) and I'm getting the Exhausted Resultset exception. Should I using the Oracle 10.2 jdbc driver instead? -- View this message in context: http://n2.nabble.com/Oracle-Blob-Except

Oracle Identity

2008-12-04 Thread ericp56
Hello, I'm using Geronimo, and an Oracle XA database pool. I've followed the steps to create a sequence in Oracle, and have added a trigger to the table so the PK is set automatically using the sequence. I've added in my persistence.xml In my code, I have: em.setFlushMode(FlushModeTy

Schema is ignored in my unit testing

2008-11-20 Thread ericp56
Hello, I have a simple JPA EJB unit test that is failing with (bolded the root error below ): ScrapEjbTest com.twcable.ivr.test.ScrapEjbTest test1(com.twcable.ivr.test.ScrapEjbTest) javax.ejb.EJBException: The bean encountered a non-application exception; nested exception is: org.apac

Transaction question

2008-09-17 Thread ericp56
I am porting an application to container-managed JPA. In my EJB, I now have a function that does something like this: function CreateAccount() { Person p = new Person(); Address a = new Address(); ... em.persist(p); em.persist(a) ... } In my Web page that uses the EJB, I have added a transact

Re: PK Problem, mismatched property

2008-09-10 Thread ericp56
Well, I got aggressive with logging and found: openjpa.Runtime - Setting the following properties from "?" into configuration: {openjpa.jdbc.SynchronizeMappings=buildSchema(ForeignKeys=true) etc. openjpa.jdbc.SynchronizeMappings=buildSchema(ForeignKeys=false) didn't make a difference, either.

Re: PK Problem, mismatched property

2008-09-09 Thread ericp56
No SynchronizeMappings property, no @GeneratedValues annotation. How frustrating. Thanks for your help, though :-). I started a clean project, still have the issue. My classes are a little different: @Entity @Table(name="QUESTION_RESULTS") public class QuestionResults implements Serializable

Re: PK Problem, mismatched property

2008-09-09 Thread ericp56
I forgot to mention: QuestionResults SurveyResultsID (FK) (PK) QuestionID (FK)(PK) Answer... The two ID fields are the primary key, they are the unique combination that identifies the entity. Why is OpenJPA not getting it? Actually, what am I not getting? -- View this message in context: htt

RE: PK Problem, mismatched property

2008-09-09 Thread ericp56
I changed the data types in the PK class to be "long." No more PK error, but now the code is trying to create a table named OPENJPASEQ. I'm figuring it gave up on using the PK for its identity? Eric -- View this message in context: http://n2.nabble.com/PK-Problem%2C-mismatched-property-tp1078

RE: PK Problem, mismatched property

2008-09-09 Thread ericp56
I think my biggest problem is that I used Eclipse to generate the entities. I had all sorts of warnings about the compatibility of the fields, so I set the length of the fields using the @Column annotation. I tried removing the @Column from the PK class, but it didn't make a difference. Eric

PK Problem, mismatched property

2008-09-09 Thread ericp56
I have three tables: Question id long (PK) description string etc. Survey id long (PK) surveydate Date etc. QuestionResults SurveyResultsID (FK) QuestionID (FK) Answer Here's my class that won't persist, because of errors (to follow): @Entity @Table(name="QuestionResults") @IdClass(QuestionResul

Persist method is updating my reference tables, too.

2008-07-09 Thread ericp56
I am using an EntityManager to look up information in a reference table. I use the resulting object to set an int value in a new record I will persist. When I persist, the new record is inserted, and the reference table is updated (yikes). Am I not understanding something about this? Should I

Using QueryResultCache to store reference tables?

2008-07-09 Thread ericp56
I have some queries on reference tables that won't be changing often. Can I use QueryResultCache to store those queries/results? I don't understand the documentation on this.:confused: Eric -- View this message in context: http://n2.nabble.com/Using-QueryResultCache-to-store-reference-tables-

Re: Tomcat Injection

2008-07-09 Thread ericp56
Indeed, that is the answer. For now, I need to stick with Tomcat, so I'll create an EntityManagerFactory singleton. Thanks! Eric -- View this message in context: http://n2.nabble.com/Tomcat-Injection-tp395699p469860.html Sent from the OpenJPA Users mailing list archive at Nabble.com.

Re: Tomcat Injection

2008-07-08 Thread ericp56
I tried: emf = OpenJPAPersistence.getEntityManagerFactory(); but it doesn't find persistence.xml, and raises: org.apache.openjpa.persistence.ArgumentException: A JDBC Driver or DataSource class name must be specified in the ConnectionDriverName property. Are ther

Tomcat Injection

2008-07-08 Thread ericp56
Hello, After reading some documentation, I though I had my injection code worked out, but apparently not. I am using Tomcat with OpenJPA. In my class, I have: @PersistenceUnit(unitName = "CallScheduler") private @Resource(name="bean/OpenJPAEMF")OpenJPAEntityManagerFactory emf;