Dan,
I'm definitely not using the latest torque, so I don't know if my case
is the same as yours, but I had to use sequence instead of native.
Hope it helps
Paul
-----Original Message-----
From: Dan Finkelstein
Sent: Wed 10/10/2001 6:10 PM
To: '[EMAIL PROTECTED]'
Cc:
Subject: Torque: Oracle with idMethod as "native"
Hi --
I'm setting up a development using Torque (without Turbine)
connected to
Oracle. Using Steve Davis's "detailed example (long)" (Thanks,
Steve!!!!),
I got finished...so I thought! Then I changed the idbroker to
"native" to
test out an insert. I modified the schema file as shown:
<database defaultIdMethod="native">
The sql that torque generated looked fine -- the create sequence
code was
included. When I ran my test program, which tried to do an
insert, the
following error came up:
java.sql.SQLException: ORA-00923: FROM keyword not found
where
expected
I investigated and found that the framework was tried to call
oracle with
select null.nextval from dual
instead of
select company_seq.nextval from dual
This has really stumped me. I'm using the latest
jakarta-turbine-torque
from cvs. Below are some more details. Any ideas?
Dan
===============================
SHELL LINES
===============================
D:\projects\par>java PLTest
id_in_sql...select null.nextval from dual
java.sql.SQLException: ORA-00923: FROM keyword not found where
expected
at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
at
oracle.jdbc.oci8.OCIDBAccess.check_error(OCIDBAccess.java:1503)
at
oracle.jdbc.oci8.OCIDBAccess.parseExecuteDescribe(OCIDBAccess.java:
5)
at
oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.j
a:1600)
at
oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.java:1
8)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleState
nt.java:1805)
at
oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.jav
410)
at
com.workingdogs.village.QueryDataSet.<init>(QueryDataSet.java:112)
at
org.apache.torque.oid.SequenceIdGenerator.getIdAsVillageValue(Seque
eIdGenerator.java:189)
at
org.apache.torque.oid.SequenceIdGenerator.getIdAsBigDecimal(Sequenc
dGenerator.java:126)
at
org.apache.torque.util.BasePeer.doInsert(BasePeer.java:791)
at
org.apache.torque.util.BasePeer.doInsert(BasePeer.java:695)
at
com.bluescope.pl.tables.BaseCompanyPeer.doInsert(BaseCompanyPeer.ja
:126)
at
com.bluescope.pl.tables.BaseCompanyPeer.doInsert(BaseCompanyPeer.ja
:112)
at
com.bluescope.pl.tables.BaseCompanyPeer.doInsert(BaseCompanyPeer.ja
:344)
at PLTest.main(PLTest.java:26)
D:\projects\par>
===============================
PART OF MY SCHEMA XML FILE
===============================
<database
defaultIdMethod="native"
>
<table name="COMPANY">
<column name="ID" required="true" autoIncrement="true"
primaryKey="true" type="INTEGER"/>
<column name="NAME" required="true" size="255"
type="VARCHAR"/>
<column name="GLOBALXML" required="true" size="255"
type="VARCHAR"/>
<column name="UPDATED" required="true" type="TIMESTAMP"/>
</table>
===============================
PART OF MY JAVA TEST PROGRAM
===============================
// initialize Torque
Torque.init("/projects/par/par.properties");
Company c = new Company();
c.setName ("IBM");
c.setGlobalxml ("abcxml");
c.setUpdated(new Date());
CompanyPeer.doInsert (c);
===============================
PART OF MY PROPERTIES FILE
===============================
services.DatabaseService.database.default=default
services.DatabaseService.database.default.driver=oracle.jdbc.driver.Orac
leDr
iver
services.DatabaseService.database.default.url=jdbc:oracle:oci8:@DBBOX
services.DatabaseService.database.default.username=xxx
services.DatabaseService.database.default.password=xxx
services.DatabaseService.database.adapter=DBOracle
services.DatabaseService.database.adapter.DBOracle=oracle.jdbc.driver.Or
acle
Driver
---------------------------------------------------------------------
To unsubscribe, e-mail:
[EMAIL PROTECTED]
For additional commands, e-mail:
[EMAIL PROTECTED]
<<winmail.dat>>
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
