July 23, 2001

As I planned last week, I am going to test if JDBC was installed properly. First, I created a small dummy file in MySQL called "jdbctest". It contains two files (tables), MRFILES and SRLD both of which are real files I copied from the UMLS database. Then I wrote a program to test if the JDBC driver can actually retrieve data from the database. I used Class.forName("org.gjt.mm.mysql.Driver").newInstance(); to load JDBC driver. Then I used Connection Con=DriverManager.getConnection ("jdbc:mysql://localhost/jdbctest?user=medinfo&password=inform"); to connect the driver. You can find more detail information from here. Now, the UMLS database is successfully setup and JDBC driver is working properly, our next goal is to replace all the UMLS API calls in the Dynacat implementation with calls to the new database. In order to do that, we need to understand the existing java codes. Thus we are reading Wanda's dissertation which will help us to understand the codes. We also helped one of the grad student to download a bunch of html, table, and pdf files.

Related Links:

Home

Index

Previous Week

Next Week

If you have any questions, please contact me. Thank you.

Name:

Christine Groce

Email:

ccgroce@hotmail.com