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

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