Thread: jdbc connection from Eomodeler to postgresql 7.2.3

jdbc connection from Eomodeler to postgresql 7.2.3

From
János Löbb
Date:
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



Re: jdbc connection from Eomodeler to postgresql 7.2.3

From
János Löbb
Date:
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@postgresql.org)
>


PostgreSQL 7.2.1 Programmer's Guide in pdf format

From
"cristi"
Date:
Where can I find "PostgreSQL 7.2.1 Programmer's Guide" in PDF (or PS)
format?

Thanks!


Re: PostgreSQL 7.2.1 Programmer's Guide in pdf format

From
Eric Walstad
Date:
Do a Google search for:

"PostgreSQL 7.2.1 Programmer's Guide" in PDF

The very first result will lead you there.

Repeat after me:
"Google is my friend..."

:)

Eric.

cristi wrote:
> Where can I find "PostgreSQL 7.2.1 Programmer's Guide" in PDF (or PS)
> format?
>
> Thanks!


Re: PostgreSQL 7.2.1 Programmer's Guide in pdf format

From
Eric Walstad
Date:
Do a Google search for:

"PostgreSQL 7.2.1 Programmer's Guide" in PDF

The very first result will lead you there.

Repeat after me:
"Google is my friend..."

:)

Eric.

cristi wrote:
> Where can I find "PostgreSQL 7.2.1 Programmer's Guide" in PDF (or PS)
> format?
>
> Thanks!