Java Development

[bskania]

Hello,

I am a newbe in the development of blackberry application.

I want to connect to postgresql database from my blackberry app.

I am getting the JAR file for that from postgresql.

But I am not getting full java support in blackberry for connection to the Postgresql.

So If any one having Idea.

Pls Let me know how can I connect to postgresql.

Thanks In advance,

bskania.

[peter_strange · Accepted solution]

Welcome to the BlackBerry Java forum.

I presume that you have obtained a jar that will interface between Java and postgre,  Unless this has been specifically written fro BlackBerry devices, then this will not work on BlackBerry unfortunately.  The code I suspect you have got will work only on Java SE environments, not Java ME.

The usual solution to this sort of problem is to write a middleware application, that takes http requests from the Blackberry converts these to the required SQL, runs the SQL, then formats the data for transmission back to the Blackberry.  This sort of solution is required for all databases, unless you purchase a middle ware product that has already been built - and the only one of these that I an aware of is the Sybase offering for iSQLAnywhere.    You will find other peoples comments if you search the forum, I would suggest searching for "SQL Server".

Good luck.

[bskania]

Thanks for you reply.

So In that case I can go with webservices? If I dont want to purchase any middleware.

[peter_strange · Accepted solution]

That is correct.

It is usually not that difficult to do, as long as you have a relatively simple database structure and not too much data to pass around. 

Edit:

Should have said it earlier - welcome to the forum!