Hi All,

I am trying to integrate OpenERP with a java application.
I have tested the given samples [login,findDatabase].
But I am unable to do create/update/search methods.
Can anyone please give some sample code in java?

I know it is something like rpcClient.execute("methodName",paramters);
[rpcClient is my openerp webservice client]

can you please give the format for "methodName/s" and parameters

it would be great if someone can provide some sample codes in java.

Thanks
Shameer

Hello..

I found that no questions regarding the OpenERP webservices answered properly. Is that means those webservices are not useful or nobody can implement it!

Got the solution!!!

That's good to hear! What was it?

I developed java code to perform create/search/read operations using OpenERP webservice. And trying to create clients to all the ORM methods in OpenERP

mail me for the details

mal.me.shameer@gmail.com

Thanks

Hi shameer

could you or someone else please post the solution to integrating openerp via java?

Thanks

------------------------
Java Code for browse Method
--------------------------


package com.xmlrpc.client;

import java.net.URL;
import java.util.Vector;

import org.apache.xmlrpc.client.XmlRpcClient;
import org.apache.xmlrpc.client.XmlRpcClientConfigImpl;

public class Browse {

public static void main(String args[]) throws Exception {
// USEFUL ONLY LOCALLY WITH IN THE SERVER
Vector params1 = new Vector();
params1.addElement("openerpdb");
params1.addElement("admin");
params1.addElement("admin");

XmlRpcClient xmlrpcLogin = new XmlRpcClient();
XmlRpcClientConfigImpl xmlrpcConfigLogin = new XmlRpcClientConfigImpl();
xmlrpcConfigLogin.setEnabledForExtensions(true);
xmlrpcConfigLogin.setServerURL(new URL("http", "192.168.1.153", 8069, "/xmlrpc/common"));
xmlrpcLogin.setConfig(xmlrpcConfigLogin);

Object id = xmlrpcLogin.execute("login", params1);
System.out.println("Login Id : " + id.toString());

System.out.println("------------------------");

XmlRpcClient client = new XmlRpcClient();
XmlRpcClientConfigImpl clientConfig = new XmlRpcClientConfigImpl();
clientConfig.setEnabledForExtensions(true);
clientConfig.setServerURL(new URL("http", "192.168.1.153", 8069, "/xmlrpc/object"));
client.setConfig(clientConfig);

// Object[] params2 = { "parner_id", "name" };
Object[] params2 = { 24 };
Vector<Object> params = new Vector<Object>();
params.add(params2);
Vector<Object> arg = new Vector<Object>();
arg.add("openerpdb");
arg.add(1);
arg.add("admin");
arg.add("res.partner.address");
arg.add("browse");
// arg.add(24);
arg.add(params2);

Object c = client.execute("execute", arg);
// System.out.println("partner addressees with partner Id 24 :");
// for (Object obj : ids) {
// int a = Integer.parseInt(obj.toString());
// System.out.println(a);
// }

}
}

------------------------
Java Code for Create Method
------------------------

package com.xmlrpc.client;

import java.net.URL;
import java.util.HashMap;
import java.util.Vector;

import org.apache.xmlrpc.client.XmlRpcClient;
import org.apache.xmlrpc.client.XmlRpcClientConfigImpl;

public class Create {

public static void main(String args[]) throws Exception {

Vector params1 = new Vector();
params1.addElement("openerpdb");
params1.addElement("admin");
params1.addElement("admin");

XmlRpcClient xmlrpcLogin = new XmlRpcClient();
XmlRpcClientConfigImpl xmlrpcConfigLogin = new XmlRpcClientConfigImpl();
xmlrpcConfigLogin.setEnabledForExtensions(true);
xmlrpcConfigLogin.setServerURL(new URL("http", "localhost", 8069, "/xmlrpc/common"));
xmlrpcLogin.setConfig(xmlrpcConfigLogin);

Object id = xmlrpcLogin.execute("login", params1);
System.out.println("Login Id : " + id.toString());

System.out.println("------------------------");

XmlRpcClient client = new XmlRpcClient();
XmlRpcClientConfigImpl clientConfig = new XmlRpcClientConfigImpl();
clientConfig.setEnabledForExtensions(true);
clientConfig.setServerURL(new URL("http", "localhost", 8069, "/xmlrpc/object"));
client.setConfig(clientConfig);

HashMap<Object, Object> params = new HashMap<Object, Object>();

params.put("street", "Edamon3");
params.put("partner_id", "24");
params.put("city", "Punalur3");
params.put("name", "ShameerHabeeb3");

Vector<Object> arg = new Vector<Object>();

arg.add("openerpdb");
arg.add(1);
arg.add("admin");
arg.add("res.partner.address");
arg.add("create");
arg.add(params);

Object ret_id = client.execute("execute", arg);
System.out.println("Created new partner address with id :" + ret_id.toString());

}
}

-----------------------
Java code for FindDB method
-----------------------

