Thread: [JSPDBAdmin-Developers] CVS: jspdbadmin/src/java/org/jspdbadmin/util/jdbc OracleDataSource.java,NONE
Status: Planning
Brought to you by:
aalmenar
|
From: Adrian A. <aal...@us...> - 2002-08-08 05:01:53
|
Update of /cvsroot/jspdbadmin/jspdbadmin/src/java/org/jspdbadmin/util/jdbc
In directory usw-pr-cvs1:/tmp/cvs-serv6099/src/java/org/jspdbadmin/util/jdbc
Added Files:
OracleDataSource.java MySQLDataSource.java
Log Message:
Maybe Some Helpful Classes
--- NEW FILE: OracleDataSource.java ---
/******************************************************************************
* JSPDBAdmin: Software to maintain and administrate Databases *
* Copyright (C) 2001 Adrian Almenar *
* *
* This program 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 2 of the License, or *
* (at your option) any later version. *
* *
* This program 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 this program; if not, write to the Free Software *
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA *
******************************************************************************/
/*
* $Id: OracleDataSource.java,v 1.1 2002/08/08 05:01:50 aalmenar Exp $
* $Date: 2002/08/08 05:01:50 $
*/
package org.jspdbadmin.util.jdbc;
import java.io.PrintWriter;
import java.sql.*;
import javax.sql.*;
/*****************************************************************
* This class only implements <code>DataSource</code> for Oracle
* <b>TODO: (Need to be more specific here)</b>
* @author <a href="mailto:aal...@ca...">Adrian Almenar</a>
* @version $Revision: 1.1 $
*****************************************************************/
public class OracleDataSource implements DataSource {
public static {
new oracle.jdbc.driver.OracleDriver();
}
protected boolean usingThinDriver;
protected String description = "Oracle Datasource";
protected String serverName;
protected int portNumber;
protected String databaseName;
public OracleDataSource(String host, int port, String sid) {
setServerName(host);
setPortNumber(port);
setDatabaseName(sid);
usingThinDriver = true;
}
public OracleDataSource(String sid) {
setDatabaseName(sid);
usingThinDriver = false;
}
public boolean isUsingThinDriver() {
return usingThinDriver;
}
public void setUsingThinDriver(boolean thin) {
usingThinDriver = thin;
}
public String getDescription() {
return description;
}
public void setDescription(String desc) {
description = desc;
}
public String getServerName() {
return serverName;
}
public void setServerName(String name) {
serverName = name;
}
public int getPortNumber() {
return portNumber;
}
public void setPortNumber(int port) {
portNumber = port;
}
public String getDatabaseName() {
return databaseName;
}
public void setDatabaseName(String name) {
databaseName = name;
}
public Connection getConnection() throws SQLException{
return getConnection(null, null);
}
public Connection getConnection(String userid, String password) throws SQLException {
String url = "jdbc:oracle:" + getSubname();
return DriverManager.getConnection(url, userid, password);
}
protected String getSubname() {
return (isUsingThinDriver()
? "thin:@" + getServerName() + ":" + getPortNumber() + ":" + getDatabaseName()
: "oci8:@" + getDatabaseName());
}
public int getLoginTimeout() throws SQLException {
return DriverManager.getLoginTimeout();
}
public PrintWriter getLogWriter() throws SQLException {
return DriverManager.getLogWriter();
}
public void setLoginTimeout(int timeout) throws SQLException {
DriverManager.setLoginTimeout(timeout);
}
public void setLogWriter(PrintWriter writer) throws SQLException {
DriverManager.setLogWriter(writer);
}
}
--- NEW FILE: MySQLDataSource.java ---
/******************************************************************************
* JSPDBAdmin: Software to maintain and administrate Databases *
* Copyright (C) 2001 Adrian Almenar *
* *
* This program 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 2 of the License, or *
* (at your option) any later version. *
* *
* This program 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 this program; if not, write to the Free Software *
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA *
******************************************************************************/
/*
* $Id: MySQLDataSource.java,v 1.1 2002/08/08 05:01:51 aalmenar Exp $
* $Date: 2002/08/08 05:01:51 $
*/
package org.jspdbadmin.util.jdbc;
import java.io.PrintWriter;
import java.sql.*;
import javax.sql.*;
/*****************************************************************
* This class only implements <code>DataSource</code> for MySQL
* <b>TODO: (Need to be more specific here)</b>
* @author <a href="mailto:aal...@ca...">Adrian Almenar</a>
* @version $Revision: 1.1 $
*****************************************************************/
public class MySQLDataSource implements DataSource {
public static {
//FIXME NEED TO CHECK WHAT IS CORRECT
new org.gjt.mm.mysql.Driver();
//Class.forName("org.gjt.mm.mysql.Driver").newInstance();
}
protected boolean usingThinDriver;
protected String description = "MySQL Datasource";
protected String serverName;
protected int portNumber;
protected String databaseName;
public MySQLDataSource(String host, int port, String sid) {
setServerName(host);
setPortNumber(port);
setDatabaseName(sid);
}
public String getDescription() {
return description;
}
public void setDescription(String desc) {
description = desc;
}
public String getServerName() {
return serverName;
}
public void setServerName(String name) {
serverName = name;
}
public int getPortNumber() {
return portNumber;
}
public void setPortNumber(int port) {
portNumber = port;
}
public String getDatabaseName() {
return databaseName;
}
public void setDatabaseName(String name) {
databaseName = name;
}
public Connection getConnection() throws SQLException{
return getConnection(null, null);
}
public Connection getConnection(String userid, String password) throws SQLException {
String url = "jdbc:mysql://" + getSubname()+"?" + userid +"&"+ password;
return DriverManager.getConnection(url);
}
protected String getSubname() {
return (getServerName() + ":" + getPortNumber() +"/"+ getDatabaseName());
}
public int getLoginTimeout() throws SQLException {
return DriverManager.getLoginTimeout();
}
public PrintWriter getLogWriter() throws SQLException {
return DriverManager.getLogWriter();
}
public void setLoginTimeout(int timeout) throws SQLException {
DriverManager.setLoginTimeout(timeout);
}
public void setLogWriter(PrintWriter writer) throws SQLException {
DriverManager.setLogWriter(writer);
}
}
|
|
From: Don <do...@cr...> - 2002-08-08 16:49:43
|
I don't think you need to include the java source code in your mail list.
It makes the message too heavy. We can just checkout from the cvs.
Best,
Don.
----- Original Message -----
From: "Adrian Almenar" <aal...@us...>
To: <jsp...@li...>
Sent: Thursday, August 08, 2002 12:01 AM
Subject: [JSPDBAdmin-Developers] CVS:
jspdbadmin/src/java/org/jspdbadmin/util/jdbc OracleDataSource.java,NONE,1.1
MySQLDataSource.java,NONE,1.1
> Update of /cvsroot/jspdbadmin/jspdbadmin/src/java/org/jspdbadmin/util/jdbc
> In directory
usw-pr-cvs1:/tmp/cvs-serv6099/src/java/org/jspdbadmin/util/jdbc
>
> Added Files:
> OracleDataSource.java MySQLDataSource.java
> Log Message:
> Maybe Some Helpful Classes
>
> --- NEW FILE: OracleDataSource.java ---
>
/***************************************************************************
***
> * JSPDBAdmin: Software to maintain and administrate Databases
*
> * Copyright (C) 2001 Adrian Almenar
*
> *
*
> * This program 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 2 of the License, or
*
> * (at your option) any later version.
*
> *
*
> * This program 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 this program; if not, write to the Free Software
*
> * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307
USA *
>
****************************************************************************
**/
>
> /*
> * $Id: OracleDataSource.java,v 1.1 2002/08/08 05:01:50 aalmenar Exp $
> * $Date: 2002/08/08 05:01:50 $
> */
>
> package org.jspdbadmin.util.jdbc;
>
> import java.io.PrintWriter;
> import java.sql.*;
> import javax.sql.*;
>
> /*****************************************************************
> * This class only implements <code>DataSource</code> for Oracle
> * <b>TODO: (Need to be more specific here)</b>
> * @author <a href="mailto:aal...@ca...">Adrian Almenar</a>
> * @version $Revision: 1.1 $
> *****************************************************************/
> public class OracleDataSource implements DataSource {
>
> public static {
> new oracle.jdbc.driver.OracleDriver();
> }
>
> protected boolean usingThinDriver;
> protected String description = "Oracle Datasource";
> protected String serverName;
> protected int portNumber;
> protected String databaseName;
>
>
> public OracleDataSource(String host, int port, String sid) {
> setServerName(host);
> setPortNumber(port);
> setDatabaseName(sid);
> usingThinDriver = true;
> }
>
> public OracleDataSource(String sid) {
> setDatabaseName(sid);
> usingThinDriver = false;
> }
>
> public boolean isUsingThinDriver() {
> return usingThinDriver;
> }
>
> public void setUsingThinDriver(boolean thin) {
> usingThinDriver = thin;
> }
>
> public String getDescription() {
> return description;
> }
>
> public void setDescription(String desc) {
> description = desc;
> }
>
> public String getServerName() {
> return serverName;
> }
>
> public void setServerName(String name) {
> serverName = name;
> }
>
> public int getPortNumber() {
> return portNumber;
> }
>
> public void setPortNumber(int port) {
> portNumber = port;
> }
>
> public String getDatabaseName() {
> return databaseName;
> }
>
> public void setDatabaseName(String name) {
> databaseName = name;
> }
>
> public Connection getConnection() throws SQLException{
> return getConnection(null, null);
> }
>
> public Connection getConnection(String userid, String password) throws
SQLException {
> String url = "jdbc:oracle:" + getSubname();
> return DriverManager.getConnection(url, userid, password);
> }
>
> protected String getSubname() {
> return (isUsingThinDriver()
> ? "thin:@" + getServerName() + ":" + getPortNumber() + ":" +
getDatabaseName()
> : "oci8:@" + getDatabaseName());
> }
>
> public int getLoginTimeout() throws SQLException {
> return DriverManager.getLoginTimeout();
> }
>
> public PrintWriter getLogWriter() throws SQLException {
> return DriverManager.getLogWriter();
> }
>
> public void setLoginTimeout(int timeout) throws SQLException {
> DriverManager.setLoginTimeout(timeout);
> }
>
> public void setLogWriter(PrintWriter writer) throws SQLException {
> DriverManager.setLogWriter(writer);
> }
>
> }
>
> --- NEW FILE: MySQLDataSource.java ---
>
/***************************************************************************
***
> * JSPDBAdmin: Software to maintain and administrate Databases
*
> * Copyright (C) 2001 Adrian Almenar
*
> *
*
> * This program 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 2 of the License, or
*
> * (at your option) any later version.
*
> *
*
> * This program 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 this program; if not, write to the Free Software
*
> * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307
USA *
>
****************************************************************************
**/
>
> /*
> * $Id: MySQLDataSource.java,v 1.1 2002/08/08 05:01:51 aalmenar Exp $
> * $Date: 2002/08/08 05:01:51 $
> */
>
> package org.jspdbadmin.util.jdbc;
>
> import java.io.PrintWriter;
> import java.sql.*;
> import javax.sql.*;
>
> /*****************************************************************
> * This class only implements <code>DataSource</code> for MySQL
> * <b>TODO: (Need to be more specific here)</b>
> * @author <a href="mailto:aal...@ca...">Adrian Almenar</a>
> * @version $Revision: 1.1 $
> *****************************************************************/
> public class MySQLDataSource implements DataSource {
>
> public static {
> //FIXME NEED TO CHECK WHAT IS CORRECT
> new org.gjt.mm.mysql.Driver();
> //Class.forName("org.gjt.mm.mysql.Driver").newInstance();
> }
>
> protected boolean usingThinDriver;
> protected String description = "MySQL Datasource";
> protected String serverName;
> protected int portNumber;
> protected String databaseName;
>
>
> public MySQLDataSource(String host, int port, String sid) {
> setServerName(host);
> setPortNumber(port);
> setDatabaseName(sid);
> }
>
> public String getDescription() {
> return description;
> }
>
> public void setDescription(String desc) {
> description = desc;
> }
>
> public String getServerName() {
> return serverName;
> }
>
> public void setServerName(String name) {
> serverName = name;
> }
>
> public int getPortNumber() {
> return portNumber;
> }
>
> public void setPortNumber(int port) {
> portNumber = port;
> }
>
> public String getDatabaseName() {
> return databaseName;
> }
>
> public void setDatabaseName(String name) {
> databaseName = name;
> }
>
> public Connection getConnection() throws SQLException{
> return getConnection(null, null);
> }
>
> public Connection getConnection(String userid, String password) throws
SQLException {
> String url = "jdbc:mysql://" + getSubname()+"?" + userid +"&"+
password;
> return DriverManager.getConnection(url);
> }
>
> protected String getSubname() {
> return (getServerName() + ":" + getPortNumber() +"/"+
getDatabaseName());
> }
>
> public int getLoginTimeout() throws SQLException {
> return DriverManager.getLoginTimeout();
> }
>
> public PrintWriter getLogWriter() throws SQLException {
> return DriverManager.getLogWriter();
> }
>
> public void setLoginTimeout(int timeout) throws SQLException {
> DriverManager.setLoginTimeout(timeout);
> }
>
> public void setLogWriter(PrintWriter writer) throws SQLException {
> DriverManager.setLogWriter(writer);
> }
>
> }
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> JSPDBAdmin-Developers mailing list
> JSP...@li...
> https://lists.sourceforge.net/lists/listinfo/jspdbadmin-developers
>
|
|
From: Adrian A. <aal...@ca...> - 2002-08-08 23:49:02
|
how about making a CVS list, just to see the commits ?
----- Original Message -----
From: "Don" <do...@cr...>
To: <jsp...@li...>
Sent: Thursday, August 08, 2002 12:49
Subject: Re: [JSPDBAdmin-Developers] CVS:
jspdbadmin/src/java/org/jspdbadmin/util/jdbc OracleDataSource.java,NONE,1.1
MySQLDataSource.java,NONE,1.1
> I don't think you need to include the java source code in your mail list.
> It makes the message too heavy. We can just checkout from the cvs.
>
> Best,
> Don.
>
> ----- Original Message -----
> From: "Adrian Almenar" <aal...@us...>
> To: <jsp...@li...>
> Sent: Thursday, August 08, 2002 12:01 AM
> Subject: [JSPDBAdmin-Developers] CVS:
> jspdbadmin/src/java/org/jspdbadmin/util/jdbc
OracleDataSource.java,NONE,1.1
> MySQLDataSource.java,NONE,1.1
>
>
> > Update of
/cvsroot/jspdbadmin/jspdbadmin/src/java/org/jspdbadmin/util/jdbc
> > In directory
> usw-pr-cvs1:/tmp/cvs-serv6099/src/java/org/jspdbadmin/util/jdbc
> >
> > Added Files:
> > OracleDataSource.java MySQLDataSource.java
> > Log Message:
> > Maybe Some Helpful Classes
> >
> > --- NEW FILE: OracleDataSource.java ---
> >
>
/***************************************************************************
> ***
> > * JSPDBAdmin: Software to maintain and administrate Databases
> *
> > * Copyright (C) 2001 Adrian Almenar
> *
> > *
> *
> > * This program 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 2 of the License, or
> *
> > * (at your option) any later version.
> *
> > *
> *
> > * This program 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 this program; if not, write to the Free Software
> *
> > * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307
> USA *
> >
>
****************************************************************************
> **/
> >
> > /*
> > * $Id: OracleDataSource.java,v 1.1 2002/08/08 05:01:50 aalmenar Exp $
> > * $Date: 2002/08/08 05:01:50 $
> > */
> >
> > package org.jspdbadmin.util.jdbc;
> >
> > import java.io.PrintWriter;
> > import java.sql.*;
> > import javax.sql.*;
> >
> > /*****************************************************************
> > * This class only implements <code>DataSource</code> for Oracle
> > * <b>TODO: (Need to be more specific here)</b>
> > * @author <a href="mailto:aal...@ca...">Adrian Almenar</a>
> > * @version $Revision: 1.1 $
> > *****************************************************************/
> > public class OracleDataSource implements DataSource {
> >
> > public static {
> > new oracle.jdbc.driver.OracleDriver();
> > }
> >
> > protected boolean usingThinDriver;
> > protected String description = "Oracle Datasource";
> > protected String serverName;
> > protected int portNumber;
> > protected String databaseName;
> >
> >
> > public OracleDataSource(String host, int port, String sid) {
> > setServerName(host);
> > setPortNumber(port);
> > setDatabaseName(sid);
> > usingThinDriver = true;
> > }
> >
> > public OracleDataSource(String sid) {
> > setDatabaseName(sid);
> > usingThinDriver = false;
> > }
> >
> > public boolean isUsingThinDriver() {
> > return usingThinDriver;
> > }
> >
> > public void setUsingThinDriver(boolean thin) {
> > usingThinDriver = thin;
> > }
> >
> > public String getDescription() {
> > return description;
> > }
> >
> > public void setDescription(String desc) {
> > description = desc;
> > }
> >
> > public String getServerName() {
> > return serverName;
> > }
> >
> > public void setServerName(String name) {
> > serverName = name;
> > }
> >
> > public int getPortNumber() {
> > return portNumber;
> > }
> >
> > public void setPortNumber(int port) {
> > portNumber = port;
> > }
> >
> > public String getDatabaseName() {
> > return databaseName;
> > }
> >
> > public void setDatabaseName(String name) {
> > databaseName = name;
> > }
> >
> > public Connection getConnection() throws SQLException{
> > return getConnection(null, null);
> > }
> >
> > public Connection getConnection(String userid, String password) throws
> SQLException {
> > String url = "jdbc:oracle:" + getSubname();
> > return DriverManager.getConnection(url, userid, password);
> > }
> >
> > protected String getSubname() {
> > return (isUsingThinDriver()
> > ? "thin:@" + getServerName() + ":" + getPortNumber() + ":" +
> getDatabaseName()
> > : "oci8:@" + getDatabaseName());
> > }
> >
> > public int getLoginTimeout() throws SQLException {
> > return DriverManager.getLoginTimeout();
> > }
> >
> > public PrintWriter getLogWriter() throws SQLException {
> > return DriverManager.getLogWriter();
> > }
> >
> > public void setLoginTimeout(int timeout) throws SQLException {
> > DriverManager.setLoginTimeout(timeout);
> > }
> >
> > public void setLogWriter(PrintWriter writer) throws SQLException {
> > DriverManager.setLogWriter(writer);
> > }
> >
> > }
> >
> > --- NEW FILE: MySQLDataSource.java ---
> >
>
/***************************************************************************
> ***
> > * JSPDBAdmin: Software to maintain and administrate Databases
> *
> > * Copyright (C) 2001 Adrian Almenar
> *
> > *
> *
> > * This program 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 2 of the License, or
> *
> > * (at your option) any later version.
> *
> > *
> *
> > * This program 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 this program; if not, write to the Free Software
> *
> > * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307
> USA *
> >
>
****************************************************************************
> **/
> >
> > /*
> > * $Id: MySQLDataSource.java,v 1.1 2002/08/08 05:01:51 aalmenar Exp $
> > * $Date: 2002/08/08 05:01:51 $
> > */
> >
> > package org.jspdbadmin.util.jdbc;
> >
> > import java.io.PrintWriter;
> > import java.sql.*;
> > import javax.sql.*;
> >
> > /*****************************************************************
> > * This class only implements <code>DataSource</code> for MySQL
> > * <b>TODO: (Need to be more specific here)</b>
> > * @author <a href="mailto:aal...@ca...">Adrian Almenar</a>
> > * @version $Revision: 1.1 $
> > *****************************************************************/
> > public class MySQLDataSource implements DataSource {
> >
> > public static {
> > //FIXME NEED TO CHECK WHAT IS CORRECT
> > new org.gjt.mm.mysql.Driver();
> > //Class.forName("org.gjt.mm.mysql.Driver").newInstance();
> > }
> >
> > protected boolean usingThinDriver;
> > protected String description = "MySQL Datasource";
> > protected String serverName;
> > protected int portNumber;
> > protected String databaseName;
> >
> >
> > public MySQLDataSource(String host, int port, String sid) {
> > setServerName(host);
> > setPortNumber(port);
> > setDatabaseName(sid);
> > }
> >
> > public String getDescription() {
> > return description;
> > }
> >
> > public void setDescription(String desc) {
> > description = desc;
> > }
> >
> > public String getServerName() {
> > return serverName;
> > }
> >
> > public void setServerName(String name) {
> > serverName = name;
> > }
> >
> > public int getPortNumber() {
> > return portNumber;
> > }
> >
> > public void setPortNumber(int port) {
> > portNumber = port;
> > }
> >
> > public String getDatabaseName() {
> > return databaseName;
> > }
> >
> > public void setDatabaseName(String name) {
> > databaseName = name;
> > }
> >
> > public Connection getConnection() throws SQLException{
> > return getConnection(null, null);
> > }
> >
> > public Connection getConnection(String userid, String password) throws
> SQLException {
> > String url = "jdbc:mysql://" + getSubname()+"?" + userid +"&"+
> password;
> > return DriverManager.getConnection(url);
> > }
> >
> > protected String getSubname() {
> > return (getServerName() + ":" + getPortNumber() +"/"+
> getDatabaseName());
> > }
> >
> > public int getLoginTimeout() throws SQLException {
> > return DriverManager.getLoginTimeout();
> > }
> >
> > public PrintWriter getLogWriter() throws SQLException {
> > return DriverManager.getLogWriter();
> > }
> >
> > public void setLoginTimeout(int timeout) throws SQLException {
> > DriverManager.setLoginTimeout(timeout);
> > }
> >
> > public void setLogWriter(PrintWriter writer) throws SQLException {
> > DriverManager.setLogWriter(writer);
> > }
> >
> > }
> >
> >
> >
> > -------------------------------------------------------
> > This sf.net email is sponsored by:ThinkGeek
> > Welcome to geek heaven.
> > http://thinkgeek.com/sf
> > _______________________________________________
> > JSPDBAdmin-Developers mailing list
> > JSP...@li...
> > https://lists.sourceforge.net/lists/listinfo/jspdbadmin-developers
> >
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> JSPDBAdmin-Developers mailing list
> JSP...@li...
> https://lists.sourceforge.net/lists/listinfo/jspdbadmin-developers
>
|
|
From: Don <do...@cr...> - 2002-08-09 14:07:05
|
That would be fine.
Thanks,
Don.
----- Original Message -----
From: "Adrian Almenar" <aal...@ca...>
To: <jsp...@li...>
Sent: Thursday, August 08, 2002 6:49 PM
Subject: Re: [JSPDBAdmin-Developers] CVS:
jspdbadmin/src/java/org/jspdbadmin/util/jdbc OracleDataSource.java,NONE,1.1
MySQLDataSource.java,NONE,1.1
> how about making a CVS list, just to see the commits ?
>
> ----- Original Message -----
> From: "Don" <do...@cr...>
> To: <jsp...@li...>
> Sent: Thursday, August 08, 2002 12:49
> Subject: Re: [JSPDBAdmin-Developers] CVS:
> jspdbadmin/src/java/org/jspdbadmin/util/jdbc
OracleDataSource.java,NONE,1.1
> MySQLDataSource.java,NONE,1.1
>
>
> > I don't think you need to include the java source code in your mail
list.
> > It makes the message too heavy. We can just checkout from the cvs.
> >
> > Best,
> > Don.
> >
> > ----- Original Message -----
> > From: "Adrian Almenar" <aal...@us...>
> > To: <jsp...@li...>
> > Sent: Thursday, August 08, 2002 12:01 AM
> > Subject: [JSPDBAdmin-Developers] CVS:
> > jspdbadmin/src/java/org/jspdbadmin/util/jdbc
> OracleDataSource.java,NONE,1.1
> > MySQLDataSource.java,NONE,1.1
> >
> >
> > > Update of
> /cvsroot/jspdbadmin/jspdbadmin/src/java/org/jspdbadmin/util/jdbc
> > > In directory
> > usw-pr-cvs1:/tmp/cvs-serv6099/src/java/org/jspdbadmin/util/jdbc
> > >
> > > Added Files:
> > > OracleDataSource.java MySQLDataSource.java
> > > Log Message:
> > > Maybe Some Helpful Classes
> > >
> > > --- NEW FILE: OracleDataSource.java ---
> > >
> >
>
/***************************************************************************
> > ***
> > > * JSPDBAdmin: Software to maintain and administrate Databases
> > *
> > > * Copyright (C) 2001 Adrian Almenar
> > *
> > > *
> > *
> > > * This program 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 2 of the License, or
> > *
> > > * (at your option) any later version.
> > *
> > > *
> > *
> > > * This program 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 this program; if not, write to the Free Software
> > *
> > > * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA
02111-1307
> > USA *
> > >
> >
>
****************************************************************************
> > **/
> > >
> > > /*
> > > * $Id: OracleDataSource.java,v 1.1 2002/08/08 05:01:50 aalmenar Exp $
> > > * $Date: 2002/08/08 05:01:50 $
> > > */
> > >
> > > package org.jspdbadmin.util.jdbc;
> > >
> > > import java.io.PrintWriter;
> > > import java.sql.*;
> > > import javax.sql.*;
> > >
> > > /*****************************************************************
> > > * This class only implements <code>DataSource</code> for Oracle
> > > * <b>TODO: (Need to be more specific here)</b>
> > > * @author <a href="mailto:aal...@ca...">Adrian Almenar</a>
> > > * @version $Revision: 1.1 $
> > > *****************************************************************/
> > > public class OracleDataSource implements DataSource {
> > >
> > > public static {
> > > new oracle.jdbc.driver.OracleDriver();
> > > }
> > >
> > > protected boolean usingThinDriver;
> > > protected String description = "Oracle Datasource";
> > > protected String serverName;
> > > protected int portNumber;
> > > protected String databaseName;
> > >
> > >
> > > public OracleDataSource(String host, int port, String sid) {
> > > setServerName(host);
> > > setPortNumber(port);
> > > setDatabaseName(sid);
> > > usingThinDriver = true;
> > > }
> > >
> > > public OracleDataSource(String sid) {
> > > setDatabaseName(sid);
> > > usingThinDriver = false;
> > > }
> > >
> > > public boolean isUsingThinDriver() {
> > > return usingThinDriver;
> > > }
> > >
> > > public void setUsingThinDriver(boolean thin) {
> > > usingThinDriver = thin;
> > > }
> > >
> > > public String getDescription() {
> > > return description;
> > > }
> > >
> > > public void setDescription(String desc) {
> > > description = desc;
> > > }
> > >
> > > public String getServerName() {
> > > return serverName;
> > > }
> > >
> > > public void setServerName(String name) {
> > > serverName = name;
> > > }
> > >
> > > public int getPortNumber() {
> > > return portNumber;
> > > }
> > >
> > > public void setPortNumber(int port) {
> > > portNumber = port;
> > > }
> > >
> > > public String getDatabaseName() {
> > > return databaseName;
> > > }
> > >
> > > public void setDatabaseName(String name) {
> > > databaseName = name;
> > > }
> > >
> > > public Connection getConnection() throws SQLException{
> > > return getConnection(null, null);
> > > }
> > >
> > > public Connection getConnection(String userid, String password)
throws
> > SQLException {
> > > String url = "jdbc:oracle:" + getSubname();
> > > return DriverManager.getConnection(url, userid, password);
> > > }
> > >
> > > protected String getSubname() {
> > > return (isUsingThinDriver()
> > > ? "thin:@" + getServerName() + ":" + getPortNumber() + ":"
+
> > getDatabaseName()
> > > : "oci8:@" + getDatabaseName());
> > > }
> > >
> > > public int getLoginTimeout() throws SQLException {
> > > return DriverManager.getLoginTimeout();
> > > }
> > >
> > > public PrintWriter getLogWriter() throws SQLException {
> > > return DriverManager.getLogWriter();
> > > }
> > >
> > > public void setLoginTimeout(int timeout) throws SQLException {
> > > DriverManager.setLoginTimeout(timeout);
> > > }
> > >
> > > public void setLogWriter(PrintWriter writer) throws SQLException {
> > > DriverManager.setLogWriter(writer);
> > > }
> > >
> > > }
> > >
> > > --- NEW FILE: MySQLDataSource.java ---
> > >
> >
>
/***************************************************************************
> > ***
> > > * JSPDBAdmin: Software to maintain and administrate Databases
> > *
> > > * Copyright (C) 2001 Adrian Almenar
> > *
> > > *
> > *
> > > * This program 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 2 of the License, or
> > *
> > > * (at your option) any later version.
> > *
> > > *
> > *
> > > * This program 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 this program; if not, write to the Free Software
> > *
> > > * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA
02111-1307
> > USA *
> > >
> >
>
****************************************************************************
> > **/
> > >
> > > /*
> > > * $Id: MySQLDataSource.java,v 1.1 2002/08/08 05:01:51 aalmenar Exp $
> > > * $Date: 2002/08/08 05:01:51 $
> > > */
> > >
> > > package org.jspdbadmin.util.jdbc;
> > >
> > > import java.io.PrintWriter;
> > > import java.sql.*;
> > > import javax.sql.*;
> > >
> > > /*****************************************************************
> > > * This class only implements <code>DataSource</code> for MySQL
> > > * <b>TODO: (Need to be more specific here)</b>
> > > * @author <a href="mailto:aal...@ca...">Adrian Almenar</a>
> > > * @version $Revision: 1.1 $
> > > *****************************************************************/
> > > public class MySQLDataSource implements DataSource {
> > >
> > > public static {
> > > //FIXME NEED TO CHECK WHAT IS CORRECT
> > > new org.gjt.mm.mysql.Driver();
> > > //Class.forName("org.gjt.mm.mysql.Driver").newInstance();
> > > }
> > >
> > > protected boolean usingThinDriver;
> > > protected String description = "MySQL Datasource";
> > > protected String serverName;
> > > protected int portNumber;
> > > protected String databaseName;
> > >
> > >
> > > public MySQLDataSource(String host, int port, String sid) {
> > > setServerName(host);
> > > setPortNumber(port);
> > > setDatabaseName(sid);
> > > }
> > >
> > > public String getDescription() {
> > > return description;
> > > }
> > >
> > > public void setDescription(String desc) {
> > > description = desc;
> > > }
> > >
> > > public String getServerName() {
> > > return serverName;
> > > }
> > >
> > > public void setServerName(String name) {
> > > serverName = name;
> > > }
> > >
> > > public int getPortNumber() {
> > > return portNumber;
> > > }
> > >
> > > public void setPortNumber(int port) {
> > > portNumber = port;
> > > }
> > >
> > > public String getDatabaseName() {
> > > return databaseName;
> > > }
> > >
> > > public void setDatabaseName(String name) {
> > > databaseName = name;
> > > }
> > >
> > > public Connection getConnection() throws SQLException{
> > > return getConnection(null, null);
> > > }
> > >
> > > public Connection getConnection(String userid, String password)
throws
> > SQLException {
> > > String url = "jdbc:mysql://" + getSubname()+"?" + userid +"&"+
> > password;
> > > return DriverManager.getConnection(url);
> > > }
> > >
> > > protected String getSubname() {
> > > return (getServerName() + ":" + getPortNumber() +"/"+
> > getDatabaseName());
> > > }
> > >
> > > public int getLoginTimeout() throws SQLException {
> > > return DriverManager.getLoginTimeout();
> > > }
> > >
> > > public PrintWriter getLogWriter() throws SQLException {
> > > return DriverManager.getLogWriter();
> > > }
> > >
> > > public void setLoginTimeout(int timeout) throws SQLException {
> > > DriverManager.setLoginTimeout(timeout);
> > > }
> > >
> > > public void setLogWriter(PrintWriter writer) throws SQLException {
> > > DriverManager.setLogWriter(writer);
> > > }
> > >
> > > }
> > >
> > >
> > >
> > > -------------------------------------------------------
> > > This sf.net email is sponsored by:ThinkGeek
> > > Welcome to geek heaven.
> > > http://thinkgeek.com/sf
> > > _______________________________________________
> > > JSPDBAdmin-Developers mailing list
> > > JSP...@li...
> > > https://lists.sourceforge.net/lists/listinfo/jspdbadmin-developers
> > >
> >
> >
> >
> > -------------------------------------------------------
> > This sf.net email is sponsored by:ThinkGeek
> > Welcome to geek heaven.
> > http://thinkgeek.com/sf
> > _______________________________________________
> > JSPDBAdmin-Developers mailing list
> > JSP...@li...
> > https://lists.sourceforge.net/lists/listinfo/jspdbadmin-developers
> >
>
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> JSPDBAdmin-Developers mailing list
> JSP...@li...
> https://lists.sourceforge.net/lists/listinfo/jspdbadmin-developers
>
|