db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bogdan Vatkov" <bvat...@globaltech-bg.com>
Subject Re: IDBroker broken ?
Date Thu, 11 Dec 2003 11:09:08 GMT
Hi Siegfried,

You may be right ...i have used tableType = MyISAM
I have set the tableType to InnoDB:

InnoDB tables -- Stable (in 3.23 from 3.23.49)
The InnoDB transactional storage engine has been declared stable in the
MySQL 3.23 tree, starting from version 3.23.49. InnoDB is being used in
large, heavy-load production systems.

And now the error is different:
(after the error  SELECT count(*) FROM `user` gives 91900 records)

java.sql.SQLException: General error,  message from server: "Column 'id'
cannot be null"

 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1626)

 at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:886)

 at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:945)

 at com.mysql.jdbc.Connection.execSQL(Connection.java:1844)

 at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1602)

 at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1488)

 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:899)

 at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:742)

 at edu.tu.fksu.BusinessObjects.BaseUserPeer.doInsert(BaseUserPeer.java:242)

 at edu.tu.fksu.BusinessObjects.BaseUserPeer.doInsert(BaseUserPeer.java:606)

 at edu.tu.fksu.BusinessObjects.BaseUser.save(BaseUser.java:1372)

 at edu.tu.fksu.BusinessObjects.BaseUser.save(BaseUser.java:1336)

 at edu.tu.fksu.BusinessObjects.BaseUser.save(BaseUser.java:1316)

 at
edu.tu.fksu.WebComponents.UserManagement.BaseUserEdit.actualizeCustom(BaseUs
erEdit.java:75)

 at edu.tu.fksu.Weblication.Actualizable.actualize(Actualizable.java:70)

 at org.apache.jsp.User_edit_jsp._jspService(User_edit_jsp.java:79)

 at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137)

 at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

 at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:2
10)

 at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)

 at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)

 at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

 at
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.
java:684)

 at
org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatch
er.java:575)

 at
org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher
.java:498)

 at
org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:8
22)

 at org.apache.jsp.index_jsp._jspService(index_jsp.java:141)

 at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137)

 at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

 at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:2
10)

 at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)

 at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)

 at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

 at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:247)

 at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:193)

 at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:256)

 at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)

 at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)

 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)

 at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:191)

 at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)

 at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)

 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)

 at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)

 at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180
)

 at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)

 at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.
java:171)

 at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)

 at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172
)

 at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)

 at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)

 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)

 at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
:174)

 at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)

 at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)

 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)

 at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)

 at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:594)

 at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne
ction(Http11Protocol.java:392)

 at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)

 at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
a:619)

 at java.lang.Thread.run(Thread.java:536)

rethrown as org.apache.torque.TorqueException: General error,  message from
server: "Column 'id' cannot be null"

 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.doInsert(BasePeer.java:742)

 at edu.tu.fksu.BusinessObjects.BaseUserPeer.doInsert(BaseUserPeer.java:242)

 at edu.tu.fksu.BusinessObjects.BaseUserPeer.doInsert(BaseUserPeer.java:606)

 at edu.tu.fksu.BusinessObjects.BaseUser.save(BaseUser.java:1372)

 at edu.tu.fksu.BusinessObjects.BaseUser.save(BaseUser.java:1336)

 at edu.tu.fksu.BusinessObjects.BaseUser.save(BaseUser.java:1316)

 at
edu.tu.fksu.WebComponents.UserManagement.BaseUserEdit.actualizeCustom(BaseUs
erEdit.java:75)

 at edu.tu.fksu.Weblication.Actualizable.actualize(Actualizable.java:70)

 at org.apache.jsp.User_edit_jsp._jspService(User_edit_jsp.java:79)

 at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137)

 at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

 at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:2
10)

 at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)

 at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)

 at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

 at
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.
java:684)

 at
org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatch
er.java:575)

 at
org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher
.java:498)

 at
org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:8
22)

 at org.apache.jsp.index_jsp._jspService(index_jsp.java:141)

 at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137)

 at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

 at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:2
10)

 at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)

 at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)

 at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

 at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:247)

 at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:193)

 at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:256)

 at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)

 at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)

 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)

 at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:191)

 at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)

 at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)

 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)

 at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)

 at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180
)

 at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)

 at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.
java:171)

 at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)

 at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172
)

 at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)

 at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)

 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)

 at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
:174)

 at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)

 at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)

 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)

 at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)

 at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:594)

 at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne
ction(Http11Protocol.java:392)

 at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)

 at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
a:619)

 at java.lang.Thread.run(Thread.java:536)

Caused by: java.sql.SQLException: General error,  message from server:
"Column 'id' cannot be null"

 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1626)

 at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:886)

 at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:945)

 at com.mysql.jdbc.Connection.execSQL(Connection.java:1844)

 at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1602)

 at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1488)

 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:899)

 ... 55 more

With best regards,
Bogdan




---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message