각종 IT개발 기술해결 메모 ::

IE에서 마우스 오른쪽 버튼 막는 사이트 해제!!!

분류없음 2012/01/18 11:12

웹브라우징은 본질적으로 복사본을 열람하는 행위인데

굳이 복사를 막겠다고 인터넷 익스플로러의 마우스 오른쪽 버튼 막는 사이트들이 있다. 그런짓 하지마라. 해봤자 의미없다. 근본적으로 막을 수 없다는 얘기

chaoskcuf ( http://chaoskcuf.com/125 )님께서 인터넷 익스플로러에서 마우스 오른쪽 버튼을 활성화 시켜주는 도구를 만들어주셨다.

Windows7 / Internet Explorer 8에서 정상 동작한다

Posted by 칠복

트랙백이 없고 댓글이 없습니다.

윈도우용 무설치 오라클 클라이언트

분류없음 2012/01/16 11:23

* Toad for Eclipse plugin : http://www.quest.com/toad-extension-for-eclipse/

* SQL Explorer : http://sourceforge.net/projects/eclipsesql

eclipse 플러이인버전과 독립실행 버전 두가지 제공

* Oracle SQL Developer : http://www.oracle.com/technetwork/developer-tools/sql-developer/overview/index.html

* DbVisualizer for the Oracle : http://www.dbvis.com/

* Oracle Instant Client : http://www.oracle.com/technetwork/database/features/instant-client

다운로드 후 압축 해제하여 바로 사용 but, Grid 툴은 포함하지 않음

※ Oracle Instant Client 외에 나머지는 한글 깨짐, NLS_CHARACTERSET;US7ASCII 인 경우

Posted by 칠복

트랙백이 없고 댓글이 없습니다.

Servlet Filter에서 Spring Bean 객체 참조 얻어오기

분류없음 2011/12/24 14:44

filter에 객체를 inject 할 수 없는 것으로 가정하고 아래처럼 코딩함

public class PolicyCheckFilter implements javax.servlet.Filter {

private ApplicationContext applicationContext = null;

private SystemAclDAO systemAclDAO;
....

public void init(FilterConfig filterConfig) throws ServletException {

logger = LogFactory.getLog(getClass());

logger.info("filter initializing");

applicationContext = WebApplicationContextUtils.getWebApplicationContext(filterConfig.getServletContext());

if(applicationContext.getBean("systemAclDAO", SystemAclDAO.class) != null)

systemAclDAO = (SystemAclDAO)applicationContext.getBean("systemAclDAO", SystemAclDAO.class);

else

logger.info("systemAclDAO bean을 찾을 수 없음! filter 동작불가");

logger.info("filter initializing done / systemAclDAO=" + systemAclDAO);

}
.....

}

Posted by 칠복

트랙백이 없고 댓글이 없습니다.

phpmyadmin 에서 프러시져 목록 조회하기

분류없음 2011/12/15 08:49

phpmyadmin 3.4.5 에는 '프러시져 목록 조회' 메뉴가 없음. 아마 이후 버전에도 없을 것 같음
아래 쿼리로 조회한다.

SELECT ROUTINE_TYPE, ROUTINE_NAME, ROUTINE_DEFINITION
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_SCHEMA = 'oms'

Posted by 칠복

트랙백이 없고 댓글이 없습니다.

CXF 관련 에러 exception: org.xml.sax.SAXParseException: An invalid XML character (Unicode: 0x0) was found in the element content of the document.

분류없음 2011/11/22 16:57

테이블에서 binary(blob)데이터를 읽어서 전송하려 했을 때 발생함


[서버 측 에러메시지]

2011. 11. 22 오후 4:53:53 org.apache.catalina.core.StandardWrapperValve invoke
심각: Servlet.service() for servlet jsp threw exception
org.xml.sax.SAXParseException: An invalid XML character (Unicode: 0x0) was found in the element content of the document.
	at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAXParseException(ErrorHandlerWrapper.java:236)
	at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.fatalError(ErrorHandlerWrapper.java:215)
	at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:386)
	at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:316)
	at com.sun.org.apache.xerces.internal.impl.XMLScanner.reportFatalError(XMLScanner.java:1438)
	at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(XMLDocumentFragmentScannerImpl.java:1672)
	at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:368)
	at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:834)
	at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:764)
	at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:148)
	at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1242)
	at javax.xml.parsers.SAXParser.parse(SAXParser.java:375)
	at org.apache.axis.encoding.DeserializationContext.parse(DeserializationContext.java:227)
	at org.apache.axis.SOAPPart.getAsSOAPEnvelope(SOAPPart.java:696)
	at org.apache.axis.Message.getSOAPEnvelope(Message.java:435)
	at org.apache.axis.handlers.soap.MustUnderstandChecker.invoke(MustUnderstandChecker.java:62)
	at org.apache.axis.client.AxisClient.invoke(AxisClient.java:206)
	at org.apache.axis.client.Call.invokeEngine(Call.java:2784)
	at org.apache.axis.client.Call.invoke(Call.java:2767)
	at org.apache.axis.client.Call.invoke(Call.java:2443)
	at org.apache.axis.client.Call.invoke(Call.java:2366)
	at org.apache.axis.client.Call.invoke(Call.java:1812)
	at mke.oms.wsdlSEI.OrganProcessImplServiceSoapBindingStub.userViewInfoForWS(OrganProcessImplServiceSoapBindingStub.java:563)
	at mke.oms.wsdlSEI.OrganProcessProxy.userViewInfoForWS(OrganProcessProxy.java:86)
	at org.apache.jsp.organ_jsp._jspService(organ_jsp.java:132)
	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:386)
	at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
	at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:864)
	at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579)
	at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1665)
	at java.lang.Thread.run(Thread.java:595)
2011. 11. 22 오후 4:54:01 org.apache.catalina.core.StandardWrapperValve invoke
심각: Servlet.service() for servlet jsp threw exception
org.xml.sax.SAXParseException: An invalid XML character (Unicode: 0x0) was found in the element content of the document.
	at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAXParseException(ErrorHandlerWrapper.java:236)
	at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.fatalError(ErrorHandlerWrapper.java:215)
	at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:386)
	at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:316)
	at com.sun.org.apache.xerces.internal.impl.XMLScanner.reportFatalError(XMLScanner.java:1438)
	at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(XMLDocumentFragmentScannerImpl.java:1672)
	at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:368)
	at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:834)
	at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:764)
	at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:148)
	at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1242)
	at javax.xml.parsers.SAXParser.parse(SAXParser.java:375)
	at org.apache.axis.encoding.DeserializationContext.parse(DeserializationContext.java:227)
	at org.apache.axis.SOAPPart.getAsSOAPEnvelope(SOAPPart.java:696)
	at org.apache.axis.Message.getSOAPEnvelope(Message.java:435)
	at org.apache.axis.handlers.soap.MustUnderstandChecker.invoke(MustUnderstandChecker.java:62)
	at org.apache.axis.client.AxisClient.invoke(AxisClient.java:206)
	at org.apache.axis.client.Call.invokeEngine(Call.java:2784)
	at org.apache.axis.client.Call.invoke(Call.java:2767)
	at org.apache.axis.client.Call.invoke(Call.java:2443)
	at org.apache.axis.client.Call.invoke(Call.java:2366)
	at org.apache.axis.client.Call.invoke(Call.java:1812)
	at mke.oms.wsdlSEI.OrganProcessImplServiceSoapBindingStub.userViewInfoForWS(OrganProcessImplServiceSoapBindingStub.java:563)
	at mke.oms.wsdlSEI.OrganProcessProxy.userViewInfoForWS(OrganProcessProxy.java:86)
	at org.apache.jsp.organ_jsp._jspService(organ_jsp.java:132)
	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:386)
	at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
	at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:864)
	at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579)
	at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1665)
	at java.lang.Thread.run(Thread.java:595)
2011. 11. 22 오후 4:55:34 org.apache.catalina.core.StandardWrapperValve invoke
심각: Servlet.service() for servlet jsp threw exception
org.xml.sax.SAXParseException: An invalid XML character (Unicode: 0x0) was found in the element content of the document.
	at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAXParseException(ErrorHandlerWrapper.java:236)
	at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.fatalError(ErrorHandlerWrapper.java:215)
	at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:386)
	at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:316)
	at com.sun.org.apache.xerces.internal.impl.XMLScanner.reportFatalError(XMLScanner.java:1438)
	at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(XMLDocumentFragmentScannerImpl.java:1672)
	at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:368)
	at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:834)
	at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:764)
	at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:148)
	at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1242)
	at javax.xml.parsers.SAXParser.parse(SAXParser.java:375)
	at org.apache.axis.encoding.DeserializationContext.parse(DeserializationContext.java:227)
	at org.apache.axis.SOAPPart.getAsSOAPEnvelope(SOAPPart.java:696)
	at org.apache.axis.Message.getSOAPEnvelope(Message.java:435)
	at org.apache.axis.handlers.soap.MustUnderstandChecker.invoke(MustUnderstandChecker.java:62)
	at org.apache.axis.client.AxisClient.invoke(AxisClient.java:206)
	at org.apache.axis.client.Call.invokeEngine(Call.java:2784)
	at org.apache.axis.client.Call.invoke(Call.java:2767)
	at org.apache.axis.client.Call.invoke(Call.java:2443)
	at org.apache.axis.client.Call.invoke(Call.java:2366)
	at org.apache.axis.client.Call.invoke(Call.java:1812)
	at mke.oms.wsdlSEI.OrganProcessImplServiceSoapBindingStub.userViewInfoForWS(OrganProcessImplServiceSoapBindingStub.java:563)
	at mke.oms.wsdlSEI.OrganProcessProxy.userViewInfoForWS(OrganProcessProxy.java:86)
	at org.apache.jsp.organ_jsp._jspService(organ_jsp.java:132)
	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:386)
	at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
	at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:864)
	at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579)
	at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1665)
	at java.lang.Thread.run(Thread.java:595)

 
