Hi Yves, This has nothing to do with Nutch. It strictly has to do with Gora. That was my justification for moving a similar thread (it may actually even have been this one) over to user@gora. As Renato explained, by the looks of it Microsoft Azure platform has a client library which enables you to interact with any products residing in there. None of this has been written into Gora, therefore this is most likely whit it is not working. It is difficult (without writing the individual client implementations) to get a storage abstraction layer which provides you with similar functionality over several SQL datastores. It was our plan to re-write gora-sql module with the JOOQ sql library (which is ASL v2.0 licensed IIRC) however again this would not cover your use case I don't think. Currently I don't think that MS-SQL will work with the Gora SQL module. Lewis
On Tue, Apr 16, 2013 at 12:36 PM, Yves S. Garret <[email protected] > wrote: > Hi, this is what happens after I specified where the jar file that I need > should be located. > > http://bin.cakephp.org/view/1051380 > > It's not easy to figure out what the problem is if the only error that you > get is a Java error :) . > > Also, as a general question, has anyone ever had Nutch outputting > information into some other database besides MySQL? How about MS-SQL? How > did you configure Nutch and the database? > > > On Tue, Apr 16, 2013 at 1:27 PM, Renato Marroquín Mogrovejo < > [email protected]> wrote: > > > Hi all, > > > > I think the problem is the drivers Microsoft Azure requires. Right now > > Gora supports HDSQL but Azure needs some of the following clients [1], > > and right now we have no support in any of those clients :( > > Maybe you could try playing around with these clients inside Gora and > > give it a shot? I would be happy to help you trying this out man. > > > > > > Renato M. > > > > > > [1] > > http://msdn.microsoft.com/en-us/library/windowsazure/ee336245.aspx#dlaps > > > > 2013/4/16 Yves S. Garret <[email protected]>: > > > I just tried what you suggested and this is the error that I got: > > > > > > http://bin.cakephp.org/view/1346910103 > > > > > > > > > On Tue, Apr 16, 2013 at 1:18 AM, Canan GİRGİN <[email protected] > > >wrote: > > > > > >> I think, your connection parameters must be like this: > > >> > > >> gora.sqlstore.jdbc.driver=com.mysql.jdbc.Driver > > >> gora.sqlstore.jdbc.url=jdbc:mysql:// > > >> 423fsdff23.database.windows.net:1433/nutchtest > > >> gora.sqlstore.jdbc.user=developer > > >> gora.sqlstore.jdbc.password=secret-pass > > >> > > >> ---------- Forwarded message ---------- > > >> From: Yves S. Garret <[email protected]> > > >> Date: Sat, Apr 13, 2013 at 4:02 AM > > >> Subject: Trying to output to db in MS-SQL on Azure > > >> To: [email protected] > > >> > > >> > > >> I took the following tutorial [ http://nlp.solutions.asia/?p=180 ] > and > > >> modified parts of it in order to output into a MS-SQL database hosted > on > > >> Azure. > > >> > > >> This is my gora.properties that's enabled (yes, some of the necessary > > info > > >> was changed): > > >> gora.sqlstore.jdbc.driver=org.hsqldb.jdbc.JDBCDriver > > >> gora.sqlstore.jdbc.url=jdbc:hsqldb:hsql:// > > >> 423fsdff23.database.windows.net:1433/nutchtest > > >> gora.sqlstore.jdbc.user=developer > > >> gora.sqlstore.jdbc.password=secret-pass > > >> > > >> I don't understand where I'm going wrong. Any suggestions? > > >> > > > -- *Lewis*
