This content has been marked as final. Show 6 replies
What's in this log file?
Side note: I don't think the term crawl is the right word here. You are trying to connect to a database to query it. Crawling is an action more commonly associated with parsing information and links on the web.
Following are the logs present at D:\install\Endeca\apps\databaseapp\config\script\..\..\.\logs\forges\Forge\Edf.Pipeline.RecordPipeline.JavaManipulator.LoadData.log
Oct 22, 2012 4:05:56 PM com.endeca.edf.adapter.AdapterRunner run
SEVERE: Error handling result set.
com.endeca.edf.adapter.plugins.JdbcAdapterException: Error handling result set.
Caused by: com.endeca.edf.adapter.AdapterError: DefaultJdbcColumnHandler encountered and unhandled JDBC Type: -9.
... 3 more
As per your suggestion i have changed the thread title.
Edited by: NitinHD on Oct 22, 2012 9:16 PM
Hi Nitin,1 person found this helpful
Check with the driver information for MSSQL you are providing while fetching the data from DB.
This might help you,
Thanks for the direction.
Have switched to the latest driver(v4) but problem persists.
On changing the driver to jtds-1.2.6 i was able to connect to database and was able to index data.
Edited by: NitinHD on Oct 23, 2012 3:29 AM
Type -9 is java.sql.Types.NVARCHAR . Support was added for this column type a while back, but you'll need to download, install and use use the latest "Oracle Endeca Advanced JDBC Column Handler 6.1.2 for Generic Platform". Also, you would need to set passthrough COLUMN_HANDLER_CLASS=com.endeca.soleng.itl.jdbc.AdvancedJDBCColumnHandler2 (instead of the standard/documented com.endeca.soleng.itl.jdbc.AdvancedJDBCColumnHandler). I don't think this is currently documented - the Handler2 adds support for the Unicode types NCHAR, NVARCHAR etc.1 person found this helpful
Thanks a lot for the directions:).
The solution suggested by you worked.
Edited by: NitinHD on Oct 28, 2012 10:23 PM