geronimo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Yannick LE NY (JIRA)" <...@geronimo.apache.org>
Subject [jira] Updated: (DAYTRADER-80) DayTrader 2.1.3 : problem because tables in Table.ddl file with sql command are not lower case with Jboss EAP 5.1.0
Date Tue, 23 Nov 2010 16:40:14 GMT

     [ 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.


Mime
View raw message