home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.oracle      Overblown overpriced overengineered SHIT      2,288 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 1,151 of 2,288   
   Royco to All   
   Oracle OCI, COM+, dblinks and Multi Thre   
   26 Feb 04 15:31:01   
   
   XPost: comp.database.oracle, comp.databases.oracle.misc, comp.da   
   abases.oracle.server   
   XPost: comp.databases.oracle.tools   
   From: bla@bla.nl   
      
   Hi,   
      
   Situation as follows   
   - a C++ component with OCI-calls running under the control of COM (w2k)   
   - component is marked transactional   
   - the component connects to database1 but wants to update tables in   
   database2 (through a databaselink).   
   - Oracle version is 8i on client and server   
      
   Initially we received an Oracle error 24777 : Use of non-migratable database   
   link not allowed.   
      
   After reading some documentation we decided to configure Multi Threaded   
   Server but now the database-server processen are instable.   
   Doing something like "insert into database2 as select from a table in   
   database1" hangs up the database-processes.   
      
   Is there some thinking-error in our solution?????   
   How can I make a 'transactional' com-component doing selects and updates in   
   more then 1 database?   
      
      
   roy   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca