Accéder à une base de données d'un serveur OpenERP en utilisant un client Android

Version imprimable

Bonjour, je bosse sur une application client serveur entre android et un serveur OpenERP, je peux établir la connexion avec une base de donnée, maintenant j'essai de lire, écrire, créer des partenaires.. dans de la base de donnée, ces codes sont en java

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
------------------------
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", "Stendhal");
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());
 
}
}

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
--------------------------
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());
}
}

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
-----------------------------
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());
}
}

pour android j'ai essayé le code suivant (l'application ne démarre pas):

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
 
 
	public Button login_button;
	public TextView host_tv,user_tv, pass_tv;
	public EditText host_txt,user_txt, pass_txt;
 
	public XMLRPCClient rpcClient, regClient;
	public static final String HOST = "http://192.168.2.8:8069/xmlpc";
	public static final String URL_COMMON = "/common";
	public static final String URL_OBJECT = "/object";
	public static final String URL_DB = "/db";
 
	public String DB_NAME = "";
	public String USERNAME = "";
	public String PASSWORD = "";
	public String res = "";
	public int uid = 0;
 
	public String partner = "";
	public int partner_id = 0;
	public Spinner db_spinner;
	public ArrayAdapter spinnerArrayAdapter;
 
	@Override
	public void onCreate(Bundle savedInstanceState) {
		super.onCreate(savedInstanceState);
		setContentView(R.layout.main);
 
		// TEXTVIEW		
		user_tv = (TextView) findViewById(R.id.user_tv);
		pass_tv = (TextView) findViewById(R.id.pass_tv);
		// EDITTEXT
		user_txt = (EditText) findViewById(R.id.user_txt);
		pass_txt = (EditText) findViewById(R.id.pass_txt);
 
		// BUTTOn
		login_button = (Button) findViewById(R.id.login_button);
		login_button.setOnClickListener(LoginButtonClick);
 
 
		db_spinner = (Spinner) findViewById(R.id.db_spinner);
		spinnerArrayAdapter = new ArrayAdapter(this ,android.R.layout.simple_spinner_item);
		spinnerArrayAdapter.setDropDownViewResource(android.R.layout.simple_dropdown_item_1line);
		getDatabaseList();
 
		db_spinner.setAdapter(spinnerArrayAdapter);
	}
 
	public void showToastNotification(String  message) {
		Toast tmptoast = Toast.makeText(this, message, Toast.LENGTH_SHORT);
		tmptoast.show();
 
	}
 
	private OnClickListener LoginButtonClick = new OnClickListener() {
		@Override
		public void onClick(View v) {
			try {
				uid = Create();
				if (uid > 0) {
					String succes ="successful login from "+ USERNAME+" using database "+DB_NAME;
					showToastNotification(succes);
				} else {
					String fail = "bad login or password from "+ USERNAME+" using database " +DB_NAME;
					showToastNotification(fail);
				}
			} catch (Exception e) {
				Log.i("------------------ LOGIN FAILED 1", e.toString());
			}
		}
	};
	public int Create()// String host, int port, String tinydb, String login,
						// String password)
	{
		USERNAME = user_txt.getText().toString();
		PASSWORD = pass_txt.getText().toString();
		DB_NAME = db_spinner.getSelectedItem().toString();
		rpcClient = new XMLRPCClient(HOST+URL_OBJECT );
 
				// Create
			  HashMap<String, Object> vals = new HashMap<String, Object>();
			    vals.put("name", "un nom du partenaire");
			    vals.put("ref", "une reference");
			    Object[] params = new Object[]{DB_NAME, 1,PASSWORD, "res.partner", "create", vals};
 
				//Object res = null;
				try {
					res =(String) rpcClient.call("execute", params);
					Log.i("------------------CURRENT USER ID  ",  res);
 
					Object uid1 = Integer.parseInt(res);
					if (uid1 instanceof Integer)
						return (Integer) uid1;
					return -1;
	} catch (XMLRPCException e) {
		Log.i("------------------ LOGIN FAILED-XMLRPCException", e.toString());
		return -2;
	} catch (Exception e) {
		Log.i("------------------ LOGIN FAILED-EXCEPTION", e.toString());
		return -3;
	}}
 
 
	public void  getDatabaseList() {
		 rpcClient = new XMLRPCClient(HOST+URL_DB);
			Vector<Object> params = new Vector<Object>();
			Object result = null;
			try {
				 result= rpcClient.call("list", params);
			} catch (XMLRPCException e) {
				e.printStackTrace();
			}
			Object[] a = (Object[]) result;
			for (int i = 0; i < a.length; i++) {
			    if (a[i] instanceof String){
			    	spinnerArrayAdapter.add(a[i].toString());
			    	}
				}
		Log.i("------------------ getDatabaseList","4");
		if (a.length == 0) {
			showToastNotification("No database exist");
		}
	 }
}

