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)
)
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? |