I'm new to castor.
I'm using version 0.9.3.
I'm trying to run the script example jdo, after having previously set
the database.xml to
<!DOCTYPE databases PUBLIC "-//EXOLAB/Castor JDO Configuration DTD
Version 1.0//EN"
"http://castor.exolab.org/jdo-conf.dtd";>
<database name="test" engine="sql-server" >
<data-source class-name="com.jnetdirect.jsql.JSQLDataSource">
<params user="name" password="pass"
port-number="1234" server-name="hostxx" />
</data-source>
<mapping href="mapping.xml" />
</database>
here is the log message I get :
example jdo
[test] Loading mapping descriptors from
file:/D:/Install/Castor/castor-0.9.3/build/examples/jdo/mapping.xml
[test] SQL for creating myapp.ProductGroup: INSERT INTO "prod_group"
("id","name") VALUES (?,?)
[test] SQL for deleting myapp.ProductGroup: DELETE FROM "prod_group"
WHERE "id"=?
[test] SQL for updating myapp.ProductGroup: UPDATE "prod_group" SET
"name"=? WHERE "id"=? AND "name"=?
[test] SQL for loading myapp.ProductGroup: SELECT "prod_group"."name"
FROM "prod_group" 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","prod_detail" WHERE "prod"."id"*="prod_detail"."prod_id" AND
"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"=?,"name"=? WHERE "id"=? AND "prod_id"=? AND "name"=?
[test] SQL for loading myapp.ProductDetail: SELECT
"prod_detail"."prod_id","prod_detail"."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_id","prod_detail"."id","computer"."cpu"
FROM "prod","computer","prod_detail" WHERE "computer"."id"="prod"."id"
AND "computer"."id"*="prod_detail"."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"=? AND "name"=?
[test] SQL for loading myapp.Category: SELECT "category"."name" FROM
"category" WHERE "category"."id"=?
[test] Begin transaction
[test] SELECT
"prod"."id","prod"."name","prod"."price","prod"."group_id","prod_detail"."id"
FROM "prod","prod_detail" WHERE "prod"."id"*="prod_detail"."prod_id" AND
("prod"."id" = ?)
JSQLConnect Trial license - expires on:Mon Dec 17 01:04:07 CET 2001,
unlimited connections
[test] org.exolab.castor.jdo.PersistenceException: Nested error:
com.jnetdirect.jsql.u: Invalid object name 'prod'. while executing
SELECT
"prod"."id","prod"."name","prod"."price","prod"."group_id","prod_detail"."id"
FROM "prod","prod_detail" WHERE "prod"."id"*="prod_detail"."prod_id" AND
("prod"."id" = ?)
[test] com.jnetdirect.jsql.u: Invalid object name 'prod'.
[test] at com.jnetdirect.jsql.aq.a(Unknown Source)
[test] at com.jnetdirect.jsql.ae.f(Unknown Source)
[test] at com.jnetdirect.jsql.ae.int(Unknown Source)
[test] at com.jnetdirect.jsql.ae.do(Unknown Source)
[test] at com.jnetdirect.jsql.ak.executeQuery(Unknown Source)
[test] at
org.exolab.castor.jdo.engine.SQLEngine$SQLQuery.execute(SQLEngine.java:1582)
[test] at
org.exolab.castor.persist.TransactionContext.query(TransactionContext.java:616)
[test] at
org.exolab.castor.jdo.engine.OQLQueryImpl.execute(OQLQueryImpl.java:457)
[test] at
org.exolab.castor.jdo.engine.OQLQueryImpl.execute(OQLQueryImpl.java:404)
[test] at jdo.Test.run(Test.java:99)
[test] at jdo.Test.main(Test.java:54)
can anyone help?
--
