how does one use JDO to run ALTER TABLE sql command?

[Paul Joseph]

Hi,

My colleague and I are trying to use jdo to do an
"alter table" command.

There don't seem to be any examples showing how this
is done and we are having a bit of a tough time.

The logs show that the right statement is being
executed.

However, the following error is received:
==========================
SQLQUERY: ALTER TABLE array_webtask_usr ADD COLUMN
s_email varchar(100)
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl]
ERROR: SQLException during the execution of the SQL
query: No results were returned by the query.
==========================
Question: how does one alter a table using jdo?

A snippet of our code is as follows:

try {
    String sqlQuery = "ALTER TABLE " + tableName + "
ADD COLUMN " + columnName + " " + dataType + ";";
                                                        System.out.println("Query is" 
+ sqlQuery);
                                                        QueryBySQL querySql = new
QueryBySQL(obj.getClass(), sqlQuery);
                                                        broker =
PersistenceBrokerFactory.defaultPersistenceBroker();
                                                        broker.beginTransaction();
                                                        
broker.getObjectByQuery(querySql);
                                                        broker.commitTransaction();
        } catch (Exception e) {
        e.printStackTrace();
        broker.abortTransaction();
        return null;
}




---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]