Java Doc for ErrorLogReader.java in  » Database-DBMS » db-derby-10.2 » org » apache » derby » diag » Java Source Code / Java DocumentationJava Source Code and Java Documentation

Java Source Code / Java Documentation
1. 6.0 JDK Core
2. 6.0 JDK Modules
3. 6.0 JDK Modules com.sun
4. 6.0 JDK Modules com.sun.java
5. 6.0 JDK Modules sun
6. 6.0 JDK Platform
7. Ajax
8. Apache Harmony Java SE
9. Aspect oriented
10. Authentication Authorization
11. Blogger System
12. Build
13. Byte Code
14. Cache
15. Chart
16. Chat
17. Code Analyzer
18. Collaboration
19. Content Management System
20. Database Client
21. Database DBMS
22. Database JDBC Connection Pool
23. Database ORM
24. Development
25. EJB Server geronimo
26. EJB Server GlassFish
27. EJB Server JBoss 4.2.1
28. EJB Server resin 3.1.5
29. ERP CRM Financial
30. ESB
31. Forum
32. GIS
33. Graphic Library
34. Groupware
35. HTML Parser
36. IDE
37. IDE Eclipse
38. IDE Netbeans
39. Installer
40. Internationalization Localization
41. Inversion of Control
42. Issue Tracking
43. J2EE
44. JBoss
45. JMS
46. JMX
47. Library
48. Mail Clients
49. Net
50. Parser
51. PDF
52. Portal
53. Profiler
54. Project Management
55. Report
56. RSS RDF
57. Rule Engine
58. Science
59. Scripting
60. Search Engine
61. Security
62. Sevlet Container
63. Source Control
64. Swing Library
65. Template Engine
66. Test Coverage
67. Testing
68. UML
69. Web Crawler
70. Web Framework
71. Web Mail
72. Web Server
73. Web Services
74. Web Services apache cxf 2.0.1
75. Web Services AXIS2
76. Wiki Engine
77. Workflow Engines
78. XML
79. XML UI
Java
Java Tutorial
Java Open Source
Jar File Download
Java Articles
Java Products
Java by API
Photoshop Tutorials
Maya Tutorials
Flash Tutorials
3ds-Max Tutorials
Illustrator Tutorials
GIMP Tutorials
C# / C Sharp
C# / CSharp Tutorial
C# / CSharp Open Source
ASP.Net
ASP.NET Tutorial
JavaScript DHTML
JavaScript Tutorial
JavaScript Reference
HTML / CSS
HTML CSS Reference
C / ANSI-C
C Tutorial
C++
C++ Tutorial
Ruby
PHP
Python
Python Tutorial
Python Open Source
SQL Server / T-SQL
SQL Server / T-SQL Tutorial
Oracle PL / SQL
Oracle PL/SQL Tutorial
PostgreSQL
SQL / MySQL
MySQL Tutorial
VB.Net
VB.Net Tutorial
Flash / Flex / ActionScript
VBA / Excel / Access / Word
XML
XML Tutorial
Microsoft Office PowerPoint 2007 Tutorial
Microsoft Office Excel 2007 Tutorial
Microsoft Office Word 2007 Tutorial
Java Source Code / Java Documentation » Database DBMS » db derby 10.2 » org.apache.derby.diag 
Source Cross Reference  Class Diagram Java Document (Java Doc) 


java.lang.Object
   org.apache.derby.vti.VTITemplate
      org.apache.derby.diag.ErrorLogReader

ErrorLogReader
public class ErrorLogReader extends VTITemplate (Code)
ErrorLogReader is a virtual table interface (VTI) which contains all the statements of "interest" in db2j.log or a specified file when db2j.language.logStatementText=true.

One use of this VTI is to determine the active transactions and the SQL statements in those transactions at a given point in time, say when a deadlock or lock timeout occurred. In order to do that, you must first find the timestamp (timestampConstant) of interest in the error log. The SQL to view the active transactions at a given in time is:

SELECT vti.ts, threadid, cast(xid as int) as xid_int, cast(lccid as int) as lccid_int, logtext 
 FROM new org.apache.derby.diag.ErrorLogReader() vti, 
 (VALUES timestampConstant) t(ts)
 WHERE vti.ts <= t.ts AND 
 vti.ts >
 (SELECT MAX(ts) IS NULL ? '2000-01-01 00:00:00.1' : MAX(ts)
 FROM new org.apache.derby.diag.ErrorLogReader() vti_i
 WHERE (logtext LIKE 'Committing%' OR
 logtext LIKE 'Rolling%') AND
 vti.xid = vti_i.xid AND ts < t.ts)
 ORDER BY xid_int, vti.ts
 

