이응기역

<script type="text/javascript">
document.onreadystatechange = () => {
  if (document.readyState === 'complete') {
	// Script to hide/show menu
	var button = document.querySelector('#menu-button');
	console.log('b11:', button);
	var menu = document.querySelector('#menu');
	button.addEventListener('click', function (event) {
		  if (menu.style.display == "") {
			  menu.style.display = "none";
			  button.innerHTML = "Show Menu";
		  } else {
			  menu.style.display = "";
			  button.innerHTML = "Hide Menu";
		  }
		}
	  );

  }
};
</script>
<button id="menu-button">Hide Menu</button>
<nav id="menu">
  <ul>
    <li>Item 1</li>
    <li>Item 2</li>
    <li>Item 3</li>
  </ul>
</nav>

strwaberry,

mysql.xs.dll not found

=> 

Copying C:\strawberry\c\bin\libmysql.dll_ to c:\strawberry\perl\vendor\lib\auto\mysql

(https://github.com/perl5-dbi/DBD-mysql/issues/318)

세션(DEV_ 등) 선택 [LOAD]
Conection 선택 후, Seconds .... 에 입력 (eg. 180)
Session 선책 후, [SAVE]

https://blog.webhostpython.com/2016/01/14/how-to-prevent-an-ssh-timeout-in-putty/

	@Resource
	private EntityManagerFactory barEntityManagerFactory;
    
    ...
	
        EntityManager entityManager = barEntityManagerFactory.createEntityManager();
		EntityTransaction transaction = entityManager.getTransaction();

		transaction.begin();
		
        entityManager.createNativeQuery(" drop table bar ").executeUpdate();
		
        transaction.commit();

https://github.com/gratiartis/multids-demo/tree/now-with-spring-boot
https://scattercode.co.uk/2016/01/05/multiple-databases-with-spring-boot-and-spring-data-jpa/
https://scattercode.co.uk/2013/11/18/spring-data-multiple-databases/


#logging:
#  level: INFO
..
    url: jdbc:mysql://localhost:3306/foo_schema?useSSL=false&useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC
    password: 1234
(application.yml)

    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>8.0.13</version>
    </dependency>
(pom.xml)

-- 첫번째 cmd 창에서
C:\Users\User1>plink -load MYTUNNEL_ -L 3307:localhost:3307

-- 새 cmd 창에서
C:\program files\....\bin> mysqldump.exe --column-statistics=0 --single-transaction -uscott0 -pcoff_scott0!@ -h 127.0.0.1 -P 3307 dragondb > dump.sql
 

* 원인 : metadata (JobRepository) 가 중복되어서 에러

* 조치 : parameter 를 넘겨서 처리한다

jojoldu.tistory.com/326

www.codeusingjava.com/boot/batch/hello

mysql 
dbeaver error
Unable to load authentication plugin 'caching_sha2_password'

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'passwd11';

deep-jin.tistory.com/entry/Connect-MySQL-with-DBeaver-Unable-to-load-authentication-plugin-cachingsha2password-%EC%97%90%EB%9F%AC