Jboss works fine with my tables in DB2, as long as I prefix all my <table-name> with the name of my DB2 tablespace. I have to do that because otherwise SQL queries will not work. It is ok to have a <table-name> entry wich is a concatenation of a schema name and a table name, because it works perfectly like that. And I use a script to generate the structure of my database.
The problem is there: as part of the <create-table>/<remove-table> features, I would have expected the tableExists method to "behave" in an appropriate manner. If I set <create-table> to true, and that my table already exists, I do not expect to receive n exceptions reports. When I write specs, I define a "behaviour", and I try to stick to it so that my software is kind of "proved". I do not have a SIMPLE solution for all dbms: in Jboss, there is only one parameter for method tableExists, that is tableName. But it should be considered that a table may exist in a tablespace, for instance. That is why I only ASKED if there was an easy way to set a tablename prefix or even a schema name in jbosscmp-jdbc.xml... Thanks, Jerome. PS: I must not be the only one who thinks it is a problem ;) http://main.jboss.org/thread.jsp?forum=66&thread=12265&message=3670879 * * * View thread online: http://main.jboss.org/thread.jsp?forum=66&thread=12960 _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
