[android-developers] Android database

2012-03-27 Thread Kirupa
How can we access database of a android application(in android phone)
from another database of a same android application but another
android phone through the Bluetooth.(same application, same
database but different android phone)

-- 
You received this message because you are subscribed to the Google
Groups Android Developers group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en


[android-developers] android database connectivity problem

2012-03-20 Thread Ritam Roy Choudhury
Hi,

I am trying to do a database connectivity in my android emulator, the
problem is i am doing a servlet program that includes a sqlite
connectivity in it.

After compiling the java files,generating the classes.dex, I am adding
META-INF and classes.dex into a classes.zip file with the respective
jars in the lib directory.Later a war file is generated from (WEB-
INF,META-INF,index.html  the database file).The war is then uploaded.

But when i download the war file and run it from the i-jetty server, I
am getting the following error: org.sqlite.jdbc
java.lang.ClassNotFound Exeption.

The jars have been uploaded in the android emulator by an application
written in an activity class along with the respective database i am
trying to work on.

It is working properly on the Jetty server with the class paths set
with the jars and classes,but not on the I-Jetty server in the phone.

Eventually the I-Jetty server is able to run all servlet programs that
doesn't include a database connectivity.

I have tried to do the database connectivity with hsqldb database but
the result is the same.

I have been trying for days but couldn't get this database
connectivity from my android emulator working, Could anyone please
help me, Here is my code,

try{
 out.println(html+
 head+
 titleDataBase/title+
 /head+
 body+
 h1DataBase tbl_countries : /h1);
 Class.forName(org.sqlite.JDBC);
 //Class.forName(SQLite.JDBCDriver).newInstance();
 Connection conn
=DriverManager.getConnection(jdbc:sqlite:webapps/DbTest/
TestData.db);
 Statement stat=conn.createStatement();
 stat.executeUpdate(drop table if exists tbl_countries;);
 stat.executeUpdate(create table tbl_countries (id INTEGER
PRIMARY KEY AUTOINCREMENT, country_name TEXT););
 PreparedStatement prep = conn.prepareStatement(insert into
tbl_countries(country_name) values (?););
 prep.setString(1, Australia);
 prep.addBatch();
 prep.setString(1, Srilanka);
 prep.addBatch();
 prep.setString(1, USA);
 prep.addBatch();
 conn.setAutoCommit(false);
 prep.executeBatch();
 conn.setAutoCommit(true);
 out.println(table border=1);
 out.println(tr);
 out.println(thbid/b/th);
 out.println(thbcountry_name/b/th);
 out.println(/tr);
 ResultSet rs = stat.executeQuery(select * from
tbl_countries;);
 while (rs.next())
{
 out.println(tr);
 out.println(td+rs.getString(id)+/
td);
 
out.println(td+rs.getString(country_name)+/td);
 out.println(/tr);
}
 rs.close();
 conn.close();
   }
   catch(Exception e)
   {
out.println(h2+e.getMessage()+/h2);
String str=e.toString();
out.println(h2+str+/h2);
}
   out.println(/table/body/html);
  }

Thanks,
Ritam Roy Choudhury

-- 
You received this message because you are subscribed to the Google
Groups Android Developers group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en


[android-developers] Android database problem while refering .sql file

2011-11-20 Thread Shajahan
If there are SQLite create/insert statements in .sql (eg.;
createtablestmt.sql) file  .then how it is called from Android Project

Am getting the error that no such table exits in the database ... and
also I dont see any CREATE table statements in the project.

Note :  am refering to some old project to get hold of this concept.

-- 
You received this message because you are subscribed to the Google
Groups Android Developers group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en

[android-developers] android database

2011-10-17 Thread Samuel
Hi,

I would like to start learning database programming in android.
What the best database and also free?
Do you have any recommendations of book regarding android database
programming?

Thanks alot,
Samuel

-- 
You received this message because you are subscribed to the Google
Groups Android Developers group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en


Re: [android-developers] android database

2011-10-17 Thread TreKing
On Mon, Oct 17, 2011 at 4:30 AM, Samuel jrl...@gmail.com wrote:


 I would like to start learning database programming in android.
 What the best database and also free?
 Do you have any recommendations of book regarding android database
 programming?


http://developer.android.com/reference/android/database/package-summary.html

-
TreKing http://sites.google.com/site/rezmobileapps/treking - Chicago
transit tracking app for Android-powered devices

-- 
You received this message because you are subscribed to the Google
Groups Android Developers group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en

[android-developers] android database remote access

2011-06-27 Thread kiran nayak
hi all
is it possible to access android database (sqlite) form a remote
client such as pc??

-- 
You received this message because you are subscribed to the Google
Groups Android Developers group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en


[android-developers] Android Database Example Error