The ErrorLogReader virtual table has the following columns:

  • TS varchar(26) - the timestamp of the statement.
  • THREADID varchar(40) - the thread name.
  • XID varchar(15) - the transaction ID.
  • LCCID varchar(15) - the connection ID.
  • DATABASE varchar(128) - Database name
  • DRDAID varchar(50) - nullable. DRDA ID for network server session.
  • LOGTEXT long varchar - text of the statement or commit or rollback.



Constructor Summary
public  ErrorLogReader()
     ErrorLogReader() accesses the derby.log in derby.system.home, if set, otherwise it looks in the current directory.
public  ErrorLogReader(String inputFileName)
    

Method Summary
public  voidclose()
    
public  ResultSetMetaDatagetMetaData()
    
public  StringgetString(int columnNumber)
     All columns in the Db2jLogReader VTI have a of String type.
public  booleannext()
    
public  booleanwasNull()
    


Constructor Detail
ErrorLogReader
public ErrorLogReader()(Code)
ErrorLogReader() accesses the derby.log in derby.system.home, if set, otherwise it looks in the current directory. ErrorLogReader('filename') will access the specified file name.



ErrorLogReader
public ErrorLogReader(String inputFileName)(Code)




Method Detail
close
public void close()(Code)

See Also:   java.sql.ResultSet.close



getMetaData
public ResultSetMetaData getMetaData()(Code)

See Also:   java.sql.ResultSet.getMetaData



getString
public String getString(int columnNumber) throws SQLException(Code)
All columns in the Db2jLogReader VTI have a of String type.
See Also:   java.sql.ResultSet.getString
exception:
  SQLException - If database-access error occurs.



next
public boolean next() throws SQLException(Code)

See Also:   java.sql.ResultSet.next
exception:
  SQLException - If database-access error occurs.



wasNull
public boolean wasNull()(Code)

See Also:   java.sql.ResultSet.wasNull



