https://blog.youkuaiyun.com/jastarzh-cnhttps://blog.youkuaiyun.com/https://blog.youkuaiyun.com/jastar/article/details/50728035https://blog.youkuaiyun.com/jastar/article/details/50728035jastarWed, 24 Feb 2016 09:57:49 +0800https://blog.youkuaiyun.com/jastar/article/details/7880647https://blog.youkuaiyun.com/jastar/article/details/7880647jastarSat, 18 Aug 2012 13:54:51 +0800https://blog.youkuaiyun.com/jastar/article/details/6259500https://blog.youkuaiyun.com/jastar/article/details/6259500jastarFri, 18 Mar 2011 16:55:00 +0800https://blog.youkuaiyun.com/jastar/article/details/6220789https://blog.youkuaiyun.com/jastar/article/details/6220789jastarThu, 03 Mar 2011 15:17:00 +0800今天优化一个查询语句：
select to_char(m_date, 'MM'), count(*) from m_table group by to_char(m_date, 'MM'), 速度比较慢，需要1.5s左右的时间。在群里面讨教了一下高手，说通过函数索引可以优化, 于是：
create index m_date_month on m_table (to_char(m_date, 'MM'));
执行查询，
select to_char(m_da]]>https://blog.youkuaiyun.com/jastar/article/details/6077505https://blog.youkuaiyun.com/jastar/article/details/6077505jastarWed, 15 Dec 2010 13:40:00 +0800https://blog.youkuaiyun.com/jastar/article/details/6076183https://blog.youkuaiyun.com/jastar/article/details/6076183jastarTue, 14 Dec 2010 19:53:00 +0800这样才可以体现出Oracle集群的价值
jdbc:oracle:thin:@(DESCRIPTION =
        (ADDRESS_LIST =
                 (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.0.1)(PORT = 1521))
                 (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.0.2)(PORT ]]>https://blog.youkuaiyun.com/jastar/article/details/6066365https://blog.youkuaiyun.com/jastar/article/details/6066365jastarThu, 09 Dec 2010 19:47:00 +0800https://blog.youkuaiyun.com/jastar/article/details/6060910https://blog.youkuaiyun.com/jastar/article/details/6060910jastarTue, 07 Dec 2010 16:05:00 +0800 [was_profile] > Web 容器 > 定制属性
增加属性com.ibm.ws.webcontainer.invokefilterscompatibility 值为true]]>https://blog.youkuaiyun.com/jastar/article/details/6043771https://blog.youkuaiyun.com/jastar/article/details/6043771jastarMon, 29 Nov 2010 20:27:00 +0800客户端sqlplus和plsql developer连接集群数据库时时常会有ORA-12545错误，几率很高。据称是Oracle的bug。可以通过修改服务器rac1和rac2的数据库初始化参数来解决这个问题。
SQL> sqlplus sys/***@orcl1 as sysdba;
SQL> alter system set local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = 172.168.0.2) (PORT = 152]]>https://blog.youkuaiyun.com/jastar/article/details/6014562https://blog.youkuaiyun.com/jastar/article/details/6014562jastarWed, 17 Nov 2010 13:12:00 +0800 
让程序修改Quartz定时执行的时间，灵活执行Schedule。先看Spring配置
https://blog.youkuaiyun.com/jastar/article/details/6013293https://blog.youkuaiyun.com/jastar/article/details/6013293jastarTue, 16 Nov 2010 21:09:00 +0800https://blog.youkuaiyun.com/jastar/article/details/5943317https://blog.youkuaiyun.com/jastar/article/details/5943317jastarFri, 15 Oct 2010 14:39:00 +0800child1.html和child2.html都是父页面parent.html中的一个子iframe，请看child1.html如何调用child2.html中的方法。
parent.html
https://blog.youkuaiyun.com/jastar/article/details/5753820https://blog.youkuaiyun.com/jastar/article/details/5753820jastarWed, 21 Jul 2010 21:58:00 +0800https://blog.youkuaiyun.com/jastar/article/details/5747375https://blog.youkuaiyun.com/jastar/article/details/5747375jastarMon, 19 Jul 2010 20:15:00 +0800https://blog.youkuaiyun.com/jastar/article/details/5721773https://blog.youkuaiyun.com/jastar/article/details/5721773jastarThu, 08 Jul 2010 20:23:00 +08001. 首先需要keytool生成一个keystore
keytool -genkey -alias jastar -keyalg RSA -keystore jastar.keystore -validity 365
2.修改%jboss-home%/server/default/deploy/jboss-web.deployer/server.xml
    https://blog.youkuaiyun.com/jastar/article/details/5680183https://blog.youkuaiyun.com/jastar/article/details/5680183jastarSat, 19 Jun 2010 15:42:00 +0800https://blog.youkuaiyun.com/jastar/article/details/5666234https://blog.youkuaiyun.com/jastar/article/details/5666234jastarSat, 12 Jun 2010 12:47:00 +0800在局域网中有A, B, C,...其中只有A有外网ip，并且A主机有两个网卡，那么局域网就可以通过A作为代理访问外网了。
A 网卡1[外网]
ip address：172.158.0.234
subnet mask: 255.255.255.0
defaut getway: 172.158.0.1
A网卡2[内网]
ip address：192.168.1.2
subnet mask: 255.255.255.0
d]]>https://blog.youkuaiyun.com/jastar/article/details/5666209https://blog.youkuaiyun.com/jastar/article/details/5666209jastarSat, 12 Jun 2010 12:29:00 +0800 drop user sysman cascade; SQL> drop role MGMT_USER; SQL> drop user MGMT_VIEW cascade; SQL> drop public synonym MGMT_TARGET_BLA]]>