Re: Oracle error ORA-00604: ?? SQL ?? 1 ???? ORA-01000

Hi Rick, Is my case description clear enough? Any suggestions? Regards, Yu Wang On Sat, Mar 8, 2014 at 3:36 PM, yu wang wangy...@gmail.com wrote: Hi Rick, I have two very big master/slave tale I made them equal-partitioned by time stamp columns. So when users query something from two

Re: Oracle error ORA-00604: ?? SQL ?? 1 ???? ORA-01000

Actually I just want to find a OpenJpa equivalence to close() method of JDBC Statement class On Tue, Mar 11, 2014 at 5:56 PM, yu wang wangy...@gmail.com wrote: Hi Rick, Is my case description clear enough? Any suggestions? Regards, Yu Wang On Sat, Mar 8, 2014 at 3:36 PM, yu wang

Re: Oracle error ORA-00604: ?? SQL ?? 1 ???? ORA-01000

No, your question still isn't very clear. Actually I just want to find a OpenJpa equivalence to close() method of JDBC Statement class I believe that after OpenJPA is done processing a native query we will close the statement. If that isn't happening, you could try to cast your query to an

Re: Utilizing a slice for online migration

Todd - Does anyone have any experience with using the policy in this manner? My general feeling is that not many people are using slice as there has been very little mailing list traffic regarding it's usage. Be sure to let us know how it goes! Thanks, Rick On Sun, Mar 9, 2014 at 12:54 PM,

Re: Oracle error ORA-00604: ?? SQL ?? 1 ???? ORA-01000

Rick, I believe openjpa does not close the statement promptly OR an oracle database jdbc driver issue. It seem if manager is used to create a lot of native queries in a loop, the cursors in Oracle database will not be released promptly enough. I am using ojdbc6.jar + openjpa-1.2.3.jar. Anyway, I

Re: Issue with OpenJPA default cache, use external cache

Hi Alice, OpenJPA's L2 Cache provider is pluggable. Ehcache did provide a plugin for their cache [1], but this was some time ago and I don't know if they have kept it up-to-date. WebSphere also provided a plugin for their Dynacache offering [2]. This was introduced in the WAS v8.0 timeframe.

Re: Issue with OpenJPA default cache, use external cache

http://ci.apache.org/projects/openjpa/trunk/docbook/manual.html#ref_guide_cache_conf On Tue, Mar 11, 2014 at 11:04 AM, Alice ashanai...@yahoo.com wrote: Thank you Rick for your response. I will check again to make sure we have bi-directional relation. We see this issue only when the parent

Issue saving entities with fields that reference read only data

Hello, We are running into issues with saving entities with fields that reference read only data. If the entity has a field mapped with 'insertable = false' and/or 'updatable = false' for @Column or @JoinColumn, OpenJPA still tries to do an insert into the read only entity. It also complains that

Re: Issue saving entities with fields that reference read only data

If you are trying to persist an Entity that has a relationship to an (readonly) Entity that already exists in your DB, you should ensure that the existing Entity is a part of your persistence context (ie managed). OpenJPA is most likely complaining because we encountered an unmanaged field when

Re: Oracle error ORA-00604: ?? SQL ?? 1 ???? ORA-01000

Rick, I tried closeAll() but still got ora-00604 if the loop times is numberous. I think it proves it is not an issue of openJPA and I will find the solution from Oracle JDBC driver or datapase parameters directions. Anyway, I appreciate your prompt help a lot. Regards, Yu Wang On Tue, Mar