Richard,
Just to confirm background stuff ...
Is the following enabled:
In ColdFusion Administrator --> Data Sources --> {select data source in
question} --> Advanced Settings --> Allowed SQL --> Stored Procedures
I am running stored procs with no problem with MySQL 5.0.19 with ColdFusion
7.0.2 with mysql-connector-java-3.1.12.
This is the first that I have seen this thread. Sorry.
hth,
g
On 11/28/06, Richard White <[EMAIL PROTECTED]> wrote:
>
> Hi i posted a problem a while ago as i couldnt get stored procedures
> stored in mysql to work, it keeps coming up with a java.lang null pointer
> error.
>
> previous thread:
> http://www.houseoffusion.com<http://www.houseoffusion.com/groups/CF-Talk/thread.cfm/threadid:48365>
> /groups/CF-Talk/thread.cfm<http://www.houseoffusion.com/groups/CF-Talk/thread.cfm/threadid:48365>
> /threadid:48365<http://www.houseoffusion.com/groups/CF-Talk/thread.cfm/threadid:48365>
>
> i was wondering if any using mysql and cfstoredproc could provide an
> example or to see what i might be doing wrong as i cant work out whats
> wrong.
>
> I have granted full rights to my account as well so dont think its this
> but dont know why it is coming up with the null pointer. If i run the stored
> procedure from mysql it works fine so the stored procedure in the mysql
> database is fine.
>
> Thanks for any help, i would really appreciate it as i've been tearing my
> hair out for weeks, and i didn't have that much to start with!
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262059
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
