Re: Getting the SQL while running from eclipse

From: Anders Peterson (anders_peterso..ptimatika.se)
Date: Tue Nov 09 2004 - 05:19:54 EST

  • Next message: Anjo Krank: "Re: Getting the SQL while running from eclipse"

    Are you using WONDER? It seems to override arguments sent to an
    application by eclipse (as specified in the launch configuration).

    I haven't learned much about WONDER yet. I've simply started to inherit
    from various ERX* classes.

    As you can see from the console output (below) I do get "SQL", but after
    ERXProperties has done it's thing, it's gone.

    /Anders

    James Cicenia wrote:
    > Hello -
    >
    > I can't for the life of me figure out how to see the generated SQL for a
    > fetch specification I wrote.
    >
    > My qualifiers all look good so now I need to see the sql. Is there an
    > easy way to System.out it?
    > I have set all the debugs to true in Eclipse's WO and EO Arguments.
    >
    > Nothing is being displayed to the console.
    >
    > -James

    14605 [main] DEBUG NSLog - === Begin Internal Transaction
    14611 [main] DEBUG NSLog - evaluateExpression:
    <com.webobjects.jdbcadaptor.SybasePlugIn$SybaseExpression: "SELECT
    t0.aversion_level, t0.std_aversion_rate, t0.daily_task_time,
    t0.default_instrument_id, t0.default_profile_id, t0.default_user_name,
    t0.system_id, t0.input_change_tag_id, t0.std_level_weight,
    t0.new_portfolio_tag_id, t0.std_offset_weight, t0.optimal_portfolio_id,
    t0.password_required, t0.std_risk_weight,
    t0.std_significant_holding_change, t0.std_significant_share_change,
    t0.smallest_transaction FROM QGroup.QVSystem t0">
    14636 [main] DEBUG NSLog - 1 row(s) processed
    14642 [main] DEBUG NSLog - === Commit Internal Transaction
    14833 [main] DEBUG NSLog - === Begin Internal Transaction
    14839 [main] DEBUG NSLog - evaluateExpression:
    <com.webobjects.jdbcadaptor.SybasePlugIn$SybaseExpression: "SELECT
    t0.aversion_level, t0.std_aversion_rate, t0.daily_task_time,
    t0.default_instrument_id, t0.default_profile_id, t0.default_user_name,
    t0.system_id, t0.input_change_tag_id, t0.std_level_weight,
    t0.new_portfolio_tag_id, t0.std_offset_weight, t0.optimal_portfolio_id,
    t0.password_required, t0.std_risk_weight,
    t0.std_significant_holding_change, t0.std_significant_share_change,
    t0.smallest_transaction FROM QGroup.QVSystem t0">
    14847 [main] DEBUG NSLog - 1 row(s) processed
    14852 [main] DEBUG NSLog - === Commit Internal Transaction
    14860 [main] INFO NSLog - The schedule template time is: 1970-01-01
    12:00:00 Etc/GMT
    16364 [main] INFO NSLog - First daily task will be performed at:
    2004-11-09 12:00:00 Etc/GMT
    20148 [main] INFO er.extensions.ERXProperties -

    ERXProperties has found the following Properties files:
    Framework: QsdCoreData (not opened, installed)
    /Users/apete/Developer/eclipse3_ws/QsdCoreData/build/QsdCoreData.framework/Resources/Properties
    Framework: QsdBase (not opened, installed)
    /Users/apete/Developer/eclipse3_ws/QsdBase/build/QsdBase.framework/Resources/Properties
    Framework: JavaJDBCAdaptor (not opened, installed)
    /System/Library/Frameworks/JavaJDBCAdaptor.framework/Resources/Properties
    Framework: JavaWebObjects (not opened, installed)
    /System/Library/Frameworks/JavaWebObjects.framework/Resources/Properties
    Application: QsdOptApp (not opened, installed)
    /Users/apete/Developer/eclipse3_ws/QsdOptApp/build/QsdOptApp.woa/Contents/Resources/Properties

    20250 [main] INFO er.extensions.ERXCompilerProxy - initialize start
    20257 [main] INFO er.extensions.ERXCompilerProxy - Rapid-turnaround
    mode is disabled, set 'er.extensions.ERXCompilerProxyEnabled=true' in
    your WebObjects.properties to enable it.
    20337 [main] INFO er.extensions.ERXLogger - Updated the logging
    configuration with the current system properties.
    20545 [main] WARN NSLog - Opening application's URL in browser:
    http://192.168.47.33:2001/cgi-bin/WebObjects/QsdOptApp.woa
    20630 [main] INFO NSLog -
    20635 [main] INFO NSLog - ### Begin Statistics Report ###
    20640 [main] INFO NSLog - 2004-11-09 10:00:58 Etc/GMT
    20647 [main] INFO NSLog - {Memory = {Total Memory = 7294976; Free
    Memory = 965960; }; WebService = {}; Details = {}; StartedAt =
    2004-11-09 10:00:41 Etc/GMT; Pages = {}; Sessions = {Current Active
    Sessions = 0; Total Sessions Created = 0; Avg. Memory Per Session =
    {Total Memory = 0; Free Memory = 0; }; Peak Active Sessions = 0; Moving
    Avg. Transactions Per Session = 0.0; Moving Avg. Session Life = 0.0;
    Session Rate = 0.0; Avg. Transactions Per Session = 0.0; Sample Size For
    Moving Avg. = 10; Avg. Session Life = 0.0; }; DirectActions = {};
    Transactions = {Direct Action Avg. Transaction Time = 0.0; Moving Avg.
    Transaction Time = 0.0; Transaction Rate = 0.0; Sample Size For Moving
    Avg. = 100; Moving Avg. Idle Time = 0.0; Direct Action Transactions = 0;
    Web Service Transactions = 0; Avg. Idle Time = 0.0; Avg. Transaction
    Time = 0.0; Transactions = 0; Component Action Transactions = 0;
    Component Action Avg. Transaction Time = 0.0; Web Service Avg.
    Transaction Time = 0.0; }; }
    20652 [main] INFO NSLog - ### End Statistics Report ###
    20656 [main] INFO NSLog -
    30860 [WorkerThread0] INFO NSLog -
    30866 [WorkerThread0] INFO NSLog - 2004-11-09 10:01:09 Etc/GMT >>
    QCDUser fetchInstance(EOEditingContext, NSDictionary)
    30870 [WorkerThread0] INFO NSLog - This is: QCDUser
    30879 [WorkerThread0] INFO NSLog - The EC is:
    se.optimatika.proj.qsd.QBEditingContex..8a8f7
    30884 [WorkerThread0] INFO NSLog - The key is: {name = "daniel"; }



    This archive was generated by hypermail 2.0.0 : Tue Nov 09 2004 - 05:20:02 EST