Log of /trunk/schmitzm-db-pg/src/main/java/postgres

---

Revision 1815 - Directory Listing
Modified Sat Jan 14 20:35:25 2012 UTC (13 years, 1 month ago) by alfonx
Copied from: trunk/schmitzm-core/src/main/java/de/schmitzm/postgres revision 1814

Neues Modul schmitz-db mit Datenbankmethoden

---

Revision 1806 - Directory Listing
Modified Mon Dec 12 21:21:10 2011 UTC (13 years, 2 months ago) by alfonx
Original Path: trunk/schmitzm-core/src/main/java/de/schmitzm/postgres

Bisschen JavaDoc

---

Revision 1803 - Directory Listing
Modified Mon Dec 5 21:58:10 2011 UTC (13 years, 2 months ago) by alfonx
Original Path: trunk/schmitzm-core/src/main/java/de/schmitzm/postgres

Verbesserungen bei der Trigger- und Functionserstellung.

---

Revision 1798 - Directory Listing
Modified Mon Nov 28 13:11:29 2011 UTC (13 years, 3 months ago) by alfonx
Original Path: trunk/schmitzm-core/src/main/java/de/schmitzm/postgres

Indexerstellung erkennt Tablespae "null" als null.

---

Revision 1781 - Directory Listing
Modified Wed Nov 16 18:24:20 2011 UTC (13 years, 3 months ago) by alfonx
Original Path: trunk/schmitzm-core/src/main/java/de/schmitzm/postgres

Erste Aufräumanseätzt um Jregmatch 2.0-SNAPSHOT zu erstellen.

---

Revision 1752 - Directory Listing
Modified Tue Oct 11 11:51:38 2011 UTC (13 years, 4 months ago) by mojays
Original Path: trunk/schmitzm-core/src/main/java/de/schmitzm/postgres

LangUtil: handle null-time in combineDate(.)
DateInputOption.DateTime: handle null-time
PGUtil: BugFix in addIndex(.) in FillFactor-Condition; optional Parameters for createRole(.) to grand other roles to new role

---

Revision 1750 - Directory Listing
Modified Tue Oct 4 15:55:33 2011 UTC (13 years, 4 months ago) by alfonx
Original Path: trunk/schmitzm-core/src/main/java/de/schmitzm/postgres

Mehr try finally für ResultSets 

---

Revision 1748 - Directory Listing
Modified Mon Oct 3 20:47:41 2011 UTC (13 years, 4 months ago) by alfonx
Original Path: trunk/schmitzm-core/src/main/java/de/schmitzm/postgres

---

Revision 1747 - Directory Listing
Modified Mon Oct 3 10:15:59 2011 UTC (13 years, 5 months ago) by alfonx
Original Path: trunk/schmitzm-core/src/main/java/de/schmitzm/postgres

---

Revision 1746 - Directory Listing
Modified Mon Oct 3 09:59:00 2011 UTC (13 years, 5 months ago) by alfonx
Original Path: trunk/schmitzm-core/src/main/java/de/schmitzm/postgres

---

Revision 1745 - Directory Listing
Modified Sun Oct 2 13:26:29 2011 UTC (13 years, 5 months ago) by alfonx
Original Path: trunk/schmitzm-core/src/main/java/de/schmitzm/postgres

---

Revision 1743 - Directory Listing
Modified Fri Sep 30 12:29:10 2011 UTC (13 years, 5 months ago) by alfonx
Original Path: trunk/schmitzm-core/src/main/java/de/schmitzm/postgres

PGUtil FILLFACTOR Klammerfehler

---

Revision 1742 - Directory Listing
Modified Thu Sep 29 21:41:36 2011 UTC (13 years, 5 months ago) by mojays
Original Path: trunk/schmitzm-core/src/main/java/de/schmitzm/postgres

PGUtil: BugFix schliessende Klammer in SQL-Statements für Index-Anlage

---

Revision 1738 - Directory Listing
Modified Thu Sep 29 18:36:59 2011 UTC (13 years, 5 months ago) by mojays
Original Path: trunk/schmitzm-core/src/main/java/de/schmitzm/postgres

LangUtil: neue Methode callStaticMethod(.)
PGUtil: neue Methode createRoleIfNotExists(.)

---

Revision 1737 - Directory Listing
Modified Thu Sep 29 16:14:47 2011 UTC (13 years, 5 months ago) by alfonx
Original Path: trunk/schmitzm-core/src/main/java/de/schmitzm/postgres

listIndexesForTable sollte jetzt PG 8.3 kompatibel sein...

---

Revision 1734 - Directory Listing
Modified Sun Sep 25 16:59:11 2011 UTC (13 years, 5 months ago) by alfonx
Original Path: trunk/schmitzm-core/src/main/java/de/schmitzm/postgres

PG Indexes mit Fillfactor angabe erstellen

---

Revision 1733 - Directory Listing
Modified Sun Sep 25 11:10:28 2011 UTC (13 years, 5 months ago) by alfonx
Original Path: trunk/schmitzm-core/src/main/java/de/schmitzm/postgres

