You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@turbine.apache.org by "Sperlich, Tino" <t....@hpc-hamburg.de> on 2003/11/17 11:44:10 UTC

Update on ID-Table when using idMethod=native

Hi, 

I am using Torque with the native method (i.e. Sequence), so I didnt bother to setup the 
id-table. still I am getting this error message when trying to insert some permission using turbine.

Any hints would be appreciated.

Thanks,

Tino

11:12:08,509 DEBUG  - updateQuantity: UPDATE ID_TABLE SET QUANTITY = 1 WHERE TABLE_NAME = 'TURBINE_PERMISSION'
11:12:09,350 WARN   - Unhandled Exception thrown: class org.apache.turbine.util.security.DataBackendException
StandardWrapperValve[action]: Servlet.service() for servlet action threw exception
javax.servlet.ServletException: addPermission(Permission) failed: doInsert failed
	at org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:545)
	at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:486)
	at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
	at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
....
----- Root Cause -----
java.lang.reflect.InvocationTargetException
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:324)
	at org.apache.turbine.services.security.torque.PermissionPeerManager.doInsert(PermissionPeerManager.java:492)
	at org.apache.turbine.services.security.torque.TorqueSecurityService.addPermission(TorqueSecurityService.java:891)
	at org.apache.turbine.services.security.TurbineSecurity.createPermission(TurbineSecurity.java:657)
	at de.hhla.hpc.polzug.pzp.action.AdminAction.execute(AdminAction.java:106)
....
Caused by: org.apache.torque.TorqueException: ORA-00942: Tabelle oder View nicht vorhanden
	at org.apache.torque.util.BasePeer.throwTorqueException(BasePeer.java:236)
	at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:730)
	at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:639)
	at de.hhla.hpc.polzug.pzp.persistence.om.BaseTurbinePermissionPeer.doInsert(BaseTurbinePermissionPeer.java:208)
	at de.hhla.hpc.polzug.pzp.persistence.om.BaseTurbinePermissionPeer.doInsert(BaseTurbinePermissionPeer.java:182)
	... 43 more
Caused by: java.sql.SQLException: ORA-00942: Tabelle oder View nicht vorhanden
	at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:169)
	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:822)
	... 46 more
rethrown as org.apache.torque.TorqueException: doInsert failed
	at org.apache.turbine.services.security.torque.PermissionPeerManager.doInsert(PermissionPeerManager.java:498)
	at org.apache.turbine.services.security.torque.TorqueSecurityService.addPermission(TorqueSecurityService.java:891)
	at org.apache.turbine.services.security.TurbineSecurity.createPermission(TurbineSecurity.java:657)
	at de.hhla.hpc.polzug.pzp.action.AdminAction.execute(AdminAction.java:106)

---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org

Re: Update on ID-Table when using idMethod=native

Posted by Scott Eade <se...@backstagetech.com.au>.
Sperlich, Tino wrote:

>I am using Torque with the native method (i.e. Sequence), so I didnt bother to setup the 
>id-table. still I am getting this error message when trying to insert some permission using turbine.
>
The TURBINE_* tables will still use ID_TABLE (and thus you must 
configure it) unless you use the TorqueSecurityService and generate the 
om for these tables to use native also.

Scott

-- 
Scott Eade
Backstage Technologies Pty. Ltd.
http://www.backstagetech.com.au




---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org