voici le logcat:

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
02-28 11:54:11.600: ERROR/AndroidRuntime(628): FATAL EXCEPTION: main
02-28 11:54:11.600: ERROR/AndroidRuntime(628): java.lang.RuntimeException: Unable to start activity ComponentInfo{mn.usi.openerpdroid/mn.usi.openerpdroid.OpenERPDroid}: java.lang.NullPointerException
02-28 11:54:11.600: ERROR/AndroidRuntime(628):     at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2663)
02-28 11:54:11.600: ERROR/AndroidRuntime(628):     at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2679)
02-28 11:54:11.600: ERROR/AndroidRuntime(628):     at android.app.ActivityThread.access$2300(ActivityThread.java:125)
02-28 11:54:11.600: ERROR/AndroidRuntime(628):     at android.app.ActivityThread$H.handleMessage(ActivityThread.java:2033)
02-28 11:54:11.600: ERROR/AndroidRuntime(628):     at android.os.Handler.dispatchMessage(Handler.java:99)
02-28 11:54:11.600: ERROR/AndroidRuntime(628):     at android.os.Looper.loop(Looper.java:123)
02-28 11:54:11.600: ERROR/AndroidRuntime(628):     at android.app.ActivityThread.main(ActivityThread.java:4627)
02-28 11:54:11.600: ERROR/AndroidRuntime(628):     at java.lang.reflect.Method.invokeNative(Native Method)
02-28 11:54:11.600: ERROR/AndroidRuntime(628):     at java.lang.reflect.Method.invoke(Method.java:521)
02-28 11:54:11.600: ERROR/AndroidRuntime(628):     at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:868)
02-28 11:54:11.600: ERROR/AndroidRuntime(628):     at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:626)
02-28 11:54:11.600: ERROR/AndroidRuntime(628):     at dalvik.system.NativeStart.main(Native Method)
02-28 11:54:11.600: ERROR/AndroidRuntime(628): Caused by: java.lang.NullPointerException
02-28 11:54:11.600: ERROR/AndroidRuntime(628):     at mn.usi.openerpdroid.OpenERPDroid.getDatabaseList(OpenERPDroid.java:136)
02-28 11:54:11.600: ERROR/AndroidRuntime(628):     at mn.usi.openerpdroid.OpenERPDroid.onCreate(OpenERPDroid.java:66)
02-28 11:54:11.600: ERROR/AndroidRuntime(628):     at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1047)
02-28 11:54:11.600: ERROR/AndroidRuntime(628):     at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2627)
02-28 11:54:11.600: ERROR/AndroidRuntime(628):     ... 11 more
02-28 11:54:11.610: WARN/ActivityManager(58):   Force finishing activity mn.usi.openerpdroid/.OpenERPDroid
02-28 11:54:12.174: WARN/ActivityManager(58): Activity pause timeout for HistoryRecord{450b3408 mn.usi.openerpdroid/.OpenERPDroid}
02-28 11:54:22.822: WARN/ActivityManager(58): Activity destroy timeout for HistoryRecord{450b3408 mn.usi.openerpdroid/.OpenERPDroid}

