none
Fast Search 数据库连接器配置 RRS feed

  • 问题

  • 如何配置Fast Search数据库连接器?

    目前我按Fast Search SDK说明复制了一个jdbctemplete.xml,关于里面的JDBCURL属性,我不太明白,我的源数据库可以通过192.168.0.75\sqlexpress    用户名:sa 密码:sa    访问。那么我的JDBCURL值应该如何写?我目前的写法是:jdbc:sqlserver://192.168.1.75\sqlexpress:1433;DatabaseName=test

    执行到jdbcconnector.bat start -f C:\FASTSearch\etc\MyJDBCConfig.xml时报错

    错误信息:

    Copyright (c) Microsoft Corporation.  All rights reserved.
    00:26:04,247 INFO  [JDBCConnector] Starting the connector!
    00:26:04,250 INFO  [JDBCConnector] Validating config.......
    00:26:04,492 INFO  [JDBCConnector] Testing connections to external systems
    00:26:04,543 INFO  [JDBCConnector] Checking if connections to source and target
    work....
    00:26:19,298 ERROR [JDBCConnector] Failed creating adapter instace. Test connect
    ion failed.
    00:26:19,299 ERROR [JDBCConnector] Caused by: Could not connect to database: The
     TCP/IP connection to the host 192.168.1.75, port 1433 has failed. Error: "conne
    ct timed out. Verify the connection properties, check that an instance of SQL Se
    rver is running on the host and accepting TCP/IP connections at the port, and th
    at no firewall is blocking TCP connections to the port.".
    00:26:19,299 ERROR [JDBCConnector] Caused by: The TCP/IP connection to the host
    192.168.1.75, port 1433 has failed. Error: "connect timed out. Verify the connec
    tion properties, check that an instance of SQL Server is running on the host and
     accepting TCP/IP connections at the port, and that no firewall is blocking TCP
    connections to the port.".
    00:26:19,300 INFO  [JDBCConnector] Connection made to source system
    00:26:19,305 INFO  [CCTKDocumentFeeder] Publisher :Initializing: com.fastsearch.
    esp.cctk.publishers.CCTKDocumentFeeder
    00:26:19,602 INFO  [CCTKDocumentFeeder] Using Content Distributor(s): demo2010a.
    contoso.com:13390
    00:26:19,845 INFO  [CCTKDocumentFeeder] Initiated CCTK Document Feeder:
    00:26:19,846 INFO  [CCTKDocumentFeeder] FASTSearchSubmit/ActuallyPublish:true
    00:26:19,849 INFO  [CCTKDocumentFeeder] XMLExport/ExportToXML:false
    00:26:19,849 INFO  [CCTKDocumentFeeder] FASTSearchSubmit/Collection:sp
    00:26:19,850 INFO  [CCTKDocumentFeeder] FASTSearchSubmit/MaxActiveDocuments(MB):
    10
    00:26:19,850 INFO  [CCTKDocumentFeeder] FASTSearchSubmit/MaxBatchSize(KB):1000
    00:26:19,850 INFO  [CCTKDocumentFeeder] FASTSearchSubmit/BatchSubmissionTimeoutS
    ec:30
    00:26:19,851 INFO  [CCTKDocumentFeeder] FASTSearchSubmit/TimeOut:60
    00:26:19,851 INFO  [CCTKDocumentFeeder] FASTSearchSubmit/MaxDocsInBatch:100
    00:26:19,852 INFO  [CCTKDocumentFeeder] FASTSearchSubmit/MaxRetries:3
    00:26:19,852 INFO  [CCTKDocumentFeeder] FASTSearchSubmit/ContentDistributors:dem
    o2010a.contoso.com:13390
    00:26:19,853 INFO  [CCTKDocumentFeeder] FASTSearchSubmit/CallbackType:Secured
    00:26:19,853 INFO  [JDBCConnector] Connection made to target system

     

    环境说明:源数据库是sql server 2005,可以通过另一台机器的Microsoft SQL Server Management Studio连接到源数据库

    感觉FAST SEARCH SDK说的太模糊了,

    求高人指点!

     

    Thanks

    songhaitao


    2011年5月24日 7:47

答案

全部回复