[
https://issues.apache.org/jira/browse/DAYTRADER-80?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Yannick LE NY updated DAYTRADER-80:
-----------------------------------
Description:
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.
was:
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.
> 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.
