Java Doc for Procedure.java in  » Scripting » jython » com » ziclix » python » sql » 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 » Scripting » jython » com.ziclix.python.sql 
Source Cross Reference  Class Diagram Java Document (Java Doc) 


java.lang.Object
   com.ziclix.python.sql.Procedure

All known Subclasses:   com.ziclix.python.sql.procedure.SQLServerProcedure,
Procedure
public class Procedure extends Object (Code)
This class provides the necessary functionality to call stored procedures. It handles managing the database metadata and binding the appropriate parameters.
author:
   brian zimmer
author:
   last modified by $Author: fwierzbicki $
version:
   $Revision: 2542 $


Field Summary
final protected static  intCOLUMN_TYPE
    
final protected static  intDATA_TYPE
    
final protected static  intDATA_TYPE_NAME
    
final protected static  intLENGTH
    
final protected static  intNAME
    
final protected static  intNULLABLE
    
final protected static  intPRECISION
    
final protected static  intSCALE
    
protected  PyObjectcolumns
    
protected  PyCursorcursor
    
protected  BitSetinputSet
    
protected  PyObjectprocedureCatalog
    
protected  PyObjectprocedureName
    
protected  PyObjectprocedureSchema
    

Constructor Summary
public  Procedure(PyCursor cursor, PyObject name)
    

Method Summary
protected  voidfetchColumns()
     Get the columns for the stored procedure.
protected  PyObjectgetDefault()
     The value for a missing schema or catalog.
protected  StringgetProcedureName()
     Construct a procedure name for the relevant schema and catalog information.
public  booleanisInput(int index)
     This method determines whether the param at the specified index is an IN or INOUT param for a stored procedure.
public  voidnormalizeInput(PyObject params, PyObject bindings)
     Prepare the binding dictionary with the correct datatypes.
public  CallableStatementprepareCall()
     Prepares the statement and registers the OUT/INOUT parameters (if any).
public  CallableStatementprepareCall(PyObject rsType, PyObject rsConcur)
     Prepares the statement and registers the OUT/INOUT parameters (if any).
protected  voidregisterOutParameters(CallableStatement statement)
     Registers the OUT/INOUT parameters of the statement.
public  StringtoSql()
     Returns the call in the syntax:

{? = call (?, ?, ...)} {call (?, ?, ...)}

As of now, all parameters variables are created and no support for named variable calling is supported.


Field Detail
COLUMN_TYPE
final protected static int COLUMN_TYPE(Code)
Field COLUMN_TYPE



DATA_TYPE
final protected static int DATA_TYPE(Code)
Field DATA_TYPE



DATA_TYPE_NAME
final protected static int DATA_TYPE_NAME(Code)
Field DATA_TYPE_NAME



LENGTH
final protected static int LENGTH(Code)
Field LENGTH



NAME
final protected static int NAME(Code)
Field NAME



NULLABLE
final protected static int NULLABLE(Code)
Field NULLABLE



PRECISION
final protected static int PRECISION(Code)
Field PRECISION



SCALE
final protected static int SCALE(Code)
Field SCALE



columns
protected PyObject columns(Code)
Field columns



cursor
protected PyCursor cursor(Code)
Field cursor



inputSet
protected BitSet inputSet(Code)
Field inputSet



procedureCatalog
protected PyObject procedureCatalog(Code)
Field procedureCatalog



procedureName
protected PyObject procedureName(Code)
Field procedureName



procedureSchema
protected PyObject procedureSchema(Code)
Field procedureSchema




Constructor Detail
Procedure
public Procedure(PyCursor cursor, PyObject name) throws SQLException(Code)
Constructor Procedure
Parameters:
  cursor - cursor an open cursor
Parameters:
  name - name a string or tuple representing the name
throws:
  SQLException -




Method Detail
fetchColumns
protected void fetchColumns() throws SQLException(Code)
Get the columns for the stored procedure.
throws:
  SQLException -



getDefault
protected PyObject getDefault()(Code)
The value for a missing schema or catalog. This value is used to find the column names for the procedure. Not all DBMS use the same default value; for instance Oracle uses an empty string and SQLServer a null. This implementation returns the empty string. the default value (the empty string)
See Also:   java.sql.DatabaseMetaData.getProcedureColumns



getProcedureName
protected String getProcedureName()(Code)
Construct a procedure name for the relevant schema and catalog information.



isInput
public boolean isInput(int index) throws SQLException(Code)
This method determines whether the param at the specified index is an IN or INOUT param for a stored procedure. This is only configured properly AFTER a call to normalizeInput().
Parameters:
  index - JDBC indexed column index (1, 2, ...) true if the column is an input, false otherwise
throws:
  SQLException -



normalizeInput
public void normalizeInput(PyObject params, PyObject bindings) throws SQLException(Code)
Prepare the binding dictionary with the correct datatypes.
Parameters:
  params - a non-None list of params
Parameters:
  bindings - a dictionary of bindings



prepareCall
public CallableStatement prepareCall() throws SQLException(Code)
Prepares the statement and registers the OUT/INOUT parameters (if any). CallableStatement
throws:
  SQLException -



prepareCall
public CallableStatement prepareCall(PyObject rsType, PyObject rsConcur) throws SQLException(Code)
Prepares the statement and registers the OUT/INOUT parameters (if any).
Parameters:
  rsType - the value of to be created ResultSet type
Parameters:
  rsConcur - the value of the to be created ResultSet concurrency CallableStatement
throws:
  SQLException -



registerOutParameters
protected void registerOutParameters(CallableStatement statement) throws SQLException(Code)
Registers the OUT/INOUT parameters of the statement.
Parameters:
  statement - statement
throws:
  SQLException -



toSql
public String toSql() throws SQLException(Code)
Returns the call in the syntax:

{? = call (?, ?, ...)} {call (?, ?, ...)}

As of now, all parameters variables are created and no support for named variable calling is supported. String




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.