1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
|
MySQL JDBC Demo
===============
This demo shows how to implement an Ice server that uses mysql through
a JDBC API and demonstrates the following techniques:
- Mapping relational data to Ice objects, and in particular the
conversion between Ice and JDBC types.
- Using a JDBC connection pool to provide JDBC connections for Ice
requests.
- Using an Ice servant locator.
- Using a dispatch interceptor.
Building the demo
-----------------
1. Install mysql if necessary.
2. Download version 5.1.23 of the mysql JDBC connector here:
http://dev.mysql.com/downloads/connector/j/5.1.html
After extracting the archive, add mysql-connector-java-5.1.23-bin.jar
to your CLASSPATH.
3. Create a database named "library" and grant privileges to a user. In
the commands below, replace USER with the name you have chosen and
PASSWORD with a suitable password:
$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor.
mysql> CREATE DATABASE library;
Query OK, 1 row affected (0.00 sec)
mysql> GRANT ALL PRIVILEGES ON library.* TO "USER"@"localhost"
-> IDENTIFIED BY "PASSWORD";
Query OK, 0 rows affected (0.00 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.01 sec)
mysql> EXIT
4. Create the SQL tables using the script createTypes.sql:
$ mysql --user=USER --pass=PASSWORD library < createTypes.sql
5. Edit the JDBC properties in config.server to reflect your selected
user name and password:
JDBC.Username=USER
JDBC.Password=PASSWORD
NOTES:
These instructions assume that the demo server runs on the same
host as the mysql server. If you intend to run the demo server on
a different host than the mysql server, you will need to revise
the mysql privileges as well as the JDBC URL in config.server.
In order to get correct results when using multiple concurrent
clients, you need to use the SERIALIZABLE isolation level. Refer
to the mysql documentation for instructions on how to set the
isolation level:
http://dev.mysql.com/doc/refman/5.0/en/set-transaction.html
Running the demo
----------------
To run the demo, first start the server:
$ java Server
The demo includes a text file named "books" containing a series of
commands that populate the server's database with a collection of
books. Pass this file as an argument the first time you run the
client. In another window:
$ java Client books
Type "help" to get a list of valid commands.
Running the demo with Glacier2
------------------------------
The demo also supports a Glacier2 deployment. You will need to edit
config.client and uncomment these configuration parameters:
#Ice.Default.Router=DemoGlacier2/router:ssl -p 4064 -h 127.0.0.1
#Ice.ACM.Client=0
#Ice.RetryIntervals=-1
To run the demo using Glacier2, first start the server:
$ java Server
In a separate window, start the Glacier2 router:
$ glacier2router --Ice.Config=config.glacier2
In a separate window, start the client:
$ java Client books
Omit the "books" argument if you have already populated the server's
database.
SSL Certificates for IceTouch
-----------------------------
If you want to use this server with Ice Touch clients, you will need
to replace the server and Glacier2 certificates used by this demo with
the certificates included in the Ice Touch distribution.
The simplest solution is to update the IceSSL.DefaultDir property in
the Glacier2 and server configuration files to point to the certs
directory of the Ice Touch distribution.
|
