Re: _aclitem and aclitem in JDBC driver?

From: chris(at)creatop(dot)com(dot)au
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: _aclitem and aclitem in JDBC driver?
Date: 2003-01-06 23:51:17
Message-ID: 163700.1041897077491.JavaMail.nobody@MACBETH
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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


Browse pgsql-jdbc by date

  From Date Subject
Next Message Neil Conway 2003-01-07 06:50:44 Re: 7.3 Prepared statements
Previous Message Barry Lind 2003-01-06 20:28:41 Re: patches