Skip site navigation (1) Skip section navigation (2)

Re: jdbc connection from Eomodeler to postgresql 7.2.3

From: János Löbb <janos(dot)lobb(at)yale(dot)edu>
To: János Löbb <janos(dot)lobb(at)yale(dot)edu>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: jdbc connection from Eomodeler to postgresql 7.2.3
Date: 2002-10-16 20:22:37
Message-ID: 02F49278-E145-11D6-8E9B-000A27DD8970@janos.mail.yale.edu (view raw or flat)
Thread:
Lists: pgsql-novice
I did two more things here.  I started the postmaster with the -i  
option and moved the postgresql.jar file into /Library/Java/Extensions.  
  Now when I try to connect EOModeler does not complain anymore about  
the CLASSPATH but I am getting a different error message:

===============
Something unusual has occured to cause the driver to fail. Please  
report this exception: Exception: java.sql.SQLException: FATAL 1:  No  
pg_hba.conf entry for host 204.90.81.246, user postgres, database test

Stack Trace:

java.sql.SQLException: FATAL 1:  No pg_hba.conf entry for host  
204.90.81.246, user postgres, database test

	at org.postgresql.Connection.openConnection(Unknown Source)
	at org.postgresql.Driver.connect(Unknown Source)
	at java.sql.DriverManager.getConnection(DriverManager.java:512)
	at java.sql.DriverManager.getConnection(DriverManager.java:141)
	at JDBCContext.connect(JDBCContext.java:192)
	at JDBCContext._tryConnect(JDBCContext.java:249)
	at JDBCContext._fetchJDBCInfo(JDBCContext.java:474)
	at JDBCPlugIn.jdbcInfo(JDBCPlugIn.java:588)
	at JDBCAdaptor.jdbcInfo(JDBCAdaptor.java:166)
End of Stack Trace
===================

at the psql prompt I see:
test=# FATAL 1:  No pg_hba.conf entry for host 204.90.81.246, user  
postgres, database test


in the console I see:
2002-10-16 16:08:47.636 EOModeler[676] CFLog (0):  
CFPropertyListCreateFromXMLData(): Old-style plist parser: missing  
semicolon in dictionary.
2002-10-16 16:08:47.651 EOModeler[676] CFLog (0):  
CFPropertyListCreateFromXMLData(): The file name for this data might be  
(or it might not): file://localhost/usr/share/zoneinfo/America/New_York
2002-10-16 16:08:49.671 EOModeler[676] Loaded bundle with path  
/Developer/EOMBundles/EOJavaClientExtensions.EOMbundle
Initializing PostgresqlPlugin

So, what am I still not doing right ?
What is the syntax to add a pg_hba.conf entry ?

Thanks ahead,
János
P.S.  If I use URL jdbc:postgresql:test then I am IN !!

On Tuesday, Oct 15, 2002, at 18:33 America/New_York, János Löbb wrote:

> When I try to connect to Postgresql /7.2.3/ from EOModeler /Webobjects  
> 5.1.4/ I am getting the following message:
>
> Connection Failure
> JDBC connection failed for driver :'org.postgresql.Driver'. Driver not  
> found in Java Runtime! Please verify your CLASSPATH environment  
> variable. The current CLASSPATH for your application is :  
> /Developer/Applications/EOModeler.app/Contents/Resources/Java/ 
> eomodeler.zip:/Users/janos/Library/Java:/Library/Java:/System/Library/ 
> Java:/Network/Library/Java:/System/Library/Frameworks/ 
> JavaVM.framework/Classes/classes.jar:/System/Library/Frameworks/ 
> JavaVM.framework/Classes/ui.jar:/Developer/Applications/EOModeler.app/ 
> Contents/Resources/Java/eomodeler.zip
>
> I compiled postgresql with the --with-java option.  I am using the  
> following parameters when I try to connect:
>
> user:  postgres
> password:  postgres
> URL:  jdbc:postgresql:test
>
> If I specify the driver as org.postgresql.Driver, the error message is  
> the same.  In the console I can see the message:
>
> Initializing PostgresqlPlugin
>
> I downloaded the PosgresqlPluginBundle from softrack, compiled it and  
> placed the product into the /Developer/EOMBundles directory.  I also  
> copied postgresql.jar into the /Library/java folder, so it is in the  
> CLASSPATH for EOModeler.
>
> What should I do different ?
>
> János
> P.S.  postgresql is running :) From top:
> 17261 postgres     0.0%  0:00.00   1     8    17    84K  1.61M   228K   
> 13.4M
> 17260 postgres     0.0%  0:00.01   1     8    18    32K  1.61M   156K   
> 14.4M
> 17259 postgres     0.0%  0:00.81   1    10    17    40K  1.61M   760K   
> 13.4M
>
>
>
> ---------------------------(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)
>


In response to

Responses

pgsql-novice by date

Next:From: Adam Van OrnumDate: 2002-10-17 02:59:28
Subject: Name switch
Previous:From: Devinder K RajputDate: 2002-10-16 19:46:57
Subject: Re: newbie qs; examining databases and tables

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group