The first problem:
We thought we had "successfully setup the database," but we found out we didn't :-(. For the Lexicon files, we set the wrong primary key. Thus I went through all the 13 files again, and looked for any potential primary keys. EUI (The Entry Unique ID Number) looks like should be the primary key, but among all the 13 tables, it either didn't have all the numbers, or it was redundant, so apparently EUI doesn't qualify to be the primary key. Then I checked other entries. They all have the same problem as EUI. I got very frustrated. How can a DBMS NOT have a primary key? Then I happened to read a paragraph from a "UMLS fact" site, and it says that the UMLS files are not normalized. HA! So I suppose EUI is still the primary key.
The second problem:
Since JDBC is installed on ender (one of the UNIX box), everyone needs to be "rlogin ender" to access JDBC. So I was told to setup the JDBC driver so that users can access it from galt (another UNIX box server) without "rlogin ender". I have tried
Connection Con=DriverManager.getConnection ("jdbc:mysql://ender.var.tmp/jdbctest?user=medinfo&password=inform");
and many other similar combinations, but none of them worked. I also tried to look for anwsers online, but I didn't get much luck. I'll keep trying next week.