Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-3819

SimpleDB NullPointerException when inserting null value

    Details

    • Steps to Reproduce:
      Hide
      1. configure simpleDB translator in subsystem teiid in server configuration
      2. configure a resource-adapter to connect to simpleDB instance by running attached cli script
      3. create a vdb similar to the one in attachments
      4. try to insert data using the vdb, where one of the values is null
      Show
      configure simpleDB translator in subsystem teiid in server configuration configure a resource-adapter to connect to simpleDB instance by running attached cli script create a vdb similar to the one in attachments try to insert data using the vdb, where one of the values is null

      Description

      When performing INSERT query, where one of the values is null, NullPointerException is thrown.
      Example query:

      INSERT INTO SMallA(ItemName,doublenum) VALUES ('nullRow',null)
      

      Stack trace in teiid's console:

      13:59:57,789 ERROR [org.teiid.PROCESSOR] (Worker6_QueryProcessorQueue35) TEIID30019 Unexpected exception for request dypFs9C3QJ3B.14: java.lang.NullPointerException
      	at org.teiid.resource.adapter.simpledb.SimpleDBConnectionImpl.addAttribute(SimpleDBConnectionImpl.java:255)
      	at org.teiid.resource.adapter.simpledb.SimpleDBConnectionImpl.performInsert(SimpleDBConnectionImpl.java:223)
      	at org.teiid.translator.simpledb.SimpleDBInsertExecute.execute(SimpleDBInsertExecute.java:52)
      	at org.teiid.dqp.internal.datamgr.ConnectorWorkItem$1.execute(ConnectorWorkItem.java:363) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1]
      	at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:330) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1]
      	at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:298) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1]
      	at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:110) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1]
      	at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:107) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1]
      	at java.util.concurrent.FutureTask.run(FutureTask.java:262) [rt.jar:1.7.0_79]
      	at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:58) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1]
      	at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1]
      	at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1]
      	at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1]
      	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_79]
      	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_79]
      	at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_79]
      

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                shawkins Steven Hawkins
                Reporter:
                jstastny Jan Stastny
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: