"Invalid message format" error from JDBC driver

Started by Nonameabout 21 years ago2 messagesgeneral
Jump to latest
#1Noname
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,
Carnegie_Class varchar(250),
Affiliation varchar(250),
Level_of_Instruction varchar(250)

)

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Noname (#1)
Re: "Invalid message format" error from JDBC driver

leon-pg@comvision.com 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