Bugs item #661335, was opened at 2003-01-02 16:10 You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=661335&group_id=22866
Category: JBossCMP Group: v3.0 Rabbit Hole Status: Open Resolution: None Priority: 5 Submitted By: Peter Luttrell (objec) Assigned to: Nobody/Anonymous (nobody) Summary: JBoss links ejbs to tables in wrong tablespace Initial Comment: JBoss 3.0.2 Oracle8.1.7 I have 2 oracle users: user1 has 3 tables in it's default tablespace called A, B and C (which i created with one version of the deployment). ok, so i add another datasource pointing at the same db with user2 as the login. It has it's own tablespace and cannot write to user1's tablespace. I then have a deployment (another set of apps) that deploys 5 enity beans that point at tables A, B, C, D and E. I'm reusing A, B and C. When I deploy, JBoss creates tables D and E in user2's tablespace, but does not create table A, B or C. Then when i try to use the beans and write to bean/table A, JBoss blows up. with this error: java.sql.SQLException: ORA-00942: table or view does not exist I'm thinking that something is not quite write with the code that creates the tables, in specific the code that determines if it should create the table. If we create public synanins to user1's tables, then everything works fine, but this is not what i would like. I would like new tables created in user2's tablespace. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=661335&group_id=22866 ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development