Hello, I did changed OBJECTDATA field from binary to image and that error disappered; However, every user can log only once and then jetspeed starts giving -Invalid user name and/or password. Please reenter your credentials- for any user has loged once before.
On Tue, 04 Jan 2005 09:59:47 -0500, mike long wrote > 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
