Categories
  • hacks 3
  • funny stuff 3
  • programming 14
  • linux 7
  • git 1
  • todo 1
  • security 2
  • CTF 1
  • cassandra 1
foo's blog
  • Posts
  • Categories
  • Interact with the H2 Database

    From the Example of my ScrumTool

    https://github.com/fo0/ScrumTool

    interact with the database

    You can easy read the h2-database file which is default located in the same directory like your ScrumTool-VERSION.jar To access the file you just need to download the latest h2 client from the official site: https://h2database.com/h2-2019-10-14.zip Unzip the .zip and use the client h2-VERSION-.jar from the bin directory.

    The command to show the tables is i.e.

    java -cp h2*.jar org.h2.tools.Shell -url jdbc:h2:file:./database -user sa -password sa -sql "show tables"

    To print all Boards just execute the following statement

    java -cp h2*.jar org.h2.tools.Shell -url jdbc:h2:file:./database -user sa -password sa -sql "show * from tkbdata"
    Posted 7 months ago by fo0.
  • Eclipse fix missing java-source-code

  • Eclipse Bug: Occurence PartRenderingEngine's limbo

  • Robot

  • Linux Management Platform

  • Java: Sending Objects via Sockets - ClassNotFoundException

← Previous
© 2021 foo's blog. All rights reserved.
  • RSS
  • Admin area
  • GitHub
  • B4R.me
  • kevkev.ovh