Options

Write Database: java.lang.NullPointerException

dcubeddcubed Member Posts: 6 Contributor II
edited November 2018 in Help
After looping through 911 records, the process writing to the database failed as shown below.
Any ideas on how to keep the session with the database alive (assuming that's part of the problem)?
It seems that the process opens and closes a database connection for each record in the innermost loop.
If there is another mechanism to capture the predicted values from the inner loop, please advise.

Apr 18, 2012 12:09:21 PM CONFIG: Connecting to jdbc:jtds:sqlserver://servername:1433/dbname as RapidMiner.
Apr 18, 2012 12:09:21 PM SEVERE: Process failed: operator cannot be executed. Check the log messages...
Apr 18, 2012 12:09:21 PM SEVERE: Here:          Process[1] (Process)
          subprocess 'Main Process'
            +- Read CSV[1] (Read CSV)
            +- Filter Examples[1] (Filter Examples)
            +- Set Label[1] (Set Role)
            +- Select Attributes[1] (Select Attributes)
            +- Discretize[1] (Discretize by User Specification)
            +- Nominal to Binominal[1] (Nominal to Binominal)
            +- Validation[1] (Sliding Window Validation)
          subprocess 'Training'
                |  +- Neural Net[911] (Neural Net)
          subprocess 'Testing'
                  +- Apply Model[911] (Apply Model)
                  +- Performance[912] (Performance (Classification))
      ==>        +- Write Database[911] (Write Database)
Apr 18, 2012 12:09:21 PM SEVERE: java.lang.NullPointerException

Answers

  • Options
    MariusHelfMariusHelf RapidMiner Certified Expert, Member Posts: 1,869 Unicorn
    Hi,

    please post your process setup, so that we can see what you are doing right now and give you hints on how to improve it.

    Best, Marius
Sign In or Register to comment.