|
HSQLDB example source code file (RCData.java)
The HSQLDB RCData.java source code
/* Copyright (c) 2001-2008, The HSQL Development Group
* All rights reserved.
*
* Redistribution and use in source and binary forms, with or without
* modification, are permitted provided that the following conditions are met:
*
* Redistributions of source code must retain the above copyright notice, this
* list of conditions and the following disclaimer.
*
* Redistributions in binary form must reproduce the above copyright notice,
* this list of conditions and the following disclaimer in the documentation
* and/or other materials provided with the distribution.
*
* Neither the name of the HSQL Development Group nor the names of its
* contributors may be used to endorse or promote products derived from this
* software without specific prior written permission.
*
* THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
* AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
* IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
* ARE DISCLAIMED. IN NO EVENT SHALL HSQL DEVELOPMENT GROUP, HSQLDB.ORG,
* OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,
* EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,
* PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
* LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
* ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
* (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
* SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
*/
package org.hsqldb.lib;
import java.io.BufferedReader;
import java.io.File;
import java.io.FileReader;
import java.io.IOException;
import java.net.MalformedURLException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Properties;
import java.util.StringTokenizer;
/* $Id: RCData.java 1153 2009-02-14 04:14:23Z unsaved $ */
/**
* Manages all the details we need to connect up to database(s),
* in a declarative way.
* <P/>
* The file <CODE>src/org/hsqldb/sample/SqlFileEmbedder.java
* in the HSQLDB distribution provides an example of how to use RCData for your
* own programs.
*
* @see <a href="../../../../util-guide/sqltool-chapt.html#sqltool_auth-sect"
* target="guide">
* The RC File section of the HyperSQL Utilities Guide</a>
* @see org.hsqldb.sample.SqlFileEmbedder
* @author Blaine Simpson (blaine dot simpson at admc dot com)
*/
public class RCData {
public static final String DEFAULT_JDBC_DRIVER = "org.hsqldb.jdbcDriver";
private String defaultJdbcDriverName = DEFAULT_JDBC_DRIVER;
public void setDefaultJdbcDriver(String defaultJdbcDriverName) {
this.defaultJdbcDriverName = defaultJdbcDriverName;
}
public String getDefaultJdbcDriverName() {
return defaultJdbcDriverName;
}
/**
* DISABLED DUE TO SECURITY CONCERNS.
* Just for testing and debugging.
*
* N.b. this echoes passwords!
public void report() {
System.err.println("urlid: " + id + ", url: " + url + ", username: "
+ username + ", password: " + password);
}
*/
/**
* Creates a RCDataObject by looking up the given key in the
* given authentication file.
*
* @param dbKey Key to look up in the file.
* If null, then will echo all urlids in the file to stdout.
* @param file File containing the authentication information.
*/
public RCData(File file, String dbKey) throws Exception {
if (file == null) {
throw new IllegalArgumentException("RC file name not specified");
}
if (!file.canRead()) {
throw new IOException("Please set up authentication file '" + file
+ "'");
}
// System.err.println("Using RC file '" + file + "'");
StringTokenizer tokenizer = null;
boolean thisone = false;
String s;
String keyword, value;
int linenum = 0;
BufferedReader br = new BufferedReader(new FileReader(file));
while ((s = br.readLine()) != null) {
++linenum;
s = s.trim();
if (s.length() == 0) {
continue;
}
if (s.charAt(0) == '#') {
continue;
}
tokenizer = new StringTokenizer(s);
if (tokenizer.countTokens() == 1) {
keyword = tokenizer.nextToken();
value = "";
} else if (tokenizer.countTokens() > 1) {
keyword = tokenizer.nextToken();
value = tokenizer.nextToken("").trim();
} else {
try {
br.close();
} catch (IOException e) {
// Can only report on so many errors at one time
}
throw new Exception("Corrupt line " + linenum + " in '" + file
+ "': " + s);
}
if (dbKey == null) {
if (keyword.equals("urlid")) {
System.out.println(value);
}
continue;
}
if (keyword.equals("urlid")) {
if (value.equals(dbKey)) {
if (id == null) {
id = dbKey;
thisone = true;
} else {
try {
br.close();
} catch (IOException e) {
// Can only report on so many errors at one time
}
throw new Exception("Key '" + dbKey + " redefined at"
+ " line " + linenum + " in '"
+ file);
}
} else {
thisone = false;
}
continue;
}
if (thisone) {
if (keyword.equals("url")) {
url = value;
} else if (keyword.equals("username")) {
username = value;
} else if (keyword.equals("driver")) {
driver = value;
} else if (keyword.equals("charset")) {
charset = value;
} else if (keyword.equals("truststore")) {
truststore = value;
} else if (keyword.equals("password")) {
password = value;
} else if (keyword.equals("transiso")) {
ti = value;
} else if (keyword.equals("libpath")) {
libpath = value;
} else {
try {
br.close();
} catch (IOException e) {
// Can only report on so many errors at one time
}
throw new Exception("Bad line " + linenum + " in '" + file
+ "': " + s);
}
}
}
br.close();
if (dbKey == null) {
return;
}
if (url == null) {
throw new Exception("url not set " + "for '" + dbKey
+ "' in file '" + file + "'");
}
if (libpath != null) {
throw new IllegalArgumentException(
"Sorry, 'libpath' not supported yet");
}
}
/**
* Convenience constructor for backward compatibility.
*
* @see #RCData(String,String,String,String,String,String,String,String)
*/
public RCData(String id, String url, String username, String password,
String driver, String charset,
String truststore) throws Exception {
this(id, url, username, password, driver, charset, truststore, null);
}
/**
* Wrapper for unset Transaction Isolation.
*/
public RCData(String id, String url, String username, String password,
String driver, String charset, String truststore,
String libpath) throws Exception {
this(id, url, username, password, driver, charset, truststore,
libpath, null);
}
/**
* <p>Creates a new
Other HSQLDB examples (source code examples)Here is a short list of links related to this HSQLDB RCData.java source code file: |
... this post is sponsored by my books ... | |
#1 New Release! |
FP Best Seller |
Copyright 1998-2024 Alvin Alexander, alvinalexander.com
All Rights Reserved.
A percentage of advertising revenue from
pages under the /java/jwarehouse
URI on this website is
paid back to open source projects.