Raible's Wiki: AppFuseOnDB2

-       Raible's Wiki




    Raible Designs

Wiki Home

News

Recent Changes

AppFuse
Homepage

  -  Korean

  -  Chinese

  -  Italian

  -  Japanese

QuickStart Guide

  - Chinese
 
  - French

  - German

  - Italian

  - Korean

  - Portuguese

  - Spanish

  - Japanese


User Guide

  - Korean

  - Chinese
 

Tutorials

  -  Chinese

  -  German

  -  Italian

  -  Korean

  -  Portuguese

  -  Spanish


FAQ

  -  Korean


Latest Downloads

Other Applications
Struts Resume

Security Example

Struts Menu



    




    

    
         
        Set your name in

        UserPreferences
            
    





       
       
       
       




    

Referenced by

AppFuseOnPostgreSQL
AppFuseSupport
Articles
Articles_cn
Articles_de
Articles_pt
Articles_zh
CreateDAO
CreateDAO_de
CreateDAO_es
...and 4 more



    




   



   
   JSPWiki v2.2.33 
   



       
           

           

           
           
           


           Hide Menu
+            AppFuseOnDB2
            



  
    Search Wiki:
    
    
  



         
         
            Your trail: 
         
      

      


      

      
         



      
          Difference between 
          version 3 
          and 
          version 2:
          

          
At line 158 added 1 line.
__"Text" field type in MySQL:__\\
At line 167 added 1 line.
__Default table space not big enough:__\\
At line 176 added 12 lines.

__Conflicts between inserted Ids and existing Ids:__\\
I populate the database with sample data (using DBUnit) before running any of my tests.  When adding new records, I kept getting errors about conflicting keys.  Changing the generator-class from "__native__" to "__increment__" solved the problem.  I don't know if this is the best solution, I'm just trying to get ''one'' solution working at this point.

__Temporary Table Space not big enough:__\\
One of my DAOs keeps failing with the following error:
{{{
    [junit] COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL1585N  A system temporary ta
ble space with sufficient page size does not exist.  SQLSTATE=54048
}}}
Creating a Temporary Table Space that uses the Buffer Pool with page size = 8 fixed this problem.
:;''I'm sure if I had a proper database creation script, with proper table spaces sizes (page size = 8), this would be much easier.''


          

      

      

      
      Back to AppFuseOnDB2,
       or to the Page History.
       

      

      

      

      

      

      

      

      Show Menu
-AppFuseOnDB2
+    Search Wiki:
 At line 158 added 1 line.
+__"Text" field type in MySQL:__\\
 At line 167 added 1 line.
+__Default table space not big enough:__\\
 At line 176 added 12 lines.
+__Conflicts between inserted Ids and existing Ids:__\\
+I populate the database with sample data (using DBUnit) before running any of my tests.  When adding new records, I kept getting errors about conflicting keys.  Changing the generator-class from "__native__" to "__increment__" solved the problem.  I don't know if this is the best solution, I'm just trying to get ''one'' solution working at this point.
+__Temporary Table Space not big enough:__\\
+One of my DAOs keeps failing with the following error:
+{{{
+    [junit] COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL1585N  A system temporary ta
+ble space with sufficient page size does not exist.  SQLSTATE=54048
+}}}
+Creating a Temporary Table Space that uses the Buffer Pool with page size = 8 fixed this problem.
+:;''I'm sure if I had a proper database creation script, with proper table spaces sizes (page size = 8), this would be much easier.''