28/02/2012, 13h45
sinok

Bah tu as une variable nulle à la ligne 136 de ta classe OpenERPDroid, dans la méthode getDatabaseList....
28/02/2012, 15h49
oqastage

si tu parle de la variable result, je pense que je suis obligé de l'initialiser :

Code:

Object result = null;
29/02/2012, 03h42
nicroman

On parle de l'UTILISATION (NullPointerException) d'une variable nulle....

Faut voir ce qui est à la ligne 136....

Le call à rpcClient ? (a noter qu'il y a un jolie try/catch autour sans gestion de l'erreur avec un ugly e.printStackTrace.... Log.e("MonAppli","Y a une erreur",e); est quand même mieux !

spinnerArrayAdapter ?

a[i] ?

Ceci est un code qui marche et qui permet la connexion à une base de donnée avec presque la même forme que le précédent

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
public void onCreate(Bundle savedInstanceState) {
		super.onCreate(savedInstanceState);
		setContentView(R.layout.main);
 
		// TEXTVIEW		
		user_tv = (TextView) findViewById(R.id.user_tv);
		pass_tv = (TextView) findViewById(R.id.pass_tv);
		// EDITTEXT
		user_txt = (EditText) findViewById(R.id.user_txt);
		pass_txt = (EditText) findViewById(R.id.pass_txt);
 
		// BUTTOn
		login_button = (Button) findViewById(R.id.login_button);
		login_button.setOnClickListener(LoginButtonClick);
 
 
		db_spinner = (Spinner) findViewById(R.id.db_spinner);
		spinnerArrayAdapter = new ArrayAdapter(this ,android.R.layout.simple_spinner_item);
		spinnerArrayAdapter.setDropDownViewResource(android.R.layout.simple_dropdown_item_1line);
		getDatabaseList();
		db_spinner.setAdapter(spinnerArrayAdapter);
	}
 
	public void showToastNotification(String  message) {
		Toast tmptoast = Toast.makeText(this, message, Toast.LENGTH_SHORT);
		tmptoast.show();
	}
	private OnClickListener LoginButtonClick = new OnClickListener() {
		@Override
		public void onClick(View v) {
			try {
				uid = Connect();
				if (uid > 0) {
					String succes ="successful login from "+ USERNAME+" using database "+DB_NAME;
					showToastNotification(succes);
				} else {
					String fail = "bad login or password from "+ USERNAME+" using database " +DB_NAME;
					showToastNotification(fail);
				}
			} catch (Exception e) {
				Log.i("------------------ LOGIN FAILED 1", e.toString());
			}
		}
	};
	public int Connect()
	{
		USERNAME = user_txt.getText().toString();
		PASSWORD = pass_txt.getText().toString();
		DB_NAME = db_spinner.getSelectedItem().toString();
		rpcClient = new XMLRPCClient(HOST+URL_COMMON );
		try {
 
				user = (String) rpcClient.call("login", DB_NAME, USERNAME, PASSWORD).toString();
				Log.i("------------------CURRENT USER ID  ", user);
				Object uid1 = Integer.parseInt(user);
				if (uid1 instanceof Integer)
					return (Integer) uid1;
			return -1;
		} catch (XMLRPCException e) {
			Log.i("------------------ LOGIN FAILED-XMLRPCException", e.toString());
			return -2;
		} catch (Exception e) {
			Log.i("------------------ LOGIN FAILED-EXCEPTION", e.toString());
			return -3;
		}
	}
	public void  getDatabaseList() {
		 rpcClient = new XMLRPCClient(HOST+URL_DB);
			Vector<Object> params = new Vector<Object>();
			Object result = null;
			try {
				 result= rpcClient.call("list", params);
			} catch (XMLRPCException e) {
				e.printStackTrace();
			}
			Object[] a = (Object[]) result;
			for (int i = 0; i < a.length; i++) {
			    if (a[i] instanceof String){
			    	spinnerArrayAdapter.add(a[i].toString());
			    	}
				}
		Log.i("------------------ getDatabaseList","4");
		if (a.length == 0) {
			showToastNotification("No database exist");
		}
	 }

spinnerArrayAdapter et a[] c'est pour récupérer une liste des bases de données qui permet de cocher une base pour la connexion

client android pour openerp

salut;
j'ai tester ce code mais il m'affiche une exception donnee

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
02-27 11:14:04.323: E/AndroidRuntime(1055): FATAL EXCEPTION: main
02-27 11:14:04.323: E/AndroidRuntime(1055): java.lang.RuntimeException: Unable to start activity ComponentInfo{com.example.client_android/com.example.client_android.MainActivity}: java.lang.NullPointerException
02-27 11:14:04.323: E/AndroidRuntime(1055): 	at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2180)
02-27 11:14:04.323: E/AndroidRuntime(1055): 	at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2230)
02-27 11:14:04.323: E/AndroidRuntime(1055): 	at android.app.ActivityThread.access$600(ActivityThread.java:141)
02-27 11:14:04.323: E/AndroidRuntime(1055): 	at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1234)
02-27 11:14:04.323: E/AndroidRuntime(1055): 	at android.os.Handler.dispatchMessage(Handler.java:99)
02-27 11:14:04.323: E/AndroidRuntime(1055): 	at android.os.Looper.loop(Looper.java:137)
02-27 11:14:04.323: E/AndroidRuntime(1055): 	at android.app.ActivityThread.main(ActivityThread.java:5039)
02-27 11:14:04.323: E/AndroidRuntime(1055): 	at java.lang.reflect.Method.invokeNative(Native Method)
02-27 11:14:04.323: E/AndroidRuntime(1055): 	at java.lang.reflect.Method.invoke(Method.java:511)
02-27 11:14:04.323: E/AndroidRuntime(1055): 	at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:793)
02-27 11:14:04.323: E/AndroidRuntime(1055): 	at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:560)
02-27 11:14:04.323: E/AndroidRuntime(1055): 	at dalvik.system.NativeStart.main(Native Method)
02-27 11:14:04.323: E/AndroidRuntime(1055): Caused by: java.lang.NullPointerException
02-27 11:14:04.323: E/AndroidRuntime(1055): 	at com.example.client_android.MainActivity.getDatabaseList(MainActivity.java:122)
02-27 11:14:04.323: E/AndroidRuntime(1055): 	at com.example.client_android.MainActivity.onCreate(MainActivity.java:65)
02-27 11:14:04.323: E/AndroidRuntime(1055): 	at android.app.Activity.performCreate(Activity.java:5104)
02-27 11:14:04.323: E/AndroidRuntime(1055): 	at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1080)
02-27 11:14:04.323: E/AndroidRuntime(1055): 	at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2144)
02-27 11:14:04.323: E/AndroidRuntime(1055): 	... 11 more

