[tpm] DBIx::Class, DBD::Sybase, and statement caching

[J. Bobby Lopez]

Just an update for anyone who may come across this later on..

FreeTDS 0.91 is indeed way too buggy, so instead of using a new version, I
just patched FreeTDS 0.82 according to this (
http://lists.ibiblio.org/pipermail/freetds/2011q2/026925.html),
recompiled, and now it seems to be working the way I want.

-Bobby

On Fri, Sep 28, 2012 at 3:42 PM, J. Bobby Lopez <bobby.lopez at gmail.com>wrote:

> Anyone using DBD::Sybase (1.14) via DBIx::Class (0.08198), and ran into
> this error?:
>
> "error" : "Warning caught during route execution: DBIx::Class::ResultSet::first(): Your DBD::Sybase was compiled against buggy FreeTDS version 0.91. Statement caching does not work and will be disabled.
>
>
> I'm using FreeTDS 0.91 because 0.82 has an 80 character limit in varchar
> values that can be submitted to the database.  Anything over 80 chars gets
> truncated. (http://lists.ibiblio.org/pipermail/freetds/2011q2/026943.html)
>
>
> I'm hoping that 'disabling statement caching' doesn't mean a setting that
> has to be done at the database level, because it is a shared database
> server, and this would likely affect other applications/databases.
>
> Thoughts?
>
> Thanks,
> -Bobby
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.pm.org/pipermail/toronto-pm/attachments/20120928/a71e60ce/attachment.html>