Hi, thanks for your reply. But I really have no choice in this matter.
Using JDBC is my best bet here, and I would appreciate if somebody
could tell me what's going on.
On Apr 23, 2:56 pm, Charlie Collins <[EMAIL PROTECTED]> wrote:
> 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 adatabaseserver 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 mysqldatabase. The code is
> > something like:
>
> > try
>
> > > {
> > > Class.forName(DBCLASS).newInstance();
> > > }
> > > catch (Exception e)
> > > {
> > > Log.i("DataLayer", "unable to load jdbc driver");
> > > }
> > > // Connect to thedatabase
> > > //
> > > 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 android-developers@googlegroups.com
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
-~----------~----~----~----~------~----~------~--~---
