Problem in integrating Android application with Postgresql database

[ashish nayal]

I am developing a Android application with target Android 2.1.

In this application I try to integrate my application with Postgresql
database using jdbc driver.

But on running android emulator I am getting this error:

Caused by: java.lang.NoClassDefFoundError: org.postgresql.Driver

[Dave Cramer]

Hi,

You need the postgresql driver jar in your classpath.

Dave Cramer

[ashish nayal]

I have added postgresql jdbc driver in my android application using
following method:

MyAndroidProject->Properties->Java Build Path->Add External Jar

Then I have tried following jdbc drivers:

postgresql-9.0-801.jdbc4.jar
postgresql-9.0-801.jdbc3.jar
postgresql-8.3-606.jdbc4

But None of them work.

Also I have added in my application AndroidManifest.xml file following
line:

<uses-permission android:name="android.permission.INTERNET" />

But still it is not working.

Please let me know if I have to do any other setting to run this
application.

[Dave Cramer]

Hi,

Well the error is saying it can't find it, and it is in the jar. I am
not familiar with android programming enough to be helpful at this
point.

Dave Cramer

[ashish nayal]

Hi Dave,

I have also tried the the postgresql.jar you have developed but still
it is not working.
Please help me out.

Regards,
Ashish

On May 16, 5:17 pm, Dave Cramer <davecra...@gmail.com> wrote:
> Hi,
>

[edir...@gmail.com]

Hi I've did it, and it works fine, let me arrive 2 my office, and I will help U. #LUV
Enviado desde mi oficina móvil BlackBerry® de Telcel

[ashish nayal]

Hi edirav,

Please let me know the steps that i have to do to work this out.

Regards,
Ashish

[paxau10]

Hi! today i was trying to do a simple connectios to my postgre database using android and i got the same problem. could you please telme me how did you solve the problem? best regards paxau

[Michael Welter]

pg_hba.conf correct?

[paxau10]

it has a default configuration! but this has any relatuinship with the driver?

[Michael Welter]

pg_hba.conf must be configured to allow TCP communication with external devices.

[paxau10]

could you plesse tel me the steps that i've to follow?

Domingo, 18 de Novembro de 2012 16:29:53 UTC-1, mike escreveu:

[Michael Welter]

Read the pg_hba.conf file

[paxau10]

 i add  the folowwing host    all             all             0.0.0.0/0            trust

and   this is my ph_hba.comf,
# TYPE  DATABASE        USER            ADDRESS                 METHOD

# IPv4 local connections:
host    all             all             127.0.0.1/32            md5
host    all             all             0.0.0.0/0            trust
# IPv6 local connections:
host    all             all             ::1/128                 md5
# Allow replication connections from localhost, by a user with the
# replication privilege.
#host    replication     postgres        127.0.0.1/32            md5
#host    replication     postgres        ::1/128                 md5


# TYPE  DATABASE        USER            ADDRESS                 METHOD

# IPv4 local connections:
host    all             all             127.0.0.1/32            md5
host    all             all             0.0.0.0/0            trust
# IPv6 local connections:
host    all             all             ::1/128                 md5
# Allow replication connections from localhost, by a user with the
# replication privilege.
#host    replication     postgres        127.0.0.1/32            md5
#host    replication     postgres        ::1/128                 md5

[paxau10]

every time i try to connect to de database, i got  de classNotfoundExceptiom org.postgres.Driver.

if i create a java aplicatio , i can get data from my database. but in android app app a can not.

Domingo, 18 de Novembro de 2012 18:56:58 UTC-1, mike escreveu:

[Dave Cramer]

Then you are not putting it in the classpath correctly.

Dave

Dave Cramer

[paxau10]

hi! i can send
you my project,maybe there you can see what is wrong.

thanks in advance

[Dave Cramer]

I haven't worked with android in quite a while, but sure, if I have time I'll look at it.

Dave

Dave Cramer

[paxau10]

hei Dave, here is my project. it is a simple one , i´m just trying to connect to my postgre database  but  hwen i run as android app it thros a exception, classDriveNotFound.
my postgre version is 9.2 and the target API is 15(android 4.1)

best regards,  Isack

[Jasson Faerron Chavarria]

Help i have the same problem i can`t conect with postgresql :(............ i did every what do u said but still doesn`t work!!!!!!

[Dave Cramer]

What exactly did you do. Adding the driver to the libraries should be all that is required

Dave Cramer

--
You received this message because you are subscribed to the Google Groups "PgAndroid" group.
To unsubscribe from this group and stop receiving emails from it, send an email to pgandroid+...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

[Michael Welter]

You must first cause the PostgreSQL driver to be loaded.  Use the following statement:

Class.forName( "org.postgresql.Driver" );

--

[Dave Cramer]

Sorry I presumed the OP was doing that at least.

Dave Cramer

[Jasson Faerron Chavarria]

I got it jus check the JDBC  in “Properties > Java Build Path > Order and Export”, and check all the references you want exported" i dont know but is associated to ADT 17.... and i read it in this page http://android.foxykeep.com/dev/how-to-fix-the-classdefnotfounderror-with-adt-17

IT WORKS TY EVERYONE!!!!!

[nihar srivastav]

Hi I am trying to connect a simple Android App to Postgresql database and its giving an error - java.sql.Sqlexception  No suitable driver .. .Can you please help out. We have tried everything and it looks like people have got this working. 

Your expertise will be highly appreciated

Thanks so much for the help 

[David Caplin]

I had a similar issue, and spent weeks trying to solve it, assuming you still need an answer, run the whole Postgresql request under an AsyncTask instead of the main activity. Seemed to work for me. Hope this is useful for you if you still need it, or anyone else who stumbles upon it with the same error

-Skip