Andras,

Many thanks for the quick reply,
after fixing the adapter config issue now the ms-jdbc driver is complaining:
org.apache.torque.TorqueException: [Microsoft][SQLServer 2000 Driver for
JDBC][SQLServer]
String or binary data would be truncated.
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for
JDBC][SQLServer]
String or binary data would be truncated.
....

What driver are you using?
I'm using the Microsoft JDBC driver date stamped 4/19/2002 on
mssqlserver.jar

Steve

Complete stack trace:
*********************************************************
org.apache.torque.TorqueException: [Microsoft][SQLServer 2000 Driver for
JDBC][SQLServer]String or binary data would be truncated.
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for
JDBC][SQLServer]String or binary data would be truncated.
        at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
        at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
        at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown
Source)
        at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown
Source)
        at com.microsoft.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unknown
Source)
        at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
        at
com.microsoft.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknow
n Source)
        at com.microsoft.jdbc.base.BaseStatement.commonTransitionToState(Unknown
Source)
        at com.microsoft.jdbc.base.BaseStatement.postImplExecute(Unknown Source)
        at com.microsoft.jdbc.base.BasePreparedStatement.postImplExecute(Unknown
Source)
        at com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown Source)
        at com.microsoft.jdbc.base.BaseStatement.executeUpdateInternal(Unknown
Source)
        at com.microsoft.jdbc.base.BasePreparedStatement.executeUpdate(Unknown
Source)
        at com.workingdogs.village.Record.saveWithInsert(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:891)
        at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:725)
        at
com.neworder.om.BaseMyidenttablePeer.doInsert(BaseMyidenttablePeer.java:195)
        at
com.neworder.om.BaseMyidenttablePeer.doInsert(BaseMyidenttablePeer.java:480)
        at com.neworder.om.BaseMyidenttable.save(BaseMyidenttable.java:313)
        at com.neworder.om.BaseMyidenttable.save(BaseMyidenttable.java:275)
        at com.neworder.om.BaseMyidenttable.save(BaseMyidenttable.java:255)
        at com.neworder.TorqueTester.startIt(TorqueTester.java:40)
        at com.neworder.TorqueTester.main(TorqueTester.java:20)
rethrown as org.apache.torque.TorqueException: [Microsoft][SQLServer 2000
Driver for JDBC][SQLServer]String or binary data would be truncated.
        at org.apache.torque.util.BasePeer.insertOrUpdateRecord(BasePeer.java:895)
        at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:725)
        at
com.neworder.om.BaseMyidenttablePeer.doInsert(BaseMyidenttablePeer.java:195)
        at
com.neworder.om.BaseMyidenttablePeer.doInsert(BaseMyidenttablePeer.java:480)
        at com.neworder.om.BaseMyidenttable.save(BaseMyidenttable.java:313)
        at com.neworder.om.BaseMyidenttable.save(BaseMyidenttable.java:275)
        at com.neworder.om.BaseMyidenttable.save(BaseMyidenttable.java:255)
        at com.neworder.TorqueTester.startIt(TorqueTester.java:40)
        at com.neworder.TorqueTester.main(TorqueTester.java:20)
rethrown as org.apache.torque.TorqueException: [Microsoft][SQLServer 2000
Driver for JDBC][SQLServer]String or binary data would be truncated.
        at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:729)
        at
com.neworder.om.BaseMyidenttablePeer.doInsert(BaseMyidenttablePeer.java:195)
        at
com.neworder.om.BaseMyidenttablePeer.doInsert(BaseMyidenttablePeer.java:480)
        at com.neworder.om.BaseMyidenttable.save(BaseMyidenttable.java:313)
        at com.neworder.om.BaseMyidenttable.save(BaseMyidenttable.java:275)
        at com.neworder.om.BaseMyidenttable.save(BaseMyidenttable.java:255)
        at com.neworder.TorqueTester.startIt(TorqueTester.java:40)
        at com.neworder.TorqueTester.main(TorqueTester.java:20)
> -----Original Message-----
> From: Andras Balogh [mailto:[EMAIL PROTECTED]]
> Sent: Monday, November 18, 2002 11:41 AM
> To: Turbine Torque Users List
> Subject: Re: IdGenerator for table 'myIdentTable' is null
>
>
> Hi Steve,
>
> Same think happened to me and i had a hard time tracking it down :)
>
> It is a configuration issue:
>
> torque.database.bookstore.adapter=mssql
> should be
> torque.database.fcpmerrorreport.adapter=mssql
>
> Just let me know if you have problems because my config is pretty much the
> same.
>
> Best wishes,
>
> Andras.
>
>
>
>
> ----- Original Message -----
> From: "Steve Hansen" <[EMAIL PROTECTED]>
> To: "Turbine Torque Users List" <[EMAIL PROTECTED]>
> Sent: Monday, November 18, 2002 19:33
> Subject: IdGenerator for table 'myIdentTable' is null
>
>
> > Hello,
> >
> > I'm having trouble doing an insert using torque. My setup is:
> > torque-3.0-rc1
> > ant 1.5.1
> > jdk1.3.1_01
> > MS-SQL 2000 sp1
> >
> > The error I'm getting is:
> > org.apache.torque.TorqueException: IdGenerator for table
> 'myIdentTable' is
> > null
> > at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:690)
> > at
> >
> com.neworder.om.BaseMyidenttablePeer.doInsert(BaseMyidenttablePeer
> .java:195)
> > at
> >
> com.neworder.om.BaseMyidenttablePeer.doInsert(BaseMyidenttablePeer
> .java:480)
> > at com.neworder.om.BaseMyidenttable.save(BaseMyidenttable.java:313)
> > at com.neworder.om.BaseMyidenttable.save(BaseMyidenttable.java:275)
> > at com.neworder.om.BaseMyidenttable.save(BaseMyidenttable.java:255)
> > at com.neworder.TorqueTester.startIt(TorqueTester.java:40)
> > at com.neworder.TorqueTester.main(TorqueTester.java:20)
> >
>
>
>
> --
> To unsubscribe, e-mail:
> <mailto:[EMAIL PROTECTED]>
> For additional commands, e-mail:
> <mailto:[EMAIL PROTECTED]>
>
>


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

Reply via email to