我需要做什么来使用MSSQL-服务器与网络-收割机？

Question

主体几乎什么都说了。我已经下载了驱动程序。但是如何将它们与网络收割机结合使用呢？https://sourceforge.net/p/web-harvest/

我得到了：

<database connection="jdbc:sqlserver://192.168.1.115;databaseName=IMDB;user=sa;password=xxxxxxxxxxxxx ;" jdbcclass="com.microsoft.sqlserver.jdbc.SQLServerDriver">
<template>
INSERT INTO First (imdbid, titel, [plot-kurz], laufzeit)
values (${myId}, '${myUrl}', '${myText}', '${mySource}')
</template>
</database>

但用这些台词我得到了：

org.webharvest.exception.DatabaseException： com.microsoft.sqlserver.jdbc.SQLServerException: Falsche语法在der N he von '，‘。在… org.webharvest.runtime.processors.plugins.DatabasePlugin.executePlugin(DatabasePlugin.java:132) at org.webharvest.runtime.processors.WebHarvestPlugin.execute(WebHarvestPlugin.java:125) at org.webharvest.runtime.processors.BaseProcessor.run(BaseProcessor.java:115) at org.webharvest.runtime.processors.BodyProcessor.execute(BodyProcessor.java:25) at org.webharvest.runtime.processors.BaseProcessor.run(BaseProcessor.java:115) at org.webharvest.runtime.processors.CaseProcessor.execute(CaseProcessororg.webharvest.runtime.processors.BaseProcessor.run(BaseProcessor.java:115) at org.webharvest.runtime.processors.BodyProcessor.execute(BodyProcessor.java:25) at org.webharvest.runtime.processors.EmptyProcessor.execute(EmptyProcessor.java:58) at org.webharvest.runtime.processors.BaseProcessor.run(BaseProcessor.java:115) at org.webharvest.runtime.processors.BodyProcessor.execute(BodyProcessor.java:25) at org.webharvest.runtime.processorsorg.webharvest.runtime.processors.LoopProcessor.execute(LoopProcessor.java:116)，org.webharvest.runtime.processors.BaseProcessor.run(BaseProcessor.java:115)，org.webharvest.runtime.processors.BodyProcessor.execute(BodyProcessor.java:25)，org.webharvest.runtime.processors.WhileProcessor.execute(WhileProcessor.java:94)，org.webharvest.runtime.processors.BaseProcessor.run(BaseProcessor.java:115)，org。webharvest.runtime.Scraper.execute(Scraper.java:166) at org.webharvest.runtime.Scraper.execute(Scraper.java:179) at org.webharvest.gui.ScraperExecutionThread.run(ScraperExecutionThread.java:56) he: com.microsoft.sqlserver.jdbc.SQLServerException: Falsche Syntax der N he von '，“”在com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:332)地址为 org.webharvest.runtime.processors.plugins.DatabasePlugin.executePlugin(DatabasePlugin.java:84) .再来19

Answer 1

您的连接似乎正常--这个错误是Server告诉您它正在得到一个糟糕的查询。例如:如果${myID}计算为空字符串。