Re: [JSPDBAdmin-Developers] CVS: jspdbadmin/src/java/org/jspdbadmin/util/jdbc OracleDataSource.java,
Status: Planning
Brought to you by:
aalmenar
Menu
▾
▴
Re: [JSPDBAdmin-Developers] CVS: jspdbadmin/src/java/org/jspdbadmin/util/jdbc OracleDataSource.java,NONE,1.1 MySQLDataSource.java,NONE,1.1
|
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
>
|
