Another thing here. Although you will see gora-sql 0.2 dependency on Maven central don't pull it as we need to rewrite the entire module with another license firendly API... we're focusing on JOOQ but unfortunately the work hasn't really kicked off yet.
Please stick to gora-sql 0.1.1-incubating for the time being. Thanks On Wed, May 16, 2012 at 8:19 PM, Ramsel Ruiz <[email protected]> wrote: > Lewis, > > It was a simple HSQLDB config error. > > Thanks! > > > On Fri, May 11, 2012 at 4:33 PM, Lewis John Mcgibbney < > [email protected]> wrote: > >> Hi Ramsel, >> >> It would be great if you could provide what configuration you have >> included, also whether or not you are keeping up to date with HEAD? >> >> This is most likely something to do with your HSQLDB configuration not >> matching between server and gora.properties configuration >> >> Lewis >> >> On Sat, May 12, 2012 at 12:25 AM, Ramsel Ruiz >> <[email protected]> wrote: >> > I just checked out nutchgora on Wednesday, and I'm getting exceptions >> > trying to run an initial crawl. I found some threads regarding this issue >> > but not sure if it was ever solved: >> > >> http://old.nabble.com/java.net.ConnectException%3A-Connection-refused-with-Hsqldb-2.2.8-during-mock-tests-tt33648175.html#a33691612 >> > >> > Anyone have any suggestions? >> > >> > Exception in thread "main" org.apache.gora.util.GoraException: >> > java.io.IOException: java.sql.SQLTransientConnectionException: >> > java.net.ConnectException: Connection refused >> > at >> > >> org.apache.gora.store.DataStoreFactory.createDataStore(DataStoreFactory.java:167) >> > at >> > >> org.apache.gora.store.DataStoreFactory.createDataStore(DataStoreFactory.java:135) >> > at >> > >> org.apache.nutch.storage.StorageUtils.createWebStore(StorageUtils.java:69) >> > at org.apache.nutch.crawl.InjectorJob.run(InjectorJob.java:243) >> > at org.apache.nutch.crawl.Crawler.runTool(Crawler.java:68) >> > at org.apache.nutch.crawl.Crawler.run(Crawler.java:136) >> > at org.apache.nutch.crawl.Crawler.run(Crawler.java:250) >> > at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65) >> > at org.apache.nutch.crawl.Crawler.main(Crawler.java:257) >> > Caused by: java.io.IOException: java.sql.SQLTransientConnectionException: >> > java.net.ConnectException: Connection refused >> > at org.apache.gora.sql.store.SqlStore.getConnection(SqlStore.java:747) >> > at org.apache.gora.sql.store.SqlStore.initialize(SqlStore.java:160) >> > at >> > >> org.apache.gora.store.DataStoreFactory.initializeDataStore(DataStoreFactory.java:102) >> > at >> > >> org.apache.gora.store.DataStoreFactory.createDataStore(DataStoreFactory.java:161) >> > ... 8 more >> > Caused by: java.sql.SQLTransientConnectionException: >> > java.net.ConnectException: Connection refused >> > at org.hsqldb.jdbc.Util.sqlException(Unknown Source) >> > at org.hsqldb.jdbc.Util.sqlException(Unknown Source) >> > at org.hsqldb.jdbc.JDBCConnection.<init>(Unknown Source) >> > at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source) >> > at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source) >> > at java.sql.DriverManager.getConnection(DriverManager.java:582) >> > at java.sql.DriverManager.getConnection(DriverManager.java:185) >> > at org.apache.gora.sql.store.SqlStore.getConnection(SqlStore.java:739) >> > ... 11 more >> > Caused by: org.hsqldb.HsqlException: java.net.ConnectException: >> Connection >> > refused >> > at org.hsqldb.ClientConnection.openConnection(Unknown Source) >> > at org.hsqldb.ClientConnection.initConnection(Unknown Source) >> > at org.hsqldb.ClientConnection.<init>(Unknown Source) >> > ... 17 more >> > Caused by: java.net.ConnectException: Connection refused >> > at java.net.PlainSocketImpl.socketConnect(Native Method) >> > at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333) >> > at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195) >> > at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182) >> > at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:432) >> > at java.net.Socket.connect(Socket.java:525) >> > at java.net.Socket.connect(Socket.java:475) >> > at java.net.Socket.<init>(Socket.java:372) >> > at java.net.Socket.<init>(Socket.java:186) >> > at org.hsqldb.server.HsqlSocketFactory.createSocket(Unknown Source) >> > ... 20 more >> >> >> >> -- >> Lewis >> -- Lewis
