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.
But when I launch Jboss AS 5.1.0, I have the following error 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.
