android WebView HTML5 access database problem

Question

i am work at an app which Embed an WebView and display a HTML5 page .

when open the html page in android chrome Browser.the database was create normal.

but when i run this app , the database can not create . it seem that html page can not create the database on WebView.

anybody know why?

here is my Activity code:

 public class efan_NewsReader extends Activity {
/** Called when the activity is first created. */
@Override
public void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.main);        
    WebView myWebView=(WebView)findViewById(R.id.my_webview);
    myWebView.setWebViewClient(new WebViewClient());
    WebSettings settings = myWebView.getSettings();  
    settings.setJavaScriptEnabled(true);
    settings.setDomStorageEnabled(true);
    settings.setDatabaseEnabled(true);
    settings.setAppCacheEnabled(false);        

    myWebView.loadUrl("http://10.10.35.47:8080/html5test/test.htm");

}}

here is my HTML5 page source code：

    <html manifest="mymanifest.manifest">
    <head>
<meta http-equiv="Content-Type" content="text/html; content="no-cache" charset=utf-8" />
<script type="text/javascript" src="js/jquery-1.6.1.min.js"></script>

<script>
$(document).ready(function(){       

    databaseTest();
});

function databaseTest(){


    //open database
     var db = openDatabase('mydb', '1.0', 'Test DB', 2 * 1024 * 1024);  

      db.transaction(function (tx) {            
      tx.executeSql('CREATE TABLE IF NOT EXISTS testHtml (id unique, contentText)');
      tx.executeSql('INSERT INTO testHtml (contentText) VALUES ("insert data test!")');  
       });  

     db.transaction(function(tx){           
     tx.executeSql('SELECT * FROM testHtml',[],function(tx,result){
            var len=result.rows.length;
            var msg = "<p>Found rows: " + len + "</p>";  
             $("#testinfo").append(msg);
        },null);
     });    


}

</script>


</head>
<body>
    <div>here is test info:</div>
    <div id="testinfo"></div>
</body>

ChristopheCVB · Accepted Answer · 2011-07-28 13:21:47Z

11

Try :

settings.setDatabaseEnabled(true);
String dbPath = this.getApplicationContext().getDir("database", Context.MODE_PRIVATE).getPath();
settings.setDatabasePath(dbPath);

And in WebChromeClient :

myWebView.setWebChromeClient(new WebChromeClient()
{
    @Override
    public void onExceededDatabaseQuota(String url, String databaseIdentifier, long currentQuota, long estimatedSize, long totalUsedQuota, WebStorage.QuotaUpdater quotaUpdater)
    {
        quotaUpdater.updateQuota(estimatedSize * 2);
    }
}

It should be OK ;)

answered Jul 28, 2011 at 13:21

ChristopheCVB

7,3031 gold badge31 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

JunM Over a year ago

I'm not sure what are the purpose of the lines after @Override but that saves my day. Thank you.

Dave S · Accepted Answer · 2013-06-27 14:07:26Z

new WebChromeClient() was throwing a constructor error so I did it this way. private WebView webView;

@Override
public void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);

    setContentView(R.layout.test_web);

    webView = (WebView) findViewById(R.id.webView1);


    webView.getSettings().setJavaScriptEnabled(true);
    webView.getSettings().setDatabaseEnabled(true);
    webView.getSettings().setDomStorageEnabled(true);
    //String sDataPath = "/data/data/" + webView.getContext().getPackageName() + "/databases/";
    String sDataPath = this.getApplicationContext().getDir("database", Context.MODE_PRIVATE).getPath();
    webView.getSettings().setDatabasePath(sDataPath);
    webView.getSettings().setDatabaseEnabled(true);
    webView.getSettings().setSavePassword(true);
    webView.getSettings().setAllowContentAccess(true);
    webView.getSettings().setAllowFileAccess(true);

    webView.setWebViewClient(new Callback());
    webView.setWebChromeClient(new webChromeClient());
    webView.loadUrl("http://www.yahoo.com");        
}

 private class Callback extends WebViewClient{  

        @Override
        public boolean shouldOverrideUrlLoading(WebView view, String url) {
            return (false);
        }

 }
 private class webChromeClient extends WebChromeClient
 {
     @Override
        public void onExceededDatabaseQuota(String url, String databaseIdentifier, long currentQuota, long estimatedSize, long totalUsedQuota, WebStorage.QuotaUpdater quotaUpdater) { 
         quotaUpdater.updateQuota(5 * 1024 * 1024); 
     }       
 }

onmyway133 · Accepted Answer · 2012-09-19 03:53:47Z

0

It's likely that the default quota is 0, so onExceededDatabaseQuota is a must

answered Sep 19, 2012 at 3:53

onmyway133

48.5k33 gold badges268 silver badges272 bronze badges

Collectives™ on Stack Overflow

android WebView HTML5 access database problem

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related