Skip to main content
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
[smila-user] mysql crawler
I configured mysql crawler with jdbc.xml and correct xsd file. However when i do this from REST client my data does not seem to index

http://localhost:8080/smila/crawlers/jdbc

{
    "jobName":"indexUpdateJob"
  }

The following error happens and does not seem to index. Can you tell me what could be the issue?

KeeperException when processing sessionid:0x13315c329620000 type:create cxid:0x923 zxid:0xfffffffffffffffe txntype:unknown reqpath:n/a Error Path:/smila/tasks Error:KeeperErrorCode = NoNode for /smila/tasks
 2011-10-18 12:12:08,116 INFO  [Thread-19                                    ]  impl.DeltaIndexingManagerImpl                 - obsoleteIdIterator could not find any obsolete ids for source: jdbc
 2011-10-18 12:12:08,225 INFO  [Thread-19                                    ]  jdbc.JdbcCrawler                              - Closing JdbcCrawler...
 2011-10-18 12:12:08,225 INFO  [Thread-19                                    ]  impl.CrawlThread                              - Removing deltaindexing lock on datasource jdbc
 2011-10-18 12:12:08,257 INFO  [Thread-19                                    ]  impl.CrawlThread                              - Finished session edac8322-3bf2-4608-99fc-d47df79314b7 and removed Deltaindexing lock on datasource jdbc
 2011-10-18 12:12:08,257 INFO  [Thread-19                                    ]  impl.CrawlThread                              - Unregistering crawling thread jdbc
 2011-10-18 12:12:08,257 INFO  [Thread-19                                    ]  impl.CrawlThread                              - Crawling thread jdbc unregistered
 2011-10-18 12:12:08,257 INFO  [Thread-19  
<?xml version="1.0" encoding="UTF-8"?>
<DataSourceConnectionConfig
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
  xsi:noNamespaceSchemaLocation="../org.eclipse.smila.connectivity.framework.crawler.jdbc/schemas/JdbcDataSourceConnectionConfigSchema.xsd">
	<DataSourceID>jdbc</DataSourceID>
	<SchemaID>org.eclipse.smila.connectivity.framework.crawler.jdbc</SchemaID>
	<DataConnectionID>
		<Crawler>JdbcCrawler</Crawler>
	</DataConnectionID>
<DeltaIndexing>full</DeltaIndexing>
<Attributes>
<Attribute Name="name" HashAttribute="false" KeyAttribute="false" Type="String">
<ColumnName>name</ColumnName>
<SqlType>string</SqlType>
</Attribute>

<Attribute Name="email" HashAttribute="false" KeyAttribute="false" Type="string">
<ColumnName>email</ColumnName>
<SqlType>string</SqlType>
</Attribute>


<Attribute Name="id" HashAttribute="true" KeyAttribute="true" Type="long">
<ColumnName>id</ColumnName>
<SqlType>long</SqlType>
</Attribute>

</Attributes>
<Process>
<Selections>
<!--
<Grouping> <Stepping>20</Stepping> <SQL>SELECT CONVERT(varchar, [nMessageID]) as Leading_ID FROM [KinkonGmbHTestDB].[dbo].[SMILA_NewsView] ORDER BY Leading_ID ASC</SQL> </Grouping>
-->
<SQL>
(SELECT id, name as name ,email as email FROM authors) 
</SQL>
</Selections>
<Database Connection="jdbc:mysql://localhost:3306/vidya" FetchSize="100000" User="root" Password="" JdbcDriver="com.mysql.jdbc.Driver"/>
</Process>
</DataSourceConnectionConfig>

Attachment: JdbcDataSourceConnectionConfigSchema.xsd
Description: Binary data

Back to the top