SubSonic Forums
All Your Database Are Belong To Us

Subsonic is not generating Stored Procedures

Latest post 12-14-2008 3:28 PM by DenysNikolayenko. 7 replies.
  • 10-05-2008 2:29 PM

    Subsonic is not generating Stored Procedures

    Hi,

    I've a simple stored procedure and I don't know why SubSonic isn't generating the wrapper for the procedure.

    I'm using the Subsonic version 2.1 with mysql.

    Does anyone knows why?

    Thanks

  • 10-07-2008 5:11 PM In reply to

    • ranomore
    • Top 10 Contributor
    • Joined on 11-05-2007
    • Salt Lake City
    • Posts 322

    Re: Subsonic is not generating Stored Procedures

    Do you see the stored procedure when you run this sql:

    SELECT routine_name FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_SCHEMA = ?databaseName

    This is the sql that subsonic executes. It's in SubSonic\DataProviders\MySqlDataProvider.cs

     

    -dave

  • 10-07-2008 10:38 PM In reply to

    Re: Subsonic is not generating Stored Procedures

    Hi Dave,

    Thanks for your Replay.

    I've executed the query that you mentioned, and I receive the name of all stored procedures, but no one of then are been generated :(

    Look in the image:

    Query

     

  • 10-10-2008 4:27 AM In reply to

    Re: Subsonic is not generating Stored Procedures

    Does the login subsonic is using have permissions to see the SP?

    Find a bug? Create a Work Item for a fast response.. Want to help? Create a patch for us!

  • 10-10-2008 8:13 AM In reply to

    Re: Subsonic is not generating Stored Procedures

    Yes,

    This query that I've executed was with the same user that is configurated in my project with subsonic. :(

    Any ideia?

  • 10-29-2008 11:28 AM In reply to

    • spindi
    • Not Ranked
    • Joined on 10-29-2008
    • Posts 2

    Re: Subsonic is not generating Stored Procedures

    The exact same is happening for me.

    ASP.NET 3.5, SubSonic 2.1, MySQL 5

     

  • 10-29-2008 11:28 AM In reply to

    • spindi
    • Not Ranked
    • Joined on 10-29-2008
    • Posts 2

    Re: Subsonic is not generating Stored Procedures

    I'm going to try and compile the SVN source and see if that helps

  • 12-14-2008 3:28 PM In reply to

    Re: Subsonic is not generating Stored Procedures

    The same for me. ASP.NET 3.5 + SubSonic 2.1 Final + MySQL 5.0.

    Is there any way to fix it?

Page 1 of 1 (8 items) | RSS