package com.xmlrpc.client;

import java.net.URL;
import java.util.Vector;

import org.apache.xmlrpc.XmlRpcException;
import org.apache.xmlrpc.client.XmlRpcClient;
import org.apache.xmlrpc.client.XmlRpcClientConfigImpl;

public class FindDB {

public static void main(String args[]) throws Exception {

XmlRpcClient xmlrpcDb = new XmlRpcClient();
XmlRpcClientConfigImpl xmlrpcConfigDb = new XmlRpcClientConfigImpl();
xmlrpcConfigDb.setEnabledForExtensions(true);
xmlrpcConfigDb.setServerURL((new URL("http", "localhost", 8069, "/xmlrpc/db")));
xmlrpcDb.setConfig(xmlrpcConfigDb);
try {
// Retrieve databases
Vector<Object> params = new Vector<Object>();
Object result = xmlrpcDb.execute("list", params);
Object[] a = (Object[]) result;
Vector<String> res = new Vector<String>();
for (int i = 0; i < a.length; i++) {
if (a[i] instanceof String) {
res.addElement((String) a[i]);
System.out.println(a[i]);
}
}
} catch (XmlRpcException e) {
e.printStackTrace();
}
}
}

-----------------------
Java Code for Login method
-----------------------


package com.xmlrpc.client;

import java.net.URL;
import java.util.Vector;

import org.apache.xmlrpc.XmlRpcException;
import org.apache.xmlrpc.client.XmlRpcClient;
import org.apache.xmlrpc.client.XmlRpcClientConfigImpl;

public class Login {

public static void main(String args[]) throws Exception {
XmlRpcClient xmlrpcLogin = new XmlRpcClient();
XmlRpcClientConfigImpl xmlrpcConfigLogin = new XmlRpcClientConfigImpl();
xmlrpcConfigLogin.setEnabledForExtensions(true);
xmlrpcConfigLogin.setServerURL(new URL("http", "192.168.1.153", 8069, "/xmlrpc/common"));
xmlrpcLogin.setConfig(xmlrpcConfigLogin);
try {
// Connect
Vector params = new Vector();
params.addElement("openerpdb");
params.addElement("admin");
params.addElement("admin");

Object id = xmlrpcLogin.execute("login", params);
System.out.println("id : " + id);
} catch (XmlRpcException e) {
} catch (Exception e) {

}
}
}

--------------------------
Java Code for Read mthod
--------------------------

package com.xmlrpc.client;

import java.net.URL;
import java.util.HashMap;
import java.util.Vector;

import org.apache.xmlrpc.client.XmlRpcClient;
import org.apache.xmlrpc.client.XmlRpcClientConfigImpl;

public class Read {

public static void main(String args[]) throws Exception {
XmlRpcClient client = new XmlRpcClient();
XmlRpcClientConfigImpl clientConfig = new XmlRpcClientConfigImpl();
clientConfig.setEnabledForExtensions(true);
clientConfig.setServerURL(new URL("http", "192.168.1.153", 8069, "/xmlrpc/object"));
client.setConfig(clientConfig);

Object[] params2 = { "city", "name", "partner_id", "country_id", "email", "create_date",
"write_date" };

Vector<Object> arg = new Vector<Object>();

arg.add("openerpdb");
arg.add(1);
arg.add("admin");
arg.add("res.partner.address");
arg.add("read");
arg.add(3);
arg.add(params2);

HashMap ids = (HashMap) client.execute("execute", arg);

Object[] partner = (Object[]) ids.get("partner_id");
Object[] country = (Object[]) ids.get("country_id");

System.out.println(ids.get("id"));
System.out.println(ids.get("name"));
System.out.println(ids.get("city"));
System.out.println(ids.get("email"));
System.out.println(ids.get("create_date"));
System.out.println(ids.get("write_date"));
System.out.println("partner : " + partner[0].toString() + " , " + partner[1].toString());
System.out.println("country : " + country[0].toString() + " , " + country[1].toString());
}
}

-----------------------------
Java Code for Search method
-----------------------------

package com.xmlrpc.client;

import java.net.URL;
import java.util.Vector;

import org.apache.xmlrpc.client.XmlRpcClient;
import org.apache.xmlrpc.client.XmlRpcClientConfigImpl;

