6 Replies Latest reply: Oct 29, 2012 12:23 AM by 969865 RSS

    Querying/Connecting to Database in Endeca

    969865
      Hi,

      Am trying to crawl database content in Endeca.

      Database: MS SQL server 2008 R2

      Following is the error that occurs every time i initiate crawling:

      ERROR     10/22/12 03:59:39.456 UTC (1350878379456)     FORGE     {baseline}: (AdapterRunner): Error handling result set.
      com.endeca.edf.adapter.plugins.JdbcAdapterException: Error handling result set.
           at com.endeca.edf.adapter.plugins.JdbcAdapter.handleQuery(JdbcAdapter.java:135)
           at com.endeca.edf.adapter.plugins.JdbcAdapter.execute(JdbcAdapter.java:97)
           at com.endeca.edf.adapter.AdapterRunner.run(AdapterRunner.java:168)
           at com.endeca.edf.adapter.AdapterRunner.main(AdapterRunner.java:43)
      Caused by: com.endeca.edf.adapter.AdapterError: DefaultJdbcColumnHandler encountered and unhandled JDBC Type: -9.
           at com.endeca.edf.adapter.plugins.DefaultJdbcColumnHandler.handleColumn(DefaultJdbcColumnHandler.java:294)
           at com.endeca.edf.adapter.plugins.JdbcAdapter.handleRow(JdbcAdapter.java:160)
           at com.endeca.edf.adapter.plugins.JdbcAdapter.handleQuery(JdbcAdapter.java:130)
           ... 3 more
           
      ERROR     10/22/12 03:59:40.518 UTC (1350878380518)     FORGE     {baseline}: The java process evaluating the java manipulator class 'com.endeca.edf.adapter.plugins.JdbcAdapter' failed. Check the file 'D:\install\Endeca\apps\databaseapp\config\script\..\..\.\logs\forges\Forge\Edf.Pipeline.RecordPipeline.JavaManipulator.LoadData.log' for more information.     
      ERROR     10/22/12 03:59:40.594 UTC (1350878380593)     FORGE     {baseline}: Forge failed with 2 errors and 0 warnings.     



      On trying the same with MYSQL as database it workes fine. I am a bit confused here as for every database same set of steps should work.
      Could you please give me pointers to troubleshoot the problem.

      Thanks in anticipation:)

      Nitin

      Edited by: NitinHD on Oct 22, 2012 9:15 PM
        • 1. Re: Database crawling in Endeca
          gose - oracle
          What's in this log file?

          D:\install\Endeca\apps\databaseapp\config\script\..\..\.\logs\forges\Forge\Edf.Pipeline.RecordPipeline.JavaManipulator.LoadData.log

          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.
          • 2. Re: Querying/Connecting to Database in Endeca
            969865
            Hi Gose,
            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.
                 at com.endeca.edf.adapter.plugins.JdbcAdapter.handleQuery(JdbcAdapter.java:135)
                 at com.endeca.edf.adapter.plugins.JdbcAdapter.execute(JdbcAdapter.java:97)
                 at com.endeca.edf.adapter.AdapterRunner.run(AdapterRunner.java:168)
                 at com.endeca.edf.adapter.AdapterRunner.main(AdapterRunner.java:43)
            Caused by: com.endeca.edf.adapter.AdapterError: DefaultJdbcColumnHandler encountered and unhandled JDBC Type: -9.
                 at com.endeca.edf.adapter.plugins.DefaultJdbcColumnHandler.handleColumn(DefaultJdbcColumnHandler.java:294)
                 at com.endeca.edf.adapter.plugins.JdbcAdapter.handleRow(JdbcAdapter.java:160)
                 at com.endeca.edf.adapter.plugins.JdbcAdapter.handleQuery(JdbcAdapter.java:130)
                 ... 3 more

            As per your suggestion i have changed the thread title.

            Nitin

            Edited by: NitinHD on Oct 22, 2012 9:16 PM
            • 3. Re: Querying/Connecting to Database in Endeca
              Pravin Chikhale
              Hi Nitin,

              Check with the driver information for MSSQL you are providing while fetching the data from DB.

              This might help you,
              http://stackoverflow.com/questions/1366077/getting-unhandled-token-type-unknown-token-0x53-error-when-connecting-to-mss

              HTH

              --Pravin                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   
              • 4. Re: Querying/Connecting to Database in Endeca
                969865
                Hi Pravin,
                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.

                Nitin

                Edited by: NitinHD on Oct 23, 2012 3:29 AM
                • 5. Re: Querying/Connecting to Database in Endeca
                  Brett R-Oracle
                  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.

                  Best
                  Brett
                  • 6. Re: Querying/Connecting to Database in Endeca
                    969865
                    Hi Brett,
                    Thanks a lot for the directions:).

                    The solution suggested by you worked.

                    Nitin

                    Edited by: NitinHD on Oct 28, 2012 10:23 PM