Can i use jdbc in android

And thanks in advance. Sujay 6, 2 2 gold badges 27 27 silver badges 49 49 bronze badges. Add a comment. Active Oldest Votes. Community Bot 1 1 1 silver badge. Jack Jack 8, 4 4 gold badges 45 45 silver badges 73 73 bronze badges. I don't know how you can consider this an answer. You don't recommend JDBC which supports native drivers for databases. And then you don't support web services. So tell me, what's the use of this "answer"? JohnMerlino He didn't ask for a web service implementation and I'm not going to fully code one here.

I did research and presented information. Show 3 more comments. Ali Ali 41 1 1 bronze badge. If you are trying to present complete code please make sure it compiles — Zannith. Arun Arun 1 1 silver badge 9 9 bronze badges. Do you want to keep your database on mobile? Use sqlite instead of mysql. Kamal Kamal 5, 8 8 gold badges 42 42 silver badges 57 57 bronze badges. Ofcourse you can create a web service using JSP.

Though if you are looking for a proper documented, professional and reusable solution, you can use any tool like RESTEasy. David Untama David Untama 3 3 silver badges 16 16 bronze badges. There is a open source pure-Java jdbc driver that should run on Android although I haven't tried it myself. You will have to adapt the JDBC URL to connect to the sqlite db; that way you can use the local android database while making few changes to your data access code. Change the Dirver Name and before import the lib file jtds 1.

Since this question has gotten a good deal of attention, I wanted to answer it and describe what I've learned and what worked for me to correct this problem in my large, database-driven application:. Do NOT use managed cursors. There's a reason why they're deprecated. They're completely problematic. Realistically, there's very few scenarios where you actually need to use a managed cursor anyway. Instead, run your query and populate an object with the results.

I close the cursor within the function and I'm done. This can also wreak havoc on your app's db connections. I thought I was doing this but, sure enough, found a spot that I wasn't explicitly closing a cursor. Communication link error mysql jdbc. Java jdbc mysql updatequery. Java jdbc database connection. JDBC connection string for oracle not connecting. Connect android app with website using WCF. Layout: fixed fluid. Web02 2. Strip HTML.

Encode HTML. Paste as-is. Code block. Quoted Text. Best guess. Optional Password.