|
Server : Apache/2.2.2 (Fedora) System : Linux App1.pathumtani.go.th 2.6.20-1.2320.fc5smp #1 SMP Tue Jun 12 19:40:16 EDT 2007 i686 User : apache ( 48) PHP Version : 5.2.9 Disable Function : NONE Directory : /usr/share/xalan-j2/samples/extensions/sql/ |
Upload File : |
аЯрЁБс > ўџ D F ўџџџ C џџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџьЅС Y П % bjbjѓWѓW < = = ! џџ џџ џџ ] Њ Њ Њ Њ Њ Њ Њ О О О О О к $ О 6 Ж Ђ М М М М Т Y
Ь % h ћ § § § § § § $ ь є р ! Њ ! 3
Њ Њ М М л 3
3
3
H Њ М Њ М ћ О О Њ Њ Њ Њ ћ 3
Ш 3
ћ Њ Њ ћ М ў n]kћЋРО О е ^ ћ Xalan SQL Extension
Connections and Queries
TOC \o "2-3" \t "Heading 1,1" Database Connections PAGEREF _Toc509119435 \h 1
Providing Connection information in the XSL File PAGEREF _Toc509119436 \h 1
XConnection(Sring DBDriver, String DBurl) PAGEREF _Toc509119437 \h 1
XConnection(String DBDriver, String DBurl, String User, String Password) PAGEREF _Toc509119438 \h 1
XConnection(String DBDriver, String DBurl, NodeList Properties) PAGEREF _Toc509119439 \h 1
Providing Connection information in the XML File PAGEREF _Toc509119440 \h 1
XConnection(NodeList ConnectionData) PAGEREF _Toc509119441 \h 1
Using Existing Connections in a connection pool PAGEREF _Toc509119442 \h 2
XConnection(String ConnectionName) PAGEREF _Toc509119443 \h 2
Connection Pools PAGEREF _Toc509119444 \h 2
Overview PAGEREF _Toc509119445 \h 2
Creating a new wrapper PAGEREF _Toc509119446 \h 2
The Default Connection Pool PAGEREF _Toc509119447 \h 2
Queries PAGEREF _Toc509119448 \h 2
Standard queries PAGEREF _Toc509119449 \h 2
Parameter based queries PAGEREF _Toc509119450 \h 2
Overview PAGEREF _Toc509119451 \h 2
Handling Value and Type Information PAGEREF _Toc509119452 \h 2
Examples PAGEREF _Toc509119453 \h 3
Basic PAGEREF _Toc509119454 \h 3
External Connections PAGEREF _Toc509119455 \h 3
PQuery PAGEREF _Toc509119456 \h 3
Database Connections
The SQL Extension provides 2 basic mechanisms to connect to the database. The connection information can either be provided in the XSL/XML or pulled from a Connection Pool that was created outside the Xalan library.
The XConnection object is used to represent a connection to the database. The actual connection is established through the object constructor. Each of the different mechanisms differs with the signature of the extension.
When the connection information is provided in the XSL or XML sources, a default connection pool will be created on its behalf but due to restrictions in some drivers, the actual pooling of connections will disabled by default. See Connection Pools, The Default Connection Pool.
Providing Connection information in the XSL File
When providing Connection Information from the XSL or XML input sources, the XConnection object will create a default connection pool that will exist for the lifetime of the Transformation object.
XConnection(Sring DBDriver, String DBurl)
Create a standard JDBC connection using the specified driver and URL. This is used primarily for local databases that do not return user identification.
XConnection(String DBDriver, String DBurl, String User, String Password)
Create a standard JDBC Connection, which also provides user identification.
XConnection(String DBDriver, String DBurl, NodeList Properties)
Create a standard JDBC connection that loads the database driver using the specified URL. The NodeList provides will then be converted into a properties object which will be passes in when getting the JDBC connection.
Providing Connection information in the XML File
XConnection(NodeList ConnectionData)
Create connection and pass in the complete connection information as a Nodelist. This allows the XML data to provide the connection information. The node list will be used to create a named value pair list where the Node Name will represent the name and the Node Value will be the value. Required Tags consist of dbdriver and dburl. Optional tags can include user and password to specify the user identification but can also include any other database connection property.
Using Existing Connections in a connection pool
XConnection(String ConnectionName)
The Xalan SQL Extensions allows the controlling program to create an external JDBC Connection Pool and reference the connection pools by name inside the Stylsheet. Besides providing a mechanism to share connection resources with Xalan, is also allows the Stylesheet to not be concerned with the Connection properties all together.
Connection Pools
Overview
Connection pools allow the Xalan Transformer to share connections with the rest of the application. Any existing JDBC Connection pool should be compatible with the Xalan Transformer by creating a wrapper class around the specific connection pool and registering it with the XConnectionPoolManager.
Creating a new wrapper
The org.apache.xalan.lib.sql.connection is the interface that needs to be implemented be compatible with the Xalan Transformer.
The Default Connection Pool
To provide a uniform internal programming model, the XConnection object will create an instance of the DefaultConnectionPool. By default the Default Connection Pool will
Queries
Standard queries
query(XConnection conn, String SQL)
Standard queries take a connection as arguments, an XConnection and the SQL String. It is the responsibility of the Stylesheet designer to format the SQL String completely including any quotes that are necessary. For static queries this is fine because the sting can be assembled at design time.
Parameter based queries
Overview
Parameter based queries are used when data that dynamically changes the query needs to be supplied from the XML Data.
The Stylesheet will provide the skeleton template of the query with place holders where the data goes, then provides several mechanisms to apply that data from the XML Data.
Parameter based queries take advantage of the JDBC Prepared statement semantics.
Handling Value and Type Information
When using parameterized query the place markers in the query (a ?) will be replaced with data that is provided using one of the addParameter.. methods. When adding data to a parameter based query, the type of each value must also be included so that real query can be produced. The type information can be passed in as a component of the Query or the Data which ever is more convenient to the Stylesheet designer.
If the type information is missing for a data point, the default type is set to String.
The list of possible value types include, string, bigdecimal, boolean, bytes, date, double, float, long, short, time, timestamp.
pquery(XConnection, query)
When just the query statement is passed as a parameter, the Type information must be passed in as a component of the data.
pquery(XConnection, query, typeinfo)
This allows the query to be specified using the ? place holders and defining the type for each of the placeholders as a comma separated value string. i.e. string,int,string,datetime
addParameter(XConnection, value)
Add a new value to be used with a pquery, each new value is appended to a list that will be merged into the query statement when the pquery statement is executed. All data points must be added prior to executing the pquery statement.
addParameterWithType(XConnection, value,type)
Add a new value specifying the type information also.
addParameterFromElement(XConnection, NodeList)
Add a block of data points from a node list queried from the XML Data Source. Each tag name at the START_TAG and TAG1 level are irrelevant, the only significant information is the value and possibly the type attribute.
If the type attribute is present, it will set the current type. If the type information is missing, it will either be provide through one of the other mechanisms or default to a string.
<START_TAG>
<TAG1> type=int>value</TAG1>
</START_TAG
Typical implementation
<xsl:param name=plist select=/START_TAG />
<xsl:addParameterFromElement( $conn, $plist);
Examples
All of the following examples use the Enhydra InstantDB which is included as part of the Xalan distribution to operate. Please read the Enhydra documentation on managing an InstantDB http://www.instantdb.co.uk/
Basic
The XML/XSL Files (dbinfo.xml and dbtest.xsl) provide an example of implementing a basic connection where the connection information is provided in the XSL file using a static query.
The XML/XSL Files (dbinfo.xml and dbtest-cinfo.xsl) provide an example of implementing a basic connection where the connection information is provided as a node list in the XML file using a static query.
External Connections
The java file ExternalConnection demonstrates how to build a JDBC connection pool that is independent of Xalan. The actual connection pool used is the Default Connection pool inside the Xalan SQL Extension, which already implements the ConnectionPool interface so no wrapper was required. To implement a third party connection pool, a wrapper function must be implemented.
PQuery
The XML/XSL file (dbInfo.xml and dbtest.xsl) provide an example of implementing a parameter based query.
, - L M b c } ~ Г Д Ю Я а б в § ў f g
Ц Ч с т у ф х 2 3 4 5 6 \ ] w x y z { Ќ Ч Ш Щ Ъ Ы я №
њ њї№їц№ї№ї№їм№ї№ї№їв№ї№ї№їШ№ї№ї№їО№ї№ї№їД№ї№ї№їЊ№ї№ї№ї №ї№ї№ї jk UmH jю UmH jq UmH jє UmH jw UmH jњ UmH j} UmH j UmH
j UmH mH j U ? , г ц 7 | Ь @ i м 5 m к ) ^
§ § ї ё ы ы ы ё ы ё ы ї ё ё ё ї ё ё ы ы ї ё ё ё щ ч
Ц Ж!
Ц Ж!
Ц Ж!
, г ц 7 | Ь @ i м 5 m к ) ^
t
Q h ^
! j ќќїђэшуойдЯЪХРЛЖБЌЇЂ~ysnhc]
Gўџџ жџџџ
џџџ Яџџџ
§џџ 6ўџџ џџџ ыџџџ њџџ Жњџџ ыњџџ ћџџ :ћџџ ~ћџџ Їћџџ пћџџ ќџџ 8ќџџ tќџџ Ћќџџ дќџџ §џџ H§џџ §џџ н§џџ .ўџџ ўџџ їўџџ Aџџџ џџџ шџџџ "
! ; < = > ? I J d e f g h М Н з и й к л ф х џ 0 1 2 3 4 M N h i j k l v w К ѕюыюыюысюыюыюызюыюыюыЭюыюыюыУюыюыюыЙюыюыюыЏюыюыюыЅюыюыюыюыюы jа UmH jS UmH jж UmH jY UmH jм UmH j_ UmH jт UmH je UmH mH
j UmH jш UmH =К Л е ж з и й у ф ў џ
$ % & ' ( > ? Y Z [ \ ] e f
% јѕыјѕјѕјѕсјѕјѕјѕзјѕјѕјѕЭјѕјѕјѕУјѕјѕО j UjA
UmH jФ UmH jG UmH jЪ UmH jM UmH mH
j UmH % t
Q h ^
! j Ж і а & 7 Z Ѕ Ж П щ F N _ Ћ § § § ћ љ ї љ ї ѕ ї ѕ ћ ї ѕ ћ ї ѕ ѓ ћ љ ћ љ ћ љ ѓ ћ ѕ ѕ j Ж і а & 7 Z Ѕ Ж П щ F N _ Ћ У Ь B № A e _ с ќ x W ћѕ№ъфпйгЮЫХРКЕЏЊЫЄytojd_Yп
Щќџџ хџџџ
`§џџ т§џџ :ўџџ мџџџ
jўџџ гўџџ џџџ їџџџ
шџџџ
ўџџ Ыџџџ яџџџ
јџџџ фџџџ
%ўџџ щџџџ
Мўџџ їџџџ
яџџџ нџџџ
аџџџ
їџџ лџџџ
Яџџџ
Зљџџ Рџџџ
В§џџ Зџџџ!Ћ У Ь B № A e _ с ќ x W x b Ц ѕ б И Ф Х н ! :! C! § ћ љ љ љ ћ љ љ љ ї ѕ ї љ ї ѕ ї ѕ ї љ љ љ љ љ љ љ љ љ ѓ W x b Ц ѕ б И Ф Х н ! :! C! " " г" # Д# )% 0% % њѕяъфпкеаЫЦСМЗДЏЉЄ љџџџ
ќџџ ыџџџ
§џџ Cџџџ њџџџ
$џџџ їџџџ К§џџ щ§џџ ўџџ ўџџ ўџџ /ўџџ ;ўџџ ѕўџџ бџџџ
{њџџ вџџџ
пњџџ пџџџ
ъћџџC! " " г" # Д# )% 0% % § ћ љ љ ћ љ ћ љ Аа/ Ар=!А"А# $ %А } D аЩъyљКЮ Њ KЉ _ T o c 5 0 9 1 1 9 4 3 5 } D аЩъyљКЮ Њ KЉ _ T o c 5 0 9 1 1 9 4 3 6 } D аЩъyљКЮ Њ KЉ _ T o c 5 0 9 1 1 9 4 3 7 } D аЩъyљКЮ Њ KЉ _ T o c 5 0 9 1 1 9 4 3 8 } D аЩъyљКЮ Њ KЉ _ T o c 5 0 9 1 1 9 4 3 9 } D аЩъyљКЮ Њ KЉ _ T o c 5 0 9 1 1 9 4 4 0 } D аЩъyљКЮ Њ KЉ _ T o c 5 0 9 1 1 9 4 4 1 } D аЩъyљКЮ Њ KЉ _ T o c 5 0 9 1 1 9 4 4 2 } D аЩъyљКЮ Њ KЉ _ T o c 5 0 9 1 1 9 4 4 3 } D аЩъyљКЮ Њ KЉ _ T o c 5 0 9 1 1 9 4 4 4 } D аЩъyљКЮ Њ KЉ _ T o c 5 0 9 1 1 9 4 4 5 } D аЩъyљКЮ Њ KЉ _ T o c 5 0 9 1 1 9 4 4 6 } D аЩъyљКЮ Њ KЉ _ T o c 5 0 9 1 1 9 4 4 7 } D аЩъyљКЮ Њ KЉ _ T o c 5 0 9 1 1 9 4 4 8 } D аЩъyљКЮ Њ KЉ _ T o c 5 0 9 1 1 9 4 4 9 } D аЩъyљКЮ Њ KЉ _ T o c 5 0 9 1 1 9 4 5 0 } D аЩъyљКЮ Њ KЉ _ T o c 5 0 9 1 1 9 4 5 1 } D аЩъyљКЮ Њ KЉ _ T o c 5 0 9 1 1 9 4 5 2 } D аЩъyљКЮ Њ KЉ _ T o c 5 0 9 1 1 9 4 5 3 } D аЩъyљКЮ Њ KЉ _ T o c 5 0 9 1 1 9 4 5 4 } D аЩъyљКЮ Њ KЉ _ T o c 5 0 9 1 1 9 4 5 5 } D аЩъyљКЮ Њ KЉ _ T o c 5 0 9 1 1 9 4 5 6
[ $ @ёџ $ N o r m a l mH H @ H H e a d i n g 1 $Є№ Є< @& 5CJ KH OJ QJ J @ J H e a d i n g 2 $hЄ№ Є< @& 56CJ OJ QJ L @ L H e a d i n g 3 $аЄ№ Є< @&
Ц CJ OJ QJ H ` H H e a d i n g 4 $аЄ№ Є< @& 5CJ OJ QJ 6 @ 6 H e a d i n g 5
Є№ Є< @& CJ < A@ђџЁ < D e f a u l t P a r a g r a p h F o n t @ >@ ђ @ T i t l e $Є№ Є< @& 5CJ KH OJ QJ , @ , T O C 1
Єx Єx 5;& @ & T O C 2 Ш : & @ & T O C 3 6 & @ & T O C 4 X CJ & @ & T O C 5 CJ & @ & T O C 6 ш CJ & @ & T O C 7 А CJ & @ & T O C 8 x CJ & @ & T O C 9 @ CJ * ўO * b o d y 3
$а8 & ўo Ђ& b o d y 4
а8 . ўO В. b o d y 1 $аhЄ№ " ўoТ" b o d y 2 а ( U@Ђ б( H y p e r l i n k >*B*8 V@Ђ с8 F o l l o w e d H y p e r l i n k >*B* ! < џџџџ
К % Ћ C! % j W % , L b ~ Г Я б § f Ц т ф 3 5 \ x z Ќ Ш Ъ я
< > I e g М и к ф 1 3 M i k v К ж и у џ % ' > Z \ e
!
tџ%tџР%tџР%tџР%tџР%tџР%tџР%tџР%tџР%tџР%tџР%tџР%tџР%tџР%tџР%tџР%tџР%tџР%tџР%tџР%tџР%tџР%tџР №8 № @ ё џџ џ ї № № №0 №( №
№ №B
№ S № П Ы џ ? № џџ
_ T o c 5 0 9 0 6 2 5 5 3
_ T o c 5 0 9 0 6 2 5 5 4
_ T o c 5 0 9 0 6 2 5 5 5
_ T o c 5 0 9 1 1 9 4 3 5
_ T o c 5 0 9 1 1 9 4 3 6
_ T o c 5 0 9 1 1 9 4 3 7
_ T o c 5 0 9 1 1 9 4 3 8
_ T o c 5 0 9 1 1 9 4 3 9
_ T o c 5 0 9 1 1 9 4 4 0
_ T o c 5 0 9 1 1 9 4 4 1
_ T o c 5 0 9 1 1 9 4 4 2
_ T o c 5 0 9 1 1 9 4 4 3
_ T o c 5 0 9 1 1 9 4 4 4
_ T o c 5 0 9 1 1 9 4 4 5
_ T o c 5 0 9 1 1 9 4 4 6
_ T o c 5 0 9 1 1 9 4 4 7
_ T o c 5 0 9 1 1 9 4 4 8
_ T o c 5 0 9 1 1 9 4 4 9
_ T o c 5 0 9 1 1 9 4 5 0
_ T o c 5 0 9 1 1 9 4 5 1
_ T o c 5 0 9 1 1 9 4 5 2
_ T o c 5 0 9 1 1 9 4 5 3
_ T o c 5 0 9 1 1 9 4 5 4
_ T o c 5 0 9 1 1 9 4 5 5
_ T o c 5 0 9 1 1 9 4 5 6 h ^ !
Ж
а 7 Ѕ Ж щ F N Ћ У A : )! !
+ i
ѕ
% 6 Y Е О џ M ^ Т Ы d B Г /! ! e j j o p x 4
<
E
J
Щ
б
к
п
$ m u `
h
o
t
J X ^ c ѓ ќ ? D к п c h б ч ' m r q u Ѕ ! }
о
Д Ж ї џ Ѕ <! d! ! џџ
J o h n G e n t i l i n S D : \ P r o j e c t s \ S M A R T 9 1 1 \ D o c u m e n t s \ D e t a i l D e s i g n \ X a l a n E x t e n s i o n s \ X a l a n S Q L E x t e n s i o n . d o c
J o h n G e n t i l i n < C : \ W I N D O W S \ T E M P \ A u t o R e c o v e r y s a v e o f X a l a n S Q L E x t e n s i o n . a s d
J o h n G e n t i l i n < C : \ W I N D O W S \ T E M P \ A u t o R e c o v e r y s a v e o f X a l a n S Q L E x t e n s i o n . a s d
J o h n G e n t i l i n < C : \ W I N D O W S \ T E M P \ A u t o R e c o v e r y s a v e o f X a l a n S Q L E x t e n s i o n . a s d
J o h n G e n t i l i n < C : \ W I N D O W S \ T E M P \ A u t o R e c o v e r y s a v e o f X a l a n S Q L E x t e n s i o n . a s d
J o h n G e n t i l i n < C : \ W I N D O W S \ T E M P \ A u t o R e c o v e r y s a v e o f X a l a n S Q L E x t e n s i o n . a s d
J o h n G e n t i l i n S D : \ P r o j e c t s \ S M A R T 9 1 1 \ D o c u m e n t s \ D e t a i l D e s i g n \ X a l a n E x t e n s i o n s \ X a l a n S Q L E x t e n s i o n . d o c
J o h n G e n t i l i n S D : \ P r o j e c t s \ S M A R T 9 1 1 \ D o c u m e n t s \ D e t a i l D e s i g n \ X a l a n E x t e n s i o n s \ X a l a n S Q L E x t e n s i o n . h t m
J o h n G e n t i l i n S D : \ P r o j e c t s \ S M A R T 9 1 1 \ D o c u m e n t s \ D e t a i l D e s i g n \ X a l a n E x t e n s i o n s \ X a l a n S Q L E x t e n s i o n . h t m
J o h n G e n t i l i n S D : \ P r o j e c t s \ S M A R T 9 1 1 \ D o c u m e n t s \ D e t a i l D e s i g n \ X a l a n E x t e n s i o n s \ X a l a n S Q L E x t e n s i o n . d o c џ@ ! ! ft ! ! ! 0 @ G : џ T i m e s N e w R o m a n 5 S y m b o l 3& : џ A r i a l " q а h kSFkSF м Д ; Д ЅРД Д 20 " ! џџ X a l a n S Q L E x t e n s i o n
J o h n G e n t i l i n
J o h n G e n t i l i n ўџ
р
ђљOhЋ +'Гй0 t Ќ И а м №
0 <
H T \ d l ф Xalan SQL Extension ala John Gentilin ns ohn Normal.dot i John Gentilin ns 3 hn Microsoft Word 8.0 @ FУ# @ оN ћЋР@ jеeћЋР м Д ўџ
еЭе. +,љЎD еЭе. +,љЎX h p Є Ќ Д М Ф Ь
д є ф Eye Catching Solutions Inc ; " j Xalan SQL Extension Title 6 >
_PID_GUID ф A N { 1 0 9 0 0 3 8 6 - 1 7 2 5 - 1 1 D 5 - 8 E 0 1 - 0 0 1 0 A 4 0 A 4 A 3 7 }
ўџџџ ! " # $ % & ўџџџ( ) * + , - . / 0 1 2 ўџџџ4 5 6 7 8 9 : ўџџџ< = > ? @ A B ўџџџ§џџџE ўџџџўџџџўџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџR o o t E n t r y џџџџџџџџ Р F `ў№xЋР иukћЋРG D a t a
џџџџџџџџџџџџ 1 T a b l e џџџџџџџџ ' d W o r d D o c u m e n t џџџџ < S u m m a r y I n f o r m a t i o n ( џџџџџџџџџџџџ 3 D o c u m e n t S u m m a r y I n f o r m a t i o n 8 џџџџџџџџ ; C o m p O b j џџџџ j O b j e c t P o o l џџџџџџџџџџџџ иukћЋР иukћЋР ўџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџ ўџ
џџџџ Р F Microsoft Word Document
MSWordDoc Word.Document.8 є9Вq