[prev in list] [next in list] [prev in thread] [next in thread]
List: turbine-torque-user
Subject: RE: Error using Oracle + Torque 3.1 (ORA-00923)
From: Thomas Fischer <tfischer () apache ! org>
Date: 2006-03-11 18:00:19
Message-ID: 20060311095547.T45269 () minotaur ! apache ! org
[Download RAW message or body]
If everything were normal, the Torque generator should have added that. No
idea why it did not work.
One thing may be that there is a bug in the schema.xml. Xml is case
sensitive, this often deceives the eye. If you are interested in further
research, you might want to validate your hml against the dtd (this is
done by the generator only since 3.2 )
Thomas
On Fri, 10 Mar 2006, Hay, Markus wrote:
> We seem to have found the problem.
>
> In ImageMapBuilder.java, the following line was added:
>
> tMap.setPrimaryKeyMethodInfo("SEQ_IMAGE");
>
> I'm not sure if this is something that is normally included in the
> Torque generated classes, but in this particular case it wasn't there.
>
> Thanks for your help and suggestions. Using P6Spy allowed us to track
> this down.
>
>
> Markus F. Hay
> Software Engineer
> SecureInfo Corporation
> 211 N. Loop 1604 E.
> Suite 200
> San Antonio, Texas 78232
> 210.445.6613 (cell)
> 210.403.5702 (fax)
> www.secureinfo.com
>
>
> This message may contain confidential and/or legally privileged
> information. If it has been sent to you in error, please reply
> immediately to advise the sender of the error and then destroy this
> message, any copies of this message and any printout of this message. If
> you are not the intended recipient of the message, any unauthorized
> dissemination, distribution or copying of the material in this message,
> and any attachments to the message, is strictly forbidden.
>
> -----Original Message-----
> From: Thomas Fischer [mailto:fischer@seitenbau.net]
> Sent: Friday, March 10, 2006 11:50 AM
> To: Apache Torque Users List
> Subject: RE: Error using Oracle + Torque 3.1 (ORA-00923)
>
> "Hay, Markus" <markus.hay@secureinfo.com> schrieb am 10.03.2006
> 17:24:28:
>
>> I did as you suggested and added in P6Spy. The second line is what
>> appears to be the problem:
>>
>> 1142005304218|15|1|statement||SELECT IMAGE.IMAGE_ID, IMAGE.GUID,
>> IMAGE.FLAVOR_ID, IMAGE.MODIFIED_DATE, IMAGE.DEPRECATED FROM IMAGE
>> ORDER BY IMAGE.IMAGE_ID ASC
>> 1142005304234|16|2|statement||select null.nextval from dual
>>
>> null.nextval should be SEQ_IMAGE.nextval, so what would cause this to
>> happen?
>
> I am not too familiar with the 3.1 code, because this changed between
> Torque 3.1 and Torque 3.2.
> Remote diagnosis is very difficult at this point because the "Trigger"
> SQL statement seems to indicate that you have customized Torque (I did
> not find the word "Trigger" in any templates for 3.1.1, and I doubt very
> much that it appears in 3.1 templates). Somehow, Torque fails to
> retrieve the name of the trigger; no idea why. You would need to debug
> into the
> BasePeer.doInsert(Criteria,connection) method in the Torque library to
> find out more.
>
>> Also, the defaultIdMethod is set to native, and from doing a little
>> bit of reading, it appears that even if it is changed to sequence it
>> still defaults to native. That is according to what I found here:
>> -
>> http://mail-archives.apache.org/mod_mbox/jakarta-turbine-user/200110.m
>> bo x/%3CD100792A5BFFD311955C00508BC270DE401EC6@MAIL%3E
>> -
>> http://mail-archives.apache.org/mod_mbox/jakarta-turbine-user/200110.m
>> bo x/%3CD100792A5BFFD311955C00508BC270DE401EBB@MAIL%3E
>>
>
> Yes, "sequence" and "native" are the same id method in the case of
> oracle.
>
>> I should state that I'm not too terribly familiar with how triggers
>> work and our DB person is out. What I did do is compare the create
>> trigger/sequence statements for the IMAGE table to that of another
>> table that had content successfully imported and the syntax is
> identical.
>> Additionally, I modified ImageMapBuilder.java and set the primary key
>> method to sequence manually to see if this would make a difference
>> (tMap.setPrimaryKeyMethod(TableMap.SEQUENCE)). Same result. Any
>> suggestions?
>
> No, nothing like this will help. Torque asks the key from the sequence
> the key in a separate statement, which fails and throws the exception,
> which will happen even if the key is generated automatically (because
> Torque does not know it is generated automatically.). What you can do is
> to set the IdMethod to noIdMewthod (look into the dtd what the value for
> the IdMethod
> is) and rely on your trigger to generate the correct id.
>
> Thomas
>
>> -----Original Message-----
>> From: Thomas Fischer [mailto:fischer@seitenbau.net]
>> Sent: Friday, March 10, 2006 1:41 AM
>> To: Apache Torque Users List
>> Subject: RE: Error using Oracle + Torque 3.1 (ORA-00923)
>>
>> A few things come to my mind:
>> - It would be most helpful if the offending SQL statement would be
>> known.
>> You can e.g. use P6Spy to print out the sql statements issued by
> Torque.
>> See
>> http://wiki.apache.org/db-torque/FrequentlyAskedQuestions#head-46f663e
>> 01
>> bea72682fdc5f60ae02f2a47de29fec
>>
>> Only if this does not help:
>> - You have got a blob in your table. Blobs in oracle are not supported
>
>> in the data access layer which is used by torque (village). There is a
>
>> custom village library available for oracle, read the oracle howto on
>> the Torque homepage.
>> - I am not so sure with Torque 3.1, but looking at the trigger code,
>> it does not seem to be generated by torque this way. This might also
>> cause the problem. Which IdMethod are you using ?
>>
>> Thomas
>>
>> "Hay, Markus" <markus.hay@secureinfo.com> schrieb am 09.03.2006
>> 23:55:22:
>>
>>> Hello.
>>>
>>> We're using Torque 3.1 with our application and the following
>>> TorqueException is being thrown when we are importing application
>>> content into the database (note that everything works fine when
>>> using
>>> MSSQL):
>>>
>>> [Stack_Trace] =
>>> org.apache.torque.util.BasePeer.throwTorqueException(BasePeer.java:2
>>> 36
>>> )
>>> org.apache.torque.util.BasePeer.doInsert(BasePeer.java:730)
>>> com.secureinfo.flatties.om.BaseImagePeer.doInsert(BaseImagePeer.java
>>> :2
>>> 39
>>> )
>>> com.secureinfo.flatties.om.BaseImagePeer.doInsert(BaseImagePeer.java
>>> :6
>>> 01
>>> )
>>> com.secureinfo.flatties.om.BaseImage.save(BaseImage.java:644)
>>> com.secureinfo.baboon.export.db.ObjectInjector.injectPrimaryObject(O
>>> bj
>>> ec
>>> tInjector.java:628)
>>> com.secureinfo.baboon.export.db.ObjectInjector.inject(ObjectInjector
>>> .j
>>> av
>>> a:390)
>>>
> com.secureinfo.baboon.export.xml.DBImporter.importXML(DBImporter.java:
>>> 45
>>> 0)
>>> com.secureinfo.baboon.export.xml.DBImporter.injectClasses(DBImporter
>>> .j
>>> av
>>> a:337)
>>>
> com.secureinfo.baboon.export.xml.DBImporter.runImport(DBImporter.java:
>>> 24
>>> 7)
>>> com.secureinfo.baboon.export.ui.ContentAdminFramework.performImport(
>>> Co
>>> nt
>>> entAdminFramework.java:596)
>>> com.secureinfo.baboon.export.ui.ContentAdminFramework.prepImport(Con
>>> te
>>> nt
>>> AdminFramework.java:525)
>>> com.secureinfo.baboon.export.ui.ContentAdminFramework.locateData(Con
>>> te
>>> nt
>>> AdminFramework.java:298)
>>> com.secureinfo.baboon.export.ui.ContentAdminFramework.postTaskConfig
>>> (C
>>> on
>>> tentAdminFramework.java:247)
>>> com.secureinfo.baboon.export.ui.ContentAdminFramework.doRun(ContentA
>>> dm
>>> in
>>> Framework.java:175)
>>> com.secureinfo.baboon.export.ui.ContentAdminFramework.run(ContentAdm
>>> in
>>> Fr
>>> amework.java:114)
>>> com.secureinfo.baboon.export.ui.DBMain.invoke(DBMain.java:157)
>>> com.secureinfo.baboon.export.ui.DBMain.main(DBMain.java:262)
>>> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>> sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
>>> java.lang.reflect.Method.invoke(Unknown Source)
>>> BootStrapContent.main(BootStrapContent.java:54)
>>> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>> sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
>>> java.lang.reflect.Method.invoke(Unknown Source)
>>> com.zerog.lax.LAX.launch(DashoA8113)
>>> com.zerog.lax.LAX.main(DashoA8113)
>>> org.apache.torque.TorqueException: ORA-00923: FROM keyword not found
>
>>> where expected
>>>
>>>
>>> ** The following is what we are using in our Torque XML file that
>>> generates the classes (for the particluar table that is causing the
>>> above error):
>>> <table name="IMAGE" idMethod="native">
>>> <column primaryKey="true" required="true" type="INTEGER"
>>> name="IMAGE_ID"/>
>>> <column type="BINARY" name="DATA"/>
>>> <column type="DATE" name="MODIFIED_DATE"/>
>>> <column type="VARCHAR" name="MODIFIED_USER_NAME"/>
>>> <column type="VARCHAR" name="MODIFIED_DOMAIN_NAME"/>
>>> <column type="INTEGER" javaType="object" name="FLAVOR_ID"/>
>>> <column type="VARCHAR" name="GUID"/>
>>> <column type="BIT" javaType="object" name="DEPRECATED"/>
>>> <column type="INTEGER" javaType="object"
>> name="DEPRECATED_BY"/>
>>> <column type="CHAR" name="image_hash"/>
>>> <column type="VARCHAR" name="image_name"/> </table>
>>>
>>> ** The table is created as follows (through various scripts during
>>> the
>>
>>> installation process):
>>> CREATE TABLE IMAGE (
>>> IMAGE_ID INT NOT NULL,
>>> DATA BLOB NULL,
>>> MODIFIED_DATE TIMESTAMP NULL,
>>> MODIFIED_USER_NAME VARCHAR2 (50) NULL,
>>> MODIFIED_DOMAIN_NAME VARCHAR2 (50) NULL,
>>> FLAVOR_ID INT NULL,
>>> GUID VARCHAR2 (256) NULL,
>>> DEPRECATED SMALLINT NULL,
>>> DEPRECATED_BY INT NULL,
>>> image_hash char(32) null,
>>> image_name varchar(50) null
>>> )
>>>
>>> ALTER TABLE IMAGE ADD CONSTRAINT XK_IMAGE PRIMARY KEY (IMAGE_ID);
>>>
>>> CREATE SEQUENCE SEQ_IMAGE START WITH 1 INCREMENT BY 1;
>>>
>>> CREATE OR REPLACE TRIGGER IMAGE_IDENTITY BEFORE INSERT ON "IMAGE"
>>> FOR EACH ROW BEGIN
>>> IF :NEW.IMAGE_ID IS NULL THEN
>>> SELECT NVL(:NEW.IMAGE_ID, SEQ_IMAGE.NEXTVAL)
>>> INTO :NEW.IMAGE_ID
>>> FROM DUAL;
>>> END IF;
>>> END;
>>>
>>> --------
>>>
>>> Does anyone know what the problem is and how I might fix it? I've
>>> searched around but haven't run into a solution for this. Is this an
>
>>> issue with Torque or does something need to change on our end?
>>> Thanks in advance.
>>>
>>> Markus F. Hay
>>> Configuration Manager
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
>> For additional commands, e-mail: torque-user-help@db.apache.org
>>
>>
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
>> For additional commands, e-mail: torque-user-help@db.apache.org
>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic