mcs/class/System.Data/Test/DataProviderTests/dataadaptertests/Runtests.exe.config

   1 <?xml version="1.0" encoding="utf-8" ?>
   2 <configuration>
   3         <appSettings>
   4                 <add key="databases" value="mysql;mssql;postgres;oracle" />
   5                 <add key="deleteTables" value="Y"/>
   6                 <add key="createTables" value="Y"/>
   7                 <add key="insertData" value="Y"/>
   8         </appSettings>
   9
  10         <configSections>
  11                 <section name="mysql" type="SectionHandlers.SectionHandler, DbRetrieve" allowLocation="true"/>
  12                 <section name="mssql" type="SectionHandlers.SectionHandler, DbRetrieve" allowLocation="true"/>
  13                 <section name="postgres" type="SectionHandlers.SectionHandler, DbRetrieve" allowLocation="true"/>
  14                 <section name="oracle" type="SectionHandlers.SectionHandler, DbRetrieve" allowLocation="true"/>
  15         </configSections>
  16
  17         <mysql>
  18                 <database>
  19                         <name> mysql </name>
  20                         <connectionString> "Server=164.99.152.215;Database=mysql;User Id=sudha;Password=novell" </connectionString>
  21                         <OdbcConnString>DSN=Mysql-Test-DSN;uid=sudha;pwd=novell </OdbcConnString>
  22                 </database>
  23                 <tables>
  24                         <numTables> 3 </numTables>
  25                         <table1>
  26                                 <name>numericTable </name>
  27                                 <numColumns>15</numColumns>
  28                                 <column1>
  29                                         <name> serialNo </name>
  30                                         <type> TINYINT UNSIGNED</type>
  31                                         <constraint> PRIMARY KEY</constraint>
  32                                 </column1>
  33                                 <column2>
  34                                         <name> unsigned_tinyInt </name>
  35                                         <type> TINYINT UNSIGNED</type>
  36                                 </column2>
  37                                 <column3>
  38                                         <name> signed_tinyInt </name>
  39                                         <type> TINYINT </type>
  40                                 </column3>
  41                                 <column4>
  42                                         <name> bit </name>
  43                                         <type> BIT </type>
  44                                 </column4>
  45                                 <column5>
  46                                         <name> bool </name>
  47                                         <type> BOOL </type>
  48                                 </column5>
  49                                 <column6>
  50                                         <name> unsigned_smallint</name>
  51                                         <type> SMALLINT UNSIGNED</type>
  52                                 </column6>
  53                                 <column7>
  54                                         <name> signed_smallint</name>
  55                                         <type> SMALLINT </type>
  56                                 </column7>
  57                                 <column8>
  58                                         <name> unsigned_mediumint</name>
  59                                         <type> MEDIUMINT UNSIGNED</type>
  60                                 </column8>
  61                                 <column9>
  62                                         <name> signed_mediumint</name>
  63                                         <type> MEDIUMINT </type>
  64                                 </column9>
  65                                 <column10>
  66                                         <name> unsigned_int</name>
  67                                         <type> INT UNSIGNED</type>
  68                                 </column10>
  69                                 <column11>
  70                                         <name> signed_int</name>
  71                                         <type> INT </type>
  72                                 </column11>
  73                                 <column12>
  74                                         <name> unsigned_integer</name>
  75                                         <type> INTEGER UNSIGNED</type>
  76                                 </column12>
  77                                 <column13>
  78                                         <name> signed_integer</name>
  79                                         <type> INTEGER </type>
  80                                 </column13>
  81                                 <column14>
  82                                         <name> unsigned_bigint</name>
  83                                         <type> BIGINT UNSIGNED </type>
  84                                 </column14>
  85                                 <column15>
  86                                         <name> signed_bigint</name>
  87                                         <type> BIGINT </type>
  88                                 </column15>
  89                         </table1>
  90                         <table2>
  91                                 <name>realNoTable </name>
  92                                 <numColumns>11</numColumns>
  93                                 <column1>
  94                                         <name> serialNo </name>
  95                                         <type> TINYINT UNSIGNED </type>
  96                                 </column1>
  97                                 <column2>
  98                                         <name> unsigned_float </name>
  99                                         <type> FLOAT(24) UNSIGNED </type>
 100                                 </column2>
 101                                 <column3>
 102                                         <name> signed_float </name>
 103                                         <type> FLOAT(24) </type>
 104                                 </column3>
 105                                 <column4>
 106                                         <name> unsigned_double_float </name>
 107                                         <type> FLOAT(25) UNSIGNED</type>
 108                                 </column4>
 109                                 <column5>
 110                                         <name> signed_double_float </name>
 111                                         <type> FLOAT(53) </type>
 112                                 </column5>
 113                                 <column6>
 114                                         <name> unsigned_double</name>
 115                                         <type> DOUBLE UNSIGNED </type>
 116                                 </column6>
 117                                 <column7>
 118                                         <name> signed_double</name>
 119                                         <type> DOUBLE </type>
 120                                 </column7>
 121                                 <column8>
 122                                         <name> unsigned_double_precision</name>
 123                                         <type> DOUBLE PRECISION UNSIGNED</type>
 124                                 </column8>
 125                                 <column9>
 126                                         <name> signed_real</name>
 127                                         <type> REAL </type>
 128                                 </column9>
 129                                 <column10>
 130                                         <name> unsigned_decimal</name>
 131                                         <type> DECIMAL(6,3) UNSIGNED</type>
 132                                 </column10>
 133                                 <column11>
 134                                         <name> signed_numeric</name>
 135                                         <type> NUMERIC(5,3) </type>
 136                                 </column11>
 137                         </table2>
 138                         <table3>
 139                                 <name>dateTable </name>
 140                                 <numColumns>6</numColumns>
 141                                 <column1>
 142                                         <name> serialNo </name>
 143                                         <type> TINYINT UNSIGNED </type>
 144                                 </column1>
 145                                 <column2>
 146                                         <name> dateField</name>
 147                                         <type> DATE </type>
 148                                 </column2>
 149                                 <column3>
 150                                         <name> datetimeField</name>
 151                                         <type> DATETIME </type>
 152                                 </column3>
 153                                 <column4>
 154                                         <name> timestampField</name>
 155                                         <type> TIMESTAMP </type>
 156                                 </column4>
 157                                 <column5>
 158                                         <name> timeField</name>
 159                                         <type> TIME </type>
 160                                 </column5>
 161                                 <column6>
 162                                         <name> yearField</name>
 163                                         <type> YEAR </type>
 164                                 </column6>
 165                         </table3>
 166                 </tables>
 167                 <values>
 168                         <numTables>3</numTables>
 169                         <table1>
 170                                 <tableName>numericTable</tableName>
 171                                 <numRows>4</numRows>
 172                                 <numCols>15</numCols>
 173                                 <row1>
 174                                         <column1> 1 </column1>
 175                                         <column2> 0</column2>
 176                                         <column3> -128</column3>
 177                                         <column4> -128</column4>
 178                                         <column5> -128</column5>
 179                                         <column6> 0 </column6>
 180                                         <column7> -32768 </column7>
 181                                         <column8> 0</column8>
 182                                         <column9> -8388608 </column9>
 183                                         <column10> 0 </column10>
 184                                         <column11> -2147483648 </column11>
 185                                         <column12> 0 </column12>
 186                                         <column13> -2147483648 </column13>
 187                                         <column14> 0 </column14>
 188                                         <column15> -9223372036854775808 </column15>
 189                                 </row1>
 190                                 <row2>
 191                                         <column1> 2 </column1>
 192                                         <column2> 100</column2>
 193                                         <column3> 50 </column3>
 194                                         <column4> 100 </column4>
 195                                         <column5> 100 </column5>
 196                                         <column6> 3000 </column6>
 197                                         <column7> -300 </column7>
 198                                         <column8> 500000 </column8>
 199                                         <column9> -100000 </column9>
 200                                         <column10> 4000000 </column10>
 201                                         <column11> 500000 </column11>
 202                                         <column12> 4000000 </column12>
 203                                         <column13> 500000 </column13>
 204                                         <column14> 5000000000 </column14>
 205                                         <column15> -5000000000 </column15>
 206                                 </row2>
 207                                 <row3>
 208                                         <column1> 3 </column1>
 209                                         <column2> 255</column2>
 210                                         <column3> 127</column3>
 211                                         <column4> 127</column4>
 212                                         <column5> 127</column5>
 213                                         <column6> 65535</column6>
 214                                         <column7> 32767 </column7>
 215                                         <column8> 16777215 </column8>
 216                                         <column9> 8388607 </column9>
 217                                         <column10> 4294967295 </column10>
 218                                         <column11> 2147483647 </column11>
 219                                         <column12> 4294967295 </column12>
 220                                         <column13> 2147483647 </column13>
 221                                         <column14> 18446744073709551615 </column14>
 222                                         <column15> 9223372036854775807 </column15>
 223                                 </row3>
 224                                 <row4>
 225                                         <column1> 4 </column1>
 226                                         <column2> null </column2>
 227                                         <column3> null </column3>
 228                                         <column4> null </column4>
 229                                         <column5> null </column5>
 230                                         <column6> null </column6>
 231                                         <column7> null </column7>
 232                                         <column8> null </column8>
 233                                         <column9> null </column9>
 234                                         <column10> null </column10>
 235                                         <column11> null </column11>
 236                                         <column12> null </column12>
 237                                         <column13> null </column13>
 238                                         <column14> null </column14>
 239                                         <column15> null </column15>
 240                                 </row4>
 241                                 <changes>
 242                                         <numChanges>5</numChanges>
 243                                         <change1>
 244                                                 <row>1</row>
 245                                                 <col>2</col>
 246                                                 <value>58 </value>
 247                                         </change1>
 248                                         <change2>
 249                                                 <row>1</row>
 250                                                 <col>6</col>
 251                                                 <value> 10 </value>
 252                                         </change2>
 253                                         <change3>
 254                                                 <row>2</row>
 255                                                 <col>3</col>
 256                                                 <value>27 </value>
 257                                         </change3>
 258                                         <change4>
 259                                                 <row>2</row>
 260                                                 <col>6</col>
 261                                                 <value>999 </value>
 262                                         </change4>
 263                                         <change5>
 264                                                 <row>1</row>
 265                                                 <col>14</col>
 266                                                 <value>999</value>
 267                                         </change5>
 268                                 </changes>
 269                         </table1>
 270                         <table2>
 271                                 <tableName>realNoTable</tableName>
 272                                 <numRows>6</numRows>
 273                                 <numCols>11</numCols>
 274                                 <row1>
 275                                         <column1> 1 </column1>
 276                                         <column2> 0 </column2>
 277                                         <column3> 0 </column3>
 278                                         <column4> 0 </column4>
 279                                         <column5> 0 </column5>
 280                                         <column6> 0 </column6>
 281                                         <column7> 0 </column7>
 282                                         <column8> 0 </column8>
 283                                         <column9> 0 </column9>
 284                                         <column10> 0 </column10>
 285                                         <column11> 0 </column11>
 286                                 </row1>
 287                                 <row2>
 288                                         <column1> 2 </column1>
 289                                         <column2> 1.175494351E-38 </column2>
 290                                         <column3> -3.402823466E+38 </column3>
 291                                         <column4> 1.175494351E-38 </column4>
 292                                         <column5> -1.797693134862315E+308 </column5>
 293                                         <column6> 1.175494351E-38 </column6>
 294                                         <column7> -1.797693134862315E+308 </column7>
 295                                         <column8> 1.175494351E-38 </column8>
 296                                         <column9> -1.797693134862315E+308 </column9>
 297                                         <column10> 99.999 </column10>
 298                                         <column11> -23.456 </column11>
 299                                 </row2>
 300                                 <row3>
 301                                         <column1> 3 </column1>
 302                                         <column2> 3.402823466E+38 </column2>
 303                                         <column3> -1.175494351E-38 </column3>
 304                                         <column4> 3.402823466E+38 </column4>
 305                                         <column5> -2.2250738585072014E-308 </column5>
 306                                         <column6> 3.402823466E+38 </column6>
 307                                         <column7> -2.2250738585072014E-308 </column7>
 308                                         <column8> 3.402823466E+38 </column8>
 309                                         <column9> -2.2250738585072014E-308 </column9>
 310                                         <column10> 778.123 </column10>
 311                                         <column11> -99.999 </column11>
 312                                 </row3>
 313                                 <row4>
 314                                         <column1> 4 </column1>
 315                                         <column2> 1.2345E+20</column2>
 316                                         <column3> 1.175494351E-38 </column3>
 317                                         <column4> 1.2345E+20 </column4>
 318                                         <column5> 2.2250738585072014E-308 </column5>
 319                                         <column6> 1.2345E+20 </column6>
 320                                         <column7> 2.2250738585072014E-308 </column7>
 321                                         <column8> 1.2345E+20 </column8>
 322                                         <column9> 2.2250738585072014E-308 </column9>
 323                                         <column10> 308.90 </column10>
 324                                         <column11> 12.345 </column11>
 325                                 </row4>
 326                                 <row5>
 327                                         <column1> 5 </column1>
 328                                         <column2> 3.452E-19</column2>
 329                                         <column3> 3.402823466E+38 </column3>
 330                                         <column4> 4.32E-15 </column4>
 331                                         <column5> 1.797693134862315E+308 </column5>
 332                                         <column6> 4.32E-15 </column6>
 333                                         <column7> 1.797693134862315E+308 </column7>
 334                                         <column8> 4.32E-15 </column8>
 335                                         <column9> 1.797693134862315E+308 </column9>
 336                                         <column10> 999.999 </column10>
 337                                         <column11> 999.999 </column11>
 338                                 </row5>
 339                                 <row6>
 340                                         <column1> 6 </column1>
 341                                         <column2> null </column2>
 342                                         <column3> null </column3>
 343                                         <column4> null </column4>
 344                                         <column5> null </column5>
 345                                         <column6> null </column6>
 346                                         <column7> null </column7>
 347                                         <column8> null </column8>
 348                                         <column9> null </column9>
 349                                         <column10> null </column10>
 350                                         <column11> null </column11>
 351                                 </row6>
 352                                 <changes>
 353                                         <numChanges>1</numChanges>
 354                                         <change1>
 355                                                 <row>1</row>
 356                                                 <col>2</col>
 357                                                 <value>67.58 </value>
 358                                         </change1>
 359                                         <change2>
 360                                                 <row>1</row>
 361                                                 <col>5</col>
 362                                                 <value>1.58E+124 </value>
 363                                         </change2>
 364                                         <change3>
 365                                                 <row>2</row>
 366                                                 <col>7</col>
 367                                                 <value>-1.58E-124 </value>
 368                                         </change3>
 369                                         <change4>
 370                                                 <row>1</row>
 371                                                 <col>8</col>
 372                                                 <value>1.12238E-62 </value>
 373                                         </change4>
 374                                 </changes>
 375                         </table2>
 376                         <table3>
 377                                 <tableName>dateTable</tableName>
 378                                 <numRows>9</numRows>
 379                                 <numCols>6</numCols>
 380                                 <row1>
 381                                         <column1> 1 </column1>
 382                                         <column2> '1000-01-01' </column2>
 383                                         <column3> '1000-01-01 00:00:00' </column3>
 384                                         <column4> '1970-01-02 00:00:00' </column4>
 385                                         <column5>  '-23:59:59' </column5>
 386                                         <column6> 2004 </column6>
 387                                 </row1>
 388                                 <row2>
 389                                         <column1> 2 </column1>
 390                                         <column2> '1999-12-17' </column2>
 391                                         <column3> '1999-12-17 08:00:00' </column3>
 392                                         <column4> '2000-01-01 04:40:00' </column4>
 393                                         <column5> '-23:45:56' </column5>
 394                                         <column6> 1999 </column6>
 395                                 </row2>
 396                                 <row3>
 397                                         <column1> 3 </column1>
 398                                         <column2> '9999-12-31' </column2>
 399                                         <column3> '9999-12-31 23:59:59' </column3>
 400                                         <column4> '2037-12-31 23:59:59' </column4>
 401                                         <column5> '23:59:59' </column5>
 402                                         <column6> 2155</column6>
 403                                 </row3>
 404                                 <row4>
 405                                         <column1> 4 </column1>
 406                                         <column2> '1999@12@31' </column2>
 407                                         <column3> '1999@12@31 11+30+45' </column3>
 408                                         <column4> '1999@12@31 11+30+45' </column4>
 409                                         <column5> '12:23:34' </column5>
 410                                         <column6> 1901</column6>
 411                                 </row4>
 412                                 <row5>
 413                                         <column1> 5 </column1>
 414                                         <column2> '9999.11.18' </column2>
 415                                         <column3> '9999.11.18 11*45*50' </column3>
 416                                         <column4> '2037.11.18 11*45*50' </column4>
 417                                         <column5> '23:34:34' </column5>
 418                                         <column6> 2069 </column6>
 419                                 </row5>
 420                                 <row6>
 421                                         <column1> 6 </column1>
 422                                         <column2> '9999/11/09' </column2>
 423                                         <column3> '9999/11/09 12:23:34' </column3>
 424                                         <column4> '2037/11/09 12:23:34' </column4>
 425                                         <column5> '09:08:07' </column5>
 426                                         <column6> 1970</column6>
 427                                 </row6>
 428                                 <row7>
 429                                         <column1> 7 </column1>
 430                                         <column2> 19980404 </column2>
 431                                         <column3> 19980404083050 </column3>
 432                                         <column4> 19980404083050 </column4>
 433                                         <column5> 083045 </column5>
 434                                         <column6> 0000</column6>
 435                                 </row7>
 436                                 <row8>
 437                                         <column1> 8 </column1>
 438                                         <column2> '0000-00-00' </column2>
 439                                         <column3> '0000-00-00 00:00:00' </column3>
 440                                         <column4> 00000000000000 </column4>
 441                                         <column5> '00:00:00'</column5>
 442                                         <column6> 00</column6>
 443                                 </row8>
 444                                 <row9>
 445                                         <column1> 9 </column1>
 446                                         <column2> null </column2>
 447                                         <column3> null </column3>
 448                                         <column4> null </column4>
 449                                         <column5> null </column5>
 450                                         <column6> null </column6>
 451                                 </row9>
 452                                 <changes>
 453                                         <numChanges>3</numChanges>
 454                                         <change1>
 455                                                 <row>1</row>
 456                                                 <col>5</col>
 457                                                 <value>'12:23:34' </value>
 458                                         </change1>
 459                                         <change2>
 460                                                 <row>1</row>
 461                                                 <col>3</col>
 462                                                 <value>'2004-12-17 08:00:00' </value>
 463                                         </change2>
 464                                         <change3>
 465                                                 <row>1</row>
 466                                                 <col>6</col>
 467                                                 <value> 1980 </value>
 468                                         </change3>
 469                                 </changes>
 470                         </table3>
 471                 </values>
 472                 <queries>
 473                         <numQueries> 2 </numQueries>
 474                         <query1> Select COLUMNS from TABLE1 order by COLUMN1 </query1>
 475                         <query2> Select COLUMN1,COLUMN3,COLUMN5 from TABLE2 order by COLUMN1 </query2>
 476                         <query3> Select COLUMN2,COLUMN4 from TABLE3 order by COLUMN1 </query3>
 477                 </queries>
 478         </mysql>
 479         <mssql>
 480                 <database>
 481                         <name> mssql </name>
 482                         <connectionString> Server=164.99.155.85;Database=mono-test;User ID=sa;Password=novell;</connectionString>
 483                         <OdbcConnString>DSN=MsSQL-DSN;uid=sa;pwd=novell </OdbcConnString>
 484                 </database>
 485                 <StoredProcExists> Y </StoredProcExists>
 486                 <tables>
 487                         <numTables> 5 </numTables>
 488                         <table1>
 489                                 <name>numericTable </name>
 490                                 <numColumns>6</numColumns>
 491                                 <column1>
 492                                         <name> sNo </name>
 493                                         <type> tinyint </type>
 494                                 </column1>
 495                                 <column2>
 496                                         <name> bigInteger </name>
 497                                         <type> bigint </type>
 498                                 </column2>
 499                                 <column3>
 500                                         <name> integer </name>
 501                                         <type>int</type>
 502                                 </column3>
 503                                 <column4>
 504                                         <name> smallInteger </name>
 505                                         <type> smallint </type>
 506                                 </column4>
 507                                 <column5>
 508                                         <name> tinyInt </name>
 509                                         <type> tinyint </type>
 510                                 </column5>
 511                                 <column6>
 512                                         <name> bit </name>
 513                                         <type> bit </type>
 514                                 </column6>
 515                         </table1>
 516                         <table2>
 517                                 <name>dateTimeTable </name>
 518                                 <numColumns>3</numColumns>
 519                                 <column1>
 520                                         <name> sNo </name>
 521                                         <type> tinyInt </type>
 522                                 </column1>
 523                                 <column2>
 524                                         <name> date</name>
 525                                         <type> datetime </type>
 526                                 </column2>
 527                                 <column3>
 528                                         <name> smalldate </name>
 529                                         <type> smalldatetime </type>
 530                                 </column3>
 531                         </table2>
 532                         <table3>
 533                                 <name>realNosTable </name>
 534                                 <numColumns>5</numColumns>
 535                                 <column1>
 536                                         <name> sNo </name>
 537                                         <type> tinyInt </type>
 538                                 </column1>
 539                                 <column2>
 540                                         <name> decimalCol </name>
 541                                         <type> decimal(8,4) </type>
 542                                 </column2>
 543                                 <column3>
 544                                         <name> numericCol </name>
 545                                         <type> numeric(6,4) </type>
 546                                 </column3>
 547                                 <column4>
 548                                         <name> floatCol </name>
 549                                         <type> float </type>
 550                                 </column4>
 551                                 <column5>
 552                                         <name> realCol </name>
 553                                         <type> real </type>
 554                                 </column5>
 555                         </table3>
 556                         <table4>
 557                                 <name>moneyTable </name>
 558                                 <numColumns>3</numColumns>
 559                                 <column1>
 560                                         <name> sNo </name>
 561                                         <type> tinyInt </type>
 562                                 </column1>
 563                                 <column2>
 564                                         <name> money </name>
 565                                         <type> money </type>
 566                                 </column2>
 567                                 <column3>
 568                                         <name> smallmoney </name>
 569                                         <type> smallmoney </type>
 570                                 </column3>
 571                         </table4>
 572                         <table5>
 573                                 <name>charTable </name>
 574                                 <numColumns>5</numColumns>
 575                                 <column1>
 576                                         <name> sNo </name>
 577                                         <type> tinyInt </type>
 578                                 </column1>
 579                                 <column2>
 580                                         <name> characterCol </name>
 581                                         <type> char(20) </type>
 582                                 </column2>
 583                                 <column3>
 584                                         <name> ncharacterCol </name>
 585                                         <type> nchar(20) </type>
 586                                 </column3>
 587                                 <column4>
 588                                         <name> varchar </name>
 589                                         <type> varchar(20) </type>
 590                                 </column4>
 591                                 <column5>
 592                                         <name> nvarchar </name>
 593                                         <type> nvarchar(20) </type>
 594                                 </column5>
 595                         </table5>
 596                 </tables>
 597                 <values>
 598                         <numTables>5</numTables>
 599                         <table1>
 600                                 <tableName>numericTable</tableName>
 601                                 <numRows>4</numRows>
 602                                 <numCols>6</numCols>
 603                                 <row1>
 604                                         <column1> 1 </column1>
 605                                         <column2> -9223372036854775808 </column2>
 606                                         <column3> -2147483648 </column3>
 607                                         <column4> -32768 </column4>
 608                                         <column5> 0</column5>
 609                                         <column6> 0</column6>
 610                                 </row1>
 611                                 <row2>
 612                                         <column1> 2 </column1>
 613                                         <column2> 1244 </column2>
 614                                         <column3> -50 </column3>
 615                                         <column4> 234 </column4>
 616                                         <column5> 128 </column5>
 617                                         <column6> 0</column6>
 618                                 </row2>
 619                                 <row3>
 620                                         <column1> 3 </column1>
 621                                         <column2> 9223372036854775807 </column2>
 622                                         <column3> 2147483647 </column3>
 623                                         <column4>  32767 </column4>
 624                                         <column5> 255 </column5>
 625                                         <column6> 1</column6>
 626                                 </row3>
 627                                 <row4>
 628                                         <column1> 4 </column1>
 629                                         <column2> null </column2>
 630                                         <column3> null </column3>
 631                                         <column4> null </column4>
 632                                         <column5> null </column5>
 633                                         <column6> null </column6>
 634                                 </row4>
 635                                 <changes>
 636                                         <numChanges>5</numChanges>
 637                                         <change1>
 638                                                 <row>1</row>
 639                                                 <col>2</col>
 640                                                 <value>-5678 </value>
 641                                         </change1>
 642                                         <change2>
 643                                                 <row>1</row>
 644                                                 <col>6</col>
 645                                                 <value> 10 </value>
 646                                         </change2>
 647                                         <change3>
 648                                                 <row>2</row>
 649                                                 <col>3</col>
 650                                                 <value>234 </value>
 651                                         </change3>
 652                                         <change4>
 653                                                 <row>3</row>
 654                                                 <col>5</col>
 655                                                 <value>-345 </value>
 656                                         </change4>
 657                                         <change5>
 658                                                 <row>3</row>
 659                                                 <col>2</col>
 660                                                 <value>-999 </value>
 661                                         </change5>
 662                                 </changes>
 663                         </table1>
 664                         <table2>
 665                                 <tableName> dateTimeTable</tableName>
 666                                 <numRows>3</numRows>
 667                                 <numCols>3</numCols>
 668                                 <row1>
 669                                         <column1> 1 </column1>
 670                                         <column2> '1/1/1753 03:04:05.234' </column2>
 671                                         <column3> '1/1/1970 12:24'</column3>
 672                                 </row1>
 673                                 <row2>
 674                                         <column1> 2 </column1>
 675                                         <column2> '12/31/9999 00:00:00' </column2>
 676                                         <column3> '6/6/2079 00:00'</column3>
 677                                 </row2>
 678                                 <row3>
 679                                         <column1> 3 </column1>
 680                                         <column2> null </column2>
 681                                         <column3> null </column3>
 682                                 </row3>
 683                         </table2>
 684                         <table3>
 685                                 <tableName> realNosTable</tableName>
 686                                 <numRows>6</numRows>
 687                                 <numCols>5</numCols>
 688                                 <row1>
 689                                         <column1> 1 </column1>
 690                                         <column2> -9.99E+3</column2>
 691                                         <column3> -99 </column3>
 692                                         <column4> -1.7976931348623157E+308 </column4>
 693                                         <column5> -3.402823466E+38 </column5>
 694                                 </row1>
 695                                 <row2>
 696                                         <column1> 2 </column1>
 697                                         <column2> -1.23E3 </column2>
 698                                         <column3> -12 </column3>
 699                                         <column4> -2.2250738585072014E-308 </column4>
 700                                         <column5> -3.4E-38 </column5>
 701                                 </row2>
 702                                 <row3>
 703                                         <column1> 3 </column1>
 704                                         <column2> 0 </column2>
 705                                         <column3> 0 </column3>
 706                                         <column4> 0 </column4>
 707                                         <column5> 0 </column5>
 708                                 </row3>
 709                                 <row4>
 710                                         <column1> 4 </column1>
 711                                         <column2> 1.2E1 </column2>
 712                                         <column3> 12 </column3>
 713                                         <column4> 2.2250738585072014E-308 </column4>
 714                                         <column5> 4.56E-3 </column5>
 715                                 </row4>
 716                                 <row5>
 717                                         <column1> 5 </column1>
 718                                         <column2> 9.999E3 </column2>
 719                                         <column3> 99 </column3>
 720                                         <column4> 1.7976931348623157E+308 </column4>
 721                                         <column5> 3.4E+38 </column5>
 722                                 </row5>
 723                                 <row6>
 724                                         <column1> 6 </column1>
 725                                         <column2> null </column2>
 726                                         <column3> null </column3>
 727                                         <column4> null </column4>
 728                                         <column5> null </column5>
 729                                 </row6>
 730                                 <changes>
 731                                         <numChanges> 1 </numChanges>
 732                                         <change1>
 733                                                 <row> 6 </row>
 734                                                 <col> 4 </col>
 735                                                 <value> 1.2E34 </value>
 736                                         </change1>
 737                                 </changes>
 738                         </table3>
 739                         <table4>
 740                                 <tableName> moneyTable</tableName>
 741                                 <numRows>4</numRows>
 742                                 <numCols>3</numCols>
 743                                 <row1>
 744                                         <column1> 1 </column1>
 745                                         <column2> -922337203685477.5808 </column2>
 746                                         <column3> -214748.3648 </column3>
 747                                 </row1>
 748                                 <row2>
 749                                         <column1> 2 </column1>
 750                                         <column2> 5477.5808 </column2>
 751                                         <column3> 748.3648 </column3>
 752                                 </row2>
 753                                 <row3>
 754                                         <column1> 3 </column1>
 755                                         <column2> 922337203685477.5807 </column2>
 756                                         <column3> 214748.3647 </column3>
 757                                 </row3>
 758                                 <row4>
 759                                         <column1> 4 </column1>
 760                                         <column2> null </column2>
 761                                         <column3> null </column3>
 762                                 </row4>
 763                         </table4>
 764                         <table5>
 765                                 <tableName> charTable</tableName>
 766                                 <numRows>2</numRows>
 767                                 <numCols>5</numCols>
 768                                 <row1>
 769                                         <column1> 1 </column1>
 770                                         <column2> '12345678901234567890' </column2>
 771                                         <column3> 'abcdefghijklmnopqrst' </column3>
 772                                         <column4> 'zyxwvutsrqponmlkjihg' </column4>
 773                                         <column5> '12345678901234567890' </column5>
 774                                 </row1>
 775                                 <row2>
 776                                         <column1> 2 </column1>
 777                                         <column2> null </column2>
 778                                         <column3> null </column3>
 779                                         <column4> null </column4>
 780                                         <column5> null </column5>
 781                                 </row2>
 782                         </table5>
 783                 </values>
 784                 <StoredProc>
 785                         <NumStoredProc> 1 </NumStoredProc>
 786                         <StoredProc1>
 787                                 <type> generic </type>
 788                                 <name> Select_{{TABLE}}_proc </name>
 789                                 <template>
 790                                         <numStmts> 1 </numStmts>
 791                                         <stmt1><![CDATA[
 792                                         create procedure Select_{{TABLE}}_proc As
 793                                         BEGIN
 794                                                 Select {{COLUMNS}} from {{TABLE}};
 795                                         END]]>
 796                                         </stmt1>
 797                                 </template>
 798                         </StoredProc1>
 799                 </StoredProc>
 800                 <queries>
 801                         <numQueries> 5 </numQueries>
 802                         <query1> Select COLUMNS from TABLE1 order by COLUMN1 </query1>
 803                         <query2> Select COLUMN1,COLUMN2,COLUMN3 from TABLE2 order by COLUMN1 </query2>
 804                         <query3> Select COLUMN2,COLUMN4 from TABLE3 order by COLUMN1 </query3>
 805                         <query4> Select COLUMNS from TABLE4 order by COLUMN1 </query4>
 806                         <query5> Select COLUMNS from TABLE5 order by COLUMN1 </query5>
 807                 </queries>
 808         </mssql>
 809
 810         <postgres>
 811                 <database>
 812                         <name> postgres </name>
 813                         <connectionString> Server=164.99.168.144;Database=test;User Id=sudha;Password= </connectionString>
 814                         <OdbcConnString>DSN=postgres-DSN;uid=sudha;pwd= </OdbcConnString>
 815                 </database>
 816                 <tables>
 817                         <numTables> 5 </numTables>
 818                         <table1>
 819                                 <name>numericTable </name>
 820                                 <numColumns> 4 </numColumns>
 821                                 <column1>
 822                                         <name> serialNo </name>
 823                                         <type> smallint </type>
 824                                 </column1>
 825                                 <column2>
 826                                         <name> small_int </name>
 827                                         <type> smallint </type>
 828                                 </column2>
 829                                 <column3>
 830                                         <name> int </name>
 831                                         <type> integer </type>
 832                                 </column3>
 833                                 <column4>
 834                                         <name> bigInteger </name>
 835                                         <type> bigint </type>
 836                                 </column4>
 837
 838                         </table1>
 839                         <table2>
 840                                 <name>realNoTable </name>
 841                                 <numColumns> 5 </numColumns>
 842                                 <column1>
 843                                         <name> serialNo </name>
 844                                         <type> smallint </type>
 845                                 </column1>
 846                                 <column2>
 847                                         <name> numeric_column </name>
 848                                         <type> numeric(10,6) </type>
 849                                 </column2>
 850                                 <column3>
 851                                         <name> numeric_noscale </name>
 852                                         <type> decimal(10) </type>
 853                                 </column3>
 854                                 <column4>
 855                                         <name> realNo </name>
 856                                         <type> real </type>
 857                                 </column4>
 858                                 <column5>
 859                                         <name> doubleNo  </name>
 860                                         <type> double precision </type>
 861                                 </column5>
 862                         </table2>
 863                         <table3>
 864                                 <name> charTable </name>
 865                                 <numColumns> 4 </numColumns>
 866                                 <column1>
 867                                         <name> serialNo </name>
 868                                         <type> smallint </type>
 869                                 </column1>
 870                                 <column2>
 871                                         <name> charColumn </name>
 872                                         <type> char(20) </type>
 873                                 </column2>
 874                                 <column3>
 875                                         <name> varcharColumn </name>
 876                                         <type> varchar(20) </type>
 877                                 </column3>
 878                                 <column4>
 879                                         <name> textColumn </name>
 880                                         <type> text </type>
 881                                 </column4>
 882                         </table3>
 883                         <table4>
 884                                 <name> dateTimeTable </name>
 885                                 <numColumns> 5 </numColumns>
 886                                 <column1>
 887                                         <name> serialNo </name>
 888                                         <type> smallint </type>
 889                                 </column1>
 890                                 <column2>
 891                                         <name> timestampCol </name>
 892                                         <type> timestamp </type>
 893                                 </column2>
 894                                 <column3>
 895                                         <name> intervalCol </name>
 896                                         <type> interval </type>
 897                                 </column3>
 898                                 <column4>
 899                                         <name> dateCol </name>
 900                                         <type> date </type>
 901                                 </column4>
 902                                 <column5>
 903                                         <name> timeCol </name>
 904                                         <type> time </type>
 905                                 </column5>
 906                         </table4>
 907                         <table5>
 908                                 <name> booleanTable </name>
 909                                 <numColumns> 2 </numColumns>
 910                                 <column1>
 911                                         <name> serialNo </name>
 912                                         <type> smallint </type>
 913                                 </column1>
 914                                 <column2>
 915                                         <name> bool </name>
 916                                         <type> boolean </type>
 917                                 </column2>
 918                         </table5>
 919                 </tables>
 920                 <values>
 921                         <numTables>5</numTables>
 922                         <table1>
 923                                 <tableName>numericTable</tableName>
 924                                 <numRows>4</numRows>
 925                                 <numCols>4</numCols>
 926                                 <row1>
 927                                         <column1> 1 </column1>
 928                                         <column2> -32768 </column2>
 929                                         <column3> -2147483648 </column3>
 930                                         <column4> -9223372036854775808 </column4>
 931                                 </row1>
 932                                 <row2>
 933                                         <column1> 2 </column1>
 934                                         <column2> 123 </column2>
 935                                         <column3> -648 </column3>
 936                                         <column4> 0 </column4>
 937                                 </row2>
 938                                 <row3>
 939                                         <column1> 3 </column1>
 940                                         <column2> 32767 </column2>
 941                                         <column3> 2147483647 </column3>
 942                                         <column4> 9223372036854775807 </column4>
 943                                 </row3>
 944                                 <row4>
 945                                         <column1> 4 </column1>
 946                                         <column2> null </column2>
 947                                         <column3> null </column3>
 948                                         <column4> null </column4>
 949                                 </row4>
 950                                 <changes>
 951                                         <numChanges>  2 </numChanges>
 952                                         <change1>
 953                                                 <row> 3 </row>
 954                                                 <col> 2 </col>
 955                                                 <value> 2000 </value>
 956                                         </change1>
 957                                         <change2>
 958                                                 <row> 2 </row>
 959                                                 <col> 3 </col>
 960                                                 <value> 2000000 </value>
 961                                         </change2>
 962                                 </changes>
 963                         </table1>
 964                         <table2>
 965                                 <tableName>realNoTable</tableName>
 966                                 <numRows>6</numRows>
 967                                 <numCols>5</numCols>
 968                                 <row1>
 969                                         <column1> 1 </column1>
 970                                         <column2> -9999.999999 </column2>
 971                                         <column3> -9999999999 </column3>
 972                                         <column4> -9.99999E-38 </column4>
 973                                         <column5> -9.999999999999999E-308 </column5>
 974                                 </row1>
 975                                 <row2>
 976                                         <column1> 2 </column1>
 977                                         <column2> -123.99 </column2>
 978                                         <column3> -1239 </column3>
 979                                         <column4> 9.99999E-38 </column4>
 980                                         <column5> 9.999999999999999E-308 </column5>
 981                                 </row2>
 982                                 <row3>
 983                                         <column1> 3 </column1>
 984                                         <column2> 0 </column2>
 985                                         <column3> 0 </column3>
 986                                         <column4> 0 </column4>
 987                                         <column5> 0 </column5>
 988                                 </row3>
 989                                 <row4>
 990                                         <column1> 4 </column1>
 991                                         <column2> 123.99 </column2>
 992                                         <column3> 123 </column3>
 993                                         <column4> -9.99999E37 </column4>
 994                                         <column5> -1.79769313486231E308 </column5>
 995                                 </row4>
 996                                 <row5>
 997                                         <column1> 5 </column1>
 998                                         <column2> 9999.999999 </column2>
 999                                         <column3> 9999999999 </column3>
