>- pass it to DriverManager.getConnection(url, user, password)
>- pass a "user" property when calling DriverManager.getConnection(url,
These two options can't be used as its done by Crystal Reports at runtime.
>- pass it in the URL: jdbc:postgresql://host:port/database?user=username
I tried this but getting the same error message Logon Failed.
(I am not able to include the message in my server log as it seems to have
No messages since yesterday. Not sure why my logging has stopped)
[mailto:pgsql-jdbc-owner(at)postgresql(dot)org]On Behalf Of Oliver Jowett
Sent: Wednesday, March 09, 2005 3:23 PM
To: Rover, Mischa de
Subject: Re: [JDBC] Crystal Reports: Connection rejected: FATAL: no
Rover, Mischa de wrote:
> ERROR [datainterface]
> com.crystaldecisions.reports.reportdefinition.datainterface.h: Logon
> Error: Connection rejected: FATAL: no PostgreSQL user name specified in
> startup packet
This means that you are passing no user information when trying to make
a connection (JDBC does not default to any particular user). It's a bit
weird that it works against 7.3, though. If you specify
"?protocolVersion=2" in the connection URL against an 8.0 server, does
Is Crystal Reports the one that eats all the stack traces? It'd be
useful to know the call path that generated this exception.
You have a few of choices as to how to pass in the user info:
- pass it to DriverManager.getConnection(url, user, password)
- pass a "user" property when calling DriverManager.getConnection(url,
- pass it in the URL: jdbc:postgresql://host:port/database?user=username
I'm not familiar with Crystal Reports so I don't know how you'd
configure it to use one of these approaches. Does it let you tweak the
connection URL directly?
> This message contains information that may be privileged or confidential
> and is the property of the Capgemini Group. It is intended only for the
> person to whom it is addressed. If you are not the intended recipient,
> you are not authorized to read, print, retain, copy, disseminate,
> distribute, or use this message or any part thereof. If you receive this
> message in error, please notify the sender immediately and delete all
> copies of this message.
You are sending this message to a public list, so the boilerplate is
pointless. (and anyway, what does "RCPT TO" mean if not "intended
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
In response to
pgsql-jdbc by date
|Next:||From: Oliver Jowett||Date: 2005-03-09 22:18:54|
|Subject: Re: Crystal Reports: Connection rejected: FATAL: no PostgreSQL|
|Previous:||From: Oliver Jowett||Date: 2005-03-09 21:31:32|
|Subject: Re: PostgreSQL 8.0 can't print duration in log when client|