Methods inherited from org.apache.derby.vti.VTITemplate
public boolean absolute(int row) throws SQLException(Code)(Java Doc)
public void afterLast() throws SQLException(Code)(Java Doc)
public void beforeFirst() throws SQLException(Code)(Java Doc)
public void cancelRowUpdates() throws SQLException(Code)(Java Doc)
public void clearWarnings() throws SQLException(Code)(Java Doc)
public void deleteRow() throws SQLException(Code)(Java Doc)
public int findColumn(String columnName) throws SQLException(Code)(Java Doc)
public boolean first() throws SQLException(Code)(Java Doc)
public Array getArray(int i) throws SQLException(Code)(Java Doc)
public Array getArray(String colName) throws SQLException(Code)(Java Doc)
public java.io.InputStream getAsciiStream(int columnIndex) throws SQLException(Code)(Java Doc)
public java.io.InputStream getAsciiStream(String columnName) throws SQLException(Code)(Java Doc)
public BigDecimal getBigDecimal(int columnIndex, int scale) throws SQLException(Code)(Java Doc)
public BigDecimal getBigDecimal(String columnName, int scale) throws SQLException(Code)(Java Doc)
public BigDecimal getBigDecimal(int columnIndex) throws SQLException(Code)(Java Doc)
public BigDecimal getBigDecimal(String columnName) throws SQLException(Code)(Java Doc)
public java.io.InputStream getBinaryStream(int columnIndex) throws SQLException(Code)(Java Doc)
public java.io.InputStream getBinaryStream(String columnName) throws SQLException(Code)(Java Doc)
public Blob getBlob(int i) throws SQLException(Code)(Java Doc)
public Blob getBlob(String colName) throws SQLException(Code)(Java Doc)
public boolean getBoolean(int columnIndex) throws SQLException(Code)(Java Doc)
public boolean getBoolean(String columnName) throws SQLException(Code)(Java Doc)
public byte getByte(int columnIndex) throws SQLException(Code)(Java Doc)
public byte getByte(String columnName) throws SQLException(Code)(Java Doc)
public byte[] getBytes(int columnIndex) throws SQLException(Code)(Java Doc)
public byte[] getBytes(String columnName) throws SQLException(Code)(Java Doc)
public java.io.Reader getCharacterStream(int columnIndex) throws SQLException(Code)(Java Doc)
public java.io.Reader getCharacterStream(String columnName) throws SQLException(Code)(Java Doc)
public Clob getClob(int i) throws SQLException(Code)(Java Doc)
public Clob getClob(String colName) throws SQLException(Code)(Java Doc)
public int getConcurrency() throws SQLException(Code)(Java Doc)
public String getCursorName() throws SQLException(Code)(Java Doc)
public java.sql.Date getDate(int columnIndex) throws SQLException(Code)(Java Doc)
public java.sql.Date getDate(String columnName) throws SQLException(Code)(Java Doc)
public java.sql.Date getDate(int columnIndex, Calendar cal) throws SQLException(Code)(Java Doc)
public java.sql.Date getDate(String columnName, Calendar cal) throws SQLException(Code)(Java Doc)
public double getDouble(int columnIndex) throws SQLException(Code)(Java Doc)
public double getDouble(String columnName) throws SQLException(Code)(Java Doc)
public int getFetchDirection() throws SQLException(Code)(Java Doc)
public int getFetchSize() throws SQLException(Code)(Java Doc)
public float getFloat(int columnIndex) throws SQLException(Code)(Java Doc)
public float getFloat(String columnName) throws SQLException(Code)(Java Doc)
public int getInt(int columnIndex) throws SQLException(Code)(Java Doc)
public int getInt(String columnName) throws SQLException(Code)(Java Doc)
public long getLong(int columnIndex) throws SQLException(Code)(Java Doc)
public long getLong(String columnName) throws SQLException(Code)(Java Doc)
public Object getObject(int columnIndex) throws SQLException(Code)(Java Doc)
public Object getObject(String columnName) throws SQLException(Code)(Java Doc)
public Object getObject(int i, java.util.Map map) throws SQLException(Code)(Java Doc)
public Object getObject(String colName, java.util.Map map) throws SQLException(Code)(Java Doc)
public Ref getRef(int i) throws SQLException(Code)(Java Doc)
public Ref getRef(String colName) throws SQLException(Code)(Java Doc)
public int getRow() throws SQLException(Code)(Java Doc)
public short getShort(int columnIndex) throws SQLException(Code)(Java Doc)
public short getShort(String columnName) throws SQLException(Code)(Java Doc)
public Statement getStatement() throws SQLException(Code)(Java Doc)
public String getString(int columnIndex) throws SQLException(Code)(Java Doc)
public String getString(String columnName) throws SQLException(Code)(Java Doc)
public java.sql.Time getTime(int columnIndex) throws SQLException(Code)(Java Doc)
public java.sql.Time getTime(String columnName) throws SQLException(Code)(Java Doc)
public java.sql.Time getTime(int columnIndex, Calendar cal) throws SQLException(Code)(Java Doc)
public java.sql.Time getTime(String columnName, Calendar cal) throws SQLException(Code)(Java Doc)
public java.sql.Timestamp getTimestamp(int columnIndex) throws SQLException(Code)(Java Doc)
public java.sql.Timestamp getTimestamp(String columnName) throws SQLException(Code)(Java Doc)
public java.sql.Timestamp getTimestamp(int columnIndex, Calendar cal) throws SQLException(Code)(Java Doc)
public java.sql.Timestamp getTimestamp(String columnName, Calendar cal) throws SQLException(Code)(Java Doc)
public int getType() throws SQLException(Code)(Java Doc)
public URL getURL(int columnIndex) throws SQLException(Code)(Java Doc)
public URL getURL(String columnName) throws SQLException(Code)(Java Doc)
public java.io.InputStream getUnicodeStream(int columnIndex) throws SQLException(Code)(Java Doc)
public java.io.InputStream getUnicodeStream(String columnName) throws SQLException(Code)(Java Doc)
public SQLWarning getWarnings() throws SQLException(Code)(Java Doc)
public void insertRow() throws SQLException(Code)(Java Doc)
public boolean isAfterLast() throws SQLException(Code)(Java Doc)
public boolean isBeforeFirst() throws SQLException(Code)(Java Doc)
public boolean isFirst() throws SQLException(Code)(Java Doc)
public boolean isLast() throws SQLException(Code)(Java Doc)
public boolean last() throws SQLException(Code)(Java Doc)
public void moveToCurrentRow() throws SQLException(Code)(Java Doc)
public void moveToInsertRow() throws SQLException(Code)(Java Doc)
public boolean previous() throws SQLException(Code)(Java Doc)
public void refreshRow() throws SQLException(Code)(Java Doc)
public boolean relative(int rows) throws SQLException(Code)(Java Doc)
public boolean rowDeleted() throws SQLException(Code)(Java Doc)
public boolean rowInserted() throws SQLException(Code)(Java Doc)
public boolean rowUpdated() throws SQLException(Code)(Java Doc)
public void setFetchDirection(int direction) throws SQLException(Code)(Java Doc)
public void setFetchSize(int rows) throws SQLException(Code)(Java Doc)
public void updateArray(int columnIndex, Array x) throws SQLException(Code)(Java Doc)
public void updateArray(String columnName, Array x) throws SQLException(Code)(Java Doc)
public void updateAsciiStream(int columnIndex, java.io.InputStream x, int length) throws SQLException(Code)(Java Doc)
public void updateAsciiStream(String columnName, java.io.InputStream x, int length) throws SQLException(Code)(Java Doc)
public void updateBigDecimal(int columnIndex, BigDecimal x) throws SQLException(Code)(Java Doc)
public void updateBigDecimal(String columnName, BigDecimal x) throws SQLException(Code)(Java Doc)
public void updateBinaryStream(int columnIndex, java.io.InputStream x, int length) throws SQLException(Code)(Java Doc)
public void updateBinaryStream(String columnName, java.io.InputStream x, int length) throws SQLException(Code)(Java Doc)
public void updateBlob(int columnIndex, Blob x) throws SQLException(Code)(Java Doc)
public void updateBlob(String columnName, Blob x) throws SQLException(Code)(Java Doc)
public void updateBoolean(int columnIndex, boolean x) throws SQLException(Code)(Java Doc)
public void updateBoolean(String columnName, boolean x) throws SQLException(Code)(Java Doc)
public void updateByte(int columnIndex, byte x) throws SQLException(Code)(Java Doc)
public void updateByte(String columnName, byte x) throws SQLException(Code)(Java Doc)
public void updateBytes(int columnIndex, byte[] x) throws SQLException(Code)(Java Doc)
public void updateBytes(String columnName, byte[] x) throws SQLException(Code)(Java Doc)
public void updateCharacterStream(int columnIndex, java.io.Reader x, int length) throws SQLException(Code)(Java Doc)
public void updateCharacterStream(String columnName, java.io.Reader x, int length) throws SQLException(Code)(Java Doc)
public void updateClob(int columnIndex, Clob x) throws SQLException(Code)(Java Doc)
public void updateClob(String columnName, Clob x) throws SQLException(Code)(Java Doc)
public void updateDate(int columnIndex, java.sql.Date x) throws SQLException(Code)(Java Doc)
public void updateDate(String columnName, java.sql.Date x) throws SQLException(Code)(Java Doc)
public void updateDouble(int columnIndex, double x) throws SQLException(Code)(Java Doc)
public void updateDouble(String columnName, double x) throws SQLException(Code)(Java Doc)
public void updateFloat(int columnIndex, float x) throws SQLException(Code)(Java Doc)
public void updateFloat(String columnName, float x) throws SQLException(Code)(Java Doc)
public void updateInt(int columnIndex, int x) throws SQLException(Code)(Java Doc)
public void updateInt(String columnName, int x) throws SQLException(Code)(Java Doc)
public void updateLong(int columnIndex, long x) throws SQLException(Code)(Java Doc)
public void updateLong(String columnName, long x) throws SQLException(Code)(Java Doc)
public void updateNull(int columnIndex) throws SQLException(Code)(Java Doc)
public void updateNull(String columnName) throws SQLException(Code)(Java Doc)
public void updateObject(int columnIndex, Object x, int scale) throws SQLException(Code)(Java Doc)
public void updateObject(int columnIndex, Object x) throws SQLException(Code)(Java Doc)
public void updateObject(String columnName, Object x, int scale) throws SQLException(Code)(Java Doc)
public void updateObject(String columnName, Object x) throws SQLException(Code)(Java Doc)
public void updateRef(int columnIndex, Ref x) throws SQLException(Code)(Java Doc)
public void updateRef(String columnName, Ref x) throws SQLException(Code)(Java Doc)
public void updateRow() throws SQLException(Code)(Java Doc)
public void updateShort(int columnIndex, short x) throws SQLException(Code)(Java Doc)
public void updateShort(String columnName, short x) throws SQLException(Code)(Java Doc)
public void updateString(int columnIndex, String x) throws SQLException(Code)(Java Doc)
public void updateString(String columnName, String x) throws SQLException(Code)(Java Doc)
public void updateTime(int columnIndex, java.sql.Time x) throws SQLException(Code)(Java Doc)
public void updateTime(String columnName, java.sql.Time x) throws SQLException(Code)(Java Doc)
public void updateTimestamp(int columnIndex, java.sql.Timestamp x) throws SQLException(Code)(Java Doc)
public void updateTimestamp(String columnName, java.sql.Timestamp x) throws SQLException(Code)(Java Doc)
public boolean wasNull() throws SQLException(Code)(Java Doc)

Methods inherited from java.lang.Object
native protected Object clone() throws CloneNotSupportedException(Code)(Java Doc)
public boolean equals(Object obj)(Code)(Java Doc)
protected void finalize() throws Throwable(Code)(Java Doc)
final native public Class getClass()(Code)(Java Doc)
native public int hashCode()(Code)(Java Doc)
final native public void notify()(Code)(Java Doc)
final native public void notifyAll()(Code)(Java Doc)
public String toString()(Code)(Java Doc)
final native public void wait(long timeout) throws InterruptedException(Code)(Java Doc)
final public void wait(long timeout, int nanos) throws InterruptedException(Code)(Java Doc)
final public void wait() throws InterruptedException(Code)(Java Doc)

www.java2java.com | Contact Us
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.