Dear Goutham, I would like to reassure you that it is technically possible and it is practically workable to directly connect to an Oracle database from Android.
As long as you have a mind to secure the connection. On an internal network with Wi-Fi that is fine with WEP etc. With GPRS/3G it is best to make sure you use a SIM with a private corporate APN, or a device with a static IP address or from a known range so that you can nail down your internet router/gateway. Keep it simple - there is no need to build multiple and convoluted layers of middleware like REST services. For the "nay sayers":- Android contains and supports all standard JDBC connectivity. There are a range of commercial and free "desktop" database JDBC drivers (which contain no GUI references and so work quite happily with Android) that you can embed within your application. In fact this is what we have done with our MobiForms mobile rapid application development tool to enable the MobiForms client to connect directly to remote databases. For offline support we also offer the MobiForms Sync Server which allows data to be buffered in an Android HSQLDB database and then synchronised back via the remote MobiForms Sync Server to any database capable of JDBC connectivity such as Oracle, SQL Server, MySQL etc. The other advantages of our MobiForms Developer is that you do not have to use Eclipse, the Android SDK or write your own SQL cursors and result sets. For more information have a look at our web site: http://www.mobiforms.com. Kind regards, Tim @ MobiForms Goutham P N wrote: > Hi Everyone, > > I'm new to the android application development. I found some packages > java.sql and javax.sql packages in the API of android while going > through it. My doubt is can I access the Oracle Database directly > using drivers. So what type of driver is used to connect. > > Please any one reply me. > > Thanks & Regards. -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
