Remote Database access in BB native App

[ssadiq19]

Dear all,

I am getting problem in accessing remote database contents in blackberry native application.

Application works fine in chrome but when i compile with webworks as native app it failed to load data and no exception just wait for long and white screen.

I also tried kitchensink and geocongress which works fine in emulator, chrome but failed when running in simulator.

I am using BB OS7 Webworks 2.3

I hope someone definately has a soultion for this. It is creating stress for me.

Any working code sample will be highly appreciated.

[mitchellsimoens]

I am getting problem in accessing remote database contents in blackberry native application.

What database and how are you accessing?

[ssadiq19]

I am using sql server and accessing data through Handler.ashx file. where Handler.ashx returns result as json string

([{"Id":1,"name":"n1","Quantity":"30"},{"Id":2,"name":"n2","Quantity":"80"},{"Id":3,"name":"n3","Quantity":"90"},{"Id":4,"name":"n4","Quantity":"100"},{"Id":5,"name":"n5","Quantity":"25"}])
Ext.define('MyApp.store.MyStore', {
extend: 'Ext.data.Store',


config: {
pageSize: 5,
storeId: 'MyStore',
proxy: {
type: 'jsonp',
extraParams: {
p: '1'
},
limitParam: 'rpp',
url: "http://myURL/DB/Handler.ashx",
reader: {
type: 'json',
rootProperty: 'results'
}
},
fields: [
{
name: 'name'
},
{
name: 'Quantity'
}
]
}
});

it works fine in chrome brower. but does not display anything when compiled as native app in webworks

here is config.xml

<?xml version="1.0" encoding="UTF-8"?>
<widget xmlns="http://www.w3.org/ns/widgets"
xmlns:rim="http://www.blackberry.com/ns/widgets"
version="1.0" rim:header="WebWorks Sample">

<name>My App</name>
<access subdomains="true" uri="*"/>
<description>MyApp.</description>
</widget>

[ssadiq19]

i am using *.ashx file which is fetching info from sql server DB and converting result into JSON format