Re: No DB connection in Netscape ? Please help.
От | Kenny Freeman |
---|---|
Тема | Re: No DB connection in Netscape ? Please help. |
Дата | |
Msg-id | Pine.GSO.3.96.980814140901.16189C-100000@borg обсуждение исходный текст |
Ответ на | No DB connection in Netscape ? Please help. ("Kapoor, Nishikant X" <Nishikant.X.Kapoor@nspco.com>) |
Список | pgsql-general |
I could be on thin ice, but applets can only make connections to the site that they were loaded from. I noticed a security... something or other in the java console o/p (just a quick look). Maybe that explains why you can connect on one machine, and not the other.... On Fri, 14 Aug 1998, Kapoor, Nishikant X wrote: > Hello friends > > I have apache-1.1.3-3 and PostgreSQL-6.3.2 running on my Linux RH4.2, > kernel 2.0.30 (genx). I have a Java Applet that tries to connect to > PostgreSQL > using JDBC, from NS-4.5b1 on an IBM RISC6000, AIX-4.1.4 (mm01). > > Typing "mm01: netscape http://genx/PrfApplet.htm" brings up the applet > in the NS > but the database connection is not established. The Java console shows: > > openDb(PrfDb):Connecting to Database URL = jdbc:postgresql:prfdb... > openDb(PrfDb): Could not connect. e= security.Couldn't connect to > 'localhost' with origin from 'genx'. > > The same problems exits when I start NS from the same machine where the > PostgreSQL > server is running i.e. the Linux box(genx). > > *** But, when I use "genx: netscape http://127.0.0.1/PrfApplet.htm" on > genx, the > *** database connection gets established. > > The two machines genx and mm01 are on the same network and can ping each > other > using the hostnames. > > THE CLASSPATH IS *NOT* SET ON RISC MACHINE (mm01) and the postgresql.jar > is already > in mm01:$MOZILLA_HOME/java/classes. The JDBC interface is as follows: > > // Load the driver > try { > Class.forName(PrfConstants.DB_DRVR); > } catch(Exception e) { > System.out.println("openDb(PrfDb): Class.forName() failed. e= " > + e.getMessage()); > return (false); > } > > // Connect to database > System.out.println("openDb(PrfDb):Connecting to Database. URL = > jdbc:postgresql:prfdb..."); > try { > connect = DriverManager.getConnection("jdbc:postgresql:prfdb", > "postgres", ""); > } catch (SQLException e) { > System.out.println("openDb(PrfDb): Could not connect to > database. e=" + e.getMessage() ); > connect = null; > return (false); > } catch (Exception e) { > System.out.println("openDb(PrfDb): Could not connect. e= " + > e.getMessage()); > connect = null; > return (false); > } > > Can someone please help me. This has been much more complicated than > what I'd anticipated. > > I'm not sure if this is a problem at Java end or the PostgreSQL end. So, > please > excuse me if I've posted this problem to the wrong group. I'm just > desperate for help !!! > > Thanks much in advance. > Nishi > > --------To err is human but to really mess it up is computer-------- > mailto:nishikant.x.kapoor@nspco.com http://www.c3ipros.com/nkapoor > -----------------------------------~~~------------------------------ >
В списке pgsql-general по дате отправления: