久久亚洲精品无码AV红樱桃,亚洲A∨精品一区二区三区下载,亚洲一欧洲中文字幕在线

实现变更�l�计

俊星 — Mon, 22 Nov 2010 01:09:00 GMT

1、在本地数据库中创徏如下表：
-- Create table
create table TMP_CR_PERSONS
(
SPECIALTY     VARCHAR2(50),
USER_GROUP    VARCHAR2(50),
USER_NAME     VARCHAR2(50),
USER_CATEGORY VARCHAR2(50)
)

2、创建DBLINK�Q?br />
create database link LK2PMS connect to XXX identified by XX
using '(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.5.99)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = oradb9)
    )
)'

3、创��图，查询变更清单�Q?br /> CREATE OR REPLACE VIEW V_TMP_CR_LIST AS
SELECT D.CHANGE_REQUEST_CODE,
       D.PROJECT_NAME,
       D.PRODUCT_NAME,
       D.MODULE_NAME,
       D.TYPE,
       D.PRIVILEGE,
       D.PROPOSE_TIME,
       WF.TRANSACTOR,
       WF.TASKNAME,
       P.SPECIALTY,
       P.USER_GROUP,
       P.USER_CATEGORY
FROM PMS_CHANGE@lk2pms D,
       (SELECT MAX(ID) ID
          FROM WFT_FLOWCONTROL@lk2pms WF
         WHERE WF.WORKFLOWID = 'ChangeRequest'
         GROUP BY WF.WORKID) MX,
       WFT_FLOWCONTROL@lk2pms WF,
       TMP_CR_PERSONS P
WHERE WF.ID = MX.ID
   AND WF.WORKID = D.CHANGE_REQUEST_ID
   AND D.CHANGE_REQUEST_CODE LIKE 'CR%'
   AND WF.TRANSACTOR = P.USER_NAME
   AND D.STATE NOT IN ('�l�束','�l�止','拒绝');

4、创建统计视图：
CREATE VIEW V_TMP_CR_STAT AS
SELECT T.USER_GROUP, T.USER_NAME, COUNT(V.CHANGE_REQUEST_CODE) TOTAL
FROM V_TMP_CR_LIST V, TMP_CR_PERSONS T
WHERE V.TRANSACTOR(+) = T.USER_NAME
GROUP BY CUBE(T.USER_GROUP, T.USER_NAME);

俊星 2010-11-22 09:09 发表评论

切换IE8中碰到的问题

俊星 — Wed, 10 Nov 2010 02:04:00 GMT

1、当然是讉K��老系�l�中的，应该都采用兼容视�?br /> 2、在讉K��|�公司系�l�的时候，出现内存不能写的错误提示�Q�让后直接页面加载失败，解决办法是，扑ֈ�用SOGOU��览器加载页面后�Q�发现需要安装JITDSign�q�个插�g�Q�所以手工找到JITDSign.cab�Q�解压后直接�q�行“regsvr32 JITDSign.ocx”�Q�再��h��面�Q�OK了�?br />
3、其他问题暂未发现�?br />

俊星 2010-11-10 10:04 发表评论

发布FWMS

俊星 — Tue, 09 Nov 2010 03:59:00 GMT

1、利用命�?#8220;D:\FWMS\code\trunk\main\ear\ejb>dir /a:d /b”�Q�列丑և�所有的EJB模块清单

2、结合上面的清单�Q�结合正�?#8220;^(.*)$”�Q�替换�ؓ“”形式�Q��ƈ��得到的ant元素清单攄��到工�E�下build.xml�?#8220;Generating_Code”target中�?br />
3、基于如下正则，利用UE扚w��替换properties文�g中的project.path�Q?br /> 查找�Q?project.path.*)
目标�Q�project.path=../../../APP-INF/classes;../../../APP-INF/lib/activation.jar;../../../APP-INF/lib/ant.jar;../../../APP-INF/lib/apachepoi.jar;../../../APP-INF/lib/axis.jar;../../../APP-INF/lib/axis-ant.jar;../../../APP-INF/lib/bsh2.0.jar;../../../APP-INF/lib/classes12.zip;../../../APP-INF/lib/commons-
文�g�Q�build.properties
路径�Q�D:\FWMS\code\trunk\main\ear\ejb\
�Q�注意需要选中搜烦子目录项�Q?br />
4、上�q�完成之后，执行build_code.bat 卛_��完成EJB的编�?br />
5、设�|�ct-config.xml中相兛_��容，最后是启动weblogic �q�设�|�数据源�Q�同时发布应用�?br />
6、发布启动weblogic的时候，�?#8220;java.lang.OutOfMemoryError: PermGen space”异常�Q�在C:\bea\weblogic92\common\bin的commEnv.cmd中，查看到其内存讄��?#8220;set MEM_ARGS=-Xms128m -Xmx256m”�Q�在C:\bea\user_projects\domains\fwms_domain\bin下startWebLogic.cmd中，��d��“set MEM_ARGS=-Xms256m -Xmx512m -XX:MaxPermSize=128m”�Q�适当加大内存�?

俊星 2010-11-09 11:59 发表评论

ActiveMQ初探

俊星 — Thu, 28 Oct 2010 09:53:00 GMT

Apache ActiveMQ是一个高性能的消息代理，实现了JMS 1.1�?br /> 目前的最新版本是5.4.1
1、下载相兛_��Q��ƈ��activemq-all-5.4.1.jar加入到工�E�中�?br />
2、运行bin目录下的actionmq.bat文�g�Q�启动broker�Q�在conf下是相关的配�|�文�Ӟ��例如activemq.xml

3、可通过讉K��http://localhost:8161/admin/来查看启动情况，有可通过netstat -an|find "61616" 来查看端口，因�ؓ通过查看activemq.xml中即可发��C��输连接器即配�|�的占用61616端口�Q?br />

4、编写消息接收类�Q?br />

import javax.jms.Connection;
import javax.jms.ConnectionFactory;
import javax.jms.Destination;
import javax.jms.JMSException;
import javax.jms.MessageConsumer;
import javax.jms.Session;
import javax.jms.TextMessage;

import org.apache.activemq.ActiveMQConnection;
import org.apache.activemq.ActiveMQConnectionFactory;

public class JmsReceiver {
    public static void main(String[] args) throws JMSException {
        ConnectionFactory connectionFactory = new ActiveMQConnectionFactory(ActiveMQConnection.DEFAULT_USER,
                ActiveMQConnection.DEFAULT_PASSWORD, "tcp://localhost:61616");
        Connection connection = connectionFactory.createConnection();
        connection.start();
        Session session = connection.createSession(Boolean.TRUE, Session.AUTO_ACKNOWLEDGE);
        // 需要在activemq的控制台中创建queue�Q�testqueue
        Destination destination = session.createQueue("testqueue");
        MessageConsumer consumer = session.createConsumer(destination);

        while (true) {
            TextMessage message = (TextMessage) consumer.receive(1000);
            if (null != message)
                System.out.println("收到消息�Q?/span>" + message.getText());
            else
                break;
        }
        session.close();
        connection.close();
    }
}

5、编写消息��生类�Q?br />

import javax.jms.Connection;
import javax.jms.ConnectionFactory;
import javax.jms.DeliveryMode;
import javax.jms.Destination;
import javax.jms.JMSException;
import javax.jms.MessageProducer;
import javax.jms.Session;
import javax.jms.TextMessage;

import org.apache.activemq.ActiveMQConnection;
import org.apache.activemq.ActiveMQConnectionFactory;

public class JmsSender {
    public static void main(String[] args) throws JMSException {
        ConnectionFactory connectionFactory = new ActiveMQConnectionFactory(ActiveMQConnection.DEFAULT_USER,
                ActiveMQConnection.DEFAULT_PASSWORD, "tcp://localhost:61616");
        Connection connection = connectionFactory.createConnection();
        connection.start();
        Session session = connection.createSession(Boolean.TRUE, Session.AUTO_ACKNOWLEDGE);
        Destination destination = session.createQueue("testqueue");
        MessageProducer producer = session.createProducer(destination);
        producer.setDeliveryMode(DeliveryMode.NON_PERSISTENT);
        sendMsg(session, producer);
        session.commit();
        connection.close();
    }

    public static void sendMsg(Session session, MessageProducer producer) throws JMSException {
        // 创徏一条文本消�?/span>
        TextMessage message = session.createTextMessage("你好 ActiveMQ�Q?/span>");
        producer.send(message);
        System.out.println("");
    }
}

6、通过讉K��http://localhost:8161/admin/�Q�在queue中创建testqueue�Q�先执行消息发送类�Q�后执行消息接收�c�，借看看到消息接收�cȝ��如下执行�l�果�Q?br /> 收到消息�Q�你�?ActiveMQ�Q?br /> 收到消息�Q�你�?ActiveMQ�Q?br />
�Q�执行多�ơ消息发送类�Q�则会接受到多条“你好 ActiveMQ!”消息�Q?

俊星 2010-10-28 17:53 发表评论

CAS初步配置

俊星 — Tue, 26 Oct 2010 06:36:00 GMT

此处的CAS是指Central Authentication Service�Q�也即统一认真服务�Q�这里采用的是JASIG提供的相��x��务端及客��L��c�d��Q�结合TOMCAT�q�行��试�?br />
1、下载相关的服务器端和客��L��c�d��Q�官�|�是�Q?a >http://www.jasig.org/cas/�Q�目前我采用的是�Q?br /> 服务器端�Q�cas-server-3.3.4-release.zip
客户端：cas-client-2.0.11.zip

2、配�|�TOMCAT的SSL�Q�具体可见上一��博文：
�?CATALINA_HOME%/conf/server.xml中，��d��Q?br />                maxThreads="150" scheme="https" secure="true"
               clientAuth="false" sslProtocol="TLS"
               keystoreFile="F:\eclipse\workspace\httpc\tomcat3.keystore"
               keystorePass="123456"/>
配置OK后，可通过讉K��“https://localhost:8443/examples/servlets/servlet/HelloWorldExample”来进行验�?br />
3、配�|�CAS服务器端�Q?br /> ��cas-server-3.3.4-release.zip中modules文�g夹下的cas-server-webapp-3.3.4.war的解压到TOMCAT的webapps目录下�?br /> 重启TOMCAT后，可以通过讉K��“http://localhost:8080/cas/login”�q�输入相同的用户名密码来�q�行验证�?br /> 另：需要特别说明，cas应用中默认配�|�的是SimpleTestUsernamePasswordAuthenticationHandler�Q�该处理�c�d��要保持用户名、密码一直即可通过验证�?br />
4、配�|�CAS客户端：
在webapps\examples\WEB-INF中，对web.xml��d��如下内容�Q?br />

CAS Filter

edu.yale.its.tp.cas.client.filter.CASFilter

edu.yale.its.tp.cas.client.filter.loginUrl

https://localhost:8443/cas/login

edu.yale.its.tp.cas.client.filter.validateUrl

https://localhost:8443/cas/serviceValidate

edu.yale.its.tp.cas.client.filter.serverName

localhost:8080

CAS Filter

/servlets/servlet/HelloWorldExample

同时�Q�将cas-client-2.0.11.zip中的casclient.jar�Q�拷贝到webapps\examples\WEB-INF\lib中，重启TOMCAT卛_��q�行验证�?br />
5、验证CAS�Q?br /> a、在��览器中讉K��“http://localhost:8080/examples/servlets/servlet/HelloWorldExample”
b、基于前面配�|�的�q��o器，��览器会定向CAS的认证页�?#8220;https://localhost:8443/cas/login?service=http%3A%2F%2Flocalhost%3A8080%2Fexamples%2Fservlets%2Fservlet%2FHelloWorldExample”
c、在CAS的认证页面中输入相同的用户名密码test/test后，执行��d��
d、浏览器提示安全警告�Q�点�ȝ��定后卌��{入到“http://localhost:8080/examples/servlets/servlet/HelloWorldExample?ticket=ST-1-xWK9nwArDLbjCwYiXOqu-cas”�Q�同旉��面打�?#8220;Hello World”�Q�配�|�成功�?br />

俊星 2010-10-26 14:36 发表评论