public List makeRow(String pDataString) {
ArrayList row;
if (mFormat != null) {
// we have a format
row = new ArrayList(mFormat.getNumFields());
dbgMsg("makeRow(" + pDataString + "," + mFormat + ")");
int[] groups = mFormat.getNumFieldsArray();
dbgMsg(
"Groups of the format: "
+ StringUtils.collectionToString(ConversionUtils.asList(groups), " "));
dbgMsg("Row(" + pDataString + "," + mFormat + ")");
String[] tokens = StringUtils.split(pDataString, columnSeparatorRegex, groups);
dbgMsg("Tokens: " + StringUtils.arrayToString(tokens, "\n"));
for (int i = 0; i < tokens.length; i++) {
row.add(mFormat.makeFieldRep(i, tokens[i]));
}
} else {
// we do not have a format
String[] tokens = pDataString.split(columnSeparatorRegex);
// note: -1 indicates that the number of fields is not fixed!
if (mNumFields != -1 && tokens.length != mNumFields) {
throw new RuntimeException(
"Cannot make row: numFieds = " + mNumFields + " != numTokens = " + tokens.length);
} else {
row = new ArrayList(Arrays.asList(tokens));
}
}
return row;
}
private java.sql.Connection connectLoadBalanced(String url, Properties info) throws SQLException {
Properties parsedProps = parseURL(url, info);
if (parsedProps == null) {
return null;
}
String hostValues = parsedProps.getProperty(HOST_PROPERTY_KEY);
List hostList = null;
if (hostValues != null) {
hostList = StringUtils.split(hostValues, ",", true);
}
if (hostList == null) {
hostList = new ArrayList();
hostList.add("localhost:3306");
}
LoadBalancingConnectionProxy proxyBal = new LoadBalancingConnectionProxy(hostList, parsedProps);
return (java.sql.Connection)
java.lang.reflect.Proxy.newProxyInstance(
this.getClass().getClassLoader(), new Class[] {java.sql.Connection.class}, proxyBal);
}
public void init(Options options) {
this.options = options;
timexPatterns = new TimeExpressionPatterns(options);
// TODO: does not allow for multiple loggers
if (options.verbose) {
logger.setLevel(Level.FINE);
} else {
logger.setLevel(Level.SEVERE);
}
NumberNormalizer.setVerbose(options.verbose);
if (options.grammarFilename != null) {
List<String> filenames = StringUtils.split(options.grammarFilename, "\\s*[,;]\\s*");
this.expressionExtractor =
CoreMapExpressionExtractor.createExtractorFromFiles(timexPatterns.env, filenames);
// this.expressionExtractor =
// CoreMapExpressionExtractor.createExtractorFromFile(timexPatterns.env,
// options.grammarFilename);
} else {
this.expressionExtractor = new CoreMapExpressionExtractor();
this.expressionExtractor.setExtractRules(
timexPatterns.getTimeExtractionRule(), timexPatterns.getCompositeTimeExtractionRule());
}
this.expressionExtractor.setLogger(logger);
}
public Properties parseURL(String url, Properties defaults) throws java.sql.SQLException {
Properties urlProps = (defaults != null) ? new Properties(defaults) : new Properties();
if (url == null) {
return null;
}
if (!StringUtils.startsWithIgnoreCase(url, URL_PREFIX)
&& !StringUtils.startsWithIgnoreCase(url, MXJ_URL_PREFIX)
&& !StringUtils.startsWithIgnoreCase(url, LOADBALANCE_URL_PREFIX)
&& !StringUtils.startsWithIgnoreCase(url, REPLICATION_URL_PREFIX)) { // $NON-NLS-1$
return null;
}
int beginningOfSlashes = url.indexOf("//");
if (StringUtils.startsWithIgnoreCase(url, MXJ_URL_PREFIX)) {
urlProps.setProperty(
"socketFactory", "com.mysql.management.driverlaunched.ServerLauncherSocketFactory");
}
/*
* Parse parameters after the ? in the URL and remove them from the
* original URL.
*/
int index = url.indexOf("?"); // $NON-NLS-1$
if (index != -1) {
String paramString = url.substring(index + 1, url.length());
url = url.substring(0, index);
StringTokenizer queryParams = new StringTokenizer(paramString, "&"); // $NON-NLS-1$
while (queryParams.hasMoreTokens()) {
String parameterValuePair = queryParams.nextToken();
int indexOfEquals = StringUtils.indexOfIgnoreCase(0, parameterValuePair, "=");
String parameter = null;
String value = null;
if (indexOfEquals != -1) {
parameter = parameterValuePair.substring(0, indexOfEquals);
if (indexOfEquals + 1 < parameterValuePair.length()) {
value = parameterValuePair.substring(indexOfEquals + 1);
}
}
if ((value != null && value.length() > 0)
&& (parameter != null && parameter.length() > 0)) {
try {
urlProps.put(parameter, URLDecoder.decode(value, "UTF-8"));
} catch (UnsupportedEncodingException badEncoding) {
// punt
urlProps.put(parameter, URLDecoder.decode(value));
} catch (NoSuchMethodError nsme) {
// punt again
urlProps.put(parameter, URLDecoder.decode(value));
}
}
}
}
url = url.substring(beginningOfSlashes + 2);
String hostStuff = null;
int slashIndex = url.indexOf("/"); // $NON-NLS-1$
if (slashIndex != -1) {
hostStuff = url.substring(0, slashIndex);
if ((slashIndex + 1) < url.length()) {
urlProps.put(
DBNAME_PROPERTY_KEY, //$NON-NLS-1$
url.substring((slashIndex + 1), url.length()));
}
} else {
hostStuff = url;
}
if ((hostStuff != null) && (hostStuff.length() > 0)) {
urlProps.put(HOST_PROPERTY_KEY, hostStuff); // $NON-NLS-1$
}
String propertiesTransformClassName = urlProps.getProperty(PROPERTIES_TRANSFORM_KEY);
if (propertiesTransformClassName != null) {
try {
ConnectionPropertiesTransform propTransformer =
(ConnectionPropertiesTransform)
Class.forName(propertiesTransformClassName).newInstance();
urlProps = propTransformer.transformProperties(urlProps);
} catch (InstantiationException e) {
throw SQLError.createSQLException(
"Unable to create properties transform instance '"
+ propertiesTransformClassName
+ "' due to underlying exception: "
+ e.toString(),
SQLError.SQL_STATE_INVALID_CONNECTION_ATTRIBUTE);
} catch (IllegalAccessException e) {
throw SQLError.createSQLException(
"Unable to create properties transform instance '"
+ propertiesTransformClassName
+ "' due to underlying exception: "
+ e.toString(),
SQLError.SQL_STATE_INVALID_CONNECTION_ATTRIBUTE);
} catch (ClassNotFoundException e) {
throw SQLError.createSQLException(
"Unable to create properties transform instance '"
+ propertiesTransformClassName
+ "' due to underlying exception: "
+ e.toString(),
SQLError.SQL_STATE_INVALID_CONNECTION_ATTRIBUTE);
}
}
if (Util.isColdFusion()
&& urlProps.getProperty("autoConfigureForColdFusion", "true").equalsIgnoreCase("true")) {
String configs = urlProps.getProperty(USE_CONFIG_PROPERTY_KEY);
StringBuffer newConfigs = new StringBuffer();
if (configs != null) {
newConfigs.append(configs);
newConfigs.append(",");
}
newConfigs.append("coldFusion");
urlProps.setProperty(USE_CONFIG_PROPERTY_KEY, newConfigs.toString());
}
// If we use a config, it actually should get overridden by anything in
// the URL or passed-in properties
String configNames = null;
if (defaults != null) {
configNames = defaults.getProperty(USE_CONFIG_PROPERTY_KEY);
}
if (configNames == null) {
configNames = urlProps.getProperty(USE_CONFIG_PROPERTY_KEY);
}
if (configNames != null) {
List splitNames = StringUtils.split(configNames, ",", true);
Properties configProps = new Properties();
Iterator namesIter = splitNames.iterator();
while (namesIter.hasNext()) {
String configName = (String) namesIter.next();
try {
InputStream configAsStream =
getClass().getResourceAsStream("configs/" + configName + ".properties");
if (configAsStream == null) {
throw SQLError.createSQLException(
"Can't find configuration template named '" + configName + "'",
SQLError.SQL_STATE_INVALID_CONNECTION_ATTRIBUTE);
}
configProps.load(configAsStream);
} catch (IOException ioEx) {
throw SQLError.createSQLException(
"Unable to load configuration template '"
+ configName
+ "' due to underlying IOException: "
+ ioEx,
SQLError.SQL_STATE_INVALID_CONNECTION_ATTRIBUTE);
}
}
Iterator propsIter = urlProps.keySet().iterator();
while (propsIter.hasNext()) {
String key = propsIter.next().toString();
String property = urlProps.getProperty(key);
configProps.setProperty(key, property);
}
urlProps = configProps;
}
// Properties passed in should override ones in URL
if (defaults != null) {
Iterator propsIter = defaults.keySet().iterator();
while (propsIter.hasNext()) {
String key = propsIter.next().toString();
String property = defaults.getProperty(key);
urlProps.setProperty(key, property);
}
}
return urlProps;
}
