Hi,
I was running the 1st command line tutorial on Oracle 8.17 and I got
an error. Trace below.
(p.s. I'm running beta3
It is able to run the query to look for the metro gallery, but it fails to
create the entries in artist table
(I checked in the database). Note that the statements in the tutorial
for 'insert' work properly when I enter them 'manually' in oracle..
The trace looks weird in that I see function statements with the word
"mysql" in the class
names .. even though I changed the adapter and created the database in
oracle.
p.s. I did follow the instructions to create primary key support, and the
sequences did get
properly created in oracle (I checked). The tables did also get created.
-------------------------------------------------------------
C:\work\cayenne-1.0b3\doc\tutorials\cayenne-cmd-app>%JAVA_HOME%\bin\javac
java\
est\*.java
C:\work\cayenne-1.0b3\doc\tutorials\cayenne-cmd-app>set
CLASSPATH=%CLASSPATH%;j
va
C:\work\cayenne-1.0b3\doc\tutorials\cayenne-cmd-app>%JAVA_HOME%\bin\java
test.M
in metro
WARN QueryLogger: --- will run 1 query.
WARN QueryLogger: SELECT t0.GALLERY_NAME, t0.GALLERY_ID FROM GALLERY t0
WHERE
PPER(t0.GALLERY_NAME) LIKE UPPER(?) [bind: '%metro%'] - prepared in 16 ms.
WARN QueryLogger: === returned 1 row. - took 63 ms.
Found gallery 'The Metropolitan Museum of Art'.
Exception in thread "main" org.objectstyle.cayenne.CayenneRuntimeException:
[v.
.0b3 May 25 2003] org.objectstyle.cayenne.CayenneException: [v.1.0b3 May 25
200
] Error generating PK: ORA-00966: missing TABLE keyword
at
org.objectstyle.cayenne.access.DataContext.commitChanges(DataContext
java:735)
at test.Main.addArtist(Main.java:99)
at test.Main.runTutorial(Main.java:40)
at test.Main.main(Main.java:30)
Caused by: org.objectstyle.cayenne.CayenneException: [v.1.0b3 May 25 2003]
Erro
generating PK: ORA-00966: missing TABLE keyword
at
org.objectstyle.cayenne.access.util.PrimaryKeyHelper.createPermIdsFo
ObjEntity(PrimaryKeyHelper.java:200)
at
org.objectstyle.cayenne.access.ContextCommit.createPrimaryKeys(Conte
tCommit.java:517)
at
org.objectstyle.cayenne.access.ContextCommit.commit(ContextCommit.ja
a:139)
at
org.objectstyle.cayenne.access.DataContext.commitChanges(DataContext
java:732)
... 3 more
Caused by: java.sql.SQLException: ORA-00966: missing TABLE keyword
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
at
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:82
)
at
oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.j
va:1446)
at
oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.ja
a:1371)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatem
nt.java:1900)
at
oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:737)
at
org.objectstyle.cayenne.dba.mysql.MySQLPkGenerator.getPrimaryKey(MyS
LPkGenerator.java:150)
at
org.objectstyle.cayenne.dba.mysql.MySQLPkGenerator.pkFromDatabase(My
QLPkGenerator.java:93)
at
org.objectstyle.cayenne.dba.JdbcPkGenerator.generatePkForDbEntity(Jd
cPkGenerator.java:321)
at
org.objectstyle.cayenne.access.util.PrimaryKeyHelper.createPermIdsFo
ObjEntity(PrimaryKeyHelper.java:195)
... 6 more
C:\work\cayenne-1.0b3\doc\tutorials\cayenne-cmd-app>
Senior Bioinformatics Analyst
Core Genotyping Facility
10817 grovemont circle
Gaithersburg, MD 20877
Tel: 301-496-4060
Fax: 301-480-2235
USPS Mail Address:
8617 Grovemont Circle
Gaithersburg, MD 20892-4605
Courier and visitor Address:
Advanced Technology Center, Room 152F
8617 Grovemont Circle
Gaithersburg, MD 20877
This archive was generated by hypermail 2.0.0 : Tue Jun 17 2003 - 07:37:56 EDT