spring mvc - Hibernate using two oracle database, Error: cannot simultaneously fetch multiple bags -

-

i have 2 separate oracle schema pool information , update. somehow when have 2 hibernate.dialect pointing same dialect, give me simultaneously fetch multiple bags error. if change 1 of org.hibernate.dialect.mysqldialect, error disappear , compile table did not generate. question hibernate. while datasource mysql, able generate of table need, when switch datasource oracle, generate 3 table.

below persistent.xml

<!-- hibernate sessionfactory --> <bean id="sessionfactory"     class="org.springframework.orm.hibernate3.annotation.annotationsessionfactorybean"     p:datasource-ref="datasource">     <property name="packagestoscan" value="edu.byuh.checklist.domain" />       <property name="hibernateproperties">         <value>             hibernate.dialect=org.hibernate.dialect.oracle10gdialect             hibernate.transaction.factory_class=org.hibernate.transaction.jdbctransactionfactory             autoreconnect=true             hibernate.show_sql=true             hibernate.hbm2ddl.auto=update             hibernate.default_schema=checklist                            hibernate.flushmode=never          </value>     </property> </bean>  <bean id="orasessionfactory"     class="org.springframework.orm.hibernate3.annotation.annotationsessionfactorybean"     p:datasource-ref="oradatasource">     <!-- <property name="annotatedclasses"> <list> <value>edu.byuh.checklist.oradomain.psuserdetails</value>          <value>edu.byuh.checklist.oradomain.housingassignment</value> <value>edu.byuh.checklist.oradomain.housingfee</value>          </list> </property> -->     <property name="packagestoscan" value="edu.byuh.checklist.oradomain" />     <property name="hibernateproperties">         <value>             hibernate.dialect=org.hibernate.dialect.oracle10gdialect             <!-- hibernate.show_sql=true -->             hibernate.transaction.factory_class=org.hibernate.transaction.jdbctransactionfactory             autoreconnect=true             hibernate.default_schema=sysadm                <!-- maxconnectionage = 4 * 60 * 60 maxidletimeexcessconnections = 30                  * 60 -->             hibernate.jdbc.batch_size=${hibernate.jdbc.batch_size}             hibernate.c3p0.max_size=${hibernate.c3p0.max_size}             hibernate.c3p0.min_size=${hibernate.c3p0.min_size}             hibernate.c3p0.timeout=${hibernate.c3p0.timeout}             hibernate.c3p0.max_statements=${hibernate.c3p0.max_statements}             hibernate.c3p0.idle_test_period=${hibernate.c3p0.idle_test_period}         </value>     </property>  </bean> <!-- <beans:prop key="hibernate.transaction.factory_class"> org.hibernate.transaction.jdbctransactionfactory      </beans:prop> -->   <!-- <beans:property name="hibernateproperties"> <beans:props> <beans:prop      key="hibernate.dialect"> org.hibernate.dialect.oracle10gdialect</beans:prop>      <beans:prop key="hibernate.show_sql">true</beans:prop> <beans:prop key="hibernate.transaction.factory_class">      org.hibernate.transaction.jdbctransactionfactory </beans:prop> prop key="hibernate.hbm2ddl.auto">update</prop      <beans:prop key="hibernate.default_schema">sysadm</beans:prop> </beans:props>      </beans:property> </beans:bean> -->  <!-- read in daos hibernate package --> <context:component-scan base-package="edu.byuh.checklist.dao.hibernate" />  <!-- transaction config --> <bean id="transactionmanager"     class="org.springframework.orm.hibernate3.hibernatetransactionmanager"     p:sessionfactory-ref="sessionfactory" />  <bean id="oratransactionmanager"     class="org.springframework.orm.hibernate3.hibernatetransactionmanager"     p:sessionfactory-ref="orasessionfactory" /> <!-- <aop:config proxy-target-class="true"/> -->   <tx:annotation-driven transaction-manager="transactionmanager" />

below of domain class

