you might have an old mm.mysql...jar?
i think you need at least 2.0.11.
i use 2.0.14, myself.
On Mon, 2002-07-01 at 20:21, Vedula, Sharma wrote:
> 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
>
>
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
