Connecting Weka to Oracle Database

Weka connects to the Oracle database Weka to provide the function of connecting to the database. This article only illustrates how to set up the connection to Oracle. 1. Download the Oracle database driver jar package, usually ojdbc14.jar or oracle-10.2.0.1-jdbc14.jar, put it in a directory. Suppose E: \ Eb \ Weka-3-6 \ directory. 2. find weka in the weka installation directory. open the jar file using winrar (or other compression software) and find "DatabaseUtils. props. oracle "file, decompress it to the weka installation directory (such as E: \ Eb \ Weka-3-6 \), and change it to DatabaseUtils. props. Note: You must change the name. 3. Modify the jdbcURL line of the DatabaseUtils. props file (row 15th by default), and modify the IP address and database instance name based on your actual situation. [Plain] jdbcURL = jdbc: oracle: thin: @ 192.1.0.171: 1521: dw110 4. modify RunWeka in the weka installation directory. the cp line of the INI file (the last line of the file by default). Add the directory of the oracle driver jar package to the end. [Plain] cp = % CLASSPATH %; E: \\\\ Eb \\\\ Weka-3-6 \\\\ oracle-10.2.0.1-jdbc14.jar Note: diagonal lines and backlash; the file name must be specified and cannot be written only to the directory E: \\\\ Eb \\\ Weka-3-6. 5. from Explorer's "Open DB... "button to enter, click" User... "button. The value set in the configuration file is automatically loaded in the Database URL text box. You also need to set the Username and Password for the Database connection ). The Explorer and Experimenter modules of Weka provide the function of connecting to the database. After entering Explorer, click "Open DB... "button to go to the set Database interface; after entering the Experimenter module, click the Analyse tab, and then click" Database... "button to enter.