{"id":2328,"date":"2021-08-23T09:00:09","date_gmt":"2021-08-23T00:00:09","guid":{"rendered":"https:\/\/jennifersoft.com\/en\/uncategorized\/sql%eb%a1%9c-%ec%a0%9c%eb%8b%88%ed%8d%bc-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ec%a1%b0%ed%9a%8c%ed%95%98%ea%b8%b0\/"},"modified":"2021-08-23T13:54:13","modified_gmt":"2021-08-23T04:54:13","slug":"2021-08-23","status":"publish","type":"post","link":"https:\/\/jennifersoft.com\/en\/blog\/tech\/2021-08-23\/","title":{"rendered":"Viewing Jennifer data with SQL"},"content":{"rendered":"\n
\"\"<\/figure>\n\n\n\n

Using the Jennifer API server<\/h3>\n\n\n\n

Jennifer\nsaves the data collected per second in its own file system.
\nThe file system is developed to process large size data at high speed, and\ncustomer companies are collecting and processing large instance data in a\nstable manner. But since the file system is developed on their own, it has some\ndifficulties in viewing the data in form that a user wants to view.<\/p>\n\n\n\n

So, a lot of customers gave us feedbacks that they want to view and use Jennifer data with SQL more freely and the R&D team of Jennifer has been working hard to learn how to improve them and adding new functions as a result. <\/p>\n\n\n\n

At present, Jennifer provides two types of SQL viewing methods. In this article, I will show you how to view data by using the Jennifer API server and JDBC driver.
<\/p>\n\n\n\n

The\nJennifer API server operates as an independent process from the Jennifer\nserver.  
\nThe JDBC driver sends a request received from a user to the API server that\nreads the file DB and sends the HTTP responses as results.<\/p>\n\n\n\n

\"\"
Jennifer API Server Architecture<\/figcaption><\/figure>\n\n\n\n

Before you can use the Jennifer API, you must check whether the following files exist in the downloaded package.<\/p>\n\n\n\n

Each package is downloadable from the following link.<\/p>\n\n\n\n

API Server : https:\/\/github.com\/jennifersoft\/jennifer5-api-server<\/a> <\/p>\n\n\n\n

JDBC Driver : https:\/\/github.com\/jennifersoft\/jennifer5-jdbc-driver<\/a> <\/p>\n\n\n\n

Jennifer API server configuration file is called conf\/api_server.conf and it is prepared in the yaml format.<\/p>\n\n\n\n

apiServer:\n   host: \"0.0.0.0\"\n   port: 8080               JENNIFER API server's port number\n   authentication:\n     id: \"jennifer\"          Access ID\n     password: \"jennifer\"      Access password <\/pre>\n\n\n\n
jennifer:\n   dataServer:               Data server data \n     db:\n       - {path: \"\/home\/jennifer\/server.data\/db_data\", name: \"default\"} dbName\n   viewServer:               View server data\n     db:\n\n{path: \"\/home\/jennifer\/jennifer5-server\/db_view\", name: \"default\"}<\/pre>\n\n\n\n
   If you want to view the file DB data of multiple data servers or view servers, then add the directory paths as follows. <\/p>\n\n\n\n
db:\n  - {path: \"\/home\/jennifer\/server.data\/db_data\", name: \"default\"}\n  - {path: \"\/home\/jennifer\/server.data\/db_data1\", name: \"data1\"}\n  - {path: \"\/home\/jennifer\/server.data\/db_data2\", name: \"data2\"}<\/pre>\n\n\n\n
Now, let\u2019s learn how to use the Jennifer API server in an easy way.<\/p>\n\n\n\n
First, unzip the jennifer-api-server-{version}.zip file, and then edit the path of the view server or data server in the conf\/api_server.conf file to match the path of the user’s JENNIFER DB.<\/p>\n\n\n\n
Once you run the bin\/api-server (or api-server.bat) file, you can see the following log.<\/p>\n\n\n\n
\"\"
Example) JENNIFER API server execution<\/figcaption><\/figure>\n\n\n\n
 Now, the Jennifer API server is executed, we can view the data <\/p>\n\n\n\n
Since it is manufactured with the standard JDBC, we can use it in almost all the DB tools. In this article, we will learn how to use the built-in CLI of the driver, develop additional applications and use DBeaver which is an open-source DB management tool.<\/p>\n\n\n\n
First,\nthis is how to access by using the CLI function provided by the Jennifer JDBC\ndriver.
\nAs shown in the following, once you run the Jennifer JDBC driver, you can\neasily access the Jennifer DB.<\/p>\n\n\n\n
\"\"
Example) Running the CLI environment by using JENNIFER JDBC Driver<\/figcaption><\/figure>\n\n\n\n
Using the\nSQL statement while the CLI is running, you can view the Jennifer data.<\/p>\n\n\n\n
\"\"
Example) Viewing the JENNIFER transaction table list in the CLI environment<\/figcaption><\/figure>\n\n\n\n
If you want to implement an additional function by managing or viewing the Jennifer DB, you can use DriverManager to view data as follows.  <\/p>\n\n\n\n
\n\n\n\n
\/\/HTTP can be omitted<\/h4>\n\n\n\n