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>"+
"<title>DataBase</title>"+
"</head>"+
"<body>"+
"<h1>DataBase 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("<th><b>id</b></th>");
out.println("<th><b>country_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
