You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-user@portals.apache.org by Moabi Nyokong <Mo...@discovery.co.za> on 2003/01/16 07:28:08 UTC
FW: RE: Extending user....Insert/Update throws "Invalid Hex Numb
er" Oracle error
-----Original Message-----
From: Moabi Nyokong
Sent: 15 January 2003 09:06
To: 'Jetspeed Users List'
Subject: RE: Extending user....Insert/Update throws "Invalid Hex Number"
Oracle error
This is the contents of the Criteria object for an udate action call:
****************************************************************************
*******************
doUpdate() Criteria.toString() =
Criteria::
GS_USERS.PASSWORD_CHANGED<=>GS_USERS.PASSWORD_CHANGED={ts '2003-01-15
08:31:49.0'}:
GS_USERS.USE_DATE_JOINED_DISCOVERY<=>GS_USERS.USE_DATE_JOINED_DISCOVERY={ts
'2003-01-15 08:31:49.0'}:
GS_USERS.USE_JOB_TITLE<=>GS_USERS.USE_JOB_TITLE=123:
GS_USERS.USE_WORK_PHONE<=>GS_USERS.USE_WORK_PHONE='123':
GS_USERS.EMAIL<=>GS_USERS.EMAIL='demo@lifelinhree.com':
GS_USERS.USE_MODIFIED_BY<=>GS_USERS.USE_MODIFIED_BY='admin':
GS_USERS.DISABLED<=>GS_USERS.DISABLED='F':
GS_USERS.OBJECTDATA<=>GS_USERS.OBJECTDATA={USER_ID=4}:
GS_USERS.USER_ID<=>GS_USERS.USER_ID=4:
GS_USERS.USE_EFF_TO<=>GS_USERS.USE_EFF_TO={ts '2003-01-15
08:31:49.0'}:
GS_USERS.USE_DELETE_IND<=>GS_USERS.USE_DELETE_IND='0':
GS_USERS.USE_DATE_OF_BIRTH<=>GS_USERS.USE_DATE_OF_BIRTH={ts '2003-01-15
08:31:49.0'}:
GS_USERS.USE_JOB_LEVEL<=>GS_USERS.USE_JOB_LEVEL=123:
GS_USERS.PASSWORD_VALUE<=>GS_USERS.PASSWORD_VALUE='demo':
GS_USERS.USE_EFF_FROM<=>GS_USERS.USE_EFF_FROM={ts '2003-01-15 08:31:49.0'}:
GS_USERS.CONFIRM_VALUE<=>GS_USERS.CONFIRM_VALUE='CONFIRMED':
GS_USERS.LOGIN_NAME<=>GS_USERS.LOGIN_NAME='demo':
GS_USERS.FIRST_NAME<=>GS_USERS.FIRST_NAME='Demo':
GS_USERS.LAST_NAME<=>GS_USERS.LAST_NAME='User':
GS_USERS.USE_CREATED_BY<=>GS_USERS.USE_CREATED_BY='admin':
GS_USERS.USE_DATE_MODIFIED<=>GS_USERS.USE_DATE_MODIFIED={ts '2003-01-15
08:31:49.0'}:
GS_USERS.USE_CELL_PHONE<=>GS_USERS.USE_CELL_PHONE='123':
GS_USERS.USE_DATE_CREATED<=>GS_USERS.USE_DATE_CREATED={ts '2003-01-15
08:31:49.0'}:
GS_USERS.LAST_LOGIN<=>GS_USERS.LAST_LOGIN={ts '2003-01-15 08:31:49.0'}:
Current Query SQL (may not be complete or applicable):
SELECT * FROM GS_USERS
WHERE GS_USERS.PASSWORD_CHANGED={ts '2003-01-15 08:31:49.0'}
AND GS_USERS.USE_DATE_JOINED_DISCOVERY={ts '2003-01-15 08:31:49.0'}
AND GS_USERS.USE_JOB_TITLE=123
AND GS_USERS.USE_WORK_PHONE='123'
AND GS_USERS.EMAIL='demo@lifelinhree.com'
AND GS_USERS.USE_MODIFIED_BY='admin'
AND GS_USERS.DISABLED='F'
AND GS_USERS.OBJECTDATA={USER_ID=4}
AND GS_USERS.USER_ID=4
AND GS_USERS.USE_EFF_TO={ts '2003-01-15 08:31:49.0'}
AND GS_USERS.USE_DELETE_IND='0'
AND GS_USERS.USE_DATE_OF_BIRTH={ts '2003-01-15 08:31:49.0'}
AND GS_USERS.USE_JOB_LEVEL=123
AND GS_USERS.PASSWORD_VALUE='demo'
AND GS_USERS.USE_EFF_FROM={ts '2003-01-15 08:31:49.0'}
AND GS_USERS.CONFIRM_VALUE='CONFIRMED'
AND GS_USERS.LOGIN_NAME='demo'
AND GS_USERS.FIRST_NAME='Demo'
AND GS_USERS.LAST_NAME='User'
AND GS_USERS.USE_CREATED_BY='admin'
AND GS_USERS.USE_DATE_MODIFIED={ts '2003-01-15 08:31:49.0'}
AND GS_USERS.USE_CELL_PHONE='123'
AND GS_USERS.USE_DATE_CREATED={ts '2003-01-15 08:31:49.0'}
AND GS_USERS.LAST_LOGIN={ts '2003-01-15 08:31:49.0'}
****************************************************************************
*******************
And this is the excpetion thorwn:
****************************************************************************
*******************
java.lang.reflect.InvocationTargetException:
java.sql.SQLException: ORA-01465: invalid hex number
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:822)
at
oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1446
)
at
oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1371)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java
:1900)
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedState
ment.java:363)
at com.workingdogs.village.Record.saveWithInsert(Unknown Source)
at com.workingdogs.village.Record.save(Unknown Source)
at com.workingdogs.village.Record.save(Unknown Source)
at
org.apache.torque.util.BasePeer.insertOrUpdateRecord(BasePeer.java:891)
at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:725)
at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:615)
at
org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.doInsert(BaseTur
bineUserPeer.java:302)
at
org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.doInsert(BaseTur
bineUserPeer.java:275)
at
org.apache.jetspeed.services.security.turbine.TurbineUserManagement.addUser(
TurbineUserManagement.java:309)
at
org.apache.jetspeed.services.JetspeedUserManagement.addUser(JetspeedUserMana
gement.java:134)
at
org.apache.jetspeed.services.JetspeedSecurity.addUser(JetspeedSecurity.java:
238)
at
org.apache.jetspeed.modules.actions.portlets.security.UserUpdateAction.doIns
ert(UserUpdateAction.java:256)
at java.lang.reflect.Method.invoke(Native Method)
at
org.apache.turbine.util.velocity.VelocityActionEvent.executeEvents(VelocityA
ctionEvent.java:159)
at
org.apache.jetspeed.modules.actions.portlets.VelocityPortletAction.perform(V
elocityPortletAction.java:140)
at
org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122)
at
org.apache.turbine.modules.pages.DefaultPage.doBuild(DefaultPage.java:143)
at org.apache.turbine.modules.Page.build(Page.java:90)
at org.apache.turbine.modules.PageLoader.exec(PageLoader.java:123)
at org.apache.turbine.Turbine.doGet(Turbine.java:563)
at org.apache.turbine.Turbine.doPost(Turbine.java:658)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(Servle
tStubImpl.java:945)
at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java
:332)
at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java
:242)
at
weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(W
ebAppServletContext.java:5363)
at
weblogic.security.service.SecurityServiceManager.runAs(SecurityServiceManage
r.java:721)
at
weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletCo
ntext.java:3043)
at
weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java
:2466)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:152)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:133)
rethrown as org.apache.torque.TorqueException: ORA-01465: invalid hex number
at
org.apache.torque.util.BasePeer.insertOrUpdateRecord(BasePeer.java:895)
at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:725)
at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:615)
at
org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.doInsert(BaseTur
bineUserPeer.java:302)
at
org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.doInsert(BaseTur
bineUserPeer.java:275)
at
org.apache.jetspeed.services.security.turbine.TurbineUserManagement.addUser(
TurbineUserManagement.java:309)
at
org.apache.jetspeed.services.JetspeedUserManagement.addUser(JetspeedUserMana
gement.java:134)
at
org.apache.jetspeed.services.JetspeedSecurity.addUser(JetspeedSecurity.java:
238)
at
org.apache.jetspeed.modules.actions.portlets.security.UserUpdateAction.doIns
ert(UserUpdateAction.java:256)
at java.lang.reflect.Method.invoke(Native Method)
at
org.apache.turbine.util.velocity.VelocityActionEvent.executeEvents(VelocityA
ctionEvent.java:159)
at
org.apache.jetspeed.modules.actions.portlets.VelocityPortletAction.perform(V
elocityPortletAction.java:140)
at
org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122)
at
org.apache.turbine.modules.pages.DefaultPage.doBuild(DefaultPage.java:143)
at org.apache.turbine.modules.Page.build(Page.java:90)
at org.apache.turbine.modules.PageLoader.exec(PageLoader.java:123)
at org.apache.turbine.Turbine.doGet(Turbine.java:563)
at org.apache.turbine.Turbine.doPost(Turbine.java:658)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(Servle
tStubImpl.java:945)
at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java
:332)
at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java
:242)
at
weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(W
ebAppServletContext.java:5363)
at
weblogic.security.service.SecurityServiceManager.runAs(SecurityServiceManage
r.java:721)
at
weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletCo
ntext.java:3043)
at
weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java
:2466)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:152)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:133)
rethrown as org.apache.torque.TorqueException: ORA-01465: invalid hex number
at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:729)
at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:615)
at
org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.doInsert(BaseTur
bineUserPeer.java:302)
at
org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.doInsert(BaseTur
bineUserPeer.java:275)
at
org.apache.jetspeed.services.security.turbine.TurbineUserManagement.addUser(
TurbineUserManagement.java:309)
rethrown as
org.apache.jetspeed.services.security.UserException: Failed to create
account 'moabin': ORA-01465: invalid hex number
at
org.apache.jetspeed.services.security.turbine.TurbineUserManagement.addUser(
TurbineUserManagement.java:316)
at
org.apache.jetspeed.services.JetspeedUserManagement.addUser(JetspeedUserMana
gement.java:134)
at
org.apache.jetspeed.services.JetspeedSecurity.addUser(JetspeedSecurity.java:
238)
at
org.apache.jetspeed.modules.actions.portlets.security.UserUpdateAction.doIns
ert(UserUpdateAction.java:256)
at java.lang.reflect.Method.invoke(Native Method)
at
org.apache.turbine.util.velocity.VelocityActionEvent.executeEvents(VelocityA
ctionEvent.java:159)
at
org.apache.jetspeed.modules.actions.portlets.VelocityPortletAction.perform(V
elocityPortletAction.java:140)
at
org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122)
at
org.apache.turbine.modules.pages.DefaultPage.doBuild(DefaultPage.java:143)
at org.apache.turbine.modules.Page.build(Page.java:90)
at org.apache.turbine.modules.PageLoader.exec(PageLoader.java:123)
at org.apache.turbine.Turbine.doGet(Turbine.java:563)
at org.apache.turbine.Turbine.doPost(Turbine.java:658)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(Servle
tStubImpl.java:945)
at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java
:332)
at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java
:242)
at
weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(W
ebAppServletContext.java:5363)
at
weblogic.security.service.SecurityServiceManager.runAs(SecurityServiceManage
r.java:721)
at
weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletCo
ntext.java:3043)
at
weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java
:2466)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:152)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:133)
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>