jspdbadmin-developers Mailing List for JSPDBAdmin
Status: Planning
Brought to you by:
aalmenar
Menu
▾
▴
jspdbadmin-developers — Developers List
You can subscribe to this list here.
| 2001 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(3) |
Nov
(8) |
Dec
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2002 |
Jan
(1) |
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
(8) |
Aug
(23) |
Sep
(4) |
Oct
|
Nov
|
Dec
|
|
From: Weaver, G. <gw...@me...> - 2002-09-06 03:07:58
|
V2VsbCBIaSBhbGwgSSdtIG5ldyBoZXJlIGFuZCBob3BlIHRvIGJlIGFibGUgdG8gaGVscCB3aXRo IHRoaXMgcHJvamVjdC4NCg0KSSBoYXZlIGJlZW4gcGVydXNpbmcgdGhlIGFyY2hpdmUgb2YgdGhl IG1haWxpbmcgbGlzdHMgYW5kIHNhdyB0aGlzIHNvIEkgdGhvdWdodCBJIG1pZ2h0IHNoYXJlOg0K DQoNCiAgTmFtZTogIEdyZWdvcnkgV2VhdmVyIChqdXN0IEdyZWcgd29ya3MgZm9yIG1lKQ0KICBT b3VyY2Vmb3JnZSBIYW5kbGU6IHNuZWV6aW5nbGlvbg0KICBJQ1EgSUQ6IG5vbmUgKGhvd2V2ZXIg aWYgY2hhdHRpbmcgaXMgYSBwcmVmZXJyZWQgbWV0aG9kIG9mIGNvbW11bmljYXRpb24sIEkgX2Nv dWxkXyBnZXQgb25lIG9mIHRoZXNlLiA6KQ0KICBZYWhvbyBJRDogbm9uZQ0KICBNZXNzZW5nZXIg SUQ6IG5vbmUNCiAgV2ViIEVtYWlsOiBzbmVlemluZ2xpb25AeWFob28uY29tDQogIFdvcmsgRW1h aWw6IGd3ZWF2ZXJAbWVkLndheW5lLmVkdQ0KICBDb3VudHJ5OiBVU0ENCiAgQ2l0eTogRGV0cm9p dCwgTWljaGlnYW4NCiAgUHJlZmVycmVkIHRpbWluZ3MgZm9yIGEgY2hhdCBzZXNzaW9uKHlvdXIg bG9jYWwgdGltZSk6IGhtbSB0cmlja3kgb25lIHNpbmNlIEkgZG8gbm90IGRvIHRoZSBpbnN0YW50 IG1lc3NhZ2luZyB0aGluZy4gOigNCiANCg0KR3JlZ29yeSBKLiBXZWF2ZXIgDQpEYXRhYmFzZSBB bmFseXN0IElJIC0gV2F5bmUgU3RhdGUgVW5pdmVyc2l0eSANCjRILTIwIFVIQyANCg0KKDMxMykt OTkzLTc1NjggW2Rlc2sgcGhvbmVdIA0KKDMxMyktNTgwLTE1NzAgW2NlbGx1bGFyIHBob25lXSAN Cg0KIA0KDQo= |
|
From: Adrian A. <aal...@ca...> - 2002-09-04 14:59:04
|
Maybe, i think we need to try to do everything we can trough JDBC but if we cant we surely need to use soime native API, but thats not a problem. Adrian Pd. Subscribe to the mailing list >In your description you say "Wanted a tool Like >PHPMyAdmin but cant install PHP".Is that >because you CANNOT use PHP , or ,are unable to. >Also the kind of functionality available through >PHPMyAdmin for MySQL cannot be mirrored >through JDBC alone.Are we planning on using any >Database native API's? > >Thank You > > > |
|
From: Adrian A. <aal...@ca...> - 2002-09-03 03:39:47
|
Hi, Could each of the team members share the following information : - Name Sourceforge Handle ICQ ID Yahoo ID Messenger ID Web Email Work Email Country City Preferred timings for a chat session(your local time) We will do the trnslation into GMT ;o) This will help us organize a chat session for the team via the internet whenever necessary. Cheers, Adrian |
|
From: Adrian A. <aal...@ca...> - 2002-09-02 23:32:31
|
This is the proposal, This file can be found on the CVS with the name
JSPDBADMIN-PROPOSAL.txt
Cheers,
Adrian
Proposal for JSPDBAdmin
=======================
This document is a proposal for JSPDBAdmin Software.
Major Goals:
===========
The major goals for JSPDBAdmin 1.0 are to:
- Create an API that can handle at least for starting ORACLE, MySQL
Databases.
- Provide maximum modularity in the API
- - Make the core of the API just handling the most similar features of
each DB.- Make a web interface that uses this API.
- - This web interface must have i18n features.
- - This web interface also have to cover all databases.
- If we need to rely on a Servlet API we must use 2.3 for now
- Also the servlet-container to use is the reference implementation for
this Servlet API Tomcat 4.1.x
Things TO DO:
============
- Select the build tool we are going to use. (Jakarta-ant is the best
proposed).- Select Logging, Database Pool, Taglibs we probably are going
to need.
Later:
=====
- After we have the core, then make extensions to every database
specific
features like DB File size, % of data occupied, and things like that.
|
|
From: Adrian A. <aal...@ca...> - 2002-08-10 16:36:39
|
> > 1.- Before starting we need to select what databases we are going to > cover. > > I propose ORACLE, MySQL, Postgress. (I think those are the most used and a > > little bit difficult to administrate). > > This list is OK. Great. > > > 2.- Select the build tool we are going to use. I propose jakarta-ant cause > > it almost always make the work. > > Ant is a powerful tool for build process. We can use this once a basic > structure of the > codebase is ready. I Agree. > > > 3.- In general select the tools and technologies we need to work (Logging, > > Database Pool (If we are going to use it), Taglibs). > > What are the various API's availbale for creating Database Pools? Logging > framework > needs to be thought over and has to the implemented from the beggining. The > logging > framework should help both while development as well as in maintenance. > I propose for logging, jakarta-Log4J its great framework for development and maintenance. > > > > 4.- Make a multiple API to handle all kind of databases getting the most > > similar features to make right now the core. > This is a critical aspect. The design framework here I propose is "Abstract > Factory". Great, its closely of what i thinked but i see this aproach maybe its better. > > > > 5.- After we have the core, then make extensions to every database > specific > > features like DB File size, % of data occupied, and things like that. > OK. This anyhow is coming later. > > > > 6.- Make a web interface to use this api, this interface must be for every > > database we are going to cover can have extensions that are going to be > > activated on the build process. (We are going to need a lot of properties > or > > XML files to achieve that)., > A simple UI should act as a refrence point for the database API. I can > prepare > the reference HTML screens. Alamanar, I need your help here. I was thinking to make WEB development is Struts, it think we are going to handle things very easy if we use an MVC model for this. Can you explain me what can i do to help you ? > > > 7.- The web interface must be interesting if it has i18n on it, would be > > great, and can have a lot of users cause not everyone can handle english. > i18n definitely increases the usability of the system. > > > > > By the way, the priority is the core, and the tools we are going to use. > > > > If anyone has anithing to add, your request would be welcome. > > > > Cheers, > > > > Adrian > > > > > > > > > > My idea now is to first come up with some screens(may not be aesthetic) to > act as reference point to prepare the database API. What do others say? > Alamanar, can u create a file JSPDBADMIN-PLAN.TXT in the CVS and add this > list. Yeah tomorrow i will have CVS access, so i can do that. > > Ramana. > > > ------------------------------------------------------- > 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: RamanaJV <ram...@es...> - 2002-08-10 11:46:37
|
1.- Before starting we need to select what databases we are going to cover. > I propose ORACLE, MySQL, Postgress. (I think those are the most used and a > little bit difficult to administrate). This list is OK. > 2.- Select the build tool we are going to use. I propose jakarta-ant cause > it almost always make the work. Ant is a powerful tool for build process. We can use this once a basic structure of the codebase is ready. > 3.- In general select the tools and technologies we need to work (Logging, > Database Pool (If we are going to use it), Taglibs). What are the various API's availbale for creating Database Pools? Logging framework needs to be thought over and has to the implemented from the beggining. The logging framework should help both while development as well as in maintenance. > 4.- Make a multiple API to handle all kind of databases getting the most > similar features to make right now the core. This is a critical aspect. The design framework here I propose is "Abstract Factory". > 5.- After we have the core, then make extensions to every database specific > features like DB File size, % of data occupied, and things like that. OK. This anyhow is coming later. > 6.- Make a web interface to use this api, this interface must be for every > database we are going to cover can have extensions that are going to be > activated on the build process. (We are going to need a lot of properties or > XML files to achieve that)., A simple UI should act as a refrence point for the database API. I can prepare the reference HTML screens. Alamanar, I need your help here. > 7.- The web interface must be interesting if it has i18n on it, would be > great, and can have a lot of users cause not everyone can handle english. i18n definitely increases the usability of the system. > > By the way, the priority is the core, and the tools we are going to use. > > If anyone has anithing to add, your request would be welcome. > > Cheers, > > Adrian > > > > My idea now is to first come up with some screens(may not be aesthetic) to act as reference point to prepare the database API. What do others say? Alamanar, can u create a file JSPDBADMIN-PLAN.TXT in the CVS and add this list. Ramana. |
|
From: Adrian A. <aal...@ca...> - 2002-08-10 04:14:14
|
Also, i want to let you know that my home computer broke out, so in the weekend maybe im later answering emails. Adrian ----- Original Message ----- From: "Adrian Almenar" <aal...@ca...> To: <jsp...@li...> Sent: Friday, August 09, 2002 22:36 Subject: [JSPDBAdmin-Developers] [Targets] > > > Adrian, can I request you to draft a notes containing the purposes that > we > > > are going to achieve. We can start with some initial steps. We can > always > > > add more. > > > > OK, i will review it today and send to the list by tonight (Home time) > > 1.- Before starting we need to select what databases we are going to cover. > I propose ORACLE, MySQL, Postgress. (I think those are the most used and a > little bit difficult to administrate). > 2.- Select the build tool we are going to use. I propose jakarta-ant cause > it almost always make the work. > 3.- In general select the tools and technologies we need to work (Logging, > Database Pool (If we are going to use it), Taglibs). > > 4.- Make a multiple API to handle all kind of databases getting the most > similar features to make right now the core. > 5.- After we have the core, then make extensions to every database specific > features like DB File size, % of data occupied, and things like that. > 6.- Make a web interface to use this api, this interface must be for every > database we are going to cover can have extensions that are going to be > activated on the build process. (We are going to need a lot of properties or > XML files to achieve that)., > 7.- The web interface must be interesting if it has i18n on it, would be > great, and can have a lot of users cause not everyone can handle english. > > By the way, the priority is the core, and the tools we are going to use. > > If anyone has anithing to add, your request would be welcome. > > Cheers, > > Adrian > > > > > ------------------------------------------------------- > 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-10 02:36:37
|
> > Adrian, can I request you to draft a notes containing the purposes that we > > are going to achieve. We can start with some initial steps. We can always > > add more. > > OK, i will review it today and send to the list by tonight (Home time) 1.- Before starting we need to select what databases we are going to cover. I propose ORACLE, MySQL, Postgress. (I think those are the most used and a little bit difficult to administrate). 2.- Select the build tool we are going to use. I propose jakarta-ant cause it almost always make the work. 3.- In general select the tools and technologies we need to work (Logging, Database Pool (If we are going to use it), Taglibs). 4.- Make a multiple API to handle all kind of databases getting the most similar features to make right now the core. 5.- After we have the core, then make extensions to every database specific features like DB File size, % of data occupied, and things like that. 6.- Make a web interface to use this api, this interface must be for every database we are going to cover can have extensions that are going to be activated on the build process. (We are going to need a lot of properties or XML files to achieve that)., 7.- The web interface must be interesting if it has i18n on it, would be great, and can have a lot of users cause not everyone can handle english. By the way, the priority is the core, and the tools we are going to use. If anyone has anithing to add, your request would be welcome. Cheers, Adrian |
|
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
>
|
|
From: Adrian A. <aal...@ca...> - 2002-08-09 12:12:07
|
> Initial package structure: > *************************** > > The initial package structure I propose is > org.jspdbadmin.<database> ( For now, we have oracle and mysql. Here > come the database specific classes.) > org.jspdbadmin ( Here go the mediator classes) > org.jspdbadmin.utils (Here go the helper/utility classes) +1 > > One question my side is why the classes > OracleDataSource > MySQLDataSource extend DataSource? What is the logic behind it? I > think DataSource implementors are database vendors. Correct me if I'm wrong. OK, OracleDataSource extends DataSource (JDBC 2.x) and set the driver manager, so we can use the same jdbc api (2.x, 3.x), te only thing that changes is the datasource. each of these files loads and configures the database to use with DataSource. (You will see it looking at JDK 1.4 javax.sql.DataSource class) > Adrian, can I request you to draft a notes containing the purposes that we > are going to achieve. We can start with some initial steps. We can always > add more. OK, i will review it today and send to the list by tonight (Home time) > > Ramana. > Adrian |
|
From: RamanaJV <ram...@es...> - 2002-08-09 11:39:06
|
Initial package structure:
***************************
The initial package structure I propose is
org.jspdbadmin.<database> ( For now, we have oracle and mysql. Here
come the database specific classes.)
org.jspdbadmin ( Here go the mediator classes)
org.jspdbadmin.utils (Here go the helper/utility classes)
One question my side is why the classes
OracleDataSource
MySQLDataSource extend DataSource? What is the logic behind it? I
think DataSource implementors are database vendors. Correct me if I'm wrong.
Adrian, can I request you to draft a notes containing the purposes that we
are going to achieve. We can start with some initial steps. We can always
add more.
Ramana.
-----Original Message-----
From: Adrian Almenar [mailto:aal...@ca...]
Sent: Friday, August 09, 2002 6:02 AM
To: jsp...@li...
Subject: Re: [JSPDBAdmin-Developers] [TODO]
> TODO should actually talk about:
> * The JSP page(s) used to administer the database(s)
I think we should struts, its not complicated and it offers and MVC model
that its easy to handle.
but i think this is not critical right now.
First we need an API to make it work with JSP pages, i dont want SQL or
things that can go in classes inside the JSP's cause this makes the code
hard to maintain.
> * Initial package structure and justification
Lets start with org.jspdbadmin.*.
You agree with this ?
> * The database specific (DBS) classes and the relative package
> * The mediator classes that exist between JSP's and the DBS classes
About this i was thinking this.
Main class ----- Interface ----- Implementation class
The interface its going to be configurated with a class with a properties or
with an XML file to tell what implementation to access.
>
> Expanding these, becomes the basic plan. Add more likely.
>
> Ramana.
-------------------------------------------------------
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-09 01:53:33
|
Hi, Could each of the team members share the following information : - Name Sourceforge Handle ICQ ID Yahoo ID Messenger ID Web Email Work Email Country City Preferred timings for a chat session(your local time) We will do the trnslation into GMT ;o) This will help us organize a chat session for the team via the internet whenever necessary. Cheers, Adrian |
|
From: Adrian A. <aal...@ca...> - 2002-08-09 00:31:48
|
> TODO should actually talk about: > * The JSP page(s) used to administer the database(s) I think we should struts, its not complicated and it offers and MVC model that its easy to handle. but i think this is not critical right now. First we need an API to make it work with JSP pages, i dont want SQL or things that can go in classes inside the JSP's cause this makes the code hard to maintain. > * Initial package structure and justification Lets start with org.jspdbadmin.*. You agree with this ? > * The database specific (DBS) classes and the relative package > * The mediator classes that exist between JSP's and the DBS classes About this i was thinking this. Main class ----- Interface ----- Implementation class The interface its going to be configurated with a class with a properties or with an XML file to tell what implementation to access. > > Expanding these, becomes the basic plan. Add more likely. > > Ramana. |
|
From: Adrian A. <aal...@us...> - 2002-08-09 00:22:21
|
Update of /cvsroot/jspdbadmin/CVSROOT
In directory usw-pr-cvs1:/tmp/cvs-serv14715
Modified Files:
loginfo
Log Message:
Index: loginfo
===================================================================
RCS file: /cvsroot/jspdbadmin/CVSROOT/loginfo,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** loginfo 30 Jul 2002 01:57:21 -0000 1.2
--- loginfo 9 Aug 2002 00:22:15 -0000 1.3
***************
*** 26,28 ****
#DEFAULT (echo ""; id; echo %{sVv}; date; cat) >> $CVSROOT/CVSROOT/commitlog
! DEFAULT $CVSROOT/CVSROOT/syncmail %{sVv} jsp...@li...
\ No newline at end of file
--- 26,28 ----
#DEFAULT (echo ""; id; echo %{sVv}; date; cat) >> $CVSROOT/CVSROOT/commitlog
! DEFAULT $CVSROOT/CVSROOT/syncmail %{sVv} jsp...@li...
\ No newline at end of file
|
|
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: Adrian A. <aal...@ca...> - 2002-08-08 23:48:17
|
> I think we need to build on SQL standards, SQL 92? That's right, but if a database need some special requirements, we should think about extending it. Also would be great to make some indicator of DB Space, tools for administering it. Im not just looking to make this tool like phpmyadmin, but also with oracletool features. > > Also, we may consider using XML for DB interface, xmlquery? Can you explain a liter bit more on this ? > > Best, > Don. > > > > > ------------------------------------------------------- > 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-08 17:34:30
|
> > Im ok with that, i have more experience with oracle than with MySQL, so i > can work on the oracle side, but remember we are going to have a common web > administering page for the X databases we will support so we need to think > how we are going to implement it. > I think we need to build on SQL standards, SQL 92? Also, we may consider using XML for DB interface, xmlquery? Best, Don. |
|
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: RamanaJV <ram...@es...> - 2002-08-08 15:16:39
|
TODO should actually talk about:
* The JSP page(s) used to administer the database(s)
* Initial package structure and justification
* The database specific (DBS) classes and the relative package
* The mediator classes that exist between JSP's and the DBS classes
Expanding these, becomes the basic plan. Add more likely.
Ramana.
-----Original Message-----
From: Adrian Almenar [mailto:aal...@ca...]
Sent: Thursday, August 08, 2002 6:08 PM
To: jsp...@li...
Subject: Re: [JSPDBAdmin-Developers] CVS:
jspdbadmin/src/java/org/jspdbadmin/util/jdbc - New directory
> Almenar,
>
> I would like to first see PHPMyDBAdmin to get a feel of how it works.
Since,
> you have started with Oracle and MySQL classes, I will work with MySQL
side
> of things. In writing the code for Administering the MySQL database.
Im ok with that, i have more experience with oracle than with MySQL, so i
can work on the oracle side, but remember we are going to have a common web
administering page for the X databases we will support so we need to think
how we are going to implement it.
>
> Before that, I prefer to have a goals list ( A broad one), the project
> management technique, the developement environment and the testing
> environment. A goals list helps us in getting lot of things clarified. A
> part from the goals list, if we have a TODO list in a broad sense of how
we
> are going to achieve the administration through JSP the several databases
> and a division of modules. If we can first have these, then we can
starting
> coding.
Ok, i will make a TODO, then please help me on what we need on that TODO if
i miss something.
>
> Ramana.
>
Adrian
-------------------------------------------------------
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 12:37:25
|
> Almenar, > > I would like to first see PHPMyDBAdmin to get a feel of how it works. Since, > you have started with Oracle and MySQL classes, I will work with MySQL side > of things. In writing the code for Administering the MySQL database. Im ok with that, i have more experience with oracle than with MySQL, so i can work on the oracle side, but remember we are going to have a common web administering page for the X databases we will support so we need to think how we are going to implement it. > > Before that, I prefer to have a goals list ( A broad one), the project > management technique, the developement environment and the testing > environment. A goals list helps us in getting lot of things clarified. A > part from the goals list, if we have a TODO list in a broad sense of how we > are going to achieve the administration through JSP the several databases > and a division of modules. If we can first have these, then we can starting > coding. Ok, i will make a TODO, then please help me on what we need on that TODO if i miss something. > > Ramana. > Adrian |
|
From: RamanaJV <ram...@es...> - 2002-08-08 06:46:05
|
Almenar, I would like to first see PHPMyDBAdmin to get a feel of how it works. Since, you have started with Oracle and MySQL classes, I will work with MySQL side of things. In writing the code for Administering the MySQL database. Before that, I prefer to have a goals list ( A broad one), the project management technique, the developement environment and the testing environment. A goals list helps us in getting lot of things clarified. A part from the goals list, if we have a TODO list in a broad sense of how we are going to achieve the administration through JSP the several databases and a division of modules. If we can first have these, then we can starting coding. Ramana. |
|
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: Adrian A. <aal...@us...> - 2002-08-08 04:59:36
|
Update of /cvsroot/jspdbadmin/jspdbadmin/src/java/org/jspdbadmin/util/jdbc In directory usw-pr-cvs1:/tmp/cvs-serv4991/src/java/org/jspdbadmin/util/jdbc Log Message: Directory /cvsroot/jspdbadmin/jspdbadmin/src/java/org/jspdbadmin/util/jdbc added to the repository |
|
From: Adrian A. <aal...@us...> - 2002-08-08 04:59:36
|
Update of /cvsroot/jspdbadmin/jspdbadmin/src/java/org/jspdbadmin/util In directory usw-pr-cvs1:/tmp/cvs-serv4991/src/java/org/jspdbadmin/util Log Message: Directory /cvsroot/jspdbadmin/jspdbadmin/src/java/org/jspdbadmin/util added to the repository |
|
From: Adrian A. <aal...@ca...> - 2002-08-08 02:46:24
|
----- Original Message -----=20 From: jsp...@li...=20 To: jsp...@li...=20 Sent: Wednesday, August 07, 2002 22:37 Subject: [JSPDBAdmin-Developers] Testing 1 Testing |