1000                                         <column4> 9.99999E37 </column4>
1001                                         <column5> 1.79769313486231E308 </column5>
1002                                 </row5>
1003                                 <row6>
1004                                         <column1> 6 </column1>
1005                                         <column2> null </column2>
1006                                         <column3> null </column3>
1007                                         <column4> null </column4>
1008                                         <column5> null </column5>
1009                                 </row6>
1010                         </table2>
1011                         <table3>
1012                                 <tableName>charTable</tableName>
1013                                 <numRows>2</numRows>
1014                                 <numCols>4</numCols>
1015                                 <row1>
1016                                         <column1> 1 </column1>
1017                                         <column2> 'abcdefghijklmnopqrst' </column2>
1018                                         <column3> '1234567890' </column3>
1019                                         <column4> 'This is a fixed length text' </column4>
1020                                 </row1>
1021                                 <row2>
1022                                         <column1> 2 </column1>
1023                                         <column2> null </column2>
1024                                         <column3> null </column3>
1025                                         <column4> null </column4>
1026                                 </row2>
1027                         </table3>
1028                         <table4>
1029                                 <tableName>datetimeTable</tableName>
1030                                 <numRows>4</numRows>
1031                                 <numCols>5</numCols>
1032                                 <row1>
1033                                         <column1> 1 </column1>
1034                                         <column2> '0001-01-01 00:00:00.000000' </column2>
1035                                         <column3> '-178000000 years +4 days'  </column3>
1036                                         <column4> '0001-01-01' </column4>
1037                                         <column5> '12:23:34' </column5>
1038                                 </row1>
1039                                 <row2>
1040                                         <column1> 2 </column1>
1041                                         <column2> '2004-10-21 11:15:23' </column2>
1042                                         <column3> '7890 years 5 days 07:30' </column3>
1043                                         <column4> '2004-01-12' </column4>
1044                                         <column5> '00:00:00' </column5>
1045                                 </row2>
1046                                 <row3>
1047                                         <column1> 3 </column1>
1048                                         <column2> '9999-12-31 23:59:59.9999' </column2>
1049                                         <column3> '178000000 years 00:19:23'  </column3>
1050                                         <column4> '9999-12-31' </column4>
1051                                         <column5> '23:59:59' </column5>
1052                                 </row3>
1053                                 <row4>
1054                                         <column1> 4 </column1>
1055                                         <column2> null </column2>
1056                                         <column3> null </column3>
1057                                         <column4> null </column4>
1058                                         <column5> null </column5>
1059                                 </row4>
1060                         </table4>
1061                         <table5>
1062                                 <tableName>booleanTable</tableName>
1063                                 <numRows>3</numRows>
1064                                 <numCols>2</numCols>
1065                                 <row1>
1066                                         <column1> 1 </column1>
1067                                         <column2> TRUE </column2>
1068                                 </row1>
1069                                 <row2>
1070                                         <column1> 2 </column1>
1071                                         <column2> FALSE </column2>
1072                                 </row2>
1073                                 <row3>
1074                                         <column1> 3 </column1>
1075                                         <column2> null </column2>
1076                                 </row3>
1077                                 </table5>
1078                 </values>
1079                 <queries>
1080                         <numQueries> 5 </numQueries>
1081                         <query1> Select COLUMNS from TABLE1 order by COLUMN1 </query1>
1082                         <query2> Select COLUMN1,COLUMN2,COLUMN3 from TABLE2 order by COLUMN1 </query2>
1083                         <query3> Select COLUMN2,COLUMN4 from TABLE3 order by COLUMN1 </query3>
1084                         <query4> Select COLUMNS from TABLE4 order by COLUMN1 </query4>
1085                         <query5> Select COLUMNS from TABLE5 order by COLUMN1 </query5>
1086                 </queries>
1087         </postgres>
1088         <oracle>
1089                 <database>
1090                         <name> oracle </name>
1091                         <connectionString> Data Source=testdb.com;User Id=user9i;Password=oracle9i </connectionString>
1092                         <OdbcConnString>DSN=Oracle-DSN;uid=user9i;pwd=oracle9i </OdbcConnString>
1093                 </database>
1094                 <StoredProcExists> Y </StoredProcExists>
1095                 <tables>
1096                         <numTables> 4 </numTables>
1097                         <table1>
1098                                 <name>numericTable </name>
1099                                 <numColumns> 3 </numColumns>
1100                                 <column1>
1101                                         <name> serialNo </name>
1102                                         <type> number(1)</type>
1103                                 </column1>
1104                                 <column2>
1105                                         <name> intCol </name>
1106                                         <type> number(6)</type>
1107                                 </column2>
1108                                 <column3>
1109                                         <name> decimalCol </name>
1110                                         <type> number(6, 3)</type>
1111                                 </column3>
1112                         </table1>
1113                         <table2>
1114                                 <name> charTable </name>
1115                                 <numColumns> 5 </numColumns>
1116                                 <column1>
1117                                         <name> serialNo </name>
1118                                         <type> number(1)</type>
1119                                 </column1>
1120                                 <column2>
1121                                         <name> charCol </name>
1122                                         <type> char(10) </type>
1123                                 </column2>
1124                                 <column3>
1125                                         <name> ncharCol </name>
1126                                         <type> nchar(10) </type>
1127                                 </column3>
1128                                 <column4>
1129                                         <name> varcharCol </name>
1130                                         <type> varchar2(10) </type>
1131                                 </column4>
1132                                 <column5>
1133                                         <name> nvarcharCol </name>
1134                                         <type> nvarchar2(10) </type>
1135                                 </column5>
1136                         </table2>
1137                                 <table3>
1138                                 <name> RealNoTable </name>
1139                                 <numColumns> 2 </numColumns>
1140                                 <column1>
1141                                         <name> serialNo </name>
1142                                         <type> number(1)</type>
1143                                 </column1>
1144                                 <column2>
1145                                         <name> floatCol </name>
1146                                         <type> float(24) </type>
1147                                 </column2>
1148                         </table3>
1149                         <table4>
1150                                 <name> DateTimeTable </name>
1151                                 <numColumns> 5 </numColumns>
1152                                 <column1>
1153                                         <name> serialNo </name>
1154                                         <type> number(1)</type>
1155                                 </column1>
1156                                 <column2>
1157                                         <name> dateCol </name>
1158                                         <type> date </type>
1159                                 </column2>
1160                                 <column3>
1161                                         <name> timestampCol </name>
1162                                         <type> timestamp </type>
1163                                 </column3>
1164                                 <column4>
1165                                         <name> Int_year </name>
1166                                         <type> interval Year to month</type>
1167                                 </column4>
1168                                 <column5>
1169                                         <name> int_day </name>
1170                                         <type> interval day to second </type>
1171                                 </column5>
1172                         </table4>
1173                 </tables>
1174                 <values>
1175                         <numTables>4</numTables>
1176                         <table1>
1177                                 <tableName>numericTable</tableName>
1178                                 <numRows>4</numRows>
1179                                 <numCols>3</numCols>
1180                                 <row1>
1181                                         <column1> 1 </column1>
1182                                         <column2> -999999 </column2>
1183                                         <column3> -999.999 </column3>
1184                                 </row1>
1185                                 <row2>
1186                                         <column1> 2 </column1>
1187                                         <column2> 1000 </column2>
1188                                         <column3> 234 </column3>
1189                                 </row2>
1190                                 <row3>
1191                                         <column1> 3 </column1>
1192                                         <column2> 999999 </column2>
1193                                         <column3> 999.999 </column3>
1194                                 </row3>
1195                                 <row4>
1196                                         <column1> 4 </column1>
1197                                         <column2> null </column2>
1198                                         <column3> null </column3>
1199                                 </row4>
1200                         </table1>
1201                         <table2>
1202                                 <tableName>charTable</tableName>
1203                                 <numRows>2</numRows>
1204                                 <numCols>5</numCols>
1205                                 <row1>
1206                                         <column1> 1 </column1>
1207                                         <column2> '0123456789' </column2>
1208                                         <column3> 'abcdefghij' </column3>
1209                                         <column4> '0123456789' </column4>
1210                                         <column5> 'abcdefghij' </column5>
1211                                 </row1>
1212                                 <row2>
1213                                         <column1> 2 </column1>
1214                                         <column2> null </column2>
1215                                         <column3> null </column3>
1216                                         <column4> null </column4>
1217                                         <column5> null </column5>
1218                                 </row2>
1219                         </table2>
1220                         <table3>
1221                                 <tableName>RealNoTable</tableName>
1222                                 <numRows>6</numRows>
1223                                 <numCols>2</numCols>
1224                                 <row1>
1225                                         <column1> 1 </column1>
1226                                         <column2> 9.9999999E125  </column2>
1227                                 </row1>
1228                                 <row2>
1229                                         <column1> 2 </column1>
1230                                         <column2> -9.999999E-126 </column2>
1231                                 </row2>
1232                                 <row3>
1233                                         <column1> 3 </column1>
1234                                         <column2> 1.23E-15 </column2>
1235                                 </row3>
1236                                 <row4>
1237                                         <column1> 4 </column1>
1238                                         <column2> -9.999999E-126 </column2>
1239                                 </row4>
1240                                 <row5>
1241                                         <column1> 5 </column1>
1242                                         <column2> 9.9999999E125 </column2>
1243                                 </row5>
1244                                 <row6>
1245                                         <column1> 6 </column1>
1246                                         <column2> null </column2>
1247                                 </row6>
1248                         </table3>
1249                         <table4>
1250                                 <tableName>DateTimeTable</tableName>
1251                                 <numRows>3</numRows>
1252                                 <numCols>5</numCols>
1253                                 <row1>
1254                                         <column1> 1 </column1>
1255                                         <column2> to_date('0001-01-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss') </column2>
1256                                         <column3> TIMESTAMP'0001-01-01 00:00:00' </column3>
1257                                         <column4>  '-99-11' </column4>
1258                                         <column5>  '-99 23:59:59' </column5>
1259                                 </row1>
1260                                 <row2>
1261                                         <column1> 2 </column1>
1262                                         <column2> to_date('2004-11-23 12:34:45', 'yyyy-mm-dd hh24:mi:ss') </column2>
1263                                         <column3> TIMESTAMP'2004-11-23 12:34:45' </column3>
1264                                         <column4>  '34-5' </column4>
1265                                         <column5>  '-34 20:50:00' </column5>
1266                                 </row2>
1267                                 <row3>
1268                                         <column1> 3 </column1>
1269                                         <column2> to_date('9999-12-31 23:59:59', 'yyyy-mm-dd hh24:mi:ss') </column2>
1270                                         <column3> TIMESTAMP'9999-12-31 23:59:59' </column3>
1271                                         <column4>  '99-11' </column4>
1272                                         <column5>  '00 23:59:59' </column5>
1273                                 </row3>
1274                         </table4>
1275                 </values>
1276                 <StoredProc>
1277                         <NumStoredProc> 1 </NumStoredProc>
1278                         <StoredProc1>
1279                                 <type> generic </type>
1280                                 <name> {{TABLE}}_pkg.Select_{{TABLE}}_data</name>
1281                                 <template>
1282                                         <numStmts> 2 </numStmts>
1283                                         <stmt1><![CDATA[
1284                                         create or replace package {{TABLE}}_pkg As
1285                                                 type {{TABLE}}Cur is ref cursor return  {{TABLE}}%rowtype;
1286                                                 procedure Select{{TABLE}}Data (ref_cur out {{TABLE}}Cur);
1287                                         END {{TABLE}}_pkg;]]>
1288                                         </stmt1>
1289                                         <stmt2><![CDATA[
1290                                         create or replace package body {{TABLE}}_pkg As
1291                                                 procedure Select{{TABLE}}Data ( ref_cur out {{TABLE}}Cur) is
1292                                                 BEGIN
1293                                                         open ref_cur for select {{COLUMNS}} from {{TABLE}} order by {{COLUMN_1}};
1294                                                 End Select{{TABLE}}Data;
1295                                         END {{TABLE}}_pkg;]]></stmt2>
1296                                 </template>
1297                         </StoredProc1>
1298                 </StoredProc>
1299                 <queries>
1300                         <numQueries> 4 </numQueries>
1301                         <query1> Select COLUMNS from TABLE1 order by COLUMN1 </query1>
1302                         <query2> Select COLUMN1,COLUMN2,COLUMN3 from TABLE2 order by COLUMN1 </query2>
1303                         <query3> Select COLUMNS from TABLE3 order by COLUMN1 </query3>
1304                         <query4> Select COLUMNS from TABLE4 order by COLUMN1 </query4>
1305                 </queries>
1306         </oracle>
1307 </configuration>