mcs/class/System.Data/Test/DataProviderTests/setup/SetupDb.exe.config

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