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

SimpleDB NullPointerException when inserting null value

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 8.12.2, 8.13
    • 8.7.1.6_2
    • Misc. Connectors
    • None
    • 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

      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:

      Unable to find source-code formatter for language: plain. Available languages are: actionscript, ada, applescript, bash, c, c#, c++, cpp, css, erlang, go, groovy, haskell, html, java, javascript, js, json, lua, none, nyan, objc, perl, php, python, r, rainbow, ruby, scala, sh, sql, swift, visualbasic, xml, yaml
      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]

        1. simpledb.cli
          0.7 kB
        2. simpledb-vdb.xml
          1 kB

              rhn-engineering-shawkins Steven Hawkins
              jstastny@redhat.com Jan Stastny
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: