[JBoss-dev] [ jboss-Bugs-1068206 ] Incorrect data source used loading relationship field
Bugs item #1068206, was opened at 2004-11-17 11:27 Message generated for change (Comment added) made by starksm You can respond by visiting: https://sourceforge.net/tracker/?func=detailatid=376685aid=1068206group_id=22866 Category: JBossCMP Group: v3.2 Status: Open Resolution: None Priority: 5 Submitted By: Brad Geddes (bgeddes) Assigned to: Alexey Loubyansky (loubyansky) Summary: Incorrect data source used loading relationship field Initial Comment: Running Windows 2000, JDK 1.4.2_02, Jboss 3.2.6 I have a relationship between two EJBs associated with different data sources. When I update the relationship, it runs a select statement for the foreign key column being updated, but it runs it using the datasource for the related ejb. This causes an oracle error (ORA-00942: table or view does not exist), since the table does not exist in the other schema. InventoryMapEJB: datasource1 StatusEJB: datasource2 inventoryMapEJB.setStatus(statusEJB); This runs: SELECT inventory_map_id, status_id FROM INVENTORY_MAP WHERE (inventory_map_id=?) using datasource2 I believe the problem is in the resolveRelationship method of the JDBCCMRFieldBridge class. It checks hasForeignKey() in order to decide which dataSource to use, but the foreignKeyFields member variable hasn't been initialized yet. This happens later in the method, during the call to initializeForeignKeyFields(). The attached file is a proposed fix to this class. I just moved dataSource and table name loading to after where the foreign key fields are initialized. -- Comment By: Scott M Stark (starksm) Date: 2004-12-29 12:52 Message: Logged In: YES user_id=175228 All issues have been moved to http://jira.jboss.com. Existing issues have been moved. New issues will be closed with this canned reponse. -- You can respond by visiting: https://sourceforge.net/tracker/?func=detailatid=376685aid=1068206group_id=22866 --- SF email is sponsored by - The IT Product Guide Read honest candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://productguide.itmanagersjournal.com/ ___ JBoss-Development mailing list JBoss-Development@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-development
[JBoss-dev] [ jboss-Bugs-1068206 ] Incorrect data source used loading relationship field
Bugs item #1068206, was opened at 2004-11-17 21:27 Message generated for change (Settings changed) made by loubyansky You can respond by visiting: https://sourceforge.net/tracker/?func=detailatid=376685aid=1068206group_id=22866 Category: JBossCMP Group: v3.2 Status: Open Resolution: None Priority: 5 Submitted By: Brad Geddes (bgeddes) Assigned to: Alexey Loubyansky (loubyansky) Summary: Incorrect data source used loading relationship field Initial Comment: Running Windows 2000, JDK 1.4.2_02, Jboss 3.2.6 I have a relationship between two EJBs associated with different data sources. When I update the relationship, it runs a select statement for the foreign key column being updated, but it runs it using the datasource for the related ejb. This causes an oracle error (ORA-00942: table or view does not exist), since the table does not exist in the other schema. InventoryMapEJB: datasource1 StatusEJB: datasource2 inventoryMapEJB.setStatus(statusEJB); This runs: SELECT inventory_map_id, status_id FROM INVENTORY_MAP WHERE (inventory_map_id=?) using datasource2 I believe the problem is in the resolveRelationship method of the JDBCCMRFieldBridge class. It checks hasForeignKey() in order to decide which dataSource to use, but the foreignKeyFields member variable hasn't been initialized yet. This happens later in the method, during the call to initializeForeignKeyFields(). The attached file is a proposed fix to this class. I just moved dataSource and table name loading to after where the foreign key fields are initialized. -- You can respond by visiting: https://sourceforge.net/tracker/?func=detailatid=376685aid=1068206group_id=22866 --- This SF.Net email is sponsored by: InterSystems CACHE FREE OODBMS DOWNLOAD - A multidimensional database that combines robust object and relational technologies, making it a perfect match for Java, C++,COM, XML, ODBC and JDBC. www.intersystems.com/match8 ___ JBoss-Development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
[JBoss-dev] [ jboss-Bugs-1068206 ] Incorrect data source used loading relationship field
Bugs item #1068206, was opened at 2004-11-17 14:27 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detailatid=376685aid=1068206group_id=22866 Category: JBossCMP Group: v3.2 Status: Open Resolution: None Priority: 5 Submitted By: Brad Geddes (bgeddes) Assigned to: Nobody/Anonymous (nobody) Summary: Incorrect data source used loading relationship field Initial Comment: Running Windows 2000, JDK 1.4.2_02, Jboss 3.2.6 I have a relationship between two EJBs associated with different data sources. When I update the relationship, it runs a select statement for the foreign key column being updated, but it runs it using the datasource for the related ejb. This causes an oracle error (ORA-00942: table or view does not exist), since the table does not exist in the other schema. InventoryMapEJB: datasource1 StatusEJB: datasource2 inventoryMapEJB.setStatus(statusEJB); This runs: SELECT inventory_map_id, status_id FROM INVENTORY_MAP WHERE (inventory_map_id=?) using datasource2 I believe the problem is in the resolveRelationship method of the JDBCCMRFieldBridge class. It checks hasForeignKey() in order to decide which dataSource to use, but the foreignKeyFields member variable hasn't been initialized yet. This happens later in the method, during the call to initializeForeignKeyFields(). The attached file is a proposed fix to this class. I just moved dataSource and table name loading to after where the foreign key fields are initialized. -- You can respond by visiting: https://sourceforge.net/tracker/?func=detailatid=376685aid=1068206group_id=22866 --- This SF.Net email is sponsored by: InterSystems CACHE FREE OODBMS DOWNLOAD - A multidimensional database that combines robust object and relational technologies, making it a perfect match for Java, C++,COM, XML, ODBC and JDBC. www.intersystems.com/match8 ___ JBoss-Development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
