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 Mahaveer Jain <mj...@gmail.com> on 2006/11/04 20:46:08 UTC
Jetspeed 1.6 MSSQL not able to login
I have installed Jetspeed with MSSQL and when I login as turbine, I am
getting this error. I am not able to get it work by changing the column to
text. Has anyone got this error and how have you fixed that?
Thanks in Advance
Mahaveer
org.apache.torque.TorqueException: java.sql.SQLException: [Microsoft][ODBC
SQL Server Driver][SQL Server]String or binary data would be truncated. at
org.apache.torque.util.BasePeer.throwTorqueException(BasePeer.java:236) at
org.apache.torque.util.BasePeer.insertOrUpdateRecord(BasePeer.java:903) 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) at
org.apache.jetspeed.services.JetspeedUserManagement.saveUser(
JetspeedUserManagement.java:86) at
org.apache.jetspeed.services.JetspeedSecurity.saveUser(JetspeedSecurity.java:204)
at org.apache.jetspeed.modules.actions.JLoginUser.doPerform(JLoginUser.java:218)
at org.apache.turbine.modules.ActionEvent.perform(ActionEvent.java:148) at
org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122) at
org.apache.turbine.Turbine.doGet(Turbine.java:509) at
org.apache.turbine.Turbine.doPost(Turbine.java:658) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:709) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:252) at
org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:173) rethrown as
org.apache.jetspeed.services.security.UserException: Failed to save user
object : java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL
Server]String or binary data would be truncated. at
org.apache.jetspeed.services.security.turbine.TurbineUserManagement.saveUser
(TurbineUserManagement.java:250) at
org.apache.jetspeed.services.JetspeedUserManagement.saveUser(
JetspeedUserManagement.java:86) at
org.apache.jetspeed.services.JetspeedSecurity.saveUser(JetspeedSecurity.java:204)
at org.apache.jetspeed.modules.actions.JLoginUser.doPerform(JLoginUser.java:218)
at org.apache.turbine.modules.ActionEvent.perform(ActionEvent.java:148) at
org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122) at
org.apache.turbine.Turbine.doGet(Turbine.java:509) at
org.apache.turbine.Turbine.doPost(Turbine.java:658) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:709) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:252) at
org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:173) at
org.apache.catalina.core.StandardWrapperValve.invoke(
StandardWrapperValve.java:213) at
org.apache.catalina.core.StandardContextValve.invoke(
StandardContextValve.java:178) at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(
StandardEngineValve.java:107) at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection
(Http11BaseProtocol.java:664) at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(
PoolTcpEndpoint.java:527) at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(
LeaderFollowerWorkerThread.java:80) at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(
ThreadPool.java:684) at java.lang.Thread.run(Thread.java:595)
org.apache.torque.TorqueException: java.sql.SQLException: [Microsoft][ODBC
SQL Server Driver][SQL Server]String or binary data would be truncated. at
org.apache.torque.util.BasePeer.throwTorqueException(BasePeer.java:236) at
org.apache.torque.util.BasePeer.insertOrUpdateRecord(BasePeer.java:903) 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) at
org.apache.jetspeed.services.JetspeedUserManagement.saveUser(
JetspeedUserManagement.java:86) at
org.apache.jetspeed.services.JetspeedSecurity.saveUser(JetspeedSecurity.java:204)
at org.apache.jetspeed.modules.actions.JLoginUser.doPerform(JLoginUser.java:218)
at org.apache.turbine.modules.ActionEvent.perform(ActionEvent.java:148) at
org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122) at
org.apache.turbine.Turbine.doGet(Turbine.java:509) at
org.apache.turbine.Turbine.doPost(Turbine.java:658) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:709) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:252) at
org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:173) rethrown as
org.apache.jetspeed.services.security.UserException: Failed to save user
object : java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL
Server]String or binary data would be truncated. at
org.apache.jetspeed.services.security.turbine.TurbineUserManagement.saveUser
(TurbineUserManagement.java:250) at
org.apache.jetspeed.services.JetspeedUserManagement.saveUser(
JetspeedUserManagement.java:86) at
org.apache.jetspeed.services.JetspeedSecurity.saveUser(JetspeedSecurity.java:204)
at org.apache.jetspeed.modules.actions.JLoginUser.doPerform(JLoginUser.java:218)
at org.apache.turbine.modules.ActionEvent.perform(ActionEvent.java:148) at
org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122) at
org.apache.turbine.Turbine.doGet(Turbine.java:509) at
org.apache.turbine.Turbine.doPost(Turbine.java:658) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:709) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:252) at
org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:173) at
org.apache.catalina.core.StandardWrapperValve.invoke(
StandardWrapperValve.java:213) at
org.apache.catalina.core.StandardContextValve.invoke(
StandardContextValve.java:178) at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(
StandardEngineValve.java:107) at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection
(Http11BaseProtocol.java:664) at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(
PoolTcpEndpoint.java:527) at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(
LeaderFollowerWorkerThread.java:80) at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(
ThreadPool.java:684) at java.lang.Thread.run(Thread.java:595)
Re: Jetspeed 1.6 MSSQL not able to login
Posted by Mahaveer Jain <mj...@gmail.com>.
Thanks Hans for the answer.
I have changed the jetspeed-torque-1.6.jar file for mssql. And when I try:
torque.dsfactory.default.connection.driver = sun.jdbc.odbc.JdbcOdbcDriver
torque.dsfactory.default.connection.url = jdbc:odbc:MOVOCO_V02
torque.dsfactory.default.connection.user = sa
torque.dsfactory.default.connection.password =
I get the same error as in my first message.
When I try with
torque.dsfactory.default.connection.driver = net.avenir.jdbc3.Driver
torque.dsfactory.default.connection.url = jdbc:
AvenirDriver://localhost:1433/MOVOCO_V02
torque.dsfactory.default.connection.user = sa
torque.dsfactory.default.connection.password =
I am getting this error
There has been an Error!
Reason:
org.apache.jetspeed.om.profile.ProfileException:
java.lang.NullPointerException
Does anyone have solution for this?
Thanks in advance
Mahaveer
On 11/6/06, Mahaveer Jain <mj...@gmail.com> wrote:
>
> It is working fine with MySQL. I had to change the field Objectdata in
> turbine_user from binary to text. In MSSQL I am not able to find a datatype
> which can store binary data greater than 8000.
>
> Mahaveer
>
> On 11/6/06, Hans Plum <pl...@lat-lon.de> wrote:
> >
> > Hi Mahaveer,
> >
> > just a tip of mine: I am also struggling with backends other than hsql,
> > Oracle.
> > Did you follow the document at
> > http://portals.apache.org/jetspeed-1/install.html#Database_Configuration
> > ? Be
> > aware to replace the torque bindings described in more detail at
> > http://portals.apache.org/jetspeed-1/database.html
> >
> > Hans
> >
> > Mahaveer Jain wrote:
> > > I have installed Jetspeed with MSSQL and when I login as turbine, I am
> > > getting this error. I am not able to get it work by changing the
> > column to
> > > text. Has anyone got this error and how have you fixed that?
> > >
> > > Thanks in Advance
> > > Mahaveer
> > >
> > > org.apache.torque.TorqueException: java.sql.SQLException:
> > [Microsoft][ODBC
> > > SQL Server Driver][SQL Server]String or binary data would be
> > truncated. at
> > > org.apache.torque.util.BasePeer.throwTorqueException(BasePeer.java:236)
> > at
> > > org.apache.torque.util.BasePeer.insertOrUpdateRecord(BasePeer.java:903)
> > 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) at
> > > org.apache.jetspeed.services.JetspeedUserManagement.saveUser (
> > > JetspeedUserManagement.java:86) at
> > > org.apache.jetspeed.services.JetspeedSecurity.saveUser(
> > JetspeedSecurity.java:204)
> > >
> > > at
> > > org.apache.jetspeed.modules.actions.JLoginUser.doPerform(
> > JLoginUser.java :218)
> > >
> > > at org.apache.turbine.modules.ActionEvent.perform(ActionEvent.java:148)
> > at
> > > org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122) at
> > > org.apache.turbine.Turbine.doGet(Turbine.java :509) at
> > > org.apache.turbine.Turbine.doPost(Turbine.java:658) at
> > > javax.servlet.http.HttpServlet.service(HttpServlet.java:709) at
> > > javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at
> > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
> > > ApplicationFilterChain.java:252) at
> > > org.apache.catalina.core.ApplicationFilterChain.doFilter(
> > > ApplicationFilterChain.java:173) rethrown as
> > > org.apache.jetspeed.services.security.UserException: Failed to save
> > user
> > > object : java.sql.SQLException: [Microsoft][ODBC SQL Server
> > Driver][SQL
> > > Server]String or binary data would be truncated. at
> > >
> > org.apache.jetspeed.services.security.turbine.TurbineUserManagement.saveUser
> > >
> > > (TurbineUserManagement.java:250) at
> > > org.apache.jetspeed.services.JetspeedUserManagement.saveUser(
> > > JetspeedUserManagement.java :86) at
> > > org.apache.jetspeed.services.JetspeedSecurity.saveUser(
> > JetspeedSecurity.java:204)
> > >
> > > at
> > > org.apache.jetspeed.modules.actions.JLoginUser.doPerform(
> > JLoginUser.java:218)
> > >
> > > at org.apache.turbine.modules.ActionEvent.perform(ActionEvent.java:148)
> > at
> > > org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122) at
> > > org.apache.turbine.Turbine.doGet(Turbine.java:509) at
> > > org.apache.turbine.Turbine.doPost(Turbine.java:658) at
> > > javax.servlet.http.HttpServlet.service(HttpServlet.java:709) at
> > > javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at
> > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (
> > > ApplicationFilterChain.java:252) at
> > > org.apache.catalina.core.ApplicationFilterChain.doFilter(
> > > ApplicationFilterChain.java:173) at
> > > org.apache.catalina.core.StandardWrapperValve.invoke(
> > > StandardWrapperValve.java:213) at
> > > org.apache.catalina.core.StandardContextValve.invoke(
> > > StandardContextValve.java:178) at
> > > org.apache.catalina.core.StandardHostValve.invoke(
> > StandardHostValve.java :126)
> > >
> > > at
> > > org.apache.catalina.valves.ErrorReportValve.invoke(
> > ErrorReportValve.java:105)
> > >
> > > at org.apache.catalina.core.StandardEngineValve.invoke(
> > > StandardEngineValve.java:107) at
> > > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java
> > :148)
> > > at
> > > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
> > :869)
> > > at
> > >
> > org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection
> > >
> > > (Http11BaseProtocol.java:664) at
> > > org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(
> > > PoolTcpEndpoint.java:527) at
> > > org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(
> > > LeaderFollowerWorkerThread.java:80) at
> > > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(
> > > ThreadPool.java:684) at java.lang.Thread.run(Thread.java:595)
> > >
> > > org.apache.torque.TorqueException : java.sql.SQLException:
> > [Microsoft][ODBC
> > > SQL Server Driver][SQL Server]String or binary data would be
> > truncated. at
> > > org.apache.torque.util.BasePeer.throwTorqueException(BasePeer.java:236)
> > at
> > > org.apache.torque.util.BasePeer.insertOrUpdateRecord (BasePeer.java:903)
> > 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) at
> > > org.apache.jetspeed.services.JetspeedUserManagement.saveUser(
> > > JetspeedUserManagement.java:86) at
> > > org.apache.jetspeed.services.JetspeedSecurity.saveUser (
> > JetspeedSecurity.java:204)
> > >
> > > at
> > > org.apache.jetspeed.modules.actions.JLoginUser.doPerform(
> > JLoginUser.java:218)
> > >
> > > at org.apache.turbine.modules.ActionEvent.perform(ActionEvent.java:148)
> > at
> > > org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122) at
> > > org.apache.turbine.Turbine.doGet(Turbine.java:509) at
> > > org.apache.turbine.Turbine.doPost(Turbine.java:658) at
> > > javax.servlet.http.HttpServlet.service (HttpServlet.java:709) at
> > > javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at
> > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
> > > ApplicationFilterChain.java:252) at
> > > org.apache.catalina.core.ApplicationFilterChain.doFilter(
> > > ApplicationFilterChain.java:173) rethrown as
> > > org.apache.jetspeed.services.security.UserException: Failed to save
> > user
> > > object : java.sql.SQLException : [Microsoft][ODBC SQL Server
> > Driver][SQL
> > > Server]String or binary data would be truncated. at
> > >
> > org.apache.jetspeed.services.security.turbine.TurbineUserManagement.saveUser
> > >
> > > (TurbineUserManagement.java :250) at
> > > org.apache.jetspeed.services.JetspeedUserManagement.saveUser(
> > > JetspeedUserManagement.java:86) at
> > > org.apache.jetspeed.services.JetspeedSecurity.saveUser(
> > JetspeedSecurity.java:204)
> > >
> > > at
> > > org.apache.jetspeed.modules.actions.JLoginUser.doPerform(
> > JLoginUser.java:218)
> > >
> > > at org.apache.turbine.modules.ActionEvent.perform(ActionEvent.java:148)
> > at
> > > org.apache.turbine.modules.ActionLoader.exec (ActionLoader.java:122)
> > at
> > > org.apache.turbine.Turbine.doGet(Turbine.java:509) at
> > > org.apache.turbine.Turbine.doPost(Turbine.java:658) at
> > > javax.servlet.http.HttpServlet.service(HttpServlet.java:709) at
> > > javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at
> > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
> > > ApplicationFilterChain.java:252) at
> > > org.apache.catalina.core.ApplicationFilterChain.doFilter (
> > > ApplicationFilterChain.java:173) at
> > > org.apache.catalina.core.StandardWrapperValve.invoke(
> > > StandardWrapperValve.java:213) at
> > > org.apache.catalina.core.StandardContextValve.invoke(
> > > StandardContextValve.java :178) at
> > > org.apache.catalina.core.StandardHostValve.invoke(
> > StandardHostValve.java:126)
> > >
> > > at
> > > org.apache.catalina.valves.ErrorReportValve.invoke(
> > ErrorReportValve.java:105)
> > >
> > > at org.apache.catalina.core.StandardEngineValve.invoke (
> > > StandardEngineValve.java:107) at
> > > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java
> > :148)
> > > at
> > > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
> > :869)
> > > at
> > >
> > org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection
> > >
> > > (Http11BaseProtocol.java:664) at
> > > org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(
> > > PoolTcpEndpoint.java:527) at
> > > org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(
> > > LeaderFollowerWorkerThread.java:80) at
> > > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(
> > > ThreadPool.java:684) at java.lang.Thread.run(Thread.java:595)
> > >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
> > For additional commands, e-mail: jetspeed-user-help@portals.apache.org
> >
> >
>
Re: Jetspeed 1.6 MSSQL not able to login
Posted by Mahaveer Jain <mj...@gmail.com>.
It is working fine with MySQL. I had to change the field Objectdata in
turbine_user from binary to text. In MSSQL I am not able to find a datatype
which can store binary data greater than 8000.
Mahaveer
On 11/6/06, Hans Plum <pl...@lat-lon.de> wrote:
>
> Hi Mahaveer,
>
> just a tip of mine: I am also struggling with backends other than hsql,
> Oracle.
> Did you follow the document at
> http://portals.apache.org/jetspeed-1/install.html#Database_Configuration ?
> Be
> aware to replace the torque bindings described in more detail at
> http://portals.apache.org/jetspeed-1/database.html
>
> Hans
>
> Mahaveer Jain wrote:
> > I have installed Jetspeed with MSSQL and when I login as turbine, I am
> > getting this error. I am not able to get it work by changing the column
> to
> > text. Has anyone got this error and how have you fixed that?
> >
> > Thanks in Advance
> > Mahaveer
> >
> > org.apache.torque.TorqueException: java.sql.SQLException:
> [Microsoft][ODBC
> > SQL Server Driver][SQL Server]String or binary data would be truncated.
> at
> > org.apache.torque.util.BasePeer.throwTorqueException(BasePeer.java:236)
> at
> > org.apache.torque.util.BasePeer.insertOrUpdateRecord(BasePeer.java:903)
> 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) at
> > org.apache.jetspeed.services.JetspeedUserManagement.saveUser(
> > JetspeedUserManagement.java:86) at
> > org.apache.jetspeed.services.JetspeedSecurity.saveUser(
> JetspeedSecurity.java:204)
> >
> > at
> > org.apache.jetspeed.modules.actions.JLoginUser.doPerform(JLoginUser.java
> :218)
> >
> > at org.apache.turbine.modules.ActionEvent.perform(ActionEvent.java:148)
> at
> > org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122) at
> > org.apache.turbine.Turbine.doGet(Turbine.java:509) at
> > org.apache.turbine.Turbine.doPost(Turbine.java:658) at
> > javax.servlet.http.HttpServlet.service(HttpServlet.java:709) at
> > javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at
> > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
> > ApplicationFilterChain.java:252) at
> > org.apache.catalina.core.ApplicationFilterChain.doFilter(
> > ApplicationFilterChain.java:173) rethrown as
> > org.apache.jetspeed.services.security.UserException: Failed to save user
> > object : java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL
> > Server]String or binary data would be truncated. at
> >
> org.apache.jetspeed.services.security.turbine.TurbineUserManagement.saveUser
> >
> > (TurbineUserManagement.java:250) at
> > org.apache.jetspeed.services.JetspeedUserManagement.saveUser(
> > JetspeedUserManagement.java:86) at
> > org.apache.jetspeed.services.JetspeedSecurity.saveUser(
> JetspeedSecurity.java:204)
> >
> > at
> > org.apache.jetspeed.modules.actions.JLoginUser.doPerform(JLoginUser.java
> :218)
> >
> > at org.apache.turbine.modules.ActionEvent.perform(ActionEvent.java:148)
> at
> > org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122) at
> > org.apache.turbine.Turbine.doGet(Turbine.java:509) at
> > org.apache.turbine.Turbine.doPost(Turbine.java:658) at
> > javax.servlet.http.HttpServlet.service(HttpServlet.java:709) at
> > javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at
> > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
> > ApplicationFilterChain.java:252) at
> > org.apache.catalina.core.ApplicationFilterChain.doFilter(
> > ApplicationFilterChain.java:173) at
> > org.apache.catalina.core.StandardWrapperValve.invoke(
> > StandardWrapperValve.java:213) at
> > org.apache.catalina.core.StandardContextValve.invoke(
> > StandardContextValve.java:178) at
> > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
> :126)
> >
> > at
> > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
> :105)
> >
> > at org.apache.catalina.core.StandardEngineValve.invoke(
> > StandardEngineValve.java:107) at
> > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java
> :148)
> > at
> > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
> :869)
> > at
> >
> org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection
> >
> > (Http11BaseProtocol.java:664) at
> > org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(
> > PoolTcpEndpoint.java:527) at
> > org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(
> > LeaderFollowerWorkerThread.java:80) at
> > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(
> > ThreadPool.java:684) at java.lang.Thread.run(Thread.java:595)
> >
> > org.apache.torque.TorqueException: java.sql.SQLException:
> [Microsoft][ODBC
> > SQL Server Driver][SQL Server]String or binary data would be truncated.
> at
> > org.apache.torque.util.BasePeer.throwTorqueException(BasePeer.java:236)
> at
> > org.apache.torque.util.BasePeer.insertOrUpdateRecord(BasePeer.java:903)
> 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) at
> > org.apache.jetspeed.services.JetspeedUserManagement.saveUser(
> > JetspeedUserManagement.java:86) at
> > org.apache.jetspeed.services.JetspeedSecurity.saveUser(
> JetspeedSecurity.java:204)
> >
> > at
> > org.apache.jetspeed.modules.actions.JLoginUser.doPerform(JLoginUser.java
> :218)
> >
> > at org.apache.turbine.modules.ActionEvent.perform(ActionEvent.java:148)
> at
> > org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122) at
> > org.apache.turbine.Turbine.doGet(Turbine.java:509) at
> > org.apache.turbine.Turbine.doPost(Turbine.java:658) at
> > javax.servlet.http.HttpServlet.service(HttpServlet.java:709) at
> > javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at
> > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
> > ApplicationFilterChain.java:252) at
> > org.apache.catalina.core.ApplicationFilterChain.doFilter(
> > ApplicationFilterChain.java:173) rethrown as
> > org.apache.jetspeed.services.security.UserException: Failed to save user
> > object : java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL
> > Server]String or binary data would be truncated. at
> >
> org.apache.jetspeed.services.security.turbine.TurbineUserManagement.saveUser
> >
> > (TurbineUserManagement.java:250) at
> > org.apache.jetspeed.services.JetspeedUserManagement.saveUser(
> > JetspeedUserManagement.java:86) at
> > org.apache.jetspeed.services.JetspeedSecurity.saveUser(
> JetspeedSecurity.java:204)
> >
> > at
> > org.apache.jetspeed.modules.actions.JLoginUser.doPerform(JLoginUser.java
> :218)
> >
> > at org.apache.turbine.modules.ActionEvent.perform(ActionEvent.java:148)
> at
> > org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122) at
> > org.apache.turbine.Turbine.doGet(Turbine.java:509) at
> > org.apache.turbine.Turbine.doPost(Turbine.java:658) at
> > javax.servlet.http.HttpServlet.service(HttpServlet.java:709) at
> > javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at
> > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
> > ApplicationFilterChain.java:252) at
> > org.apache.catalina.core.ApplicationFilterChain.doFilter(
> > ApplicationFilterChain.java:173) at
> > org.apache.catalina.core.StandardWrapperValve.invoke(
> > StandardWrapperValve.java:213) at
> > org.apache.catalina.core.StandardContextValve.invoke(
> > StandardContextValve.java:178) at
> > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
> :126)
> >
> > at
> > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
> :105)
> >
> > at org.apache.catalina.core.StandardEngineValve.invoke(
> > StandardEngineValve.java:107) at
> > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java
> :148)
> > at
> > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
> :869)
> > at
> >
> org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection
> >
> > (Http11BaseProtocol.java:664) at
> > org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(
> > PoolTcpEndpoint.java:527) at
> > org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(
> > LeaderFollowerWorkerThread.java:80) at
> > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(
> > ThreadPool.java:684) at java.lang.Thread.run(Thread.java:595)
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
> For additional commands, e-mail: jetspeed-user-help@portals.apache.org
>
>
Re: Jetspeed 1.6 MSSQL not able to login
Posted by Hans Plum <pl...@lat-lon.de>.
Hi Mahaveer,
just a tip of mine: I am also struggling with backends other than hsql, Oracle.
Did you follow the document at
http://portals.apache.org/jetspeed-1/install.html#Database_Configuration ? Be
aware to replace the torque bindings described in more detail at
http://portals.apache.org/jetspeed-1/database.html
Hans
Mahaveer Jain wrote:
> I have installed Jetspeed with MSSQL and when I login as turbine, I am
> getting this error. I am not able to get it work by changing the column to
> text. Has anyone got this error and how have you fixed that?
>
> Thanks in Advance
> Mahaveer
>
> org.apache.torque.TorqueException: java.sql.SQLException: [Microsoft][ODBC
> SQL Server Driver][SQL Server]String or binary data would be truncated. at
> org.apache.torque.util.BasePeer.throwTorqueException(BasePeer.java:236) at
> org.apache.torque.util.BasePeer.insertOrUpdateRecord(BasePeer.java:903) 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) at
> org.apache.jetspeed.services.JetspeedUserManagement.saveUser(
> JetspeedUserManagement.java:86) at
> org.apache.jetspeed.services.JetspeedSecurity.saveUser(JetspeedSecurity.java:204)
>
> at
> org.apache.jetspeed.modules.actions.JLoginUser.doPerform(JLoginUser.java:218)
>
> at org.apache.turbine.modules.ActionEvent.perform(ActionEvent.java:148) at
> org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122) at
> org.apache.turbine.Turbine.doGet(Turbine.java:509) at
> org.apache.turbine.Turbine.doPost(Turbine.java:658) at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:709) at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
> ApplicationFilterChain.java:252) at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:173) rethrown as
> org.apache.jetspeed.services.security.UserException: Failed to save user
> object : java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL
> Server]String or binary data would be truncated. at
> org.apache.jetspeed.services.security.turbine.TurbineUserManagement.saveUser
>
> (TurbineUserManagement.java:250) at
> org.apache.jetspeed.services.JetspeedUserManagement.saveUser(
> JetspeedUserManagement.java:86) at
> org.apache.jetspeed.services.JetspeedSecurity.saveUser(JetspeedSecurity.java:204)
>
> at
> org.apache.jetspeed.modules.actions.JLoginUser.doPerform(JLoginUser.java:218)
>
> at org.apache.turbine.modules.ActionEvent.perform(ActionEvent.java:148) at
> org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122) at
> org.apache.turbine.Turbine.doGet(Turbine.java:509) at
> org.apache.turbine.Turbine.doPost(Turbine.java:658) at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:709) at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
> ApplicationFilterChain.java:252) at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:173) at
> org.apache.catalina.core.StandardWrapperValve.invoke(
> StandardWrapperValve.java:213) at
> org.apache.catalina.core.StandardContextValve.invoke(
> StandardContextValve.java:178) at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
>
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
>
> at org.apache.catalina.core.StandardEngineValve.invoke(
> StandardEngineValve.java:107) at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
> at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
> at
> org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection
>
> (Http11BaseProtocol.java:664) at
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(
> PoolTcpEndpoint.java:527) at
> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(
> LeaderFollowerWorkerThread.java:80) at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(
> ThreadPool.java:684) at java.lang.Thread.run(Thread.java:595)
>
> org.apache.torque.TorqueException: java.sql.SQLException: [Microsoft][ODBC
> SQL Server Driver][SQL Server]String or binary data would be truncated. at
> org.apache.torque.util.BasePeer.throwTorqueException(BasePeer.java:236) at
> org.apache.torque.util.BasePeer.insertOrUpdateRecord(BasePeer.java:903) 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) at
> org.apache.jetspeed.services.JetspeedUserManagement.saveUser(
> JetspeedUserManagement.java:86) at
> org.apache.jetspeed.services.JetspeedSecurity.saveUser(JetspeedSecurity.java:204)
>
> at
> org.apache.jetspeed.modules.actions.JLoginUser.doPerform(JLoginUser.java:218)
>
> at org.apache.turbine.modules.ActionEvent.perform(ActionEvent.java:148) at
> org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122) at
> org.apache.turbine.Turbine.doGet(Turbine.java:509) at
> org.apache.turbine.Turbine.doPost(Turbine.java:658) at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:709) at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
> ApplicationFilterChain.java:252) at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:173) rethrown as
> org.apache.jetspeed.services.security.UserException: Failed to save user
> object : java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL
> Server]String or binary data would be truncated. at
> org.apache.jetspeed.services.security.turbine.TurbineUserManagement.saveUser
>
> (TurbineUserManagement.java:250) at
> org.apache.jetspeed.services.JetspeedUserManagement.saveUser(
> JetspeedUserManagement.java:86) at
> org.apache.jetspeed.services.JetspeedSecurity.saveUser(JetspeedSecurity.java:204)
>
> at
> org.apache.jetspeed.modules.actions.JLoginUser.doPerform(JLoginUser.java:218)
>
> at org.apache.turbine.modules.ActionEvent.perform(ActionEvent.java:148) at
> org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122) at
> org.apache.turbine.Turbine.doGet(Turbine.java:509) at
> org.apache.turbine.Turbine.doPost(Turbine.java:658) at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:709) at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
> ApplicationFilterChain.java:252) at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:173) at
> org.apache.catalina.core.StandardWrapperValve.invoke(
> StandardWrapperValve.java:213) at
> org.apache.catalina.core.StandardContextValve.invoke(
> StandardContextValve.java:178) at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
>
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
>
> at org.apache.catalina.core.StandardEngineValve.invoke(
> StandardEngineValve.java:107) at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
> at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
> at
> org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection
>
> (Http11BaseProtocol.java:664) at
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(
> PoolTcpEndpoint.java:527) at
> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(
> LeaderFollowerWorkerThread.java:80) at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(
> ThreadPool.java:684) at java.lang.Thread.run(Thread.java:595)
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-user-help@portals.apache.org