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

   1 <?xml version="1.0" encoding="utf-8" ?>
   2 <configuration>
   3         <configSections>
   4                 <section name="mysql" type="SectionHandlers.SectionHandler, DbRetrieve" allowLocation="true"/>
   5                 <section name="mssql" type="SectionHandlers.SectionHandler, DbRetrieve" allowLocation="true"/>
   6                 <section name="postgres" type="SectionHandlers.SectionHandler, DbRetrieve" allowLocation="true"/>
   7                 <section name="oracle" type="SectionHandlers.SectionHandler, DbRetrieve" allowLocation="true"/>
   8         </configSections>
   9
  10         <appSettings>
  11                 <add key="databases" value="mssql" />
  12                 <add key="deleteTables" value="Y"/>
  13                 <add key="createTables" value="Y"/>
  14                 <add key="insertData" value="Y"/>
  15         </appSettings>
  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                         </table1>
 242                         <table2>
 243                                 <tableName>realNoTable</tableName>
 244                                 <numRows>6</numRows>
 245                                 <numCols>11</numCols>
 246                                 <row1>
 247                                         <column1> 1 </column1>
 248                                         <column2> 0 </column2>
 249                                         <column3> 0 </column3>
 250                                         <column4> 0 </column4>
 251                                         <column5> 0 </column5>
 252                                         <column6> 0 </column6>
 253                                         <column7> 0 </column7>
 254                                         <column8> 0 </column8>
 255                                         <column9> 0 </column9>
 256                                         <column10> 0 </column10>
 257                                         <column11> 0 </column11>
 258                                 </row1>
 259                                 <row2>
 260                                         <column1> 2 </column1>
 261                                         <column2> 1.175494351E-38 </column2>
 262                                         <column3> -3.402823466E+38 </column3>
 263                                         <column4> 1.175494351E-38 </column4>
 264                                         <column5> -1.797693134862315E+308 </column5>
 265                                         <column6> 1.175494351E-38 </column6>
 266                                         <column7> -1.797693134862315E+308 </column7>
 267                                         <column8> 1.175494351E-38 </column8>
 268                                         <column9> -1.797693134862315E+308 </column9>
 269                                         <column10> 99.999 </column10>
 270                                         <column11> -23.456 </column11>
 271                                 </row2>
 272                                 <row3>
 273                                         <column1> 3 </column1>
 274                                         <column2> 3.402823466E+38 </column2>
 275                                         <column3> -1.175494351E-38 </column3>
 276                                         <column4> 3.402823466E+38 </column4>
 277                                         <column5> -2.2250738585072014E-308 </column5>
 278                                         <column6> 3.402823466E+38 </column6>
 279                                         <column7> -2.2250738585072014E-308 </column7>
 280                                         <column8> 3.402823466E+38 </column8>
 281                                         <column9> -2.2250738585072014E-308 </column9>
 282                                         <column10> 778.123 </column10>
 283                                         <column11> -99.999 </column11>
 284                                 </row3>
 285                                 <row4>
 286                                         <column1> 4 </column1>
 287                                         <column2> 1.2345E+20</column2>
 288                                         <column3> 1.175494351E-38 </column3>
 289                                         <column4> 1.2345E+20 </column4>
 290                                         <column5> 2.2250738585072014E-308 </column5>
 291                                         <column6> 1.2345E+20 </column6>
 292                                         <column7> 2.2250738585072014E-308 </column7>
 293                                         <column8> 1.2345E+20 </column8>
 294                                         <column9> 2.2250738585072014E-308 </column9>
 295                                         <column10> 308.90 </column10>
 296                                         <column11> 12.345 </column11>
 297                                 </row4>
 298                                 <row5>
 299                                         <column1> 5 </column1>
 300                                         <column2> 3.452E-19</column2>
 301                                         <column3> 3.402823466E+38 </column3>
 302                                         <column4> 4.32E-15 </column4>
 303                                         <column5> 1.797693134862315E+308 </column5>
 304                                         <column6> 4.32E-15 </column6>
 305                                         <column7> 1.797693134862315E+308 </column7>
 306                                         <column8> 4.32E-15 </column8>
 307                                         <column9> 1.797693134862315E+308 </column9>
 308                                         <column10> 999.999 </column10>
 309                                         <column11> 999.999 </column11>
 310                                 </row5>
 311                                 <row6>
 312                                         <column1> 6 </column1>
 313                                         <column2> null </column2>
 314                                         <column3> null </column3>
 315                                         <column4> null </column4>
 316                                         <column5> null </column5>
 317                                         <column6> null </column6>
 318                                         <column7> null </column7>
 319                                         <column8> null </column8>
 320                                         <column9> null </column9>
 321                                         <column10> null </column10>
 322                                         <column11> null </column11>
 323                                 </row6>
 324                         </table2>
 325                         <table3>
 326                                 <tableName>dateTable</tableName>
 327                                 <numRows>9</numRows>
 328                                 <numCols>6</numCols>
 329                                 <row1>
 330                                         <column1> 1 </column1>
 331                                         <column2> '1000-01-01' </column2>
 332                                         <column3> '1000-01-01 00:00:00' </column3>
 333                                         <column4> '1970-01-02 00:00:00' </column4>
 334                                         <column5>  '-23:59:59' </column5>
 335                                         <column6> 2004 </column6>
 336                                 </row1>
 337                                 <row2>
 338                                         <column1> 2 </column1>
 339                                         <column2> '1999-12-17' </column2>
 340                                         <column3> '1999-12-17 08:00:00' </column3>
 341                                         <column4> '2000-01-01 04:40:00' </column4>
 342                                         <column5> '-23:45:56' </column5>
 343                                         <column6> 1999 </column6>
 344                                 </row2>
 345                                 <row3>
 346                                         <column1> 3 </column1>
 347                                         <column2> '9999-12-31' </column2>
 348                                         <column3> '9999-12-31 23:59:59' </column3>
 349                                         <column4> '2037-12-31 23:59:59' </column4>
 350                                         <column5> '23:59:59' </column5>
 351                                         <column6> 2155</column6>
 352                                 </row3>
 353                                 <row4>
 354                                         <column1> 4 </column1>
 355                                         <column2> '1999@12@31' </column2>
 356                                         <column3> '1999@12@31 11+30+45' </column3>
 357                                         <column4> '1999@12@31 11+30+45' </column4>
 358                                         <column5> '12:23:34' </column5>
 359                                         <column6> 1901</column6>
 360                                 </row4>
 361                                 <row5>
 362                                         <column1> 5 </column1>
 363                                         <column2> '9999.11.18' </column2>
 364                                         <column3> '9999.11.18 11*45*50' </column3>
 365                                         <column4> '2037.11.18 11*45*50' </column4>
 366                                         <column5> '23:34:34' </column5>
 367                                         <column6> 2069 </column6>
 368                                 </row5>
 369                                 <row6>
 370                                         <column1> 6 </column1>
 371                                         <column2> '9999/11/09' </column2>
 372                                         <column3> '9999/11/09 12:23:34' </column3>
 373                                         <column4> '2037/11/09 12:23:34' </column4>
 374                                         <column5> '09:08:07' </column5>
 375                                         <column6> 1970</column6>
 376                                 </row6>
 377                                 <row7>
 378                                         <column1> 7 </column1>
 379                                         <column2> 19980404 </column2>
 380                                         <column3> 19980404083050 </column3>
 381                                         <column4> 19980404083050 </column4>
 382                                         <column5> 083045 </column5>
 383                                         <column6> 0000</column6>
 384                                 </row7>
 385                                 <row8>
 386                                         <column1> 8 </column1>
 387                                         <column2> '0000-00-00' </column2>
 388                                         <column3> '0000-00-00 00:00:00' </column3>
 389                                         <column4> 00000000000000 </column4>
 390                                         <column5> '00:00:00'</column5>
 391                                         <column6> 00</column6>
 392                                 </row8>
 393                                 <row9>
 394                                         <column1> 9 </column1>
 395                                         <column2> null </column2>
 396                                         <column3> null </column3>
 397                                         <column4> null </column4>
 398                                         <column5> null </column5>
 399                                         <column6> null </column6>
 400                                 </row9>
 401                         </table3>
 402                 </values>
 403                 <queries>
 404                         <numQueries> 2 </numQueries>
 405                         <query1> Select COLUMNS from TABLE1 order by COLUMN1 </query1>
 406                         <query2> Select COLUMN1,COLUMN3,COLUMN5 from TABLE2 order by COLUMN1 </query2>
 407                         <query3> Select COLUMN2,COLUMN4 from TABLE3 order by COLUMN1 </query3>
 408                 </queries>
 409         </mysql>
 410         <mssql>
 411                 <database>
 412                         <name> mssql </name>
 413                         <connectionString> Server=__servername__;Database=__dbname__;User ID=sa;Password=__password__;</connectionString>
 414                         <OdbcConnString>DSN=MsSQL-DSN;uid=sa;pwd=fragile </OdbcConnString>
 415                 </database>
 416                 <StoredProcExists> N </StoredProcExists>
 417                 <tables>
 418                         <numTables> 5 </numTables>
 419                         <table1>
 420                                 <name>numericTable </name>
 421                                 <numColumns>6</numColumns>
 422                                 <column1>
 423                                         <name> sNo </name>
 424                                         <type> tinyint </type>
 425                                 </column1>
 426                                 <column2>
 427                                         <name> bigInteger </name>
 428                                         <type> bigint </type>
 429                                 </column2>
 430                                 <column3>
 431                                         <name> integer </name>
 432                                         <type>int</type>
 433                                 </column3>
 434                                 <column4>
 435                                         <name> smallInteger </name>
 436                                         <type> smallint </type>
 437                                 </column4>
 438                                 <column5>
 439                                         <name> tinyInt </name>
 440                                         <type> tinyint </type>
 441                                 </column5>
 442                                 <column6>
 443                                         <name> bit </name>
 444                                         <type> bit </type>
 445                                 </column6>
 446                         </table1>
 447                         <table2>
 448                                 <name>dateTimeTable </name>
 449                                 <numColumns>3</numColumns>
 450                                 <column1>
 451                                         <name> sNo </name>
 452                                         <type> tinyInt </type>
 453                                 </column1>
 454                                 <column2>
 455                                         <name> date</name>
 456                                         <type> datetime </type>
 457                                 </column2>
 458                                 <column3>
 459                                         <name> smalldate </name>
 460                                         <type> smalldatetime </type>
 461                                 </column3>
 462                         </table2>
 463                         <table3>
 464                                 <name>realNosTable </name>
 465                                 <numColumns>5</numColumns>
 466                                 <column1>
 467                                         <name> sNo </name>
 468                                         <type> tinyInt </type>
 469                                 </column1>
 470                                 <column2>
 471                                         <name> decimalCol </name>
 472                                         <type> decimal(8,4) </type>
 473                                 </column2>
 474                                 <column3>
 475                                         <name> numericCol </name>
 476                                         <type> numeric(6,4) </type>
 477                                 </column3>
 478                                 <column4>
 479                                         <name> floatCol </name>
 480                                         <type> float </type>
 481                                 </column4>
 482                                 <column5>
 483                                         <name> realCol </name>
 484                                         <type> real </type>
 485                                 </column5>
 486                         </table3>
 487                         <table4>
 488                                 <name>moneyTable </name>
 489                                 <numColumns>3</numColumns>
 490                                 <column1>
 491                                         <name> sNo </name>
 492                                         <type> tinyInt </type>
 493                                 </column1>
 494                                 <column2>
 495                                         <name> money </name>
 496                                         <type> money </type>
 497                                 </column2>
 498                                 <column3>
 499                                         <name> smallmoney </name>
 500                                         <type> smallmoney </type>
 501                                 </column3>
 502                         </table4>
 503                         <table5>
 504                                 <name>charTable </name>
 505                                 <numColumns>5</numColumns>
 506                                 <column1>
 507                                         <name> sNo </name>
 508                                         <type> tinyInt </type>
 509                                 </column1>
 510                                 <column2>
 511                                         <name> characterCol </name>
 512                                         <type> char(20) </type>
 513                                 </column2>
 514                                 <column3>
 515                                         <name> ncharacterCol </name>
 516                                         <type> nchar(20) </type>
 517                                 </column3>
 518                                 <column4>
 519                                         <name> varchar </name>
 520                                         <type> varchar(20) </type>
 521                                 </column4>
 522                                 <column5>
 523                                         <name> nvarchar </name>
 524                                         <type> nvarchar(20) </type>
 525                                 </column5>
 526                         </table5>
 527                 </tables>
 528                 <values>
 529                         <numTables>5</numTables>
 530                         <table1>
 531                                 <tableName>numericTable</tableName>
 532                                 <numRows>4</numRows>
 533                                 <numCols>6</numCols>
 534                                 <row1>
 535                                         <column1> 1 </column1>
 536                                         <column2> -9223372036854775808 </column2>
 537                                         <column3> -2147483648 </column3>
 538                                         <column4> -32768 </column4>
 539                                         <column5> 0</column5>
 540                                         <column6> 0</column6>
 541                                 </row1>
 542                                 <row2>
 543                                         <column1> 2 </column1>
 544                                         <column2> 1244 </column2>
 545                                         <column3> -50 </column3>
 546                                         <column4> 234 </column4>
 547                                         <column5> 128 </column5>
 548                                         <column6> 0</column6>
 549                                 </row2>
 550                                 <row3>
 551                                         <column1> 3 </column1>
 552                                         <column2> 9223372036854775807 </column2>
 553                                         <column3> 2147483647 </column3>
 554                                         <column4>  32767 </column4>
 555                                         <column5> 255 </column5>
 556                                         <column6> 1</column6>
 557                                 </row3>
 558                                 <row4>
 559                                         <column1> 4 </column1>
 560                                         <column2> null </column2>
 561                                         <column3> null </column3>
 562                                         <column4> null </column4>
 563                                         <column5> null </column5>
 564                                         <column6> null </column6>
 565                                 </row4>
 566                         </table1>
 567                         <table2>
 568                                 <tableName> dateTimeTable</tableName>
 569                                 <numRows>3</numRows>
 570                                 <numCols>3</numCols>
 571                                 <row1>
 572                                         <column1> 1 </column1>
 573                                         <column2> '1/1/1753 03:04:05.234' </column2>
 574                                         <column3> '1/1/1970 12:24'</column3>
 575                                 </row1>
 576                                 <row2>
 577                                         <column1> 2 </column1>
 578                                         <column2> '12/31/9999 00:00:00' </column2>
 579                                         <column3> '6/6/2079 00:00'</column3>
 580                                 </row2>
 581                                 <row3>
 582                                         <column1> 3 </column1>
 583                                         <column2> null </column2>
 584                                         <column3> null </column3>
 585                                 </row3>
 586                         </table2>
 587                         <table3>
 588                                 <tableName> realNosTable</tableName>
 589                                 <numRows>6</numRows>
 590                                 <numCols>5</numCols>
 591                                 <row1>
 592                                         <column1> 1 </column1>
 593                                         <column2> -9.99E+3</column2>
 594                                         <column3> -99 </column3>
 595                                         <column4> -1.7976931348623157E+308 </column4>
 596                                         <column5> -3.402823466E+38 </column5>
 597                                 </row1>
 598                                 <row2>
 599                                         <column1> 2 </column1>
 600                                         <column2> -1.23E3 </column2>
 601                                         <column3> -12 </column3>
 602                                         <column4> -2.2250738585072014E-308 </column4>
 603                                         <column5> -3.4E-38 </column5>
 604                                 </row2>
 605                                 <row3>
 606                                         <column1> 3 </column1>
 607                                         <column2> 0 </column2>
 608                                         <column3> 0 </column3>
 609                                         <column4> 0 </column4>
 610                                         <column5> 0 </column5>
 611                                 </row3>
 612                                 <row4>
 613                                         <column1> 4 </column1>
 614                                         <column2> 1.2E1 </column2>
 615                                         <column3> 12 </column3>
 616                                         <column4> 2.2250738585072014E-308 </column4>
 617                                         <column5> 4.56E-3 </column5>
 618                                 </row4>
 619                                 <row5>
 620                                         <column1> 5 </column1>
 621                                         <column2> 9.999E3 </column2>
 622                                         <column3> 99 </column3>
 623                                         <column4> 1.7976931348623157E+308 </column4>
 624                                         <column5> 3.4E+38 </column5>
 625                                 </row5>
 626                                 <row6>
 627                                         <column1> 6 </column1>
 628                                         <column2> null </column2>
 629                                         <column3> null </column3>
 630                                         <column4> null </column4>
 631                                         <column5> null </column5>
 632                                 </row6>
 633                         </table3>
 634                         <table4>
 635                                 <tableName> moneyTable</tableName>
 636                                 <numRows>4</numRows>
 637                                 <numCols>3</numCols>
 638                                 <row1>
 639                                         <column1> 1 </column1>
 640                                         <column2> -922337203685477.5808 </column2>
 641                                         <column3> -214748.3648 </column3>
 642                                 </row1>
 643                                 <row2>
 644                                         <column1> 2 </column1>
 645                                         <column2> 5477.5808 </column2>
 646                                         <column3> 748.3648 </column3>
 647                                 </row2>
 648                                 <row3>
 649                                         <column1> 3 </column1>
 650                                         <column2> 922337203685477.5807 </column2>
 651                                         <column3> 214748.3647 </column3>
 652                                 </row3>
 653                                 <row4>
 654                                         <column1> 4 </column1>
 655                                         <column2> null </column2>
 656                                         <column3> null </column3>
 657                                 </row4>
 658                         </table4>
 659                         <table5>
 660                                 <tableName> charTable</tableName>
 661                                 <numRows>2</numRows>
 662                                 <numCols>5</numCols>
 663                                 <row1>
 664                                         <column1> 1 </column1>
 665                                         <column2> '12345678901234567890' </column2>
 666                                         <column3> 'abcdefghijklmnopqrst' </column3>
 667                                         <column4> 'zyxwvutsrqponmlkjihg' </column4>
 668                                         <column5> '12345678901234567890' </column5>
 669                                 </row1>
 670                                 <row2>
 671                                         <column1> 2 </column1>
 672                                         <column2> null </column2>
 673                                         <column3> null </column3>
 674                                         <column4> null </column4>
 675                                         <column5> null </column5>
 676                                 </row2>
 677                         </table5>
 678
 679                 </values>
 680                 <StoredProc>
 681                         <NumStoredProc> 1 </NumStoredProc>
 682                         <StoredProc1>
 683                                 <type> generic </type>
 684                                 <name> Select_{{TABLE}}_proc </name>
 685                                 <template>
 686                                         <numStmts> 1 </numStmts>
 687                                         <stmt1><![CDATA[
 688                                         create procedure Select_{{TABLE}}_proc As
 689                                         BEGIN
 690                                                 Select {{COLUMNS}} from {{TABLE}};
 691                                         END]]>
 692                                         </stmt1>
 693                                 </template>
 694                         </StoredProc1>
 695                 </StoredProc>
 696                 <queries>
 697                         <numQueries> 5 </numQueries>
 698                         <query1> Select COLUMNS from TABLE1 order by COLUMN1 </query1>
 699                         <query2> Select COLUMN1,COLUMN2,COLUMN3 from TABLE2 order by COLUMN1 </query2>
 700                         <query3> Select COLUMN2,COLUMN4 from TABLE3 order by COLUMN1 </query3>
 701                         <query4> Select COLUMNS from TABLE4 order by COLUMN1 </query4>
 702                         <query5> Select COLUMNS from TABLE5 order by COLUMN1 </query5>
 703                 </queries>
 704         </mssql>
 705
 706         <postgres>
 707                 <database>
 708                         <name> postgres </name>
 709                         <connectionString> Server=164.99.168.144;Database=test;User Id=sudha;Password= </connectionString>
 710                         <OdbcConnString>DSN=postgres-DSN;uid=sudha;pwd= </OdbcConnString>
 711                 </database>
 712                 <tables>
 713                         <numTables> 5 </numTables>
 714                         <table1>
 715                                 <name>numericTable </name>
 716                                 <numColumns> 4 </numColumns>
 717                                 <column1>
 718                                         <name> serialNo </name>
 719                                         <type> smallint </type>
 720                                 </column1>
 721                                 <column2>
 722                                         <name> small_int </name>
 723                                         <type> smallint </type>
 724                                 </column2>
 725                                 <column3>
 726                                         <name> int </name>
 727                                         <type> integer </type>
 728                                 </column3>
 729                                 <column4>
 730                                         <name> bigInteger </name>
 731                                         <type> bigint </type>
 732                                 </column4>
 733
 734                         </table1>
 735                         <table2>
 736                                 <name>realNoTable </name>
 737                                 <numColumns> 5 </numColumns>
 738                                 <column1>
 739                                         <name> serialNo </name>
 740                                         <type> smallint </type>
 741                                 </column1>
 742                                 <column2>
 743                                         <name> numeric_column </name>
 744                                         <type> numeric(10,6) </type>
 745                                 </column2>
 746                                 <column3>
 747                                         <name> numeric_noscale </name>
 748                                         <type> decimal(10) </type>
 749                                 </column3>
 750                                 <column4>
 751                                         <name> realNo </name>
 752                                         <type> real </type>
 753                                 </column4>
 754                                 <column5>
 755                                         <name> doubleNo  </name>
 756                                         <type> double precision </type>
 757                                 </column5>
 758                         </table2>
 759                         <table3>
 760                                 <name> charTable </name>
 761                                 <numColumns> 4 </numColumns>
 762                                 <column1>
 763                                         <name> serialNo </name>
 764                                         <type> smallint </type>
 765                                 </column1>
 766                                 <column2>
 767                                         <name> charColumn </name>
 768                                         <type> char(20) </type>
 769                                 </column2>
 770                                 <column3>
 771                                         <name> varcharColumn </name>
 772                                         <type> varchar(20) </type>
 773                                 </column3>
 774                                 <column4>
 775                                         <name> textColumn </name>
 776                                         <type> text </type>
 777                                 </column4>
 778                         </table3>
 779                         <table4>
 780                                 <name> dateTimeTable </name>
 781                                 <numColumns> 5 </numColumns>
 782                                 <column1>
 783                                         <name> serialNo </name>
 784                                         <type> smallint </type>
 785                                 </column1>
 786                                 <column2>
 787                                         <name> timestampCol </name>
 788                                         <type> timestamp </type>
 789                                 </column2>
 790                                 <column3>
 791                                         <name> intervalCol </name>
 792                                         <type> interval </type>
 793                                 </column3>
 794                                 <column4>
 795                                         <name> dateCol </name>
 796                                         <type> date </type>
 797                                 </column4>
 798                                 <column5>
 799                                         <name> timeCol </name>
 800                                         <type> time </type>
 801                                 </column5>
 802                         </table4>
 803                         <table5>
 804                                 <name> booleanTable </name>
 805                                 <numColumns> 2 </numColumns>
 806                                 <column1>
 807                                         <name> serialNo </name>
 808                                         <type> smallint </type>
 809                                 </column1>
 810                                 <column2>
 811                                         <name> bool </name>
 812                                         <type> boolean </type>
 813                                 </column2>
 814                         </table5>
 815                 </tables>
 816                 <values>
 817                         <numTables>5</numTables>
 818                         <table1>
 819                                 <tableName>numericTable</tableName>
 820                                 <numRows>4</numRows>
 821                                 <numCols>4</numCols>
 822                                 <row1>
 823                                         <column1> 1 </column1>
 824                                         <column2> -32768 </column2>
 825                                         <column3> -2147483648 </column3>
 826                                         <column4> -9223372036854775808 </column4>
 827                                 </row1>
 828                                 <row2>
 829                                         <column1> 2 </column1>
 830                                         <column2> 123 </column2>
 831                                         <column3> -648 </column3>
 832                                         <column4> 0 </column4>
 833                                 </row2>
 834                                 <row3>
 835                                         <column1> 3 </column1>
 836                                         <column2> 32767 </column2>
 837                                         <column3> 2147483647 </column3>
 838                                         <column4> 9223372036854775807 </column4>
 839                                 </row3>
 840                                 <row4>
 841                                         <column1> 4 </column1>
 842                                         <column2> null </column2>
 843                                         <column3> null </column3>
 844                                         <column4> null </column4>
 845                                 </row4>
 846                         </table1>
 847                         <table2>
 848                                 <tableName>realNoTable</tableName>
 849                                 <numRows>6</numRows>
 850                                 <numCols>5</numCols>
 851                                 <row1>
 852                                         <column1> 1 </column1>
 853                                         <column2> -9999.999999 </column2>
 854                                         <column3> -9999999999 </column3>
 855                                         <column4> -9.99999E-38 </column4>
 856                                         <column5> -9.999999999999999E-308 </column5>
 857                                 </row1>
 858                                 <row2>
 859                                         <column1> 2 </column1>
 860                                         <column2> -123.99 </column2>
 861                                         <column3> -1239 </column3>
 862                                         <column4> 9.99999E-38 </column4>
 863                                         <column5> 9.999999999999999E-308 </column5>
 864                                 </row2>
 865                                 <row3>
 866                                         <column1> 3 </column1>
 867                                         <column2> 0 </column2>
 868                                         <column3> 0 </column3>
 869                                         <column4> 0 </column4>
 870                                         <column5> 0 </column5>
 871                                 </row3>
 872                                 <row4>
 873                                         <column1> 4 </column1>
 874                                         <column2> 123.99 </column2>
 875                                         <column3> 123 </column3>
 876                                         <column4> -9.99999E37 </column4>
 877                                         <column5> -1.79769313486231E308 </column5>
 878                                 </row4>
 879                                 <row5>
 880                                         <column1> 5 </column1>
 881                                         <column2> 9999.999999 </column2>
 882                                         <column3> 9999999999 </column3>
 883                                         <column4> 9.99999E37 </column4>
 884                                         <column5> 1.79769313486231E308 </column5>
 885                                 </row5>
 886                                 <row6>
 887                                         <column1> 6 </column1>
 888                                         <column2> null </column2>
 889                                         <column3> null </column3>
 890                                         <column4> null </column4>
 891                                         <column5> null </column5>
 892                                 </row6>
 893                         </table2>
 894                         <table3>
 895                                 <tableName>charTable</tableName>
 896                                 <numRows>2</numRows>
 897                                 <numCols>4</numCols>
 898                                 <row1>
 899                                         <column1> 1 </column1>
 900                                         <column2> 'abcdefghijklmnopqrst' </column2>
 901                                         <column3> '1234567890' </column3>
 902                                         <column4> 'This is a fixed length text' </column4>
 903                                 </row1>
 904                                 <row2>
 905                                         <column1> 2 </column1>
 906                                         <column2> null </column2>
 907                                         <column3> null </column3>
 908                                         <column4> null </column4>
 909                                 </row2>
 910                         </table3>
 911                         <table4>
 912                                 <tableName>datetimeTable</tableName>
 913                                 <numRows>4</numRows>
 914                                 <numCols>5</numCols>
 915                                 <row1>
 916                                         <column1> 1 </column1>
 917                                         <column2> '0001-01-01 00:00:00.000000' </column2>
 918                                         <column3> '-178000000 years +4 days'  </column3>
 919                                         <column4> '0001-01-01' </column4>
 920                                         <column5> '12:23:34' </column5>
 921                                 </row1>
 922                                 <row2>
 923                                         <column1> 2 </column1>
 924                                         <column2> '2004-10-21 11:15:23' </column2>
 925                                         <column3> '7890 years 5 days 07:30' </column3>
 926                                         <column4> '2004-01-12' </column4>
 927                                         <column5> '00:00:00' </column5>
 928                                 </row2>
 929                                 <row3>
 930                                         <column1> 3 </column1>
 931                                         <column2> '9999-12-31 23:59:59.9999' </column2>
 932                                         <column3> '178000000 years 00:19:23'  </column3>
 933                                         <column4> '9999-12-31' </column4>
 934                                         <column5> '23:59:59' </column5>
 935                                 </row3>
 936                                 <row4>
 937                                         <column1> 4 </column1>
 938                                         <column2> null </column2>
 939                                         <column3> null </column3>
 940                                         <column4> null </column4>
 941                                         <column5> null </column5>
 942                                 </row4>
 943                         </table4>
 944                         <table5>
 945                                 <tableName>booleanTable</tableName>
 946                                 <numRows>3</numRows>
 947                                 <numCols>2</numCols>
 948                                 <row1>
 949                                         <column1> 1 </column1>
 950                                         <column2> TRUE </column2>
 951                                 </row1>
 952                                 <row2>
 953                                         <column1> 2 </column1>
 954                                         <column2> FALSE </column2>
 955                                 </row2>
 956                                 <row3>
 957                                         <column1> 3 </column1>
 958                                         <column2> null </column2>
 959                                 </row3>
 960                         </table5>
 961                 </values>
 962                 <queries>
 963                         <numQueries> 5 </numQueries>
 964                         <query1> Select COLUMNS from TABLE1 order by COLUMN1 </query1>
 965                         <query2> Select COLUMN1,COLUMN2,COLUMN3 from TABLE2 order by COLUMN1 </query2>
 966                         <query3> Select COLUMN2,COLUMN4 from TABLE3 order by COLUMN1 </query3>
 967                         <query4> Select COLUMNS from TABLE4 order by COLUMN1 </query4>
 968                         <query5> Select COLUMNS from TABLE5 order by COLUMN1 </query5>
 969                 </queries>
 970         </postgres>
 971         <oracle>
 972                 <database>
 973                         <name> oracle </name>
 974                         <connectionString> Data Source=testdb.com;User Id=user9i;Password=oracle9i </connectionString>
 975                         <OdbcConnString>DSN=Oracle-DSN;uid=user9i;pwd=oracle9i </OdbcConnString>
 976                 </database>
 977                 <StoredProcExists> N </StoredProcExists>
 978                 <tables>
 979                         <numTables> 4 </numTables>
 980                         <table1>
 981                                 <name>numericTable </name>
 982                                 <numColumns> 3 </numColumns>
 983                                 <column1>
 984                                         <name> serialNo </name>
 985                                         <type> number(1)</type>
 986                                 </column1>
 987                                 <column2>
 988                                         <name> intCol </name>
 989                                         <type> number(6)</type>
 990                                 </column2>
 991                                 <column3>
 992                                         <name> decimalCol </name>
 993                                         <type> number(6, 3)</type>
 994                                 </column3>
 995                         </table1>
 996                         <table2>
 997                                 <name> charTable </name>
 998                                 <numColumns> 5 </numColumns>
 999                                 <column1>
