Welcome!

Welcome to the official BlackBerry Support Community Forums.

This is your resource to discuss support topics with your peers, and learn from each other.

inside custom component

Web and WebWorks Development

Reply
axg
Contributor
axg
Posts: 10
Registered: ‎04-20-2012
My Device: PlayBook

SQlite SECURITY_ERR: DOM Exception 18

I am having problems with SQLite database creation on BB OS 6.0. Same code works fine on 7.0 and 7.1 devices

Here is my code. Error is thrown when I try to open the database in the try block

 

if (!window.openDatabase) {
    alert('This device does not have HTML5 Database support');
} else {
   try{
       _db = window.openDatabase("NextGenDB", "1.0", "NextGen Database", 5 * 1024);
    }catch(error){
    failureCreateDB(error);
    }
}

 

Error: SECURITY_ERR: DOM Exception 18
I am simulating having a SD Card is inserted.
I have made sure device is not in mass storage mode.
I have tried couple of different OS versions: 6.0.0.541, 6.0.0.703

Retired
astanley
Posts: 1,382
Registered: ‎07-02-2009
My Device: BlackBerry Bold 9900
My Carrier: Bell

Re: SQlite SECURITY_ERR: DOM Exception 18

As I recall, there were some bugs being worked out along the way which you may be running in to. I think Web DB API was not fully supported until later versions of BBOS 6.  

 

Otherwise, are you seeing the error the 1st time the DB already is being created or the 2nd time you're running this code?

 

I wrote this sample once upon a time.  Curious if there is anything in here that could help you?

http://blackberry.github.io/WebWorks-Samples/kitchenSink/html/html5/db.html

Follow me on Twitter: @n_adam_stanley
-------------------------------------------------------------------------------------------------------------------------
Your app doesn't work? Use BlackBerry remote web inspector to find out why.
axg
Contributor
axg
Posts: 10
Registered: ‎04-20-2012
My Device: PlayBook

Re: SQlite SECURITY_ERR: DOM Exception 18

I ran clean.bat in the simulator but no luck. I read about Webworks and OS 6 talked issue till version 6.0.0.448. So I tried higher OS versions but nothing is helping. I'll try your sample app.
Retired
astanley
Posts: 1,382
Registered: ‎07-02-2009
My Device: BlackBerry Bold 9900
My Carrier: Bell

Re: SQlite SECURITY_ERR: DOM Exception 18

Okay, good luck. Let us know if you find a solution or can explain the problem further.

Follow me on Twitter: @n_adam_stanley
-------------------------------------------------------------------------------------------------------------------------
Your app doesn't work? Use BlackBerry remote web inspector to find out why.
axg
Contributor
axg
Posts: 10
Registered: ‎04-20-2012
My Device: PlayBook

Re: SQlite SECURITY_ERR: DOM Exception 18

We don't have a resolution for this yet and neither do we know the cause but here are some more of our findings:

 

My colleague created a simple HelloWorld app and built it with Webworks and tried running it on 9780 OS v6.0.0.703 but it failed. With the same app was hosted on our server, we tried to access the app from the device browser, it works. So SQLite is supported on the device.

 

Same app when built with PhoneGap works on the device. We have couple of extensions in our app and need to make sure they work fine before we make the decision of moving over to PhoneGap from WebWorks.

 

I was trying couple of different devices and OS versions. These are from simulators and I need to verify it on the device. Probably from this, we can separate out the devices with 256MB memory and concentrate on others. We are still looking into this issue.

 

Model

Onboard memory

OS version

Result

9650

512 MB

6.0.0.707

Works

9700

256 MB

6.0.0.723

Throws DOM 18 exception.

9780

512 MB

6.0.0.534

App loads but gets stuck at the point where we try to create a DB

9300

256 MB

6.0.0.723

Throws DOM 18 exception.

9330

512 MB

6.0.0.436. Simulator not available above v6.0.0.448

Throws DOM 18 exception.

9100

256 MB

Did not try

--

9670

512 MB

Simulator not available above v6.0.0.448

--

9800

512 MB

6.0.0.534

Works

axg
Contributor
axg
Posts: 10
Registered: ‎04-20-2012
My Device: PlayBook

Re: SQlite SECURITY_ERR: DOM Exception 18

Edit: 9330 Throws DOM 18 exception for a higher version as well (v6.0.0.706)