[
https://issues.apache.org/jira/browse/DAYTRADER-80?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12934885#action_12934885
]
Yannick LE NY commented on DAYTRADER-80:
----------------------------------------
More logs :
15:18:07,178 ERROR [Log] Error: TradeDirect:register -- error registering new
user
java.lang.Exception: KeySequenceDirect:allocNewBlock - failure to
allocate new block of keys for Entity type:
accountcom.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
'TRADEDB.keygenejb' doesn't exist
15:18:07,180 INFO [STDOUT] java.lang.Exception:
KeySequenceDirect:allocNewBlock - failure to allocate new block of keys for
Entity type: accountcom.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
Table 'TRADEDB.keygenejb' doesn't exist
15:18:07,180 INFO [STDOUT] at
org.apache.geronimo.samples.daytrader.direct.KeySequenceDirect.allocNewBlock(KeySequenceDirect.java:101)
15:18:07,180 INFO [STDOUT] at
org.apache.geronimo.samples.daytrader.direct.KeySequenceDirect.getNextID(KeySequenceDirect.java:44)
15:18:07,181 INFO [STDOUT] at
org.apache.geronimo.samples.daytrader.direct.TradeDirect.register(TradeDirect.java:1573)
15:18:07,181 INFO [STDOUT] at
org.apache.geronimo.samples.daytrader.TradeAction.register(TradeAction.java:513)
15:18:07,181 INFO [STDOUT] at
org.apache.geronimo.samples.daytrader.web.TradeBuildDB.<init>(TradeBuildDB.java:212)
15:18:07,181 INFO [STDOUT] at
org.apache.geronimo.samples.daytrader.web.TradeConfigServlet.service(TradeConfigServlet.java:408)
15:18:07,181 INFO [STDOUT] at
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
15:18:07,181 INFO [STDOUT] at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
15:18:07,181 INFO [STDOUT] at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
15:18:07,181 INFO [STDOUT] at
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
15:18:07,181 INFO [STDOUT] at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
15:18:07,181 INFO [STDOUT] at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
15:18:07,181 INFO [STDOUT] at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)
15:18:07,181 INFO [STDOUT] at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
15:18:07,181 INFO [STDOUT] at
org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:183)
15:18:07,181 INFO [STDOUT] at
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:95)
15:18:07,181 INFO [STDOUT] at
org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)
15:18:07,181 INFO [STDOUT] at
org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)
15:18:07,181 INFO [STDOUT] at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
15:18:07,181 INFO [STDOUT] at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
15:18:07,181 INFO [STDOUT] at
org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)
15:18:07,182 INFO [STDOUT] at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
15:18:07,182 INFO [STDOUT] at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)
15:18:07,182 INFO [STDOUT] at
org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:905)
15:18:07,182 INFO [STDOUT] at
org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:592)
15:18:07,182 INFO [STDOUT] at
org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:2036)
15:18:07,182 INFO [STDOUT] at java.lang.Thread.run(Thread.java:662)
15:18:07,184 ERROR [Log] Error: KeySequenceDirect:allocNewBlock - failure to
allocate new block of keys for Entity type: account
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
'TRADEDB.keygenejb' doesn't exist
15:18:07,184 INFO [STDOUT]
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
'TRADEDB.keygenejb' doesn't exist
15:18:07,185 INFO [STDOUT] at
sun.reflect.GeneratedConstructorAccessor147.newInstance(Unknown Source)
15:18:07,185 INFO [STDOUT] at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
15:18:07,185 INFO [STDOUT] at
java.lang.reflect.Constructor.newInstance(Constructor.java:513)
15:18:07,185 INFO [STDOUT] at
com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
15:18:07,185 INFO [STDOUT] at
com.mysql.jdbc.Util.getInstance(Util.java:384)
15:18:07,185 INFO [STDOUT] at
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
15:18:07,185 INFO [STDOUT] at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3566)
15:18:07,185 INFO [STDOUT] at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498)
15:18:07,185 INFO [STDOUT] at
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
15:18:07,185 INFO [STDOUT] at
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)
15:18:07,185 INFO [STDOUT] at
com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)
15:18:07,185 INFO [STDOUT] at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2113)
15:18:07,185 INFO [STDOUT] at
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2275)
15:18:07,185 INFO [STDOUT] at
org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:342)
15:18:07,185 INFO [STDOUT] at
org.apache.geronimo.samples.daytrader.direct.KeySequenceDirect.allocNewBlock(KeySequenceDirect.java:65)
15:18:07,185 INFO [STDOUT] at
org.apache.geronimo.samples.daytrader.direct.KeySequenceDirect.getNextID(KeySequenceDirect.java:44)
15:18:07,185 INFO [STDOUT] at
org.apache.geronimo.samples.daytrader.direct.TradeDirect.register(TradeDirect.java:1573)
15:18:07,185 INFO [STDOUT] at
org.apache.geronimo.samples.daytrader.TradeAction.register(TradeAction.java:513)
15:18:07,185 INFO [STDOUT] at
org.apache.geronimo.samples.daytrader.web.TradeBuildDB.<init>(TradeBuildDB.java:212)
15:18:07,186 INFO [STDOUT] at
org.apache.geronimo.samples.daytrader.web.TradeConfigServlet.service(TradeConfigServlet.java:408)
15:18:07,186 INFO [STDOUT] at
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
15:18:07,186 INFO [STDOUT] at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
15:18:07,186 INFO [STDOUT] at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
15:18:07,186 INFO [STDOUT] at
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
15:18:07,186 INFO [STDOUT] at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
15:18:07,186 INFO [STDOUT] at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
15:18:07,186 INFO [STDOUT] at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)
15:18:07,186 INFO [STDOUT] at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
15:18:07,186 INFO [STDOUT] at
org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:183)
15:18:07,186 INFO [STDOUT] at
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:95)
15:18:07,186 INFO [STDOUT] at
org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)
15:18:07,186 INFO [STDOUT] at
org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)
15:18:07,186 INFO [STDOUT] at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
15:18:07,186 INFO [STDOUT] at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
15:18:07,186 INFO [STDOUT] at
org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)
15:18:07,186 INFO [STDOUT] at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
15:18:07,187 INFO [STDOUT] at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)
15:18:07,187 INFO [STDOUT] at
org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:905)
15:18:07,187 INFO [STDOUT] at
org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:592)
15:18:07,187 INFO [STDOUT] at
org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:2036)
15:18:07,187 INFO [STDOUT] at java.lang.Thread.run(Thread.java:662)
15:18:07,187 INFO [STDOUT]
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
'TRADEDB.keygenejb' doesn't exist
15:18:07,187 INFO [STDOUT] at
sun.reflect.GeneratedConstructorAccessor147.newInstance(Unknown Source)
15:18:07,187 INFO [STDOUT] at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
15:18:07,187 INFO [STDOUT] at
java.lang.reflect.Constructor.newInstance(Constructor.java:513)
15:18:07,187 INFO [STDOUT] at
com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
15:18:07,187 INFO [STDOUT] at
com.mysql.jdbc.Util.getInstance(Util.java:384)
15:18:07,187 INFO [STDOUT] at
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
15:18:07,187 INFO [STDOUT] at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3566)
15:18:07,187 INFO [STDOUT] at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498)
15:18:07,187 INFO [STDOUT] at
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
15:18:07,187 INFO [STDOUT] at
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)
15:18:07,187 INFO [STDOUT] at
com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)
15:18:07,187 INFO [STDOUT] at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2113)
15:18:07,187 INFO [STDOUT] at
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2275)
15:18:07,187 INFO [STDOUT] at
org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:342)
15:18:07,187 INFO [STDOUT] at
org.apache.geronimo.samples.daytrader.direct.KeySequenceDirect.allocNewBlock(KeySequenceDirect.java:65)
15:18:07,187 INFO [STDOUT] at
org.apache.geronimo.samples.daytrader.direct.KeySequenceDirect.getNextID(KeySequenceDirect.java:44)
15:18:07,187 INFO [STDOUT] at
org.apache.geronimo.samples.daytrader.direct.TradeDirect.register(TradeDirect.java:1573)
15:18:07,188 INFO [STDOUT] at
org.apache.geronimo.samples.daytrader.TradeAction.register(TradeAction.java:513)
15:18:07,188 INFO [STDOUT] at
org.apache.geronimo.samples.daytrader.web.TradeBuildDB.<init>(TradeBuildDB.java:212)
15:18:07,188 INFO [STDOUT] at
org.apache.geronimo.samples.daytrader.web.TradeConfigServlet.service(TradeConfigServlet.java:408)
15:18:07,188 INFO [STDOUT] at
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
15:18:07,188 INFO [STDOUT] at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
15:18:07,188 INFO [STDOUT] at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
15:18:07,188 INFO [STDOUT] at
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
15:18:07,188 INFO [STDOUT] at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
15:18:07,188 INFO [STDOUT] at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
15:18:07,188 INFO [STDOUT] at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)
15:18:07,188 INFO [STDOUT] at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
15:18:07,188 INFO [STDOUT] at
org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:183)
15:18:07,188 INFO [STDOUT] at
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:95)
15:18:07,188 INFO [STDOUT] at
org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)
15:18:07,188 INFO [STDOUT] at
org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)
15:18:07,188 INFO [STDOUT] at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
15:18:07,188 INFO [STDOUT] at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
15:18:07,188 INFO [STDOUT] at
org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)
15:18:07,188 INFO [STDOUT] at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
15:18:07,188 INFO [STDOUT] at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)
15:18:07,189 INFO [STDOUT] at
org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:905)
15:18:07,189 INFO [STDOUT] at
org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:592)
15:18:07,189 INFO [STDOUT] at
org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:2036)
15:18:07,189 INFO [STDOUT] at java.lang.Thread.run(Thread.java:662)
> DayTrader 2.1.3 : problem because tables in Table.ddl file with sql command
> are not lower case with Jboss EAP 5.1.0
> --------------------------------------------------------------------------------------------------------------------
>
> Key: DAYTRADER-80
> URL: https://issues.apache.org/jira/browse/DAYTRADER-80
> Project: DayTrader
> Issue Type: Bug
> Security Level: public(Regular issues)
> Affects Versions: 2.1.3
> Environment: Jboss AS 5.1.0
> Sun JDK 1.6_022
> Linux RHEL5
> Mysql JDBC driver 5.1.13 (mysql-connector-java-5.1.13-bin.jar)
> Mysql Server 5.0.20
> Profile default for Jboss serveur (./run.sh -c default).
> Reporter: Yannick LE NY
> Fix For: 2.1.7
>
>
> Hello,
> I have downloaded the latest revision for Day Trader 2.1.3
> in the svn here
> http://svn.apache.org/viewvc/geronimo/daytrader/branches/old_2.1.3/?sortby=date
> and compiled it with :
> * JDK 1.6_021
> * Mandriva Linux 2010.1
> * Maven 2.2.1
> by following the instructions in the file
> http://svn.apache.org/viewvc/geronimo/daytrader/branches/2.1.3/README.jboss5?revision=907211&view=markup&sortby=file
> I create my Mysql TRADEDB database with
> daytrader-2.1.3-svn\bin\dbscripts\derby\Table.ddl
> The name for the Mysql TRADEDB database is upper case and the tables and
> fields in the tables are upper case.
> In the configuration tab, I click on "(Re)-populate DayTrader Database" and
> I have the following errors in the logs :
> 15:18:07,178 ERROR [Log] Error: TradeDirect:register -- error registering new
> user
> java.lang.Exception: KeySequenceDirect:allocNewBlock - failure to
> allocate new block of keys for Entity type:
> accountcom.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
> 'TRADEDB.keygenejb' doesn't exist
> 15:18:07,180 INFO [STDOUT] java.lang.Exception:
> KeySequenceDirect:allocNewBlock - failure to allocate new block of keys for
> Entity type:
> accountcom.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
> 'TRADEDB.keygenejb' doesn't exist
> ...
> 15:18:07,184 ERROR [Log] Error: KeySequenceDirect:allocNewBlock - failure to
> allocate new block of keys for Entity type: account
> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
> 'TRADEDB.keygenejb' doesn't exist
> 15:18:07,184 INFO [STDOUT]
> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
> 'TRADEDB.keygenejb' doesn't exist
> Can you fix this problem or use lower case for the database name, tables
> names and tables's fields name in the Table.ddl file for derby, DB2, Oracle,
> sqlserver ?
> Note that Linux and Unix are very sensitive with the case for characters and
> numbers.
> Best regards.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