[클라이언트 측 에러메시지]

org.xml.sax.SAXParseException: An invalid XML character (Unicode: 0x0) was found in the element content of the document.
	com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAXParseException(ErrorHandlerWrapper.java:236)
	com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.fatalError(ErrorHandlerWrapper.java:215)
	com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:386)
	com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:316)
	com.sun.org.apache.xerces.internal.impl.XMLScanner.reportFatalError(XMLScanner.java:1438)
	com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(XMLDocumentFragmentScannerImpl.java:1672)
	com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:368)
	com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:834)
	com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:764)
	com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:148)
	com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1242)
	javax.xml.parsers.SAXParser.parse(SAXParser.java:375)
	org.apache.axis.encoding.DeserializationContext.parse(DeserializationContext.java:227)
	org.apache.axis.SOAPPart.getAsSOAPEnvelope(SOAPPart.java:696)
	org.apache.axis.Message.getSOAPEnvelope(Message.java:435)
	org.apache.axis.handlers.soap.MustUnderstandChecker.invoke(MustUnderstandChecker.java:62)
	org.apache.axis.client.AxisClient.invoke(AxisClient.java:206)
	org.apache.axis.client.Call.invokeEngine(Call.java:2784)
	org.apache.axis.client.Call.invoke(Call.java:2767)
	org.apache.axis.client.Call.invoke(Call.java:2443)
	org.apache.axis.client.Call.invoke(Call.java:2366)
	org.apache.axis.client.Call.invoke(Call.java:1812)
	mke.oms.wsdlSEI.OrganProcessImplServiceSoapBindingStub.userViewInfoForWS(OrganProcessImplServiceSoapBindingStub.java:563)
	mke.oms.wsdlSEI.OrganProcessProxy.userViewInfoForWS(OrganProcessProxy.java:86)
	org.apache.jsp.organ_jsp._jspService(organ_jsp.java:132)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:386)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)

javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

Posted by 칠복

트랙백이 없고 댓글이 없습니다.

Apache cxf 를 사용한 Webservice 서버의 end point에서 클라이언트 ip 알아내기

분류없음 2011/11/21 15:05

package mke.oms.wsdlSEI;

import java.util.List;

import javax.annotation.Resource;

import javax.jws.WebService;

import javax.servlet.http.HttpServletRequest;

import javax.xml.ws.WebServiceContext;

import javax.xml.ws.handler.MessageContext;

import mke.oms.dao.DeptDAO;

import mke.oms.dao.UserDAO;

import mke.oms.vo.Department;

import mke.oms.vo.OrganWebServiceParam;

import mke.oms.vo.User;

import org.apache.commons.logging.Log;

import org.apache.commons.logging.LogFactory;

import org.apache.cxf.transport.http.AbstractHTTPDestination;

@WebService(endpointInterface = "mke.oms.wsdlSEI.OrganProcess")

public class OrganProcessImpl implements OrganProcess {

@Resource

WebServiceContext wsContext;

public int deptInfoListCountForWS(OrganWebServiceParam param) {

MessageContext mc = (MessageContext)wsContext.getMessageContext();

HttpServletRequest req = (HttpServletRequest)mc.get(AbstractHTTPDestination.HTTP_REQUEST);

System.out.println("Client IP = " + req.getRemoteAddr());

return 어떤정수;

}

Posted by 칠복

트랙백이 없고 댓글이 없습니다.

JSTL에 3항 연산자 Ternary Operator 가 있다는 걸 이제야 알다니!!!!

분류없음 2011/11/17 10:40

${param.numberTxt == 1 ? 'selected' : ''}

Posted by 칠복

트랙백이 없고 댓글이 없습니다.

Java reflextion 이용 parameter가 없는 메소드 호출하는 예제

분류없음 2011/11/10 19:57

User theUser = (User)arry.get( idx );

Class cls = theUser.getClass(); //User의 Class객체

String theValue = null;

try {

Class[] parameterTypes = new Class[] {}; //모든 getter에는 parameter가 없으므로 parameterTypes 배열의 길이가 0임

Method method = cls.getMethod("get" + Key, parameterTypes); //getter 메소드를 가져오고

theValue = (String)method.invoke(theUser); // getter 메소드를 호출한다

} catch (InvocationTargetException e) {