// Openbravo POS is a point of sales application designed for touch screens.
// Copyright (C) 2007-2009 Openbravo, S.L.
// http://code.google.com/p/openbravocustom/
//
// This file is part of Openbravo POS.
//
// Openbravo POS is free software: you can redistribute it and/or modify
// it under the terms of the GNU General Public License as published by
// the Free Software Foundation, either version 3 of the License, or
// (at your option) any later version.
//
// Openbravo POS is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
// GNU General Public License for more details.
//
// You should have received a copy of the GNU General Public License
// along with Openbravo POS. If not, see <http://www.gnu.org/licenses/>.
package com.openbravo.pos.forms;
import java.io.File;
import java.net.MalformedURLException;
import java.net.URL;
import java.net.URLClassLoader;
import java.sql.Driver;
import java.sql.DriverManager;
import java.sql.SQLException;
import com.openbravo.basic.BasicException;
import com.openbravo.data.loader.Session;
import com.openbravo.pos.util.AltEncrypter;
/**
*
* @author adrianromero
*/
public class AppViewConnection {
/** Creates a new instance of AppViewConnection */
private AppViewConnection() {
}
public static Session createSession(AppProperties props) throws BasicException {
try{
// register the database driver
if (isJavaWebStart()) {
Class.forName(props.getProperty("db.driver"), true, Thread.currentThread().getContextClassLoader());
} else {
ClassLoader cloader = new URLClassLoader(new URL[] {new File(props.getProperty("db.driverlib")).toURI().toURL()});
DriverManager.registerDriver(new DriverWrapper((Driver) Class.forName(props.getProperty("db.driver"), true, cloader).newInstance()));
}
String sDBUser = props.getProperty("db.user");
String sDBPassword = props.getProperty("db.password");
if (sDBUser != null && sDBPassword != null && sDBPassword.startsWith("crypt:")) {
// the password is encrypted
AltEncrypter cypher = new AltEncrypter("cypherkey" + sDBUser);
sDBPassword = cypher.decrypt(sDBPassword.substring(6));
}
return new Session(props.getProperty("db.URL"), sDBUser,sDBPassword);
} catch (InstantiationException e) {
throw new BasicException(AppLocal.getIntString("message.databasedrivererror"), e);
} catch (IllegalAccessException eIA) {
throw new BasicException(AppLocal.getIntString("message.databasedrivererror"), eIA);
} catch (MalformedURLException eMURL) {
throw new BasicException(AppLocal.getIntString("message.databasedrivererror"), eMURL);
} catch (ClassNotFoundException eCNF) {
throw new BasicException(AppLocal.getIntString("message.databasedrivererror"), eCNF);
} catch (SQLException eSQL) {
throw new BasicException(AppLocal.getIntString("message.databaseconnectionerror"), eSQL);
}
}
private static boolean isJavaWebStart() {
try {
Class.forName("javax.jnlp.ServiceManager");
return true;
} catch (ClassNotFoundException ue) {
return false;
}
}
}