"Invalid message format" error from JDBC driver

From: leon-pg(at)comvision(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: "Invalid message format" error from JDBC driver
Date: 2005-01-20 15:34:55
Message-ID: D5DC6DFE-6AF8-11D9-86EA-000A95E07710@comvision.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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)

)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message troyston campano 2005-01-20 15:50:06 Re: [ADMIN] Oracle and Postgresql Play Nice Together on Same Computer?
Previous Message Martijn van Oosterhout 2005-01-20 15:22:41 Re: How to manually insert an UTF-8 character into an SQL statement?