List Info

Thread: Connection exception
Connection exception
user name
 2006-09-21 11:40:46 

  


  

    Hi people. I'm doing a data migration script, using Java, from data in phpgroupware, to opengroupware. I take data from the phpgroupware database using sql, and I create the dates, contacts and tasks in ogo using xmlrpc, but there is a problem and this is the exception:



..org.opengroupware.jogi.ogo.ConnectionException: Address already in use: connect
.    at org.opengroupware.jogi.connect.xmlrpc.ApacheXmlRpcCaller.invoke(Unknown Source)
    at es.sgi.ogo.ogoaccess.OgoAppointmentManager.add
(OgoAppointmentManager.java:286)
    at es.sgi.ogo.objectmanagement.OgoAccess.addAppointment(OgoAccess.java:124)
    at es.sgi.ogo.main.InfoManager.createAppointment(InfoManager.java:303)
    at es.sgi.agenda.dao.AppointmentManager.createAppointment
(AppointmentManager.java:325)
    at es.sgi.agenda.datamigration.main.OwnerDataMigration.main(OwnerDataMigration.java:192)



It's very important, anyone can help me????

Thanks a lot.

Fabi


  

  
  
   
     
    

  

    Connection exception
  


  

     user name

     2006-09-21 11:57:32
  


  

    
On Sep 21, 2006, at 13:40, Fabi Avilés wrote:
> I take data from the phpgroupware database using sql,
and I create  
> the dates, contacts and tasks in ogo using xmlrpc

Slightly off topic: Wouldn't it be easier (and faster) to
directly  
generate SQL INSERTs from the input for the OGo database
schema?

I think the XML-RPC interface is (usually) not worth the
hassle for  
bulk migration scripts.

Greets,
   Helge
-- 
Helge Hess
http://d
ocs.opengroupware.org/Members/helge/


-- 
OpenGroupware.org XML-RPC
xmlrpcopengroupware.org
http://mail.opengroupware.org/mailman/listinfo/xmlrpc


  


  

    
  

  
  
   
     
    

  

    Connection exception
  


  

     user name

     2006-09-21 12:58:45
  


  

    
Quoting Fabi Avilés <fabiavmzgmail.com>:

> Hi people. I'm doing a data migration script, using
Java, from data in
> phpgroupware, to opengroupware. I take data from the
phpgroupware database
> using sql, and I create the dates, contacts and tasks
in ogo using xmlrpc,
> but there is a problem and this is the exception:
> ..org.opengroupware.jogi.ogo.ConnectionException:
Address already in use:
> connect

Seems almost more like a JOGI bug than an ogo-xmlrpcd bug. 
Very  
unfortunately there is no active JOGI maintainer.

> It's very important, anyone can help me????

Do you see anything in the ogo-xmlrpcd-*-err.log ?

-- 
OpenGroupware.org XML-RPC
xmlrpcopengroupware.org
http://mail.opengroupware.org/mailman/listinfo/xmlrpc


  


  

    
  

  
  
   
     
    

  

    Connection exception
  


  

     user name

     2006-09-21 13:02:13
  


  

    
>> I take data from the phpgroupware database using
sql, and I create   
>> the dates, contacts and tasks in ogo using xmlrpc
> Slightly off topic: Wouldn't it be easier (and faster)
to directly
> generate SQL INSERTs from the input for the OGo
database schema?
> I think the XML-RPC interface is (usually) not worth
the hassle for
> bulk migration scripts.

So long as you aren't trying to load lots of 'related'
objects, yep.   
If you've got lots of extended attributes and the like then
it can get  
rather messy with SQL since you need to know the related
company_id,  
etc...  If you are just loading basic information then I'd
use SQL.

I've got some C# code for loading contacts from delimited
files if  
your interested (uses MOGI).

-- 
OpenGroupware.org XML-RPC
xmlrpcopengroupware.org
http://mail.opengroupware.org/mailman/listinfo/xmlrpc


  


  

    
  

  
  
   
     
    






 [1-4]











   
 





about | contact  Other archives ( Real Estate discussion Medical topics )