I get the following output when I run the jdo example. Can someone shed
some light on this?
Thanks
Sharma
C:\castor-0.9.3.19>example jdo
[test] Loading mapping descriptors from
file:/C:/castor-0.9.3.19/build/examples/
jdo/mapping.xml
[test] SQL for creating myapp.ProductGroup: INSERT INTO prod_group (id,name)
VAL
UES (?,?)
[test] SQL for deleting myapp.ProductGroup: DELETE FROM prod_group WHERE
id=?
[test] SQL for updating myapp.ProductGroup: UPDATE prod_group SET name=?
WHERE i
d=? AND name=?
[test] SQL for loading myapp.ProductGroup: SELECT prod_group.name FROM
prod_gro
up WHERE prod_group.id=?
[test] SQL for creating myapp.Product: INSERT INTO prod
(id,name,price,group_id)
VALUES (?,?,?,?)
[test] SQL for deleting myapp.Product: DELETE FROM prod WHERE id=?
[test] SQL for updating myapp.Product: UPDATE prod SET
name=?,price=?,group_id=?
WHERE id=? AND name=? AND price=? AND group_id=?
[test] SQL for loading myapp.Product: SELECT
prod.name,prod.price,prod.group_id
,prod_detail.id FROM prod LEFT OUTER JOIN prod_detail ON
prod.id=prod_detail.pro
d_id WHERE prod.id=?
[test] SQL for creating myapp.ProductDetail: INSERT INTO prod_detail
(id,prod_id
,name) VALUES (?,?,?)
[test] SQL for deleting myapp.ProductDetail: DELETE FROM prod_detail WHERE
id=?
[test] SQL for updating myapp.ProductDetail: UPDATE prod_detail SET
prod_id=?,na
me=? WHERE id=? AND prod_id=? AND name=?
[test] SQL for loading myapp.ProductDetail: SELECT
prod_detail.prod_id,prod_det
ail.name FROM prod_detail WHERE prod_detail.id=?
[test] SQL for creating myapp.Computer: INSERT INTO computer (id,cpu) VALUES
(?,
?)
[test] SQL for deleting myapp.Computer: DELETE FROM computer WHERE id=?
[test] SQL for updating myapp.Computer: UPDATE computer SET cpu=? WHERE id=?
AND
cpu=?
[test] SQL for loading myapp.Computer: SELECT
prod.name,prod.price,prod.group_i
d,prod_detail.id,computer.cpu FROM computer LEFT OUTER JOIN prod_detail ON
compu
ter.id=prod_detail.prod_id,prod WHERE computer.id=prod.id AND computer.id=?
[test] SQL for creating myapp.Category: INSERT INTO category (id,name)
VALUES (?
,?)
[test] SQL for deleting myapp.Category: DELETE FROM category WHERE id=?
[test] SQL for updating myapp.Category: UPDATE category SET name=? WHERE
id=? AN
D name=?
[test] SQL for loading myapp.Category: SELECT category.name FROM category
WHERE
category.id=?
[test] Begin transaction
[test] ProductOql: org.exolab.castor.jdo.engine.OQLQueryImpl@4c194d
[test] SELECT prod.id,prod.name,prod.price,prod.group_id,prod_detail.id FROM
pro
d LEFT OUTER JOIN prod_detail ON prod.id=prod_detail.prod_id WHERE (prod.id
= ?)
[test] SIZE: 0
[test] SELECT
computer.id,prod.name,prod.price,prod.group_id,prod_detail.id,comp
uter.cpu FROM computer LEFT OUTER JOIN prod_detail ON
computer.id=prod_detail.pr
od_id,prod WHERE computer.id=prod.id AND (computer.id = ?)
[test] SELECT prod_group.id,prod_group.name FROM prod_group WHERE
(prod_group.id
= ?)
[test] Transaction checkpoint
[test] SELECT prod_group.id,prod_group.name FROM prod_group WHERE
(prod_group.id
= ?)
[test] Castor: Creating myapp.ProductGroup (3)
[test] Creating new group: 3 a group
[test] SELECT prod.id,prod.name,prod.price,prod.group_id,prod_detail.id FROM
pro
d LEFT OUTER JOIN prod_detail ON prod.id=prod_detail.prod_id WHERE (prod.id
= ?)
[test] Creating new product: 4 some product
[test] Castor: Creating myapp.Product (4)
[test] Castor: Creating myapp.ProductDetail (1)
[test] Castor: Creating myapp.ProductDetail (2)
[test] SELECT
computer.id,prod.name,prod.price,prod.group_id,prod_detail.id,comp
uter.cpu FROM computer LEFT OUTER JOIN prod_detail ON
computer.id=prod_detail.pr
od_id,prod WHERE computer.id=prod.id AND (computer.id = ?)
[test] Creating new computer: 6 MyPC
[test] Castor: Creating myapp.Computer (6)
[test] Castor: Creating myapp.ProductDetail (4)
[test] Castor: Creating myapp.ProductDetail (5)
[test] Commit transaction
[test] Castor: Loading myapp.ProductGroup (3)
[test] Castor: Loading myapp.ProductDetail (1)
[test] Castor: Loading myapp.ProductDetail (2)
[test] Castor: Loading myapp.Product (4)
<?xml version="1.0" encoding="UTF-8"?>
<product id="4">
<name>some product</name>
<price>55.0</price>
<group id="3">a group</group>
<detail id="1">one</detail>
<detail id="2">two</detail>
</product>
[test] SELECT
computer.id,prod.name,prod.price,prod.group_id,prod_detail.id,comp
uter.cpu FROM computer LEFT OUTER JOIN prod_detail ON
computer.id=prod_detail.pr
od_id,prod WHERE computer.id=prod.id
[test] org.exolab.castor.jdo.PersistenceException: Nested error:
org.gjt.mm.mysq
l.jdbc2.NotImplemented
[test] org.gjt.mm.mysql.jdbc2.NotImplemented
[test] at
org.gjt.mm.mysql.jdbc2.ResultSet.getBigDecimal(ResultSet.java:198)
[test] at
org.exolab.castor.jdo.engine.SQLTypes.getObject(SQLTypes.java:319)
[test] at
org.exolab.castor.jdo.engine.SQLEngine$SQLQuery.loadSingleField(SQLEn
gine.java:1784)
[test] at
org.exolab.castor.jdo.engine.SQLEngine$SQLQuery.loadRow(SQLEngine.jav
a:1850)
[test] at
org.exolab.castor.jdo.engine.SQLEngine$SQLQuery.fetchRaw(SQLEngine.ja
va:1923)
[test] at
org.exolab.castor.jdo.engine.SQLEngine$SQLQuery.nextIdentity(SQLEngin
e.java:1731)
[test] at
org.exolab.castor.persist.QueryResults.nextIdentity(QueryResults.java
:173)
[test] at
org.exolab.castor.jdo.engine.OQLQueryImpl$OQLEnumeration.hasMore(OQLQ
ueryImpl.java:598)
[test] at
org.exolab.castor.jdo.engine.OQLQueryImpl$OQLEnumeration.hasMore(OQLQ
ueryImpl.java:584)
[test] at jdo.Test.run(Test.java:228)
[test] at jdo.Test.main(Test.java:62)
C:\castor-0.9.3.19>
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