@suppresswarnings("serial") @entity @table(name = "checklistitem") @inheritance(strategy = inheritancetype.single_table) @discriminatorcolumn(name="itemtype", discriminatortype=discriminatortype.string) public abstract class checklistitem implements domainobject, comparable<checklistitem>{   //@sequencegenerator(name = "mysequence", sequencename = "my_seq", allocationsize=1) @sequencegenerator(name = "hibernate_sequence", sequencename = "checklistitem", allocationsize=1) @id @generatedvalue(strategy = generationtype.table) private integer id; private string title; private string subtitle; private boolean published; @column(length=2560) private string contenttxt; //list of student attributes @elementcollection(fetch = fetchtype.eager) @enumerated(enumtype.string) private list<studentattribute> appliesto;

another domain class

@entity @primarykeyjoincolumn(name = "fk_id", referencedcolumnname = "id") public class infoitemuser extends checklistitemuser implements domainobject {  private integer tries;

the problem you're facing explained in great blog http://blog.eyallupu.com/2010/06/hibernate-exception-simultaneously.html explains query example, why can't have multiple bags, , proposes solution

you have 2 eagerly fetched collections hibernate due mapping combination interprets bag. 1 visible code posted in question

@elementcollection(fetch = fetchtype.eager) @enumerated(enumtype.string) private list<studentattribute> appliesto;

you have 3 possible solutions:

  • have collections lazily loaded
  • move type list set if business logic allows it
  • annotate collections @indexcolumn

Comments

Post a Comment

Popular posts from this blog

python - mat is not a numerical tuple : openCV error -

-
i have write down code showing error ma not getting it: please help: showing mat not numerical tuple: import cv import cv2 capture = cv2.videocapture("j.3gp") while(1): _, frame1 = capture.read() grayimage1 = cv2.cvtcolor(frame1, cv2.color_bgr2gray) _, frame2 = capture.read() grayimage2 = cv2.cvtcolor(frame2, cv2.color_bgr2gray) differenceimage = cv2.absdiff(grayimage1,grayimage2) thresholdimage = cv2.threshold(differenceimage,25,255,cv2.thresh_binary) cv2.imshow("difference image", differenceimage) cv2.imshow("threshold image", thresholdimage) cv2.imshow("image", frame1) k = cv2.waitkey(30) & 0xff error arising : ----------------------------------------------------------------------------------------- traceback (most recent call last): file "desk.py", line 15, in <module> cv2.imshow("threshold image", thresholdimage) typeerror: mat not numerical tuple ...
Read more

c# - MSAA finds controls UI Automation doesn't -

-
i'm working on automating windows application. i'm using teststack white framework. i've hit problem. program has 'window' object cannot see inside of. white shows no controls inside of it. inspect.exe shows no controls inside of either when running in ui automation mode. if switch inspect msaa see controls inside fine. there anyway me use msaa c# handle on these controls? if can identify msaa functions need, can use p/invoke call them c#. here's example article doing msaa: http://www.codeproject.com/articles/38906/ui-automation-using-microsoft-active-accessibility also, pinvoke.net can used identify iaccessible (msaa) functions: http://www.pinvoke.net/search.aspx?search=iaccessible&namespace=[all] here's answer along lines: msaa com-based? finally, alternative p/invoke, might able use tlbimp.exe create wrapper assembly oleacc.dll, , access msaa functions through it. i'm not sure if works msaa, it's worth try. as e...
Read more

wordpress - .htaccess: RewriteRule: bad flag delimiters -

-
pulling hair out on one. have following .htaccess file custom redirects in addition wordpress's default settings. when tested on local wamp server worked fine after moving production i'm not getting rewriterule: bad flag delimiters error in server log , after while site goes down internal server error any appreciated. in advance! <ifmodule mod_rewrite.c> rewriteengine on rewritebase / rewriterule ^rockford_weddings___welcome\.html$ /wedding/ [r=301,l] rewriterule ^blog/?$ /journal/ [r=301,l] rewriterule ^blog/(.*)$ /$1 [r=301,l] rewriterule ^portraitinvestment/?$ /portraitinvestment\.pdf [r=301,l] rewriterule ^weddinginvestment/?$ /weddinginvestment\.pdf [r=301,l] rewriterule ^holidaycards2014/?$ /holidaycards2014\.pdf [r=301,l] </ifmodule> # begin wordpress <ifmodule mod_rewrite.c> rewriteengine on rewritebase / rewriterule ^index\.php$ - [l] rewritecond %{request_filename} !-f rewritecond %{request_filename} !-d rewriterule . /index.php [l] </...
Read more