Re: [JBoss-dev] Problem in JDBCStartCommand.java

2002-04-15 Thread Dain Sundstrom
JL@esial wrote: Hello, I am using JBoss 3.0.0beta2(200204150942) on Win2k SP2. The function tableExists in this class makes the following jdbc call: rs = dmd.getTables(con.getCatalog(), null, tableName, null); I am using DB2 as dbms, and this piece of code will not work if tableName

Re: [JBoss-dev] Problem in JDBCStartCommand.java

2002-04-15 Thread [EMAIL PROTECTED]
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

Re: [JBoss-dev] Problem in JDBCStartCommand.java

2002-04-15 Thread Dain Sundstrom
, not a qualified tablename. I would expect that most RDBMS products, open or closed source, use this convention of . delimiting tokens in table and column names. Cheers From: Dain Sundstrom [EMAIL PROTECTED] Date: 2002/04/15 Mon AM 10:40:32 EDT To: [EMAIL PROTECTED] Subject: Re: [JBoss-dev] Problem

Re: [JBoss-dev] Problem in JDBCStartCommand.java

2002-04-15 Thread Ignacio Coloma
and column names. Cheers From: Dain Sundstrom [EMAIL PROTECTED] Date: 2002/04/15 Mon AM 10:40:32 EDT To: [EMAIL PROTECTED] Subject: Re: [JBoss-dev] Problem in JDBCStartCommand.java JL@esial wrote: Hello, I am using JBoss 3.0.0beta2(200204150942) on Win2k SP2. The function

Re: [JBoss-dev] Problem in JDBCStartCommand.java

2002-04-15 Thread David Jencks
this convention of . delimiting tokens in table and column names. Cheers From: Dain Sundstrom [EMAIL PROTECTED] Date: 2002/04/15 Mon AM 10:40:32 EDT To: [EMAIL PROTECTED] Subject: Re: [JBoss-dev] Problem in JDBCStartCommand.java JL@esial wrote: Hello, I am using JBoss

Re: [JBoss-dev] Problem in JDBCStartCommand.java

2002-04-15 Thread Dain Sundstrom
: [JBoss-dev] Problem in JDBCStartCommand.java JL@esial wrote: Hello, I am using JBoss 3.0.0beta2(200204150942) on Win2k SP2. The function tableExists in this class makes the following jdbc call: rs = dmd.getTables(con.getCatalog(), null, tableName, null); I am using DB2 as dbms

Re: [JBoss-dev] Problem in JDBCStartCommand.java

2002-04-15 Thread Stephen Coy
] Date: 2002/04/15 Mon AM 10:40:32 EDT To: [EMAIL PROTECTED] Subject: Re: [JBoss-dev] Problem in JDBCStartCommand.java JL@esial wrote: Hello, I am using JBoss 3.0.0beta2(200204150942) on Win2k SP2. The function tableExists in this class makes the following jdbc call: rs = dmd.getTables

Re: [JBoss-dev] Problem in JDBCStartCommand.java

2002-04-15 Thread David Jencks
:32 EDT To: [EMAIL PROTECTED] Subject: Re: [JBoss-dev] Problem in JDBCStartCommand.java JL@esial wrote: Hello, I am using JBoss 3.0.0beta2(200204150942) on Win2k SP2. The function tableExists in this class makes the following jdbc call: rs = dmd.getTables(con.getCatalog

Re: [JBoss-dev] Problem in JDBCStartCommand.java

2002-04-15 Thread Stephen Coy
. Cheers From: Dain Sundstrom [EMAIL PROTECTED] Date: 2002/04/15 Mon AM 10:40:32 EDT To: [EMAIL PROTECTED] Subject: Re: [JBoss-dev] Problem in JDBCStartCommand.java JL@esial wrote: Hello, I am using JBoss 3.0.0beta2(200204150942) on Win2k SP2. The function tableExists in this class

Re: [JBoss-dev] Problem in JDBCStartCommand.java

2002-04-15 Thread Dain Sundstrom
. I would expect that most RDBMS products, open or closed source, use this convention of . delimiting tokens in table and column names. Cheers From: Dain Sundstrom [EMAIL PROTECTED] Date: 2002/04/15 Mon AM 10:40:32 EDT To: [EMAIL PROTECTED] Subject: Re: [JBoss-dev] Problem

RE: [JBoss-dev] Problem in JDBCStartCommand.java

2002-04-08 Thread Georg Schmid
PROTECTED]]On Behalf Of Jason Dillon Sent: Saturday, April 06, 2002 04:27 To: [EMAIL PROTECTED] Subject: Re: [JBoss-dev] Problem in JDBCStartCommand.java If there isn't sufficent support for schemas in JDBC, then we could probably add a mapping which handles the specifics on a db to db level... but I

Re: [JBoss-dev] Problem in JDBCStartCommand.java

2002-04-08 Thread Stephen Coy
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

RE: [JBoss-dev] Problem in JDBCStartCommand.java

2002-04-08 Thread Georg Schmid
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

Re: [JBoss-dev] Problem in JDBCStartCommand.java

2002-04-05 Thread Jason Dillon
If there isn't sufficent support for schemas in JDBC, then we could probably add a mapping which handles the specifics on a db to db level... but I will leave that impl to the CMP expert(s). --jason Stephen Coy wrote: The function [i]tableExists[/i] in this class makes the following jdbc