|
From: <man...@us...> - 2010-05-30 23:14:36
|
Revision: 5638
http://squirrel-sql.svn.sourceforge.net/squirrel-sql/?rev=5638&view=rev
Author: manningr
Date: 2010-05-30 23:14:29 +0000 (Sun, 30 May 2010)
Log Message:
-----------
Merged patch from Bogdan Cristian Paulon which adds a LOB node in the object tree.
Modified Paths:
--------------
trunk/sql12/plugins/oracle/doc/changes.txt
trunk/sql12/plugins/oracle/src/net/sourceforge/squirrel_sql/plugins/oracle/OraclePlugin.java
trunk/sql12/plugins/oracle/src/net/sourceforge/squirrel_sql/plugins/oracle/tab/I18NStrings.properties
Added Paths:
-----------
trunk/sql12/plugins/oracle/src/net/sourceforge/squirrel_sql/plugins/oracle/tab/LobDetailsTab.java
Modified: trunk/sql12/plugins/oracle/doc/changes.txt
===================================================================
--- trunk/sql12/plugins/oracle/doc/changes.txt 2010-05-30 22:54:27 UTC (rev 5637)
+++ trunk/sql12/plugins/oracle/doc/changes.txt 2010-05-30 23:14:29 UTC (rev 5638)
@@ -1,6 +1,11 @@
Oracle Change Log
=================
+0.21
+====
+ - Incorporated patch which provides a node in the object tree called LOB which lists all LOBs, providing
+ details about each (Thanks to Bogdan Cristian Paulon)
+
0.20
====
- Bug #1844898 (TIMESTAMP(6) WITH LOCAL TIME ZONE shows <Error>)
Modified: trunk/sql12/plugins/oracle/src/net/sourceforge/squirrel_sql/plugins/oracle/OraclePlugin.java
===================================================================
--- trunk/sql12/plugins/oracle/src/net/sourceforge/squirrel_sql/plugins/oracle/OraclePlugin.java 2010-05-30 22:54:27 UTC (rev 5637)
+++ trunk/sql12/plugins/oracle/src/net/sourceforge/squirrel_sql/plugins/oracle/OraclePlugin.java 2010-05-30 23:14:29 UTC (rev 5638)
@@ -96,6 +96,7 @@
import net.sourceforge.squirrel_sql.plugins.oracle.tab.IndexColumnInfoTab;
import net.sourceforge.squirrel_sql.plugins.oracle.tab.IndexDetailsTab;
import net.sourceforge.squirrel_sql.plugins.oracle.tab.InstanceDetailsTab;
+import net.sourceforge.squirrel_sql.plugins.oracle.tab.LobDetailsTab;
import net.sourceforge.squirrel_sql.plugins.oracle.tab.ObjectSourceTab;
import net.sourceforge.squirrel_sql.plugins.oracle.tab.OptionsTab;
import net.sourceforge.squirrel_sql.plugins.oracle.tab.SequenceDetailsTab;
@@ -196,7 +197,7 @@
*/
public String getVersion()
{
- return "0.20";
+ return "0.21";
}
/**
@@ -465,7 +466,6 @@
return ret;
}
- @SuppressWarnings("unchecked")
private void setTimezoneForSession(ISession session, OraclePreferenceBean prefs)
{
if (!prefs.getInitSessionTimezone())
@@ -785,6 +785,7 @@
addDetailTab(objTree, DatabaseObjectType.INDEX, new IndexColumnInfoTab());
addDetailTab(objTree, DatabaseObjectType.INDEX, new IndexDetailsTab());
addDetailTab(objTree, IObjectTypes.LOB, new DatabaseObjectInfoTab());
+ addDetailTab(objTree, IObjectTypes.LOB, new LobDetailsTab());
addDetailTab(objTree, DatabaseObjectType.SEQUENCE, new DatabaseObjectInfoTab());
addDetailTab(objTree, DatabaseObjectType.TRIGGER, new DatabaseObjectInfoTab());
addDetailTab(objTree, IObjectTypes.TRIGGER_PARENT, new DatabaseObjectInfoTab());
Modified: trunk/sql12/plugins/oracle/src/net/sourceforge/squirrel_sql/plugins/oracle/tab/I18NStrings.properties
===================================================================
--- trunk/sql12/plugins/oracle/src/net/sourceforge/squirrel_sql/plugins/oracle/tab/I18NStrings.properties 2010-05-30 22:54:27 UTC (rev 5637)
+++ trunk/sql12/plugins/oracle/src/net/sourceforge/squirrel_sql/plugins/oracle/tab/I18NStrings.properties 2010-05-30 23:14:29 UTC (rev 5638)
@@ -17,6 +17,8 @@
oracle.displaysSequenceDetails=Display sequence details
oracle.triggerDetails=Details
oracle.displayTriggerDetails=Display trigger details
+oracle.lobDetails=Details
+oracle.displayLobDetails=Display lob details
oracle.diplayScriptDetails=Display script details
oracle.displaySnapshotDetails=Display materialized view details
oracle.columns=Columns
Added: trunk/sql12/plugins/oracle/src/net/sourceforge/squirrel_sql/plugins/oracle/tab/LobDetailsTab.java
===================================================================
--- trunk/sql12/plugins/oracle/src/net/sourceforge/squirrel_sql/plugins/oracle/tab/LobDetailsTab.java (rev 0)
+++ trunk/sql12/plugins/oracle/src/net/sourceforge/squirrel_sql/plugins/oracle/tab/LobDetailsTab.java 2010-05-30 23:14:29 UTC (rev 5638)
@@ -0,0 +1,69 @@
+/*
+ * Copyright (C) 2010 Bogdan Cristian Paulon
+ *
+ * This library is free software; you can redistribute it and/or
+ * modify it under the terms of the GNU Lesser General Public
+ * License as published by the Free Software Foundation; either
+ * version 2.1 of the License, or (at your option) any later version.
+ *
+ * This library 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
+ * Lesser General Public License for more details.
+ *
+ * You should have received a copy of the GNU Lesser General Public
+ * License along with this library; if not, write to the Free Software
+ * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
+ */
+package net.sourceforge.squirrel_sql.plugins.oracle.tab;
+
+import java.sql.PreparedStatement;
+import java.sql.SQLException;
+
+import net.sourceforge.squirrel_sql.client.session.ISession;
+import net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.BasePreparedStatementTab;
+import net.sourceforge.squirrel_sql.fw.sql.IDatabaseObjectInfo;
+import net.sourceforge.squirrel_sql.fw.util.StringManager;
+import net.sourceforge.squirrel_sql.fw.util.StringManagerFactory;
+
+/**
+ * This class will display the details for an Oracle LOB
+ * @author bpaulon
+ */
+public class LobDetailsTab extends BasePreparedStatementTab {
+ private static final StringManager s_stringMgr = StringManagerFactory
+ .getStringManager(LobDetailsTab.class);
+
+ /**
+ * This interface defines locale specific strings.
+ */
+ private interface i18n {
+ // i18n[oracle.lobDetails=Details]
+ String TITLE = s_stringMgr.getString("oracle.lobDetails");
+ // i18n[oracle.displayLobDetails=Display LOB details]
+ String HINT = s_stringMgr.getString("oracle.displayLobDetails");
+ }
+
+ /** SQL that retrieves the data. */
+ private static String SQL =
+ "select l.owner, l.table_name, l.column_name, l.segment_name,"
+ + " l.tablespace_name, l.index_name, l.chunk, l.pctversion, "
+ + " l.retention, l.freepools, l.cache, l.logging, "
+ + " l.in_row, l.format, l.partitioned "
+ + " from sys.all_lobs l "
+ + " where l.owner = ? and l.segment_name = ? ";
+
+ public LobDetailsTab() {
+ super(i18n.TITLE, i18n.HINT, true);
+ }
+
+ protected PreparedStatement createStatement() throws SQLException {
+ ISession session = getSession();
+ PreparedStatement pstmt = session.getSQLConnection()
+ .prepareStatement(SQL);
+ IDatabaseObjectInfo doi = getDatabaseObjectInfo();
+ pstmt.setString(1, doi.getSchemaName());
+ pstmt.setString(2, doi.getSimpleName());
+ return pstmt;
+ }
+}
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
