You are right! I am wondering where I read getSchema() ?? Maybe just wishful thinking.
I am not completely sure, whether this use of getUserName() is correct. It happens to work with Oracle, when the schema name is the same as the user name (Oracle always (?) creates a separate schema for each user). However, if the user is "foo", but the table is in schema "bar", getUserName() will not return what you expect. We have exactly this case in one of our core Oracle databases (of course, with different schema and table names). Thinking a bit more, I guess the conn.getCatalog() is actually correct. You have to solve the problem on the application side, maybe in jbosscmp-jdbc.xml by using <schema>.<tablename>, e.g. bar.foo instead of foo. Georg -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Stephen Coy Sent: Monday, April 08, 2002 13:09 To: [EMAIL PROTECTED] Subject: Re: [JBoss-dev] Problem in JDBCStartCommand.java On Monday, April 8, 2002, at 05:35 PM, Georg Schmid wrote: > so one could use getSchema() instead of getCatalog() (and don't forget > to > use getSchemaTerm() :-)). > I agree that getSchema() would be handy here. Unfortunately, I don't believe that it exists. There is a getSchemas(), but that's kind of useless in this context. I've patched our code to use dmd.getUserName(), which, as far as I can ascertain, returns exactly what I would expect getSchema() to return anyway. It doesn't seem to effect the unit test suite, and it fixes my problem. My AU0.04$ :-) Steve _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
