OK, problem with that is that via ColdFusion you don't get much choice of how it retrieves the data. You simply put the
queriesinto a cfquery tag and it does all the JDBC stuff itself.
Is there a way you can do something on the server end, a conversion utility or something similar to the getString()
method? Or am I going to have to hack ColdFusion MX's Java code?
Chris
----------------------------------------------
Chris Cox
B.IT.(Information Systems)
Senior Software Engineer
Creatop Interactive Media
Level 1, 240 McCullough Street
Sunnybank. Qld. 4109
Australia
Ph: +61 7 3216 9755
Mobile: +61 412 416600
http://www.creatop.com.au/
chris@creatop.com.au
----------------------------------------------
----- Original Message -----
From: Barry Lind <blind@xythos.com>
To: Chris Cox <chris@creatop.com.au>
Sent: Saturday, January 04, 2003 4:40 AM
Subject: Re: [JDBC] _aclitem and aclitem in JDBC driver?
Chris,
The easiest way to handle this is to use getString()/setString() when
dealing with a datatype that the jdbc driver doesn't understand.
--Barry
Chris Cox wrote:
> Hi,
>
> I'm trying to programmatically handle PostgreSQL permissions using
> ColdFusion MX via JDBC. However, I can't retrieve the "relacl" column.
> It returns the following errors:
>
> "No class found for aclitem" Or "Class names may not have _ in them. You
> supplied {0}"
>
> It's possible ColdFusion's JRun server is returning these errors,
> however I just want to rule out the JDBC drivers as the problem. I am
> using the latest JDBC drivers (pg73jdbc3.jar).
>
> I have tried casting aclitem as numerous other times but PostgreSQL
> obviously doesn't allow that.
>
> Any help or suggested workarounds would be greatly appreciated.
>
> Regards,
>
> Chris
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org