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
|
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.0.8 of the mysql JDBC connector here:
http://dev.mysql.com/downloads/connector/j/5.0.html
After extracting the archive, add mysql-connector-java-5.0.8-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
NOTE: The 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.
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.
|
