"Invalid message format" error from JDBC driver

[leon-pg@xxxxxxxxxxxxx]

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,
  Carnegie_Class varchar(250),
  Affiliation varchar(250),
  Level_of_Instruction varchar(250)

)

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

              http://archives.postgresql.org