I don't have any insight to help in terms of answering your question
about using a JDBC driver from Android, but would offer one
suggestion: don't try it to begin with.
You would probably be a lot better off connecting to a server using
XML over HTTP (RESTy) or such, and then doing your JDBC stuff on the
*server*. Write your own RESTy DAL API on the server side, and connect
to that from Android - a lot more performant (and easier to maintain
going forward, decoupling), and you can control all the data aspects
on the server using any library or technology you want.
Going directly from the Android client to a database server over JDBC
is going to be problematic, and even if you do get it to work, a lot
more overhead than using a server. Remember it's a small embedded
device.
On Apr 23, 3:38 am, scimitar <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I'm trying to connect to an external mysql database. The code is
> something like:
>
> try
>
>
>
> > {
> > Class.forName(DBCLASS).newInstance();
> > }
> > catch (Exception e)
> > {
> > Log.i("DataLayer", "unable to load jdbc driver");
> > }
> > // Connect to the database
> > //
> > jdbc:mysql://[hostname][,failoverhost...][:port]/[dbname][?param1=value1][¶m2=value2].....
>
> > try
> > {
> > connection = DriverManager.getConnection(
> > DBCONNSTRING + DBHOST + "/" + DBNAME + "?user=" + USER +
> > "&password=" + PASSWORD);
>
> > }
> > catch (Exception e)
> > {
>
> > }
>
> Basically the 'DriverManager.getConnection()' call fails. The error
> messages are:
>
> D/dalvikvm( 596): Exception Ljava/lang/ClassNotFoundException; from
>
>
>
> > PathClassLoader.java:205 not caught locally
> > D/dalvikvm( 596): NOTE: loadClass 'java.sql.NClob' 0x40069968 threw
> > an exception
> > D/dalvikvm( 596): Exception Ljava/lang/ClassNotFoundException; from
> > PathClassLoader.java:205 not caught locally
> > D/dalvikvm( 596): NOTE: loadClass
> > 'com.mysql.jdbc.LocalizedErrorMessages_en_US' 0x40069968 threw an
> > exception
> > D/dalvikvm( 596): Exception Ljava/lang/ClassNotFoundException; from
> > PathClassLoader.java:205 not caught locally
> > D/dalvikvm( 596): NOTE: loadClass
> > 'com.mysql.jdbc.LocalizedErrorMessages_en' 0x40069968 threw an exception
> > I/dalvikvm-heap( 596): GC! (75 sec since last GC)
> > I/dalvikvm-heap( 596): GC old usage 90.6%; now 0.985MB used / 1.971MB
> > soft max (2.062MB real max)
> > I/dalvikvm-heap( 596): GC freed 1736 objects / 106824 bytes in 56ms
> > D/dalvikvm( 596): Exception Ljava/lang/ClassNotFoundException; from
> > PathClassLoader.java:205 not caught locally
> > D/dalvikvm( 596): NOTE: loadClass
> > 'com.mysql.jdbc.LocalizedErrorMessages' 0x40069968 threw an exception
> > D/dalvikvm( 596): Exception Ljava/lang/ClassNotFoundException; from
> > PathClassLoader.java:205 not caught locally
> > D/dalvikvm( 596): NOTE: loadClass
> > 'com.mysql.jdbc.LocalizedErrorMessages_en_US' 0x40018950 threw an
> > exception
> > D/dalvikvm( 596): Exception Ljava/lang/ClassNotFoundException; from
> > PathClassLoader.java:205 not caught locally
> > D/dalvikvm( 596): NOTE: loadClass
> > 'com.mysql.jdbc.LocalizedErrorMessages_en' 0x40018950 threw an exception
> > D/dalvikvm( 596): Exception Ljava/lang/ClassNotFoundException; from
> > PathClassLoader.java:205 not caught locally
> > D/dalvikvm( 596): NOTE: loadClass
> > 'com.mysql.jdbc.LocalizedErrorMessages' 0x40018950 threw an exception
> > D/dalvikvm( 596): Exception Ljava/lang/RuntimeException; from
> > Messages.java:68 not caught locally
> > W/dalvikvm( 596): Exception Ljava/lang/RuntimeException; thrown
> > during Lcom/mysql/jdbc/Messages;.<clinit>
> > D/dalvikvm( 596): Exception Ljava/lang/ExceptionInInitializerError;
> > from Util.java:350 not caught locally
> > W/dalvikvm( 596): Exception Ljava/lang/ExceptionInInitializerError;
> > thrown during Lcom/mysql/jdbc/Util;.<clinit>
> > D/dalvikvm( 596): Exception Ljava/lang/ExceptionInInitializerError;
> > from ViewRoot.java:964 not caught locally
> > D/dalvikvm( 596): Exception Ljava/lang/ExceptionInInitializerError;
> > from ZygoteInit.java:1555 not caught locally
>
> I would really appreciate if somebody could help me.
>
> thanks.
--~--~---------~--~----~------------~-------~--~----~
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]
Announcing the new M5 SDK!
http://android-developers.blogspot.com/2008/02/android-sdk-m5-rc14-now-available.html
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
-~----------~----~----~----~------~----~------~--~---
