"Invalid message format" error from JDBC driver

[leon-pg@comvision.com]

Hello, all. I have a query that runs perfectly when I run it from
pgAdmin3, but bombs when I run it from ColdFusion using the JDBC
driver. I'm using postgres 7.4. The query uses dblink(), which I assume
is the source of the problem.

Can anyone provide me with any insight about why this would fail over
JDBC? Thanks


select *
into cupahr_tblunit_20050120
from dblink('dbname=tafkan', '

select u.*, c1.className as Carnegie_Class, c2.className as
Affiliation, c3.className as Level_of_Instruction

from tblunit u
inner join tblClassType ct1 on ct1.clientID = 33 and ct1.classTypeName
= ''Carnegie Class''
left join tblLinkUnitClass l1 on l1.unitID = u.unitID and
l1.classTypeID = ct1.classTypeID
left join tblClass c1 on c1.classID = l1.classID
inner join tblClassType ct2 on ct2.clientID = 33 and ct2.classTypeName
= ''Affiliation''
left join tblLinkUnitClass l2 on l2.unitID = u.unitID and
l2.classTypeID = ct2.classTypeID
left join tblClass c2 on c2.classID = l2.classID
inner join tblClassType ct3 on ct3.clientID = 33 and ct3.classTypeName
= ''Level of Instruction''
left join tblLinkUnitClass l3 on l3.unitID = u.unitID and
l3.classTypeID = ct3.classTypeID
left join tblClass c3 on c3.classID = l3.classID
where u.clientid = 33



') as tblunit(

unitid int4,
clientid int4,
groupid int4,
logoid int4,
shortname varchar(50),
unitname varchar(150),
address1 varchar(100),
address2 varchar(100),
city varchar(50),
state varchar(50),
zip varchar(10),
plus4 varchar(4),
country varchar(50),
phone varchar(50),
fax varchar(50),
o_iid int4,
o_environmentid int4,
o_itype int4,
importunitid int4,
importgroupid int4,
membertype char(10),
membertypeid int4,
isgroupsummary bool,
lastupdate timestamp

[Tom Lane]

[email]leon-pg@comvision.com[/email] writes:

> Hello, all. I have a query that runs perfectly when I run it from
> pgAdmin3, but bombs when I run it from ColdFusion using the JDBC
> driver. I'm using postgres 7.4. The query uses dblink(), which I assume
> is the source of the problem.

> Can anyone provide me with any insight about why this would fail over
> JDBC? Thanks

If you didn't get any answers yet, try asking about it on pgsql-jdbc.
Also, you might want to update your jdbc driver first, just to find out
if the bug is already fixed.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

[url]http://www.postgresql.org/docs/faq[/url]