Re: DataImportHandler Error CHARBytesToJavaChars

[Lance Norskog <go...@gmail.com>]

Oracle has a bunch of functions you can use in the SELECT statement to 
translate types. You may want to translate a NULL into an empty string.

harrysmith wrote:
> Anyone ever see this error on an import?
>
> Caused by: java.lang.NullPointerException
>          at
> oracle.jdbc.driver.DBConversion._CHARBytesToJavaChars(DBConversion.java:1015)
>
> The Oracle column being converted is VARCHAR2(4000 Char) and there are NULLs
> present in the record set.
>
> Envrionment: Solr 1.4, Windows, Jetty
>
>
> Full stack trace below:
>
>          at
> org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHand
> lerCollection.java:211)
>          at
> org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.
> java:114)
>          at
> org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:1
> 39)
>          at org.mortbay.jetty.Server.handle(Server.java:285)
>          at
> org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:50
> 2)
>          at
> org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpCo
> nnection.java:821)
>          at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:513)
>          at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:208)
>          at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:378)
>          at
> org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.
> java:226)
>          at
> org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool
> .java:442)
> Caused by: java.lang.NullPointerException
>          at
> oracle.jdbc.driver.DBConversion._CHARBytesToJavaChars(DBConversion.ja
> va:1015)
>          at
> oracle.jdbc.driver.DBConversion.CHARBytesToJavaChars(DBConversion.jav
> a:892)
>          at
> oracle.jdbc.driver.T4CVarcharAccessor.unmarshalOneRow(T4CVarcharAcces
> sor.java:282)
>          at oracle.jdbc.driver.T4CTTIrxd.unmarshal(T4CTTIrxd.java:919)
>          at oracle.jdbc.driver.T4CTTIrxd.unmarshal(T4CTTIrxd.java:843)
>          at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:630)
>          at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210)
>          at
> oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:961)
>          at
> oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStateme
> nt.java:1072)
>          at
> oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.jav
> a:845)
>          at
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
> nt.java:1154)
>          at
> oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.ja
> va:1726)
>          at
> oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1696)
>
>          at
> org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.<
> init>(JdbcDataSource.java:246)
>          ... 32 more
>