iBatis logging log4j - how to get sql id in the log -

-

i have ibatis log working prints sql stmt, parameters etc. in log file. not print select id.

for example: select id="getuserinfo" parameterclass="string" resultclass="string"

i want print getuserinfo in log. how do that?

thank you, robert

are using logging framework or something? use log4j logging consoleappender class "org.apache.log4j.consoleappender" , fileappender class , have conversionpattern set "%d{iso8601} %-5p %m%n" , works me.

console appender settings

  <appender name="a1" class="org.apache.log4j.consoleappender">      <param name="target" value="system.out"/>      <param name="threshold" value="debug"/>      <layout class="org.apache.log4j.patternlayout">         <param name="conversionpattern" value="%d{iso8601} %-5p %m%n"/>      </layout>  </appender>

my log4j.xml file

<?xml version="1.0" encoding="utf-8" ?> <!doctype log4j:configuration system "log4j.dtd">  <log4j:configuration debug="false" xmlns:log4j="http://jakarta.apache.org/log4j/">    <appender name="a1" class="org.apache.log4j.consoleappender">     <param name="target" value="system.out"/>     <param name="threshold" value="debug"/>     <layout class="org.apache.log4j.patternlayout">       <param name="conversionpattern" value="%d{iso8601} %-5p %m%n"/>     </layout>   </appender>    <appender name="a2" class="org.apache.log4j.rollingfileappender">     <param name="file" value="../logs/server.log"/>     <param name="maxfilesize" value="100mb"/>     <param name="maxbackupindex" value="2"/>     <layout class="org.apache.log4j.patternlayout">       <param name="conversionpattern" value="%d{iso8601} %-5p %m%n"/>     </layout>   </appender>    <root>         <level value="debug"/>     <appender-ref ref="a1"/>     <appender-ref ref="a2"/>   </root>     </log4j:configuration>

server.log file - getxyzquery

    2013-09-02 15:34:44,230 debug {conn-100087} preparing statement:   select x,y,z xyz_tbl type_id = 1 order sort_priority asc       2013-09-02 15:34:44,230 debug {pstm-100088} executing statement:   select x,y,z xyz_tbl type_id = 1 order sort_priority asc       2013-09-02 15:34:44,231 debug {conn-100089} connection     2013-09-02 15:34:44,240 debug {pstm-100088} parameters: []     2013-09-02 15:34:44,243 debug {rset-100091} resultset     2013-09-02 15:34:44,244 debug query getxyzquery 18 ms using list (9-wlt.getworklisttabfilter mypchost)     2013-09-02 15:34:44,246 debug sql_return_conn: operational_db returned connection 000000001652311912 (a1/100 i1/40 w0)

getxyzquery select id in 

select id="getxyzquery" parameterclass="string" resultclass="string"

i hope works perhaps doesn't send me ibatis xml file , logging framework using.


Comments

Post a Comment

Popular posts from this blog

ruby on rails - Is it the correct way to implement belongs_to relation with factory girl? -

-
i have realy easy model. user have role_id depends of role table (id, name) role reference. i want create users of types on rspec test, factory girl. my first idea factory :role name "guest" factory :role_admin name "admin" end factory :role_supervisor name "supervisor" end etc... have lot different roles end factory :user email password '123456' password_confirmation '123456' association :role, factory: :role factory :admin association :role, factory: :role_admin end factory :supervisor association :role, factory: :role_supervisor end etc... have lot different roles end in model have simple method : def is(role_name) return self.role.name == role_name end it's correct way to? realy need create factory role? can make stub function in factory girl each role? i realy new test stuff, thanks. factories should reflect models. class user has_many :products en
Read more

geolocation - Windows Phone 8 - Keeping background location tracking active beyond four hours -

-
i'm in process of developing wp8 app makes use of background location tracking abilities provided os. idea monitor users position , notify them when near types of places. so far seems work fine , when running location tracking works expect. the problem is, seems phone times out background apps after around 4 hours, stopping location tracking. i can understand why microsoft did it, preserve battery life etc. there's not point having background location tracking app has manually restarted every 4 hours! if user chooses run app , made aware of potential battery hit, surely should able run indefinitely - point of course, if system runs out of resources or similar that's fair enough. does have experience this? there must hundreds of others apps in store have run issue have thought? , presumably there must way of keeping location tracking running? i've tried periodically updating live tile (using dispatchertimer) while tracking running doesn't seem enough ke
Read more

Uncaught TypeError: Cannot read property 'parentNode' of null javascript -

-
this code should make element disappear list when dropped on element (called cookiemonster) addevent(cookiemonster, 'drop', function (e) { if (e.stoppropagation) e.stoppropagation(); var el = document.getelementbyid(e.datatransfer.getdata('text')); el.parentnode.removechild(el); return false; }); create auxiliar variable this addevent(cookiemonster, 'drop', function (e) { if (e.stoppropagation) e.stoppropagation(); var el = document.getelementbyid(e.datatransfer.getdata('text')); var aux = el.parentnode; aux.removechild(el); return false; });
Read more