Hi,

 

My experience with MySQL has been uneven in this regard. I have never seen it complain about mixed case sql from the command line. Recently when using Derby I discovered that it is sensitive to case and so I have begun the process of going uppercase but some old code slips through. What tool or version of MySQL complained about case?

 

Ken

 

 

From: Bartosz Majsak [mailto:notifications@github.com] 
Sent: February 22, 2014 3:46 PM
To: omniprof/ArquillianDemo01
Subject: Re: [ArquillianDemo01] Fixed test and project setup. (#1)

 

In ArquillianDemo01/src/main/java/com/kenfogel/beans/FishActionBean.java:

> @@ -37,7 +37,7 @@
>              List<FishData> fishies = new ArrayList<>();
>  
>              try (Connection conn = ds.getConnection();
> -                            PreparedStatement stmt = conn.prepareStatement("SELECT * FROM Fish");
> +                            PreparedStatement stmt = conn.prepareStatement("SELECT * FROM FISH");

My mysql version was complaining about case sensitive name. Same in resources.xml.

—
Reply to this email directly or view it on GitHub <https://github.com/omniprof/ArquillianDemo01/pull/1/files#r9972932> .  <https://github.com/notifications/beacon/4064849__eyJzY29wZSI6Ik5ld3NpZXM6QmVhY29uIiwiZXhwaXJlcyI6MTcwODYzNDc1NCwiZGF0YSI6eyJpZCI6MjYyNDE0MjF9fQ==--01e2abf5c851c06ba2c753c463caf5bb5a013fe1.gif>