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

Crystal Reports: Connection rejected: FATAL: no PostgreSQL user name specified in startup packet.

From: "Rover, Mischa de" <mischa(dot)de(dot)rover(at)capgemini(dot)com>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: Crystal Reports: Connection rejected: FATAL: no PostgreSQL user name specified in startup packet.
Date: 2005-03-09 16:10:55
Message-ID: 301BE47715DCDA45B0A941A73876BBB652F901@NL-EXVS-01A.bnl.capgemini.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
With Crystal Reports XI report design application we create reports of a
PostgreSQL database. To establish this connection we must use the JDBC
driver version 8.0, older versions of JDBC drivers generates errors
(This method is not yet implemented).



The Java web application connects to the database also using the 8.0
JDBC driver version. When starting to run an embedded report the
following error occurs:



ERROR [datainterface]
com.crystaldecisions.reports.reportdefinition.datainterface.h: Logon
Error: Connection rejected: FATAL:  no PostgreSQL user name specified in
startup packet



When replacing (in the Java web application) the 8.0 JDBC driver with an
older version 7.3 the logon to the database works fine. But an other
problem occurs, because of the fact that the reports are designed
against an 8.0 JDBC driver most of the queries are not compatible with
the 7.3 JDBC driver version:



select "diagnose"."code", "diagnose"."omschrijving",
"episode_diagnose"."diagnose", "episode_diagnose"."datum_diagnose",
"kliniek"."code", "kliniek"."naam"

FROM   ((("public"."kliniek" "kliniek" LEFT OUTER JOIN
"public"."identificatie" "identificatie" ON
"kliniek"."code"="identificatie"."kliniek_code") LEFT OUTER JOIN
"public"."episode" "episode" ON
"identificatie"."id"="episode"."identificatie_id") LEFT OUTER JOIN
"public"."episode_diagnose" "episode_diagnose" ON
"episode"."id"="episode_diagnose"."episode_id") RIGHT OUTER JOIN
"public"."diagnose" "diagnose" ON
"episode_diagnose"."diagnose"="diagnose"."code"



ERROR:  parser: parse error at or near "{" at character 119



A simple report with no outer join works fine.



Can anyone help us with this issue.



What is the difference considering authentication between driver version
7.3 and 8.0? May be a JDBC driver with the authentication behavior of
7.3 and query handling of 8.0 would help?



Regards,



Mischa



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.

Responses

pgsql-jdbc by date

Next:From: Csaba NagyDate: 2005-03-09 16:12:40
Subject: Re: java is locked when select for update
Previous:From: Mican BicanDate: 2005-03-09 15:54:40
Subject: java is locked when select for update

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