Re: Failed to save user object using MSSQL

[mike long]

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: [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]
 


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]