<docbook><section><title>CodeSamplesJava</title><para> </para><bridgehead class="http://www.w3.org/1999/xhtml:h2">Example code</bridgehead>
<programlisting>import java.sql.*;

public class Main {

    public static void main(String[] args) {

    Connection connection = null;
    String connectionURL = &quot;****** SEE BELOW *****&quot;; 
    
    try {             
            
            Class.forName(&quot;openlink.jdbc3.Driver&quot;);
            
            connection = DriverManager.getConnection(connectionURL);
            
            System.out.println(&quot;Driver: &quot; + connection.getMetaData().getDriverName() 
                    + &quot;  Version: &quot; + connection.getMetaData().getDriverVersion());
            System.out.println(&quot;Connected to: &quot; + connection.getMetaData().getDatabaseProductName() 
                    + &quot;  Version: &quot; + connection.getMetaData().getDatabaseProductVersion());
            
            System.out.println(&quot;Connection test Successful.&quot;);
            
        } catch (Exception ex) {
            System.out.print(ex.toString());
        }
   
    }

}
</programlisting><para> </para><bridgehead class="http://www.w3.org/1999/xhtml:h2">Basic JDBC Type 1 Connection URL</bridgehead>
<para>  Format:  <computeroutput>jdbc:openlink://ODBC/DSN=&lt;dsn_name&gt;/UID=&lt;username&gt;/PWD=&lt;password&gt;</computeroutput></para><para>  Example: <computeroutput>jdbc:openlink://ODBC/DSN=access/UID=/PWD=</computeroutput></para><bridgehead class="http://www.w3.org/1999/xhtml:h2">Basic JDBC Type 3 Connection URL</bridgehead>
<para>  Format:  <computeroutput>jdbc:openlink://&lt;hostname&gt;:&lt;port&gt;/SVT=&lt;server_type&gt;/DATABASE=&lt;database&gt;/OPTIONS=&lt;connect_options&gt;/UID=&lt;username&gt;/PWD=&lt;password&gt;</computeroutput></para><para>  Example: <computeroutput>jdbc:openlink://oplussol3:5000/SVT=Progress 100SQL/DATABASE=isports/OPTIONS=-H localhost -S prs10 -N tcp/UID=sysprogress/PWD=</computeroutput></para></section></docbook>