[
https://issues.apache.org/jira/browse/DAYTRADER-80?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Forrest Xia closed DAYTRADER-80.
--------------------------------
Resolution: Fixed
fixed in 2.1 branch, pls check. Thank you for reporting this jira.
> 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
> Assignee: Forrest Xia
> 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.
