Mailing-List: contact users-help@cocoon.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@cocoon.apache.org
Received-SPF: pass (hermes.apache.org: local policy)
Message-ID: <20040919023042.6213.qmail@web53303.mail.yahoo.com>
Date: Sat, 18 Sep 2004 19:30:42 -0700 (PDT)
From: Paul Joseph <pjoseph_98@yahoo.com>
Subject: how does one use JDO to run ALTER TABLE sql command?
To: Cocoon Users <users@cocoon.apache.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

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: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org