Re: help for RDB of CSS

["Kasemir, Kay" <kasemirk@ornl.gov>]

Hi:

From: tech-talk-bounces@aps.anl.gov <tech-talk-bounces@aps.anl.gov> on behalf of 梁雅翔 <liangyx@ihep.ac.cn>
>  Hi everyone,
>  I am studying the database of CSS.
>  I created a database named "test" and tables named "collmn" in mysql,adding some value myself.
>  I had connected the database(the test database I created) with eclipse successfully.
>  Then I tried to use it in CSS.
>  After I type the URL "jdbc:mysql://localhost:3306/test?user=root&passowrd=123" in CSS preference, I got the message "Error connecting to archiver server......Detail:Table 'test.status' doesn't exist".
>  I am not good at the database. And it took me several weeks to connected the mysql with eclipse.
>
>  I want some help.
> Could someone please tell me how to do it next? It is better that you have some example.
Right, there better be examples.
Check the CSS docbook, http://cs-studio.sourceforge.net/docbook/css_book.pdf, especially the chapters "10 Relational Database" and "11 Archive System".

To elaborate, from what you write I understand that you created a database named "test" and tables named "collmn" in mysql.
You can create many databases: A database with tables for names and addresses, flowers, your CD or MP3 collection.
CSS does not include tools to browse just any generic database.
The CSS Data Browser supports a very specific database with archived control system data.
The schema is described in the docbook.
The actual MySQL schema can be found in
https://github.com/ControlSystemStudio/cs-studio/blob/master/applications/archive/archive-plugins/org.csstudio.archive.rdb/dbd/mysql_schema.txt

As you can see in the schema, there needs to be a table named 'status':

# ----------------------
# Status mapping of status ID to string
DROP TABLE IF EXISTS status;
CREATE TABLE IF NOT EXISTS status
(
   status_id INT UNSIGNED PRIMARY KEY AUTO_INCREMENT,
   name VARCHAR(100) NOT NULL UNIQUE
);
INSERT INTO status (name) VALUES ('OK'), ('disconnected');
SELECT * FROM status;

The CSS code for reading archived data expects to find such a "status" table, but your database doesn't include one, so you get the error message
"Error connecting to archiver server......Detail:Table 'test.status' doesn't exist".

Thanks,
Kay