ch.sahits.codegen.util
Class DTPConnectionParser

java.lang.Object
  ch.sahits.codegen.util.DTPConnectionParser

public class DTPConnectionParser
extends java.lang.Object

This Parser can retrieve stuff from the connection URL that are not suplied in the properties of a IConnectionProfile.
Since the connection URL is vendor specific the vendor must be suplied. The following vendors are supported:

• HSQLDB: jdbc:hsqldb:filepath i.e. 'jdbc:hsqldb:/home/myuser/.hsqldb'
• DB2: jdbc:db2//host:[port]/database i.e. 'jdbc:db2:test'
• INFORMIX: jdbc:informix-sqli://host:[port]/... i.e. 'jdbc:informix-sqli://host:port/database:INFORMIXSERVER=MyServerName'
• MS SQL SERVER (2005): jdbc:sqlserver://[host[\instanceName][:port]][;property=value[;property=value]] 'jdbc:sqlserver://localhost:1433;databaseName=AdventureWorks;integratedSecurity=true;'
• MySQL: jdbc:mysql://test oder jdbc:mysql://[host][,failoverhost...][:port]/[database][?propertyName1][=propertyValue1][&propertyName2][=propertyValue2]...
• ORACLE: jdbc:oracle:thin:@host:port:database
• POSTGRESQL: jdbc:postgresql://hostname:port/databasename
• MAXDB: jdbc:sapdb://[host][:port]/databasename
• SYBASE: jdbc:sybase:Tds:host:port/databasename
• DERBY: jdbc:derby:databasename or jdbc:derby://host:port/databasename

Since:

1.1.1

Author:

Andi Hotz

Constructor Summary

DTPConnectionParser(java.lang.String vendorName)
Constructor initializes the vendor The vendor can be retrieved from the IConnectionProfile by profile.getBaseProperties().getProperty("org.eclipse.datatools.connectivity.db.vendor").toString().toUpperCase();

Method Summary

java.lang.String	getHost(java.lang.String connectionURL) Retrieve the host name from the connection URL The host my be a location in a network or a local file
int	getPort(java.lang.String connectionURL) Retrieve the port number from the connection URL.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

DTPConnectionParser

public DTPConnectionParser(java.lang.String vendorName)

Constructor initializes the vendor The vendor can be retrieved from the IConnectionProfile by

profile.getBaseProperties().getProperty("org.eclipse.datatools.connectivity.db.vendor").toString().toUpperCase();

Parameters:

vendorName - name of the database vendor.

Method Detail

getPort

public int getPort(java.lang.String connectionURL)

Retrieve the port number from the connection URL. If the database does not need any port number 0 is returned

Parameters:

connectionURL - JDBC Connection URL

Returns:

port number

getHost

public java.lang.String getHost(java.lang.String connectionURL)

Retrieve the host name from the connection URL The host my be a location in a network or a local file

Parameters:

connectionURL - JDBC Connection URL

Returns:

name of the host