<div dir="ltr">OK, that must have gone right over my head, 'cause I did read it, but I don't see why that means I should expect there to be no trace output.<div><br></div><div>How do you trace the SQL that is generated when the create() method is called then? Obviously, I'm just turning on tracing on the connection associated with my $dbh, but if that secondary connection isn't exposed to me somehow, are you saying my only recourse is to trace the ENTIRE application execution, and then wade through the mountain of data?</div>
<div><br></div><div>I'll give that a try... Finding the SQL of interest will be a little tedious, though, but hey, I've got all day....</div><div><br></div><div>Oh, BTW, I tried switching to using NoBindVars, and was immediately reminded of why that failed for me last year:</div>
<div><br></div><div><div>DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::Sybase::st execute failed: Server message number=257 severity=16 state=1 line=1 \</div><div>server=NYTIBV6T228 text=Implicit conversion from datatype 'VARCHAR' to 'NUMERIC' is not allowed. Use the CONVERT function to run this query.</div>
<div> Server message number=257 severity=16 state=1 line=1 server=NYTIBV6T228 text=Implicit conversion from datatype 'VARCHAR' to 'NUMERIC' is not a\</div><div>llowed. Use the CONVERT function to run this query.</div>
<div> [for Statement "INSERT INTO [ENGN_afsvolume] ( [name], [target], [toplevel], [type]) VALUES ( 'canon.root', '9', '1', 'cn' )</div><div>SELECT @@IDENTITY"] at ./util/vms_bootstrap_database line 253</div>
</div><div><br></div><div>That '9', and '1' are both foreign keys which are numerics, and the dataserver doesn't like them to be quoted. </div></div><div class="gmail_extra"><br><br><div class="gmail_quote">
On Tue, Feb 4, 2014 at 12:09 PM, Peter Rabbitson <span dir="ltr"><<a href="mailto:rabbit+dbic@rabbit.us" target="_blank">rabbit+dbic@rabbit.us</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div class="im">On Tue, Feb 04, 2014 at 11:28:46AM -0500, Phillip Moore wrote:<br>
><br>
> What am I doing wrong here? Clearly, tracing is being turned on, but then<br>
> total radio silence from the create method.<br>
<br>
</div>You didn't read the linked paragraph carefully. Linking you to the<br>
source so that the highlight is apparent:<br>
<a href="https://metacpan.org/source/RIBASUSHI/DBIx-Class-0.08270/lib/DBIx/Class/Storage/DBI/Sybase/ASE.pm#L1017" target="_blank">https://metacpan.org/source/RIBASUSHI/DBIx-Class-0.08270/lib/DBIx/Class/Storage/DBI/Sybase/ASE.pm#L1017</a><br>
<br>
This codepath is not employed if you are already in a transaction:<br>
<a href="https://metacpan.org/source/RIBASUSHI/DBIx-Class-0.08270/lib/DBIx/Class/Storage/DBI/Sybase/ASE.pm#L405" target="_blank">https://metacpan.org/source/RIBASUSHI/DBIx-Class-0.08270/lib/DBIx/Class/Storage/DBI/Sybase/ASE.pm#L405</a><br>
<br>
Hope this helps<br>
Cheers<br>
<div class="HOEnZb"><div class="h5"><br>
<br>
_______________________________________________<br>
List: <a href="http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class" target="_blank">http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class</a><br>
IRC: <a href="http://irc.perl.org#dbix-class" target="_blank">irc.perl.org#dbix-class</a><br>
SVN: <a href="http://dev.catalyst.perl.org/repos/bast/DBIx-Class/" target="_blank">http://dev.catalyst.perl.org/repos/bast/DBIx-Class/</a><br>
Searchable Archive: <a href="http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk" target="_blank">http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk</a><br>
</div></div></blockquote></div><br></div>