02.Oracle/DataBase2008. 11. 28. 17:02
반응형
sourceforge.net에서 JDBC를 사용하는 모든 어플리케이션의 간단한 설정으로 소스의 변경없이 모든 Database의 Transaction에 대한
SQL을 parameter matched된 로그를 보여주는 lib가 있네요...
개발시 개발성능향상에 많은 도움이 될것같습니다.
http://log4sql.sourceforge.net 에 가보면 한글/영문 메뉴얼이 다 있군요.
아래는 링크와 해당 lib에대한 내용입니다.

In develope we use many framework and tools.
Developer's important work is developing PL/SQL.
Many tools and Framework support All Layers.
View, Model, and Controller or DataAcess Layer... so developer can concentrate business logic. And i think business logics is PL/SQL.
All PL/SQL works repeat Make query And executioning And debugging.
In that case we can use jdbc or Connection Pooling(Apache DBCP) or support 2PC (JTA,JOTM) and etc...
In many case Also we use ORM(Object Relation Mapping) ibatis or springJDBC or hibernate...
Then problem occurs "My Query How to Works! And Parameters are correct?"
I'm sure log4sql is easy And simple Configuration change But Very Usefull for you!

You can download log4sql from here(http://sourceforge.net/project/showfiles.php?group_id=209296 )log4sql Sourceforge.net



출처 : http://okjsp.pe.kr/seq/106707
Posted by 1010