Load Ingest Data
Results 1 to 2 of 2

Thread: NvPoolDataSource Usage Error [IP Address Not Provided]

  1. #1
    mrohan is offline Junior Member
    Join Date
    Jan 2010
    Posts
    1
    Rep Power
    0

    NvPoolDataSource Usage Error [IP Address Not Provided]

    I am attempting to connect to our Attunity 5.1.0.10 installation using the NvPoolDataSource connection pooling datasource. Here is the code I'm using (values in <> are not actual values, but placeholders):

    Code:
     
    final NvPoolDataSource dataSource = new NvPoolDataSource();
    dataSource.setURL(
       "jdbc:attconnect://<server-name>:<port>;DefTdpName=<tdp-name>");
    dataSource.setPassword("");
    dataSource.setUser("");
    final Connection connection = dataSource.getConnection();

    However, the call to NvPoolDataSource.getConnection() results in the following error:

    Code:
     
    Exception in thread "main" java.sql.SQLException: [J0007] The IP address of the server wasnt provided in connection information
    at com.attunity.jdbc.NvSQLWarning.createSQLException(Unknown Source)
    at com.attunity.jdbc.NvSQLWarning.createSQLException(Unknown Source)
    at com.attunity.jdbc.NvConnectPropertiesBase.checkIpPart(Unknown Source)
    at com.attunity.jdbc.NvConnectPropertiesBase.prepareConnection(Unknown Source)
    at com.attunity.jdbc.NvConnectProperties.getConnection(Unknown Source)
    at com.attunity.jdbc.NvPooledConnection.<init>(Unknown Source)
    at com.attunity.jdbc.NvConnectionPoolDataSource.getPooledConnection(Unknown Source)
    at com.attunity.jdbc.NvPoolDataSource.getConnection(Unknown Source)
    If I use the same URL / username / password values using the NvDataSource, then everything works as expected.

    I've also downloaded and tested with the Attunity 5.3.0.2 JARs with the same result.

    Any help you can provide with this issue will be appreciated.


  2. #2
    Join Date
    Sep 2006
    Posts
    233
    Rep Power
    10
    The supported way to get connection pooling with the Attunity JDBC provider is to use it either under a J2EE container via JNDI (in which case, connection pooling is used by default) or otherwise - when not using J2EE - use a connection pool component like Apache's DBCP (DBCP - Overview).
    By Dror Harari

    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
  •