"Invalid message format" error from JDBC driver

Поиск
Список
Период
Сортировка
Искать
От
leon-pg@comvision.com
Тема
"Invalid message format" error from JDBC driver
Дата
Msg-id
D5DC6DFE-6AF8-11D9-86EA-000A95E07710@comvision.com
Список
Дерево обсуждения
"Invalid message format" error from JDBC driver leon-pg@comvision.com
Re: "Invalid message format" error from JDBC driver Tom Lane <tgl@sss.pgh.pa.us>
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
В списке pgsql-general по дате отправления
От: Martijn van Oosterhout
Дата:
От: troyston campano
Дата:
FAQ