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

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