How to create a database connectivity sqlserver2000 through J2ME.

Question

I want some helps from the professional people who know a lot in the J2Me. I work on a mobile application that the user will be stored and retreve the data from the database using sqlserver 2000.

i am new in this area ( J2ME ) and I don’t know a lot, so I want help to finish this application, please...

one more, j2me is not directly support the database connectivity for that purpose we can achive with the help of servlets.

insted of servlets can we use JSP's for databaseconnectvity. please tell any one.

Answer 1

Using servlets or JSPs is your call, you can use either. Also you need to ensure that you return only very minimal data, say maybe content of 20 to 50 rows depending upon the rows size. Dont send XML or other textual data, rather send them as a binary stream which you can create using the DataOutputStream class.

Answer 2

There is no standard JDBC on J2ME.

The typical implementation of what you are trying to do is to have your J2ME client make HTTP requests to a remote server.

The body of the request is made up of your own data transfer and security protocol.

The remote server decodes the request body, creates an SQL request, runs it on SQLServer, encodes the result, sends it to the J2ME client as a reply to the initial http request.

The J2ME client is then free to decode and process the SQL request result in any way it likes.

Answer 3

If I want to send the data from MSSQL using C# language, which format should I use? I mean should I use window services or web services or asp.net? My problem is like sunneetha. The different is I want to use the C# code for the server side. Please kindly give me some instruction! Thank you

Answer 4

i need a j2me proj....

9711426368 is my cell

Answer 5

i need a code in j2me to connect to the database please help me if possibe my no is 9768593192 thanku nilesh