portals-jetspeed-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From mike long <mike.l...@dataline.com>
Subject Re: Failed to save user object using MSSQL
Date Tue, 04 Jan 2005 17:29:06 GMT
I don't know what to tell you now. I hypothesize that your converting it 
to an image made it unparseable. Someone else will have to help with that.
Raghdan Rabah wrote:

>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: jetspeed-dev-unsubscribe@jakarta.apache.org
>>>>>For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>     
>>>>>
>>>>>          
>>>>>
>>>>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: jetspeed-dev-unsubscribe@jakarta.apache.org
>>>>For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org
>>>>   
>>>>
>>>>        
>>>>
>>>---------------------------------------------------------------------
>>>To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jakarta.apache.org
>>>For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org
>>>
>>>
>>> 
>>>
>>>      
>>>
>>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: jetspeed-dev-unsubscribe@jakarta.apache.org
>>For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org
>>    
>>
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org
>
>
>  
>


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


Mime
View raw message