Newton-Raphson method

www.etcnotes.info

partial mocking method easy mock 2.x

teja.tejakantamneni.com

birt locale bug info

bugs.eclipse.org

keystore

https://docs.oracle.com/javase/jp/1.3/tooldocs/solaris/keytool.html#keycloneCmdhttp://hamasyou.com/blog/2007/10/27/weblogic-ssl/https://rms.ne.jp/sslserver/install/install_weblogic-8-9-html/https://qiita.com/makopo/items/092494d8fb32b2edf7…

get parameter info from eclipse birt report

package birtAnalizer; import java.io.File; import java.io.IOException; import javax.xml.parsers.SAXParser; import javax.xml.parsers.SAXParserFactory; import javax.xml.parsers.ParserConfigurationException; import org.xml.sax.Attributes; imp…

birt font problem with adobe acrobat

bugs.eclipse.org

postgres any column to fixed one size rec sample

sample data select * from nyukintable; id | siten | kokyakuid | nyukin | torihikibi ----+-------+-----------+--------+------------ 1 | 東京 | 001 | 77500 | 2007-01-01 2 | 大阪 | 002 | 56200 | 2007-01-02 3 | 福岡 | 003 | 17900 | 2007-01-03 …

postgres distinct on & lead

a=# select * from rate_history order by ch_date; ch_date | rate ---------------------+----------- 2021-02-15 00:00:00 | 0.0008000 2021-03-01 00:00:00 | 0.0010000 2021-03-02 00:00:00 | 0.0010000 2021-03-03 00:00:00 | 0.0010000 2021-03-04 00…

multiple column rows to array

select * from nyukintable; id | siten | kokyakuid | nyukin | torihikibi ----+-------+-----------+--------+------------ 1 | 東京 | 001 | 77500 | 2007-01-01 2 | 大阪 | 002 | 56200 | 2007-01-02 3 | 福岡 | 003 | 17900 | 2007-01-03 4 | 東京 | 0…

postgres tech

------------------------init------------------------select * from bs_summary ; agg_code | debit | credit ----------+---------+-------- 1002 | 1000000 | 1001 | 1000000 | 2001 | | 800000 2002 | | 800000(4 rows) -------------------------rollu…

memo util

Spring で DI しつつ Theories ランナーを使いたい - Qiita

apache poi and junit sample(private method)

package viewda; import java.io.File; import java.io.IOException; import java.lang.reflect.Method; import java.math.BigDecimal; import java.util.ArrayList; import java.util.List; import org.apache.poi.EncryptedDocumentException; import org.…

apache poi and junit sample

package viewda; import java.io.File; import java.io.IOException; import java.math.BigDecimal; import java.util.ArrayList; import java.util.Date; import java.util.List; import org.apache.poi.EncryptedDocumentException; import org.apache.poi…

Postgresql rotation number sample

SELECT *,mod(rn,8) FROM ( SELECT row_number() OVER (ORDER BY pro_id) AS rn, * FROM products ) AS rn_q; rn | pro_id | id | value | mod ----+--------+----+---------+----- 1 | 1111 | 2 | 99999 | 1 2 | 1234 | 1 | 10000 | 2 3 | 3343 | 3 | 12345…

test sample(junit theory)

package viewda; import static org.junit.Assert.*; import org.junit.experimental.theories.DataPoint; import org.junit.experimental.theories.Theories; import org.junit.experimental.theories.Theory; import org.junit.runner.RunWith; @RunWith(T…

group by span and sum

select settled_span.settled_date, sum(unpay.value) as sum_products from (select settled_date + cast('-6 month' as interval) + '1 day' as from_date,settled_date from future_settlements) settled_span left join unpay ON from_date <= unpay.has…

java excel read sample

import java.io.FileInputStream; import java.util.ArrayList; import java.util.List; import org.apache.poi.hssf.usermodel.HSSFSheet; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.poi.ss.usermodel.Cell; import org.apach…

postgresql trick by generate_series

select * from GENERATE_SERIES('2020-03-12'::timestamp, '2030-03-12'::timestamp, '6 month'::INTERVAL); generate_series --------------------- 2020-03-12 00:00:00 2020-09-12 00:00:00 2021-03-12 00:00:00 2021-09-12 00:00:00 2022-03-12 00:00:00…

BIRT decimal - float

ref: bugs.eclipse.org and test below: exam

compare db postgres

hacknote.jp

thanks helps

tmftake.hateblo.jp

dbunt - apache poi export excel date type format helps me

shorindo.com

found

qiita.com

my memo ( jspc )

www.ne.jp

hudson war lib

mvnrepository.com

birt add dynamic where clause to dataset query

1. query 2. dynamic where clause(if parameter in)

increase rows in count column : generate_series function

luna=# select * from sample; stake_no | cnt ----------+----- 0001 | 1 0002 | 3 (2 rows) luna=# select * from sample,generate_series(1, 99) as id where sample.cnt >= id; stake_no | cnt | id ----------+-----+---- 0001 | 1 | 1 0002 | 3 | 1 00…

postgresql - jdbc driver compatibility

jdbc.postgresql.org

bird archive site

archive.eclipse.org

easy mock nested sample

<test class> 1. inner class public class ConcatorIml implements Concater { @Override public String concat(String str1, String str2) throws Exception { String conc = ""; conc = str1+str2; return conc; } } 2.outer class public class parConcatorImpl impl</test>…