s'il ya quelqu'un qui peut m'aider ?
voila la classe MainActivity :

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
package com.example.client_android;
 
import java.util.Vector;
 
import org.xmlrpc.android.XMLRPCClient;
import org.xmlrpc.android.XMLRPCException;
 
import android.app.Activity;
import android.os.Bundle;
import android.util.Log;
import android.view.Menu;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.ArrayAdapter;
import android.widget.Button;
import android.widget.EditText;
import android.widget.Spinner;
import android.widget.TextView;
import android.widget.Toast;
 
 
public class MainActivity extends Activity {
 
	public Button login_button;
	public TextView host_tv,user_tv, pass_tv;
	public EditText host_txt,user_txt, pass_txt;
 
	public XMLRPCClient rpcClient, regClient;
	public static final String HOST = "http://10.0.2.2:8069";
	public static final String URL_COMMON = "/common";
	public static final String URL_OBJECT = "/object";
	public static final String URL_DB = "/db";
 
	public String DB_NAME = "";
	public String USERNAME = "";
	public String PASSWORD = "";
	public String user = "";
	public int uid = 0;
 
	public String partner = "";
	public int partner_id = 0;
	public Spinner db_spinner;
	public ArrayAdapter<String> spinnerArrayAdapter;
 
	@Override
	public void onCreate(Bundle savedInstanceState) {
		super.onCreate(savedInstanceState);
		setContentView(R.layout.activity_main);
 
		// TEXTVIEW		
		user_tv = (TextView) findViewById(R.id.user_tv);
		pass_tv = (TextView) findViewById(R.id.pass_tv);
		// EDITTEXT
		user_txt = (EditText) findViewById(R.id.user_txt);
		pass_txt = (EditText) findViewById(R.id.pass_txt);
 
		// BUTTOn
		login_button = (Button) findViewById(R.id.login_button);
		login_button.setOnClickListener(LoginButtonClick);
 
 
		db_spinner = (Spinner) findViewById(R.id.db_spinner);
		spinnerArrayAdapter = new ArrayAdapter(this ,android.R.layout.simple_spinner_item);
		spinnerArrayAdapter.setDropDownViewResource(android.R.layout.simple_dropdown_item_1line);
		getDatabaseList();
		db_spinner.setAdapter(spinnerArrayAdapter);
	}
 
