Guida Korea - scristalli/sql-developer-keepalive GitHub Wiki

Building the extension (Linux)

  • If you are not interested in re-building the extension and only want to use it, please skip forward to section Setup.
  • Install the latest version of Oracle JDeveloper 12c.
  • Clone the repository.
  • Open "SQL Developer 4 keepalive.jws" with JDeveloper, upgrade its version if JDeveloper asks you to do so.
  • Build the project with the pre-loaded profile "JAR-Deploy", confirming the default options.
  • Launch the script "pack_extension.sh". The file keepalive.zip created by the script is the extension file that can be installed in SQLDeveloper.

Setup

  • νŒŒμΌμ„ λ‹€μš΄λ‘œλ“œ : keepalive.zip (available in this repository under Releases).
  • 이뢀뢄은 μ•ˆν–ˆλŠ”λ° μž˜λœλ‹€. -> Make sure that you have writing permissions on the installation folder of SQL Developer. To aquire them, launch this command (edit the path if necessary): sudo chmod -R o+w /opt/sqldeveloper.
  • SQL Developer λ₯Ό μ‹€ν–‰ν•œλ‹€..
  • 도움말 -> μ—…λ°μ΄νŠΈ 확인 ν™”λ©΄μœΌλ‘œ 이동.
  • μ•„λž˜ μͺ½μ— 보면 λ‘œμ»¬νŒŒμΌμ—μ„œ μ„€μΉ˜λ₯Ό 선택후에 λ‹€μš΄λ‘œλ“œ 받은 keepalive.zip νŒŒμΌμ„ μ„ νƒν•œλ‹€..
  • SQL Developerλ₯Ό λ‹€μ‹œ μ‹œμž‘ν•΄μ•Όν•œλ‹€.
  • λ‹€μ‹œ μ‹œμž‘ν•˜κ³ λ‚˜λ©΄ λ©”λ‰΄λ°”μ•„λž˜ μͺ½μ— 텍그(?) 이미지가 μΆ”κ°€ λ˜μ–΄μžˆλ‹€. 마우슀 μ˜€λ²„ ν–ˆμ„λ•Œ keepalive 타이틀이 보인닀. μ—¬κΈ°μ—μ„œ μ‹œκ°„μ„ μ„€μ •ν•΄μ£Όλ©΄ λœλ‹€.

Use

  • The extension won't start automatically; a click on the icon is required to start it.

  • When the extension starts, the user has to input the desired timeout T in seconds. If by mistake the user does not insert a valid timeout (i.e. an integer greater than 59), T is set by default to 600.

  • Every T seconds, the query SELECT SYSDATE FROM DUAL; is sent on every open connection, in order to prevent it from closing.

  • To deactivate the keepalive extension, click the icon again.

Notes

  • The extension has a log system, which informs the user about successful operations or errors that have occurred.
  • WARNING | When the extension writes its log, the focus is gained by the log window in SQL Developer, and this might interfere with the autocomplete functionality if the user is writing a query. However, the extension is thought to be used with medium timeout settings (e.g. T=600), and we think that one click every ten minutes to bring back the focus to the active document is acceptable. FIXED IN RELEASE 1.2
  • WARNING | Some user have experienced a problem after installing the extension: they lost edits (renamings and groups) they had made to their connections. This might happen to you also.