Postgres Pro
Downloads
Home   >   mailing lists

Thread: _aclitem and aclitem in JDBC driver?

_aclitem and aclitem in JDBC driver?

From
"Chris Cox"
Date:
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

Re: _aclitem and aclitem in JDBC driver?

From
Barry Lind
Date:
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

Re: _aclitem and aclitem in JDBC driver?

From
chris@creatop.com.au
Date:
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