Re: _aclitem and aclitem in JDBC driver?

OK, problem with that is that via ColdFusion you don't get much choice of how it retrieves the data. You simply put the queries into 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(at)creatop(dot)com(dot)au
----------------------------------------------

----- Original Message -----
From: Barry Lind <blind(at)xythos(dot)com>
To: Chris Cox <chris(at)creatop(dot)com(dot)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(at)postgresql(dot)org