	public void showToastNotification(String  message) {
		Toast tmptoast = Toast.makeText(this, message, Toast.LENGTH_SHORT);
		tmptoast.show();
	}
	private OnClickListener LoginButtonClick = new OnClickListener() {
		@Override
		public void onClick(View v) {
			try {
				uid = Connect();
				if (uid > 0) {
					String succes ="successful login from "+ USERNAME+" using database "+DB_NAME;
					showToastNotification(succes);
				} else {
					String fail = "bad login or password from "+ USERNAME+" using database " +DB_NAME;
					showToastNotification(fail);
				}
			} catch (Exception e) {
				Log.i("------------------ LOGIN FAILED 1", e.toString());
			}
		}
	};
	public int Connect()
	{
		USERNAME = user_txt.getText().toString();
		PASSWORD = pass_txt.getText().toString();
		DB_NAME = db_spinner.getSelectedItem().toString();
		rpcClient = new XMLRPCClient(HOST+URL_COMMON );
		try {
 
				user = (String) rpcClient.call("login", DB_NAME, USERNAME, PASSWORD).toString();
				Log.i("------------------CURRENT USER ID  ", user);
				Object uid1 = Integer.parseInt(user);
				if (uid1 instanceof Integer)
					return (Integer) uid1;
			return -1;
		} catch (XMLRPCException e) {
			Log.i("------------------ LOGIN FAILED-XMLRPCException", e.toString());
			return -2;
		} catch (Exception e) {
			Log.i("------------------ LOGIN FAILED-EXCEPTION", e.toString());
			return -3;
		}
	}
	public void  getDatabaseList() {
		 rpcClient = new XMLRPCClient(HOST+URL_DB);
			Vector<Object> params = new Vector<Object>();
			Object result = null;
			try {
				 result= rpcClient.call("list", params);
			} catch (XMLRPCException e) {
				e.printStackTrace();
			}
			Object[] a = (Object[]) result;
			for (int i = 0; i < a.length; i++) {
			    if (a[i] instanceof String){
			    	spinnerArrayAdapter.add(a[i].toString());
			    	}
				}
		Log.i("------------------ getDatabaseList","4");
		if (a.length == 0) {
			showToastNotification("No database exist");
		}
	 }

voila le fichier xml (la vue) :

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"
    xmlns:tools="http://schemas.android.com/tools"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    tools:context=".MainActivity" >
 <TextView
        android:id="@+id/user_tv"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_alignParentLeft="true"
        android:layout_alignParentTop="true"
        android:layout_marginTop="22dp"
        android:text="user_tv" />
 
