On Thu, Nov 02, 2006 at 05:46:16PM +0100, jt wrote:
> The problem is that SQLObject.createTableSQL seems to never be used:
> in fact, SQLObject.createTable calls DBAPI.createTable that calls
> DBAPI.createTableSQL. So in order to create the view I have to call
> something like this "conn.query(MyViewObject.createTableSQL())" but I
> cannot simply call "MyViewObject.createTableSQL()".
.createTableSQL() returns two SQL queries - to create the table and to
apply the constraints - but doesn't run the queries itself. The purpose, if
I understand it right, is to collect all SQL queries and run them in any
order you want. But one has to run theese queries himself.
Oleg.
--
Oleg Broytmann http://phd.pp.ru/ [EMAIL PROTECTED]
Programmers don't die, they just GOSUB without RETURN.
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
