-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 3 posts ] 
Author Message
 Post subject: problem with DB2 400 Dialect
PostPosted: Wed Jun 28, 2006 5:55 pm 
Newbie

Joined: Wed Jun 21, 2006 2:59 pm
Posts: 3
Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp



I am haveing trouble with Identity generator it showing me this error.

could not insert: [SQL5016] Qualified object name SYSDUMMY1 not valid

With lots of pain I figured out that it was generated by this Dialect class.
as like this.
select identity_val_local() from sysibm.sysdummy1

And then it gives this error.

this is comeing from this Class.

DB2400Dialect.

written by
* @author Peter DeGregorio (pdegregorio)



Can I get answere for my problem.

this is furstating me a lot.


Top
 Profile  
 
 Post subject: "sysibm." not allowed for library lists
PostPosted: Thu Apr 26, 2007 5:25 pm 
Newbie

Joined: Wed Apr 25, 2007 5:14 pm
Posts: 5
If you are using naming=system (a.k.a. library list), then "sysibm." should not be supplied by DB2400Dialect:
http://forum.hibernate.org/viewtopic.php?t=973837

You can make a subclass of DB2400Dialect and override:
Code:
import org.hibernate.dialect.DB2Dialect;

public class NonLibListDB2Dialect extends DB2Dialect {

public String getIdentitySelectString() {
return "select identity_val_local() from sysdummy1";
}


Top
 Profile  
 
 Post subject: Re: "sysibm." not allowed for library lists
PostPosted: Fri Apr 27, 2007 3:11 pm 
Newbie

Joined: Wed Jun 21, 2006 2:59 pm
Posts: 3
jeff43017 wrote:
If you are using naming=system (a.k.a. library list), then "sysibm." should not be supplied by DB2400Dialect:
http://forum.hibernate.org/viewtopic.php?t=973837

You can make a subclass of DB2400Dialect and override:
Code:
import org.hibernate.dialect.DB2Dialect;

public class NonLibListDB2Dialect extends DB2Dialect {

public String getIdentitySelectString() {
return "select identity_val_local() from sysdummy1";
}



Jeff

I had posted this close to an Year back i had resoved this then itself by makeing custom modification to DB2400Dialect class I was on the clock did the job thanks for the reply though

Now i believe in the forum even though it was late.

Ravi


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 3 posts ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.