    <Button
        android:id="@+id/login_button"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_above="@+id/db_spinner"
        android:layout_centerHorizontal="true"
        android:text="connecter" />
 
    <Spinner
        android:id="@+id/db_spinner"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_alignParentBottom="true"
        android:layout_alignParentRight="true"
        android:layout_marginBottom="60dp" />
 
    <TextView
        android:id="@+id/pass_tv"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_alignLeft="@+id/user_tv"
        android:layout_below="@+id/user_tv"
        android:layout_marginTop="60dp"
        android:text="pass_tv" />
 
    <EditText
        android:id="@+id/pass_txt"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_alignBottom="@+id/pass_tv"
        android:layout_alignRight="@+id/db_spinner"
        android:ems="10" />
 
    <EditText
        android:id="@+id/user_txt"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_alignBottom="@+id/user_tv"
        android:layout_alignLeft="@+id/pass_txt"
        android:ems="10" >
 
        <requestFocus />
    </EditText>
 
</RelativeLayout>

merci d'avance

27/02/2013, 13h02
sinok

Citation:

02-27 11:14:04.323: E/AndroidRuntime(1055): Caused by: java.lang.NullPointerException 02-27 11:14:04.323: E/AndroidRuntime(1055): at com.example.client_android.MainActivity.getDatabaseList(MainActivity.java:122)

C'est plutôt explicite comme message...
27/02/2013, 15h37
mloukaddi

client android pour openerp

salut
j'ai tous fait code complet pas d'erreur mais toujours ça marche pas ??
27/02/2013, 16h13
sinok

Il serait préférable que tu revoies les bases de java avant de t'attaquer à quelque chose de complexe.

Quelle peut être la raison d'une NullPointerException?
27/02/2013, 19h52
mloukaddi

client android et openerp

oui d'accord je sait que c'est un exception pour l'objet initialise par la valeur null
mais je demande s'il ya de solution pour l'eviter /cett objet doit etre declarer comme null ou depart !!
merci d'avance
27/02/2013, 22h08
nicroman

Essaye d'imaginer comment le code réagit si une exception de type "XMLRPCException" a lieu pendant rpcClient.call("list", params); (ligne 117)

null ponterexception

bon j'essayer mais je vois pas la solution l'objet result doit l'initialiser par une valeur null ??

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
public void  getDatabaseList() {
		 rpcClient = new XMLRPCClient(HOST+URL_DB);
			Vector<Object> params = new Vector<Object>();
			Object result = null;
			try {
				 result= rpcClient.call("list", params);
			} catch (XMLRPCException e) {
				e.printStackTrace();
			}
			Object[] a = (Object[]) result;
			for (int i = 0; i < a.length; i++) {
			    if (a[i] instanceof String){
			    	spinnerArrayAdapter.add(a[i].toString());
			    	}
				}
		Log.i("------------------ getDatabaseList","4");
		if (a.length == 0) {
			showToastNotification("No database exist");
		}

01/03/2013, 13h24
nicroman
Code:

Object result = null;

"result" est donc null
Code:

1 2 3 try { result= rpcClient.call("list", params); } catch (XMLRPCException e) {
Une exception se produit dans rpcClient.call... donc on rentre dans le "catch"
Code:

1 2 3 e.printStackTrace(); }
Qui dit... affiche le dans System.out (et non dans le LogCat... à remplacer d'urgence par Log.e("MONTAGAMOI","Erreur Soap",e); ) et continue qand même (déjà là y a un problème... pourquoi vouloir continuer ?)
Code:

1 2 Object[] a = (Object[]) result;
Cast d'un objet null => "a" est donc null

Code:

for (int i = 0; i < a.length; i++) {

Et bim... on utilise "a.length"... mais a est null !! donc NullPointerException...

slt:ccool:;
c'est obliger de passe par null sinon le compilateur signaler une erreur d'esxeption ? en initialise la liste des base de donnee existe sur openerp server .cett objet doit charger les base de donne existe dans le serveur
c'est pour ca on utilise cette objet??
apres l'execution

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
03-01 14:59:15.771: E/MONTAGAMOI(900): Erreur Soap
03-01 14:59:15.771: E/MONTAGAMOI(900): org.xmlrpc.android.XMLRPCException: android.os.NetworkOnMainThreadException
03-01 14:59:15.771: E/MONTAGAMOI(900): 	at org.xmlrpc.android.XMLRPCClient.callEx(XMLRPCClient.java:331)
03-01 14:59:15.771: E/MONTAGAMOI(900): 	at org.xmlrpc.android.XMLRPCClient.call(XMLRPCClient.java:377)
03-01 14:59:15.771: E/MONTAGAMOI(900): 	at com.example.client_android.MainActivity.getDatabaseList(MainActivity.java:116)
03-01 14:59:15.771: E/MONTAGAMOI(900): 	at com.example.client_android.MainActivity.onCreate(MainActivity.java:64)
03-01 14:59:15.771: E/MONTAGAMOI(900): 	at android.app.Activity.performCreate(Activity.java:5104)
03-01 14:59:15.771: E/MONTAGAMOI(900): 	at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1080)
03-01 14:59:15.771: E/MONTAGAMOI(900): 	at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2144)
03-01 14:59:15.771: E/MONTAGAMOI(900): 	at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2230)
03-01 14:59:15.771: E/MONTAGAMOI(900): 	at android.app.ActivityThread.access$600(ActivityThread.java:141)
03-01 14:59:15.771: E/MONTAGAMOI(900): 	at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1234)
03-01 14:59:15.771: E/MONTAGAMOI(900): 	at android.os.Handler.dispatchMessage(Handler.java:99)
03-01 14:59:15.771: E/MONTAGAMOI(900): 	at android.os.Looper.loop(Looper.java:137)
03-01 14:59:15.771: E/MONTAGAMOI(900): 	at android.app.ActivityThread.main(ActivityThread.java:5039)
03-01 14:59:15.771: E/MONTAGAMOI(900): 	at java.lang.reflect.Method.invokeNative(Native Method)
03-01 14:59:15.771: E/MONTAGAMOI(900): 	at java.lang.reflect.Method.invoke(Method.java:511)
03-01 14:59:15.771: E/MONTAGAMOI(900): 	at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:793)
03-01 14:59:15.771: E/MONTAGAMOI(900): 	at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:560)
03-01 14:59:15.771: E/MONTAGAMOI(900): 	at dalvik.system.NativeStart.main(Native Method)
03-01 14:59:15.771: E/MONTAGAMOI(900): Caused by: android.os.NetworkOnMainThreadException
03-01 14:59:15.771: E/MONTAGAMOI(900): 	at android.os.StrictMode$AndroidBlockGuardPolicy.onNetwork(StrictMode.java:1117)
03-01 14:59:15.771: E/MONTAGAMOI(900): 	at java.net.InetAddress.lookupHostByName(InetAddress.java:385)
03-01 14:59:15.771: E/MONTAGAMOI(900): 	at java.net.InetAddress.getAllByNameImpl(InetAddress.java:236)
03-01 14:59:15.771: E/MONTAGAMOI(900): 	at java.net.InetAddress.getAllByName(InetAddress.java:214)
03-01 14:59:15.771: E/MONTAGAMOI(900): 	at org.apache.http.impl.conn.DefaultClientConnectionOperator.openConnection(DefaultClientConnectionOperator.java:137)
03-01 14:59:15.771: E/MONTAGAMOI(900): 	at org.apache.http.impl.conn.AbstractPoolEntry.open(AbstractPoolEntry.java:164)
03-01 14:59:15.771: E/MONTAGAMOI(900): 	at org.apache.http.impl.conn.AbstractPooledConnAdapter.open(AbstractPooledConnAdapter.java:119)
03-01 14:59:15.771: E/MONTAGAMOI(900): 	at org.apache.http.impl.client.DefaultRequestDirector.execute(DefaultRequestDirector.java:360)
03-01 14:59:15.771: E/MONTAGAMOI(900): 	at org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.java:555)
03-01 14:59:15.771: E/MONTAGAMOI(900): 	at org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.java:487)
03-01 14:59:15.771: E/MONTAGAMOI(900): 	at org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.java:465)
03-01 14:59:15.771: E/MONTAGAMOI(900): 	at org.xmlrpc.android.XMLRPCClient.callEx(XMLRPCClient.java:263)
03-01 14:59:15.771: E/MONTAGAMOI(900): 	... 17 more
03-01 14:59:15.921: E/AndroidRuntime(900): FATAL EXCEPTION: main
03-01 14:59:15.921: E/AndroidRuntime(900): java.lang.RuntimeException: Unable to start activity ComponentInfo{com.example.client_android/com.example.client_android.MainActivity}: java.lang.NullPointerException
03-01 14:59:15.921: E/AndroidRuntime(900): 	at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2180)
03-01 14:59:15.921: E/AndroidRuntime(900): 	at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2230)
03-01 14:59:15.921: E/AndroidRuntime(900): 	at android.app.ActivityThread.access$600(ActivityThread.java:141)
03-01 14:59:15.921: E/AndroidRuntime(900): 	at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1234)
03-01 14:59:15.921: E/AndroidRuntime(900): 	at android.os.Handler.dispatchMessage(Handler.java:99)
03-01 14:59:15.921: E/AndroidRuntime(900): 	at android.os.Looper.loop(Looper.java:137)
03-01 14:59:15.921: E/AndroidRuntime(900): 	at android.app.ActivityThread.main(ActivityThread.java:5039)
03-01 14:59:15.921: E/AndroidRuntime(900): 	at java.lang.reflect.Method.invokeNative(Native Method)
03-01 14:59:15.921: E/AndroidRuntime(900): 	at java.lang.reflect.Method.invoke(Method.java:511)
03-01 14:59:15.921: E/AndroidRuntime(900): 	at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:793)
03-01 14:59:15.921: E/AndroidRuntime(900): 	at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:560)
03-01 14:59:15.921: E/AndroidRuntime(900): 	at dalvik.system.NativeStart.main(Native Method)
03-01 14:59:15.921: E/AndroidRuntime(900): Caused by: java.lang.NullPointerException
03-01 14:59:15.921: E/AndroidRuntime(900): 	at com.example.client_android.MainActivity.getDatabaseList(MainActivity.java:122)
03-01 14:59:15.921: E/AndroidRuntime(900): 	at com.example.client_android.MainActivity.onCreate(MainActivity.java:64)
03-01 14:59:15.921: E/AndroidRuntime(900): 	at android.app.Activity.performCreate(Activity.java:5104)
03-01 14:59:15.921: E/AndroidRuntime(900): 	at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1080)
03-01 14:59:15.921: E/AndroidRuntime(900): 	at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2144)
03-01 14:59:15.921: E/AndroidRuntime(900): 	... 11 more

merci d'avance

02/03/2013, 01h44
sinok

Tu essaies de faire un appel réseau dans le main Thread (responsable de la partie UI), chose qui est interdite.

03-01 14:59:15.771: E/MONTAGAMOI(900): Caused by: android.os.NetworkOnMainThreadException

Ton appel à

Code:

rpcClient.call("list", params);

devrait être fait dans un
thread séparé
05/03/2013, 16h45
mloukaddi

slt
mais qui ce que je doit faire et comment eviter le probleme ?
05/03/2013, 16h46
nicroman

Sinok t'as répondu:

Citation:

Envoyé par sinok

Ton appel à

Code:

rpcClient.call("list", params);

devrait être fait dans un
thread séparé

Utiliser une AsyncTask peut aider....