Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2013

    Unanswered: Problem java with DB2

    Hi all,

    I connected the java with DB2 Successfully.I am using java with DB2 Database and JPA(Hibernate).
    I got the following Errors,When i reterive the data from database via application.

    1. Caused by: org.hibernate.exception.GenericJDBCException: could not load an entity: [sampleImpl#6855]
    2. Caused by: DB2 SQL Error: SQLCODE=-1585, SQLSTATE=54048, SQLERRMC=null, DRIVER=3.64.82

    I am using the following driver and Dialect

    In persistence.xml i have a entry for sampleImpl

    I Searched in google for SQLCODE=-1585 and SQLSTATE=54048,The Error code says like "A system temporary table space with sufficient page size does not exist." but we have enough space .Then wat is the issue?

    Could any one Help me ....

    Chandarasekaran Myilsamy

  2. #2
    Join Date
    Jan 2003
    Provided Answers: 5
    The error: "A system temporary table space with sufficient page size does not exist.", is not about space.

    You need to make sure you have defined a SYSTEM TEMPORARY TABLESPACE of 32K pagesize. We usually create one of each pagesize (4k, 8k, 16k, and 32k).


  3. #3
    Join Date
    Apr 2013
    Thank you ARWinner. We are working over on your solution

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts