Raghdan Rabah wrote:
Hello,
And thanks for reply.
Maybe it is the OBJECTDATA field? which field shall I modify?
------------------------ the TURBINE_USER Table is
FIRST_NAME varchar 99 0
LAST_NAME varchar 99 0
EMAIL varchar 99 1
CONFIRM_VALUE varchar 99 1
MODIFIED datetime 8
CREATED datetime 8 1
LAST_LOGIN datetime 8
DISABLED char 1 1
OBJECTDATA binary 7132 1
PASSWORD_CHANGED datetime
----------------------------------the eeror is-->
Reason:
org.apache.jetspeed.services.security.UserException: Failed to save
user object : [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary
data would be truncated.
Stacktrace:
java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL
Server]String or binary data would be truncated.
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115)
at sun.jdbc.odbc.JdbcOdbc.SQLParamData(JdbcOdbc.java:4738)
at sun.jdbc.odbc.JdbcOdbcPreparedStatement.execute
(JdbcOdbcPreparedStatement.java:225)
at sun.jdbc.odbc.JdbcOdbcPreparedStatement.executeUpdate
(JdbcOdbcPreparedStatement.java:136)
at com.workingdogs.village.Record.saveWithUpdate(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:899)
at org.apache.torque.util.BasePeer.doUpdate(BasePeer.java:1940)
at org.apache.torque.util.BasePeer.doUpdate(BasePeer.java:1835)
at
org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.doUpdate
(BaseTurbineUserPeer.java:501)
at
org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.doUpdate
(BaseTurbineUserPeer.java:471)
at
org.apache.jetspeed.services.security.turbine.TurbineUserManagement.saveUser
(TurbineUserManagement.java:245)
----------------------------------------------
On Tue, 04 Jan 2005 09:33:51 -0500, mike long wrote
Raghdan Rabah wrote:
Hello,
I have Jetspeed working with MySQL.
However, when I am trying MSSQL 2000 with SP3 and Jetspeed 1.5.
Jetspeed could read the data but could not modify any record and gives:
org.apache.jetspeed.services.security.UserException: Failed to save user
object : [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary
data
would be truncated.
Any help in how to solve this.
Regards
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Sounds like some of the data you are saving to the user table is too
long. The message does not say specifically which field, but I would
try making every field as small as possible. Apparently the form
into which you are typing data does not have proper editing.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
The error message does not say. If you are sure that your other field
lengths have not exceeded the length threshhold then you should try
objectdata. However, I don't know what is getting put into that field.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
