I want to configure proxy using code.

amitnargund · by **amitnargund** » Mon Dec 29, 2008 12:29 pm

I know the command to configure the proxy settings:
adb shell sqlite3 /data/data/com.google.android.providers.settings/databases/settings.db "\"INSERT INTO system VALUES(99,'http_proxy','[HOST]:[PORT]');\""

But I want to configure this through the code.

Here is what I am doing

SQLiteDatabase db=SQLiteDatabase.openDatabase("/data/data/com.google.android.providers.settings/databases/settings.db", null, SQLiteDatabase.OPEN_READWRITE);
db.execSQL("INSERT INTO system VALUES(99,’http_proxy', 'host:port)");

But I am constantly getting the Exception cannot open the database.

Can anybody tell me where I am doing wrong.

Also I read somewhere that Android does not allow you to access settings.db outside the data/data/com.google.providers.settings package. Is that true??

MrSnowflake · by **MrSnowflake** » Mon Dec 29, 2008 1:51 pm

You shouldn't and can't do this using the database. Remember ContentProviders? This is where you use them.

This should help you:

Syntax: [ Download ] [ Hide ]

Using java Syntax Highlighting

 
Cursor Settings =getContentResolver().query(System.CONTENT_URI, new String[]{System.NAME, System.VALUE}, System.NAME+"=?", new String[]{System.HTTP_PROXY}, null);
 
if (Settings != null) { 
 
        if (Settings.moveToFirst()) {
 
                String proxyAddress = Settings.getString(Settings.getColumnIndex(System.VALUE));
 
        }
 
Settings.close();
 
Parsed in 0.031 seconds,  using GeSHi 1.0.8.4

Now you only should use the update function of the ContentProvider instead of the query command, but it works similarily.

You should also have the read write permission for system settings.

[edit]Fixed.

amitnargund · by **amitnargund** » Tue Dec 30, 2008 6:42 am

Thanks for the reply!

I would like to know what mSetting? It is object of which class?

I want to configure proxy using code.

I want to configure proxy using code.

Who is online