---

Revision 1732 - Directory Listing
Modified Sun Sep 25 10:56:57 2011 UTC (13 years, 5 months ago) by alfonx
Original Path: trunk/schmitzm-core/src/main/java/de/schmitzm/postgres

---

Revision 1731 - Directory Listing
Modified Sun Sep 25 10:34:57 2011 UTC (13 years, 5 months ago) by alfonx
Original Path: trunk/schmitzm-core/src/main/java/de/schmitzm/postgres

Drop Index korrigiert...

---

Revision 1730 - Directory Listing
Modified Sun Sep 25 09:52:01 2011 UTC (13 years, 5 months ago) by alfonx
Original Path: trunk/schmitzm-core/src/main/java/de/schmitzm/postgres

Index NEU-erstellung kann  bei addINdex in PGUtil jettz erzwungen werden...

---

Revision 1729 - Directory Listing
Modified Sat Sep 24 14:14:32 2011 UTC (13 years, 5 months ago) by alfonx
Original Path: trunk/schmitzm-core/src/main/java/de/schmitzm/postgres

	/**
	 * Liefert die Anzahl der offenen Sessions zur Datenbank.
	 * 
	 * @param c
	 *            DB-Verbindung
	 * @param dbName
	 *            Name der Datenbank fuer die die Sessions gezaehlt werden (kann {@code null} sein)
	 * @param userName
	 *            Name des Users fuer den die Sessions gezaehlt werden (kann {@code null} sein)
	 * @param queryLike
	 *            like-Beindung auf die Query die in der Session ausgeführt wird, oder <code>null</code>
	 */
	public static int getOpenSessionCount(Connection c, String dbName, String userName, String queryLike)
			throws SQLException {

---

Revision 1728 - Directory Listing
Modified Tue Sep 13 15:33:33 2011 UTC (13 years, 5 months ago) by alfonx
Original Path: trunk/schmitzm-core/src/main/java/de/schmitzm/postgres

Alle Verwendungen von ResultSet mit
		try {
			...
		} finally {
			rs.close();
		}
ausgestattet.

---

Revision 1727 - Directory Listing
Modified Tue Sep 13 14:11:22 2011 UTC (13 years, 5 months ago) by alfonx
Original Path: trunk/schmitzm-core/src/main/java/de/schmitzm/postgres

Alle Verwendungen von ResultSet mit
		try {
			...
		} catch (Exception e) {
			rs.close();
		}
ausgestattet.

---

Revision 1726 - Directory Listing
Modified Mon Sep 12 18:20:55 2011 UTC (13 years, 5 months ago) by mojays
Original Path: trunk/schmitzm-core/src/main/java/de/schmitzm/postgres

PGUtil: Method to determine the current count of open sessions

---

Revision 1712 - Directory Listing
Modified Tue Sep 6 10:38:45 2011 UTC (13 years, 5 months ago) by alfonx
Original Path: trunk/schmitzm-core/src/main/java/de/schmitzm/postgres

	/**
	 * Der : (Doppelpunkt) hat in PSQL eine besondere Bedeutung. Er wind mit
	 * dieser methode escaped. Diese Methode sollte mit <code>like E'"+PGUtil.escape(...)+"'</code>
	 * verwendet werden.
	 */
	public static String escape(String key) {
		key = key.replaceAll(":", "\\:");
		return key;
	}

---

Revision 1703 - Directory Listing
Modified Wed Aug 31 16:22:47 2011 UTC (13 years, 6 months ago) by alfonx
Original Path: trunk/schmitzm-core/src/main/java/de/schmitzm/postgres

---

Revision 1702 - Directory Listing
Modified Wed Aug 31 16:01:54 2011 UTC (13 years, 6 months ago) by alfonx
Original Path: trunk/schmitzm-core/src/main/java/de/schmitzm/postgres

---

Revision 1701 - Directory Listing
Modified Wed Aug 31 15:11:27 2011 UTC (13 years, 6 months ago) by alfonx
Original Path: trunk/schmitzm-core/src/main/java/de/schmitzm/postgres

Besser überprüfug ob ein Index auf einer tabelle in einem anderen Schma schon existiert.

---

Revision 1697 - Directory Listing
Modified Mon Aug 29 13:06:28 2011 UTC (13 years, 6 months ago) by alfonx
Original Path: trunk/schmitzm-core/src/main/java/de/schmitzm/postgres

* Neue Methode um Indexes einer Tabelle aufzuzählen.  * Neue Indexes werden nur erstellt,w enn ein gleichnamiger Index noch nicht existiert => Spart eine Exception im Log pro Index.

---

Revision 1696 - Directory Listing
Added Mon Aug 29 13:05:14 2011 UTC (13 years, 6 months ago) by alfonx
Original Path: trunk/schmitzm-core/src/main/java/de/schmitzm/postgres

PGUtil war in in einem falschen package ...geotools.... Dafür haben wir aber PGUtilGT