2010-09-03 Thread ngreenwood6
I am not sure where to send this but I was hoping someone in this
group could help me. I was looking at this example
http://developer.android.com/guide/topics/data/data-storage.html#db.
If you look at the constructor it is named different than the class. I
assume this is a bug unless I am missing something. I thought that I
would point this out so that it can be fixed if need be to avoid any
confusion for future developers.

-- 
You received this message because you are subscribed to the Google
Groups Android Developers group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en


[android-developers] Android Database and PC Applications

2010-06-21 Thread Boardy
Hi all,

I am currently doing some research on a program that I would like to
develop for the Android platform. The android device will store
information for the program using the internal SQLite3 Database.

I also would like to to develop a program in either C# or Java
(preferably C#) that will synchronise the data between the android and
the PC.

The idea is that the PC application will get the data out of the
SQLite3 Database.

How can I get a PC application ideally in C# to be able to get the
information out of the android device, is there a way that I can use
the ADB without having to have the Android SDK installed on the PC.
Another way I was thinking is that the PC application runs a service
that I develop on the Android platform that exports the database into
a CSV file to be stored on the SD card, however, I am still going to
need to use ADB to get the data in order to avoid the user having to
put the phone into Disk Drive instead of Sync Mode.

Thanks for your help.

-- 
You received this message because you are subscribed to the Google
Groups Android Developers group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en


Re: [android-developers] Android Database and PC Applications

2010-06-21 Thread Mark Murphy
On Mon, Jun 21, 2010 at 10:30 AM, Boardy
board.christop...@googlemail.com wrote:
 How can I get a PC application ideally in C# to be able to get the
 information out of the android device, is there a way that I can use
 the ADB without having to have the Android SDK installed on the PC.

Have the Android application upload the data to a Web service.

Have the C# application use the Web service. Or replace the C# desktop
application with a Web application.

-- 
Mark Murphy (a Commons Guy)
http://commonsware.com | http://github.com/commonsguy
http://commonsware.com/blog | http://twitter.com/commonsguy

Android App Developer Books: http://commonsware.com/books

-- 
You received this message because you are subscribed to the Google
Groups Android Developers group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en


Re: [android-developers] Android Database and PC Applications

2010-06-21 Thread Steven Maitlall
There is a .NET Sync Framework that you could use with C#.

http://msdn.microsoft.com/en-us/sync/default.aspx

On Mon, Jun 21, 2010 at 10:33 AM, Mark Murphy mmur...@commonsware.comwrote:

 On Mon, Jun 21, 2010 at 10:30 AM, Boardy
 board.christop...@googlemail.com wrote:
  How can I get a PC application ideally in C# to be able to get the
  information out of the android device, is there a way that I can use
  the ADB without having to have the Android SDK installed on the PC.

 Have the Android application upload the data to a Web service.

 Have the C# application use the Web service. Or replace the C# desktop
 application with a Web application.

 --
 Mark Murphy (a Commons Guy)
 http://commonsware.com | http://github.com/commonsguy
 http://commonsware.com/blog | http://twitter.com/commonsguy

 Android App Developer Books: http://commonsware.com/books

 --
 You received this message because you are subscribed to the Google
 Groups Android Developers group.
 To post to this group, send email to android-developers@googlegroups.com
 To unsubscribe from this group, send email to
 android-developers+unsubscr...@googlegroups.comandroid-developers%2bunsubscr...@googlegroups.com
 For more options, visit this group at
 http://groups.google.com/group/android-developers?hl=en




-- 
Steven
Maraj
http://www.marajservices.com

-- 
You received this message because you are subscribed to the Google
Groups Android Developers group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en

[android-developers] Android Database

2010-02-25 Thread Julian
I am trying to create an application that reads information from a
database on a separate server(not the android phone).  Does anyone
have any information on how to create a database connector class?

-- 
You received this message because you are subscribed to the Google
Groups Android Developers group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en


Re: [android-developers] Android Database

2010-02-25 Thread Mark Murphy
Julian wrote:
 I am trying to create an application that reads information from a
 database on a separate server(not the android phone).  Does anyone
 have any information on how to create a database connector class?

Write a Web service that connects to the database and runs on some
server, then access the Web service from the phone. I recommend
REST-style APIs, since Android does not have built-in support for SOAP
or XML-RPC.

-- 
Mark Murphy (a Commons Guy)
http://commonsware.com | http://twitter.com/commonsguy

Warescription: Three Android Books, Plus Updates, One Low Price!

-- 
You received this message because you are subscribed to the Google
Groups Android Developers group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en


[android-developers] Android Database connectivity program

2008-11-04 Thread Nataraaj

Hello guys,

 I want to connect android application with MS - SQL Server,
where can i get sample code for this?

Plz provide me with an web link for the source.

Regards,
Ram Nataraaj

--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google
Groups Android Developers group.
To post to this group, send email to android-developers@googlegroups.com
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
-~--~~~~--~~--~--~---