change the line in the database.xml
url="jdbc:oracle:thin:@bpromote:1521:ORCL?user=system">
to
url="jdbc:oracle:thin:system/manager@bpromote:1521:ORCL">
oracle does not understand the "?user=xxxx" parameter as listed in the
Castor Docs.
----- Original Message -----
From: "John Wang" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, December 10, 2001 7:10 PM
Subject: [castor-dev] Excetion running JDO example (SQLException: "invalid
arguments in call")
> I got exception while running the jdo examples coming with 0.9.3 version
of
> castor. I am using Oracle database, I guess there is no problem with
>
> [test] Begin transaction
> [test] SELECT
> "PROD"."ID","PROD"."NAME","PROD"."PRICE","PROD"."GROUP_ID","PROD_D
> ETAIL"."ID" FROM "PROD","PROD_DETAIL" WHERE
> "PROD"."ID"="PROD_DETAIL"."PROD_ID"(
> +) AND ("PROD"."ID" = ?)
> [test] org.exolab.castor.jdo.PersistenceException: Nested error:
> java.sql.SQLExc
> eption: invalid arguments in call
> [test] org.exolab.castor.jdo.PersistenceException: Nested error:
> java.sql.SQLExc
> eption: invalid arguments in call
> [test] at
> org.exolab.castor.jdo.engine.TransactionContextImpl.getConnection(Tra
> nsactionContextImpl.java:207)
> [test] at
> org.exolab.castor.persist.TransactionContext.query(TransactionContext
> .java:616)
> [test] at
> org.exolab.castor.jdo.engine.OQLQueryImpl.execute(OQLQueryImpl.java:4
> 57)
> [test] at
> org.exolab.castor.jdo.engine.OQLQueryImpl.execute(OQLQueryImpl.java:4
> 04)
> [test] at jdo.Test.run(Test.java:99)
> [test] at jdo.Test.main(Test.java:54)
>
>
> The database config I am using is:
> <database name="test" engine="oracle">
> <driver class-name="oracle.jdbc.driver.OracleDriver"
> url="jdbc:oracle:thin:@bpromote:1521:ORCL?user=system">
> <param name="password" value="manager" />
> </driver>
> <mapping href="mapping.xml" />
> </database>
>
> What is the problem with this exception?
>
> Thanks very much,
> John
>
> -----------------------------------------------------------
> 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
