RE: [smila-dev] SMILA Crawling mySQL DB

[Thomas Menzel <tmenzel@xxxxxxx>]

Hi Kerstin,

If I'm not mistaken, then your restriction pattern doesn't include the port part(:3306) of the connection string you have spec'ed.
If that is the default port for mySQL then you might be able to just omit it in the connection string - that is, if the driver supports that...

I would just simply remove the constraint on the attribute and make it a normalizedString without any restrictions (and thus patterns).

See also 282116: [crawler] JDBC :: remove all constraints on the connection string
https://bugs.eclipse.org/bugs/show_bug.cgi?id=282116

Thomas Menzel @ IT-Solutions GmbH

-----Original Message-----
From: smila-dev-bounces@xxxxxxxxxxx [mailto:smila-dev-bounces@xxxxxxxxxxx] On Behalf Of Kerstin Bach
Sent: Dienstag, 16. Februar 2010 19:44
To: Smila project developer mailing list
Subject: [smila-dev] SMILA Crawling mySQL DB

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

_______________________________________________
smila-dev mailing list
smila-dev@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/smila-dev