[smila-dev] SMILA Crawling mySQL DB

[Kerstin Bach <bach@xxxxxxxxxxxxxxxxxxxxx>]

Dear all,

we are trying to use the mySQL-Crawler that has already been mentioned 
on this list. Is there somewhere an example on how to set up such a crawler?

We've already created an DataSourceConnectionConfig (based on the kinkon 
example). Further we've added the following mySQL connection string 
restriction to the JdbcDataSourceConnectionConfigSchema.xsd:
<xs:pattern 
value="jdbc:mysql://[\w\.\-]+:\d+(;(DatabaseName|HostProcess|NetAddress|Password|PortNumber|ProgramName|SelectMethod|SendStringParametersAsUnicode|ServerName|User)=[\w\i]+)*" 
/>

However we got the following error:
Error loading DataSource with DataSourceId 'jdbc': 
javax.xml.bind.UnmarshalException
 - with linked exception:
[org.xml.sax.SAXParseException: cvc-pattern-valid: Value 
'jdbc:mysql://localhost:3306/forum' is not facet-valid with respect to 
pattern 
'jdbc:oracle:thin:@[\w\.\-]+:\d+:\w+|jdbc:microsoft:sqlserver://[\w\.\-]+:\d+(;(DatabaseName|HostProcess|NetAddress|Password|PortNumber|ProgramName|SelectMethod|SendStringParametersAsUnicode|ServerName|User)=[\w\i]+)*|jdbc:sqlserver://[\w\.\-]+:\d+(;(DatabaseName|HostProcess|NetAddress|Password|PortNumber|ProgramName|SelectMethod|SendStringParametersAsUnicode|ServerName|User)=[\w\i]+)*|jdbc:odbc:[\w\.\-]+|jdbc:derby:[\w\.\-\\:/]+' 
for type '#AnonType_ConnectionDatabaseProcess'.]

What did we miss - any suggestions?

Thanks in advance!

Best,
Kerstin