Get Data Moving 1
Results 1 to 1 of 1

Thread: General JDBC Troubleshooting

  1. #1
    Costi Zaboura is offline World Wide Support Manager
    Join Date
    Aug 2006
    Posts
    300
    Rep Power
    14

    JDBC Drivers - General JDBC Troubleshooting

    DESCRIPTION

    There are two methods to enable JDBC Tracing:

    1. Connectiong String



    Add the following parameters to the JDBC connection string:
    Log=n

    Where "n" can be any of the following log levels:

    0 - Default, no logging.
    1 - Logging of JDBC API.
    2 - Logging of NAVAPI.
    3 - Logging of both JDBC and NAVAPI API's.

    LogFile=Full path of the log file name. Can contain two tokens: %T = Current Date/Time.
    %I = Sequence number of the connection in this session

    Example:
    jdbc:attconnect://localhost;DefTdpName=ADABAS;OneTdpMode=1;Log=1;Log File=C:\\JDBC_%I.log
    • This will enable JDBC API logging level.
    • Log files will be created as C:\JDBC_1.LOG, C:\JDBC_2.LOG, etc...
    2. Attunity Connect DataSource



    You can specify the logging in the JDBC DataSource class, for example:
    com.attunity.jdbc.NvDataSource ds = new com.attunity.jdbc.NvDataSource():

    ds.setLogLevel(1);
    ds.setLogFile("C:\\JDBC_%I.log");
    Last edited by Admin_attu; 08-31-2006 at 12:31 PM.
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •