Data Cannot Be Written to Bolts When the Storm-JDBC Plug-in Is Used to Develop Oracle Databases

Symptom

When the Storm-JDBC plug-in is used to develop Oracle write Bolts, the Oracle database can be connected, but data cannot be written to the Oracle database.

Possible Causes

• The topology definition is incorrect.
• The definition of the database table result is incorrect.

Cause Analysis

1. On the Storm web UI, check the DAG of the topology. The DAG is consistent with the topology definition.

   

2. The definition of the KeyWordFilter Bolt is consistent with the expParser field.

   

   

3. View the table definition in the Oracle database. The field name is in uppercase, which is inconsistent with flow definition field name.

   

4. When the execute method is debugged independently, it is found that the thrown field does not exist.

   

Procedure

The field name of the stream definition is changed to uppercase letters, which is the same as that defined in the database table.