1000                                         <name> serialNo </name>
1001                                         <type> number(1)</type>
1002                                 </column1>
1003                                 <column2>
1004                                         <name> charCol </name>
1005                                         <type> char(10) </type>
1006                                 </column2>
1007                                 <column3>
1008                                         <name> ncharCol </name>
1009                                         <type> nchar(10) </type>
1010                                 </column3>
1011                                 <column4>
1012                                         <name> varcharCol </name>
1013                                         <type> varchar2(10) </type>
1014                                 </column4>
1015                                 <column5>
1016                                         <name> nvarcharCol </name>
1017                                         <type> nvarchar2(10) </type>
1018                                 </column5>
1019                         </table2>
1020                         <table3>
1021                                 <name> RealNoTable </name>
1022                                 <numColumns> 2 </numColumns>
1023                                 <column1>
1024                                         <name> serialNo </name>
1025                                         <type> number(1)</type>
1026                                 </column1>
1027                                 <column2>
1028                                         <name> floatCol </name>
1029                                         <type> float(24) </type>
1030                                 </column2>
1031                         </table3>
1032                         <table4>
1033                                 <name> DateTimeTable </name>
1034                                 <numColumns> 5 </numColumns>
1035                                 <column1>
1036                                         <name> serialNo </name>
1037                                         <type> number(1)</type>
1038                                 </column1>
1039                                 <column2>
1040                                         <name> dateCol </name>
1041                                         <type> date </type>
1042                                 </column2>
1043                                 <column3>
1044                                         <name> timestampCol </name>
1045                                         <type> timestamp </type>
1046                                 </column3>
1047                                 <column4>
1048                                         <name> Int_year </name>
1049                                         <type> interval Year to month</type>
1050                                 </column4>
1051                                 <column5>
1052                                         <name> int_day </name>
1053                                         <type> interval day to second </type>
1054                                 </column5>
1055                         </table4>
1056
1057                 </tables>
1058                 <values>
1059                         <numTables>4</numTables>
1060                         <table1>
1061                                 <tableName>numericTable</tableName>
1062                                 <numRows>4</numRows>
1063                                 <numCols>3</numCols>
1064                                 <row1>
1065                                         <column1> 1 </column1>
1066                                         <column2> -999999 </column2>
1067                                         <column3> -999.999 </column3>
1068                                 </row1>
1069                                 <row2>
1070                                         <column1> 2 </column1>
1071                                         <column2> 1000 </column2>
1072                                         <column3> 234 </column3>
1073                                 </row2>
1074                                 <row3>
1075                                         <column1> 3 </column1>
1076                                         <column2> 999999 </column2>
1077                                         <column3> 999.999 </column3>
1078                                 </row3>
1079                                 <row4>
1080                                         <column1> 4 </column1>
1081                                         <column2> null </column2>
1082                                         <column3> null </column3>
1083                                 </row4>
1084                         </table1>
1085                         <table2>
1086                                 <tableName>charTable</tableName>
1087                                 <numRows>2</numRows>
1088                                 <numCols>5</numCols>
1089                                 <row1>
1090                                         <column1> 1 </column1>
1091                                         <column2> '0123456789' </column2>
1092                                         <column3> 'abcdefghij' </column3>
1093                                         <column4> '0123456789' </column4>
1094                                         <column5> 'abcdefghij' </column5>
1095                                 </row1>
1096                                 <row2>
1097                                         <column1> 2 </column1>
1098                                         <column2> null </column2>
1099                                         <column3> null </column3>
1100                                         <column4> null </column4>
1101                                         <column5> null </column5>
1102                                 </row2>
1103                         </table2>
1104                         <table3>
1105                                 <tableName>RealNoTable</tableName>
1106                                 <numRows>6</numRows>
1107                                 <numCols>2</numCols>
1108                                 <row1>
1109                                         <column1> 1 </column1>
1110                                         <column2> 9.9999999E125  </column2>
1111                                 </row1>
1112                                 <row2>
1113                                         <column1> 2 </column1>
1114                                         <column2> -9.999999E-126 </column2>
1115                                 </row2>
1116                                 <row3>
1117                                         <column1> 3 </column1>
1118                                         <column2> 1.23E-15 </column2>
1119                                 </row3>
1120                                 <row4>
1121                                         <column1> 4 </column1>
1122                                         <column2> -9.999999E-126 </column2>
1123                                 </row4>
1124                                 <row5>
1125                                         <column1> 5 </column1>
1126                                         <column2> 9.9999999E125 </column2>
1127                                 </row5>
1128                                 <row6>
1129                                         <column1> 6 </column1>
1130                                         <column2> null </column2>
1131                                 </row6>
1132                         </table3>
1133                         <table4>
1134                                 <tableName>DateTimeTable</tableName>
1135                                 <numRows>3</numRows>
1136                                 <numCols>5</numCols>
1137                                 <row1>
1138                                         <column1> 1 </column1>
1139                                         <column2> to_date('0001-01-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss') </column2>
1140                                         <column3> TIMESTAMP'0001-01-01 00:00:00' </column3>
1141                                         <column4>  '-99-11' </column4>
1142                                         <column5>  '-99 23:59:59' </column5>
1143                                 </row1>
1144                                 <row2>
1145                                         <column1> 2 </column1>
1146                                         <column2> to_date('2004-11-23 12:34:45', 'yyyy-mm-dd hh24:mi:ss') </column2>
1147                                         <column3> TIMESTAMP'2004-11-23 12:34:45' </column3>
1148                                         <column4>  '34-5' </column4>
1149                                         <column5>  '-34 20:50:00' </column5>
1150                                 </row2>
1151                                 <row3>
1152                                         <column1> 3 </column1>
1153                                         <column2> to_date('9999-12-31 23:59:59', 'yyyy-mm-dd hh24:mi:ss') </column2>
1154                                         <column3> TIMESTAMP'9999-12-31 23:59:59' </column3>
1155                                         <column4>  '99-11' </column4>
1156                                         <column5>  '00 23:59:59' </column5>
1157                                 </row3>
1158                         </table4>
1159                 </values>
1160                 <StoredProc>
1161                         <NumStoredProc> 1 </NumStoredProc>
1162                         <StoredProc1>
1163                                 <type> generic </type>
1164                                 <name> {{TABLE}}_pkg.Select_{{TABLE}}_data</name>
1165                                 <template>
1166                                         <numStmts> 2 </numStmts>
1167                                         <stmt1><![CDATA[
1168                                         create or replace package {{TABLE}}_pkg As
1169                                                 type {{TABLE}}Cur is ref cursor return  {{TABLE}}%rowtype;
1170                                                 procedure Select{{TABLE}}Data (ref_cur out {{TABLE}}Cur);
1171                                         END {{TABLE}}_pkg;]]>
1172                                         </stmt1>
1173                                         <stmt2><![CDATA[
1174                                         create or replace package body {{TABLE}}_pkg As
1175                                                 procedure Select{{TABLE}}Data ( ref_cur out {{TABLE}}Cur) is
1176                                                 BEGIN
1177                                                         open ref_cur for select {{COLUMNS}} from {{TABLE}} order by {{COLUMN_1}};
1178                                                 End Select{{TABLE}}Data;
1179                                         END {{TABLE}}_pkg;]]></stmt2>
1180                                 </template>
1181                         </StoredProc1>
1182                 </StoredProc>
1183                 <queries>
1184                         <numQueries> 4 </numQueries>
1185                         <query1> Select COLUMNS from TABLE1 order by COLUMN1 </query1>
1186                         <query2> Select COLUMN1,COLUMN2,COLUMN3 from TABLE2 order by COLUMN1 </query2>
1187                         <query3> Select COLUMNS from TABLE3 order by COLUMN1 </query3>
1188                         <query4> Select COLUMNS from TABLE4 order by COLUMN1 </query4>
1189                 </queries>
1190         </oracle>
1191 </configuration>