Home
Help
Register
Log in

Search

 
   Active Threads  

You are here: Home > LLBLGen Pro > Bugs & Issues> Sequence call is not using db2SchemaNameOverwrites
 

Pages: 1
Bugs & Issues
Sequence call is not using db2SchemaNameOverwrites
Page:1/1 

  Print all messages in this thread  
Poster Message
jovball
User



Location:
USA
Joined on:
23-Jan-2005 19:53:47
Posted:
393 posts
# Posted on: 12-Oct-2017 15:51:53.  
This is for 5.2 (5.2.1) RTM.

We are attempting to use a sequence in DB2. This is our first time using that with DB2 and LLBLGen. (We have used it previously with SQL Server and LLBLGen).

The call works correctly in our development environment which has the base schema name used for LLBLGen code generation. However, in other environments where the schema name is different, the db2SchemaNameOverwrites is not working.

IOW, the call looks like this
Code:

SELECT NEXTVAL FOR DEVDB.MY_SEQ1 FROM SYSIBM.SYSDUMMY1


But it should look like this
Code:

SELECT NEXTVAL FOR PRODDB.MY_SEQ1 FROM SYSIBM.SYSDUMMY1





Joel Reinford
LLBLGenPro Version: 5.5.3
Templates: Adapter
Framework: .Net 4.6
Database: SQL Server 2012/2014, DB2 v10
 
Top
Walaa
Support Team



Location:

Joined on:
21-Aug-2005 16:03:48
Posted:
14520 posts
# Posted on: 12-Oct-2017 18:40:43.  
Please post the db2SchemaNameOverwrites config section.

Do you have it in the config file of the application (executable project)?


  Top
jovball
User



Location:
USA
Joined on:
23-Jan-2005 19:53:47
Posted:
393 posts
# Posted on: 12-Oct-2017 21:42:44.  
I don't think that's the issue. All other queries are correctly overwriting the schema name. It's only the sequence call that is failing.

Here's what the config sections look like. I've replaced the actual values with fake values.

Code:

<configSections>
    <section name="db2SchemaNameOverwrites" type="System.Configuration.NameValueSectionHandler" />
</configSections>
    <db2SchemaNameOverwrites>
        <add key="DEVDB" value="PRODDB" />
    </db2SchemaNameOverwrites>

Joel Reinford
LLBLGenPro Version: 5.5.3
Templates: Adapter
Framework: .Net 4.6
Database: SQL Server 2012/2014, DB2 v10
 
Top
Otis
LLBLGen Pro Team



Location:
The Hague, The Netherlands
Joined on:
17-Aug-2003 18:00:36
Posted:
37605 posts
# Posted on: 13-Oct-2017 10:06:40.  
Bug. Will fix.

Frans Bouma
LLBLGen Pro / ORM Profiler Lead Developer | Blog | Twitter
 
Top
Otis
LLBLGen Pro Team



Location:
The Hague, The Netherlands
Joined on:
17-Aug-2003 18:00:36
Posted:
37605 posts
# Posted on: 13-Oct-2017 10:40:29.  
Fixed in hotfix 5.2.4 / 5.1.7 (now available on the website)
Frans Bouma
LLBLGen Pro / ORM Profiler Lead Developer | Blog | Twitter
 
Top
jovball
User



Location:
USA
Joined on:
23-Jan-2005 19:53:47
Posted:
393 posts
# Posted on: 13-Oct-2017 16:29:11.  
Yes, that fixed the problem. Regular Smiley

Thanks for the quick response.


Joel Reinford
LLBLGenPro Version: 5.5.3
Templates: Adapter
Framework: .Net 4.6
Database: SQL Server 2012/2014, DB2 v10
 
Top
Pages: 1  


Powered by HnD ©2002-2007 Solutions Design
HnD uses LLBLGen Pro

Version: 2.1.12172008 Final.