[android-developers] failure to connect to database

[scimitar]

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][&param2=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
-~----------~----~----~----~------~----~------~--~---