public class Search {

public static void main(String args[]) throws Exception {

Vector params1 = new Vector();
params1.addElement("openerpdb");
params1.addElement("admin");
params1.addElement("admin");

XmlRpcClient xmlrpcLogin = new XmlRpcClient();
XmlRpcClientConfigImpl xmlrpcConfigLogin = new XmlRpcClientConfigImpl();
xmlrpcConfigLogin.setEnabledForExtensions(true);
xmlrpcConfigLogin.setServerURL(new URL("http", "localhost", 8069, "/xmlrpc/common"));
xmlrpcLogin.setConfig(xmlrpcConfigLogin);

Object id = xmlrpcLogin.execute("login", params1);
System.out.println("Login Id : " + id.toString());

System.out.println("------------------------");

XmlRpcClient client = new XmlRpcClient();
XmlRpcClientConfigImpl clientConfig = new XmlRpcClientConfigImpl();
clientConfig.setEnabledForExtensions(true);
clientConfig.setServerURL(new URL("http", "localhost", 8069, "/xmlrpc/object"));
client.setConfig(clientConfig);

Object[] params2 = { "create_uid", "=", 1 };
Vector<Object> params = new Vector<Object>();
params.add(params2);
Vector<Object> arg = new Vector<Object>();
arg.add("openerpdb");
arg.add(1);
arg.add("admin");
arg.add("product.product");
arg.add("search");
arg.add(params);

Object[] ids = (Object[]) client.execute("execute", arg);
System.out.println("partner addressees with create_uid 1 :");
for (Object obj : ids) {
int a = Integer.parseInt(obj.toString());
System.out.println(a);
}

}
}

----------------------------------
Java Code for Unlink/Delete method
----------------------------------


package com.xmlrpc.client;

import java.net.URL;
import java.util.HashMap;
import java.util.Vector;

import org.apache.xmlrpc.client.XmlRpcClient;
import org.apache.xmlrpc.client.XmlRpcClientConfigImpl;

public class Unlink {
public static void main(String args[]) throws Exception {

Vector params1 = new Vector();
params1.addElement("openerpdb");
params1.addElement("admin");
params1.addElement("admin");

XmlRpcClient xmlrpcLogin = new XmlRpcClient();
XmlRpcClientConfigImpl xmlrpcConfigLogin = new XmlRpcClientConfigImpl();
xmlrpcConfigLogin.setEnabledForExtensions(true);
xmlrpcConfigLogin.setServerURL(new URL("http", "localhost", 8069, "/xmlrpc/common"));
xmlrpcLogin.setConfig(xmlrpcConfigLogin);

Object id = xmlrpcLogin.execute("login", params1);
System.out.println("Login Id : " + id.toString());

System.out.println("------------------------");

XmlRpcClient client = new XmlRpcClient();
XmlRpcClientConfigImpl clientConfig = new XmlRpcClientConfigImpl();
clientConfig.setEnabledForExtensions(true);
clientConfig.setServerURL(new URL("http", "localhost", 8069, "/xmlrpc/object"));
client.setConfig(clientConfig);

HashMap<Object, Object> params = new HashMap<Object, Object>();

params.put("street", "Edamon34");

Vector<Object> arg = new Vector<Object>();
Object ids[] = { 25, 24 };
arg.add("openerpdb");
arg.add(1);
arg.add("admin");
arg.add("res.partner.address");
arg.add("unlink");
arg.add(ids);

Object ret_id = client.execute("execute", arg);
System.out.println("result :" + ret_id.toString());
}
}

-----------------------------
Java Code for write method
-----------------------------


package com.xmlrpc.client;

import java.net.URL;
import java.util.HashMap;
import java.util.Vector;

import org.apache.xmlrpc.client.XmlRpcClient;
import org.apache.xmlrpc.client.XmlRpcClientConfigImpl;

public class Write {
public static void main(String args[]) throws Exception {

Vector params1 = new Vector();
params1.addElement("openerpdb");
params1.addElement("admin");
params1.addElement("admin");

XmlRpcClient xmlrpcLogin = new XmlRpcClient();
XmlRpcClientConfigImpl xmlrpcConfigLogin = new XmlRpcClientConfigImpl();
xmlrpcConfigLogin.setEnabledForExtensions(true);
xmlrpcConfigLogin.setServerURL(new URL("http", "localhost", 8069, "/xmlrpc/common"));
xmlrpcLogin.setConfig(xmlrpcConfigLogin);

Object id = xmlrpcLogin.execute("login", params1);
System.out.println("Login Id : " + id.toString());

System.out.println("------------------------");

XmlRpcClient client = new XmlRpcClient();
XmlRpcClientConfigImpl clientConfig = new XmlRpcClientConfigImpl();
clientConfig.setEnabledForExtensions(true);
clientConfig.setServerURL(new URL("http", "localhost", 8069, "/xmlrpc/object"));
client.setConfig(clientConfig);

HashMap<Object, Object> params = new HashMap<Object, Object>();

params.put("street", "Edamon34");

Vector<Object> arg = new Vector<Object>();
Object ids[] = { 25, 24, 23 };
arg.add("openerpdb");
arg.add(1);
arg.add("admin");
arg.add("res.partner.address");
arg.add("write");
arg.add(ids);
arg.add(params);

Object ret_id = client.execute("execute", arg);
System.out.println("result :" + ret_id.toString());
}
}

Hello
i'm beginner in java and i want to use this code but i'd like to know if i'll use for each method a java class or make them all in one java class
thanks