RE: Unable to connect to database

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Although, even if the problem is sorted, it appears that you have an
erratic JVM problem. Having -i off should not cause your JVM to dump
core. On RH7.1 I know that I have to set LD_ASSUME_KERNEL=2.2.5 in
my java script, as not having it causes quite a few *erratic*
problems. You might want to check whether or not you need this
(Linux only, I think, and although I picked it up through the RH7.1
README (and some help from Trond ;-), I'm sure that there are other
distributions that require it, and it's possible that recent BSDs
using a Linux JVM might also require it).

Cheers...

MikeA

>> -----Original Message-----
>> From: Peter Rogers [mailto:peterarogers(at)earthlink(dot)net]
>> Sent: 19 August 2001 22:51
>> To: Lucas, Fred
>> Cc: pgsql-jdbc(at)postgresql(dot)org
>> Subject: Re: [JDBC] Unable to connect to database
>>
>>
>> Hi Fred--
>>
>> Thanks -- that was it! I can now connect to the database.
>>
>> Also thanks to everyone else to responded to my post.
>>
>> --Pete Rogers
>>
>>
>>
>> > "Lucas, Fred" wrote:
>> >
>> > Peter,
>> > The JDBC requires TCP/IP sockect to connect to
>> Postgresql, Are you
>> > running the postmaster with the -i switch? You may have
>> this already
>> > setup. I just wanted to pass it along
>> >
>> > Fred
>> >
>> > -----Original Message-----
>> > From: Peter Rogers [mailto:peterarogers(at)earthlink(dot)net]
>> > Sent: Friday, August 17, 2001 2:27 PM
>> > To: pgsql-jdbc(at)postgresql(dot)org
>> > Subject: [JDBC] Unable to connect to database
>> >
>> > Please have mercy on this poor beginner!
>> >
>> > I am totally new to both postgresql and jdbc, so I'm probably
>> > committing
>> > some very basic error, but I am unable to make a connection to
>> > my database via jdbc. I am using postgresql 7.1.2 which seems
>> > to be running OK (under Suse Linux 7.1); at least I can run the
>> > sample interactive scripts with pqsl. I built and installed
>> > jdbc
>> according
>> > to
>> > the instructions in the readme file, and I am using Java
>> 1.3. I used
>> > "createdb" to create my own database "petesdb" with username
>> > "progers".
>> > However, when I run the small piece of code below, the driver
>> > gets registered, but getConnection fails with a segmentation
>> > fault.
>> >
>> > import java.sql.*;
>> > import java.lang.reflect.*;
>> > import java.io.*;
>> > import java.util.*;
>> >
>> > public class TestDb
>> > {
>> >
>> > public static void main(String args[])
>> > {
>> > Connection db; // The connection to the database
>> > Statement st; // Our statement to run queries with
>> >
>> > try
>> > {
>> > // This line outputs debug information to stderr
>> > DriverManager.setLogStream(System.err);
>> >
>> > Class.forName("org.postgresql.Driver");
>> > System.out.println("Db driver OK");
>> >
>> > // Connect to database
>> > String url = "jdbc:postgresql:petesdb";
>> > String usr = "progers";
>> > String pwd = "petesdb_pwd";
>> > System.out.println("Connecting to Database URL =
>> " + url);
>> > db = DriverManager.getConnection(url, usr, pwd);
>> > System.out.println("Db connection OK");
>> >
>> > }
>> > catch(Exception e)
>> > {
>> > // your error handling code goes here
>> > System.out.println("Hey! no db driver or no db
>> connection");
>> >
>> > }
>> > }
>> > }
>> >
>> > The console output is as follows:
>> >
>> > DriverManager.initialize: jdbc.drivers = null
>> > JDBC DriverManager initialized
>> > registerDriver:
>> >
>> driver[className=org.postgresql.Driver,org(dot)postgresql(dot)Driver(at)4b222f
>> ]
>> > Db driver OK
>> > Connecting to Database URL = jdbc:postgresql:petesdb
>> > DriverManager.getConnection("jdbc:postgresql:petesdb")
>> > trying
>> >
>> driver[className=org.postgresql.Driver,org(dot)postgresql(dot)Driver(at)4b222f
>> ]
>> > Segmentation fault
>> >
>> > My thanks for any help anyone can offer.
>> >
>> > --Pete Rogers
>> >
>> > ---------------------------(end of
>> > broadcast)---------------------------
>> > TIP 2: you can get off all lists at once with the
>> unregister command
>> > (send "unregister YourEmailAddressHere" to
>> > majordomo(at)postgresql(dot)org)
>>
>> ---------------------------(end of
>> broadcast)---------------------------
>> TIP 4: Don't 'kill -9' the postmaster
>>

-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 6.5.3 for non-commercial use <http://www.pgp.com>

iQA/AwUBO4DeZXympNV/C086EQLJ3QCcDArs5YV+xl8pslpcG/9nMW3ica4AnRs1
MLA5a0k5SCEeNdmyVMcKeuA6
=brF8
-----END PGP SIGNATURE-----