Slice Error with simple query ( Websphere 7.0 & DB2 9.1 )

[jaidge]

I used Websphere 7.0 ( openjpa 1.2.1 snapshot ) and DB2 UBD 9.1

I want to configure slice describe as follow ( persistence.xml )

 <persistence-unit name="persistenceUnit">
   
    <provider>org.apache.openjpa.persistence.PersistenceProviderImpl</provider>
   
                <class>com.ibm.openjpa.slice.test.db1.Userdb1</class>
                <class>com.ibm.openjpa.slice.test.db2.Customerdb2</class>
                       
        <properties>

                        <property name="openjpa.BrokerFactory" value="slice" />
                        <property name="openjpa.slice.Names"   value="ONE,TWO"/>
                        <property name="openjpa.slice.Master"  value="ONE"/>
                        <property name="openjpa.slice.Lenient" value="true"/>
                       
                        <property name="openjpa.ConnectionDriverName" 
value="com.ibm.db2.jcc.DB2Driver" />
                        <property name="openjpa.ConnectionURL" 
value="jdbc:db2://localhost:52000/DB1"/>
                        <property name="openjpa.ConnectionUserName" 
value="db2admin"/>
                        <property name="openjpa.ConnectionPassword" 
value="db2admin,001" />

                       
                        <property name="openjpa.slice.ONE.ConnectionDriverName" 
value="com.ibm.db2.jcc.DB2Driver" />
                        <property name="openjpa.slice.ONE.ConnectionURL" 
value="jdbc:db2://localhost:52000/DB1"/>
                        <property name="openjpa.slice.ONE.ConnectionUserName" 
value="db2admin"/>
                        <property name="openjpa.slice.ONE.ConnectionPassword" 
value="db2admin,001" />
               
               
                <property name="openjpa.slice.TWO.ConnectionDriverName" 
value="com.ibm.db2.jcc.DB2Driver" />
                <property name="openjpa.slice.TWO.ConnectionURL" 
value="jdbc:db2://localhost:52000/DB2"/>        
                <property name="openjpa.slice.TWO.ConnectionUserName" 
value="db2admin"/>
                <property name="openjpa.slice.TWO.ConnectionPassword" 
value="db2admin,001" />
               
               
                <property name="openjpa.slice.DistributionPolicy" 
value="org.apache.openjpa.slice.policy.MyUserDistributionPolicy"/>        
                 
                <property name="openjpa.Log" value="SQL=TRACE"/>
                       
                </properties>
        </persistence-unit>

I want to use 2 several databases. For testing I build a simple database 
structure with one table in each database. Each database is connected to a 
slice so, Userdb1 is in slice one and Customerdb2 is in slice two.

When I try to make a simple SELECT udb1.udb1Id, udb1.udb1Name, udb1.udb1Mail 
FROM Userdb1 udb1, I have this error :  DB2 SQL error: SQLCODE: -204, SQLSTATE: 
42704, ...

Slice want to find Userdb1 in slice TWO but this table is in slice ONE only...

How I can do solve this problem ?

Best regards :) 
-- 
View this message in context: 
http://n2.nabble.com/Slice-Error-with-simple-query-%28-Websphere-7.0---DB2-9.1-%29-tp2544575p2544575.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.