ViewVC Help
View File | Revision Log | Show Annotations | View Changeset | Root Listing
root/owl/trunk/tools/MySQLConnection.java
Links to HEAD: (view) (annotate)
Sticky Revision:
(Current path doesn't exist after revision 950)
Sort logs by:
Revision 202 - (view) (annotate) - [select for diffs]
Modified Thu Jun 21 17:18:11 2007 UTC (17 years, 3 months ago) by duarte
File length: 21495 byte(s)
Diff to previous 177
MySQLConnection now throwing SQLException on connect
Many files changed following this: all calling classes now re-throwing or catching the SQLException
Revision 177 - (view) (annotate) - [select for diffs]
Modified Mon May 28 09:55:06 2007 UTC (17 years, 4 months ago) by duarte
File length: 22656 byte(s)
Diff to previous 176
Made public getUserName
Revision 176 - (view) (annotate) - [select for diffs]
Modified Mon May 28 09:53:00 2007 UTC (17 years, 4 months ago) by duarte
File length: 22657 byte(s)
Diff to previous 121
New static method getUserName and new constructor with only server and db
Revision 121 - (view) (annotate) - [select for diffs]
Modified Thu May 3 07:40:23 2007 UTC (17 years, 5 months ago) by stehr
File length: 21616 byte(s)
Diff to previous 109
Updated TableSorter to compile in Java 1.5 and some trivial changes in comments
Revision 109 - (view) (annotate) - [select for diffs]
Modified Tue Sep 19 09:27:12 2006 UTC (18 years ago) by duarte
File length: 21554 byte(s)
Diff to previous 97
Made loadMySQLDriver method public (needed to call it from other class) and static (makes more sense)
Revision 97 - (view) (annotate) - [select for diffs]
Modified Fri Jun 2 09:49:54 2006 UTC (18 years, 4 months ago) by duarte
File length: 21548 byte(s)
Diff to previous 94
Added getters/setters to host,db,user and password in MySQLConnection
Added another constructor to QueryThread to take just the MySQLConnection as argument
Revision 94 - (view) (annotate) - [select for diffs]
Modified Mon May 29 15:22:13 2006 UTC (18 years, 4 months ago) by duarte
File length: 21088 byte(s)
Diff to previous 93
Simplified the code for dealing with text/numerical keys.
Now there's no more double methods Integer/String, rather the methos use a generic Object[] that stores either String[] or Integer[] depending on the case.
Thus modified a few methods in DataDistributer, DataDistribution and MySQLConnection.
Revision 93 - (view) (annotate) - [select for diffs]
Modified Wed May 24 15:44:25 2006 UTC (18 years, 4 months ago) by duarte
File length: 20127 byte(s)
Diff to previous 84
Now split of data also working with text-based keys as well as numerical
MySQLConnection:
- method getAllIds4KeyAndTable now splitted into two methods one for numerical ids and another for text ids
- new methods getColumnType and isKeyNumerical
DataDistribution:
- method getIdSetsFromNodes splitted into two one for numerical ids one for text ids
DataDistributer:
- new methods: splitIdsIntoSets now splitted into two methods one numerical, one text
- change methods: splitTableToCluster, splitTable, insertIdsToKeyMaster, removePK, addPK, createNewKeyMasterTbl, removeZeros, loadSplitData, dumpSplitData to make them work for both text and numeric keys. Introduced generic type T in some of them
- some bugs corrected:
-- an important one in createNewKeyMasterTbl, was introducing record in dbs_keys with srcDb instead of destDb as it should have been
-- some bugs in loadSplitData and dumpSplitData to account for cases in which there are less ids than number of nodes and thus some nodes don't get any data. Wasn't counting with this before.
Revision 84 - (view) (annotate) - [select for diffs]
Modified Thu Apr 20 10:42:38 2006 UTC (18 years, 5 months ago) by duarte
File length: 18106 byte(s)
Diff to previous 83
Fixed bug in getTables4Db. Was closing the connection. Shouldn't do this!
Add method getAllIds4KeyAndTables, moved from DataDistribution. It makes more sense to have it here.

Revision 83 - (view) (annotate) - [select for diffs]
Modified Wed Apr 19 14:02:35 2006 UTC (18 years, 5 months ago) by duarte
File length: 17351 byte(s)
Diff to previous 80
Got rid of getTables4Db in DataDistribution
Add method getTables4Db to MySQLConnection. Makes a lot more sense.
Changed accordingly the only call to the method in DataDistribution's method chkCounts
Revision 80 - (view) (annotate) - [select for diffs]
Modified Wed Apr 12 14:59:37 2006 UTC (18 years, 5 months ago) by duarte
File length: 16310 byte(s)
Diff to previous 64
Introduced better javadoc comments in constructors.
Revision 64 - (view) (annotate) - [select for diffs]
Modified Thu Apr 6 14:47:09 2006 UTC (18 years, 5 months ago) by duarte
File length: 16015 byte(s)
Diff to previous 63
Added method getCreateIndex4Table
Revision 63 - (view) (annotate) - [select for diffs]
Modified Thu Apr 6 12:18:18 2006 UTC (18 years, 5 months ago) by duarte
File length: 14400 byte(s)
Diff to previous 62
Fixed bug in getAllIndexes4Table, the SELECT needed a DISTINCT
Revision 62 - (view) (annotate) - [select for diffs]
Modified Thu Apr 6 12:15:37 2006 UTC (18 years, 5 months ago) by duarte
File length: 14391 byte(s)
Diff to previous 61
Got rid of method dbExists. Was useless and not working.
Revision 61 - (view) (annotate) - [select for diffs]
Modified Thu Apr 6 10:07:22 2006 UTC (18 years, 5 months ago) by duarte
File length: 15633 byte(s)
Diff to previous 60
Added method setSqlMode, to set sql_mode server variable
Revision 60 - (view) (annotate) - [select for diffs]
Modified Thu Apr 6 09:24:28 2006 UTC (18 years, 5 months ago) by duarte
File length: 15009 byte(s)
Diff to previous 59
Added method dbExists to check whether database exists in server, used in constructor that passes a dbName
Moved all the private methods to the beginning of methods section
Revision 59 - (view) (annotate) - [select for diffs]
Modified Thu Apr 6 08:24:15 2006 UTC (18 years, 5 months ago) by duarte
File length: 13690 byte(s)
Diff to previous 58
Changed comments in constructors
Changed in method readConnectionFile:
- variable to count mandatory parameters to paramCount
- number of mandatory parameters now 4, dbname is also mandatory
Revision 58 - (view) (annotate) - [select for diffs]
Modified Wed Apr 5 08:45:23 2006 UTC (18 years, 5 months ago) by duarte
File length: 13503 byte(s)
Diff to previous 57
Now executeSQL method throws exception instead of catching it. Thought it was better than the calling class deals with these exceptions.
Revision 57 - (view) (annotate) - [select for diffs]
Modified Wed Apr 5 07:38:32 2006 UTC (18 years, 5 months ago) by duarte
File length: 12564 byte(s)
Diff to previous 55
Added getConnectionObject
Added printDbSizeInfo and 2 getRange methods from utils4DB
Made private the loadMySQLDriver and readConnectionFile methods

Revision 55 - (view) (annotate) - [select for diffs]
Added Tue Apr 4 15:27:49 2006 UTC (18 years, 5 months ago) by duarte
File length: 8697 byte(s)
Initial commit.
Class to create a connection to mysql db with basic functionality.
Cann take parameters for connection as argument in constructor or from connection file (passing the filename to the constructor)
Using code from both DBConnection (henning) and mySQLConnect (ioannis)

This form allows you to request diffs between any two revisions of this file. For each of the two "sides" of the diff, enter a numeric revision.

  Diffs between and
  Type of Diff should be a