Sorry.. I was trying give the solution the same time as the problem. My problem is if you are using foreign-key-mapping with two tables that are not in the default datasource the relation tries to execute the sql command on the default datasource. For table mapping you can specify the datasource for the relation table. For foreign-key-mapping we should use the datasource of the table not the default.
So.. table a and b in datasource LocalDb. The default datasource is RemoteDb. a has a 1 to many unidirection relationship with b. When you are trying to access the collection it is looking for b in thew RemoteDb instead of the LocalDb. New Dad , lack of sleep ... I hope this is clear ... On Fri, 2002-06-14 at 13:40, Dain Sundstrom wrote: > Dave Smith wrote: > > > If I have two tables a nd b that are related with a forgien key but the > > tables are not in the default datasource it tries to bind the relation > > to the default datasource. In JDBCCMRFieldBridge.java it should set the > > default Datasource for the relation from the JDBCEntityBridge.java. If > > it is table mapping and the datasource is supplied then it should be > > ignored. > > > Dave, you lost me. If your are using a foreign-key-mapping the > datasorce present in JDBCCMRFieldBridge should not be used. Is it being > used? If it is, where? > > -dain > > > > _______________________________________________________________ > > Don't miss the 2002 Sprint PCS Application Developer's Conference > August 25-28 in Las Vegas - >http://devcon.sprintpcs.com/adp/index.cfm?source=osdntextlink > > _______________________________________________ > Jboss-development mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-development _______________________________________________________________ Don't miss the 2002 Sprint PCS Application Developer's Conference August 25-28 in Las Vegas - http://devcon.sprintpcs.com/adp/index.cfm?source=osdntextlink _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
