[jboss-user] [Beginner's Corner] - Re: getSingleResult() issues in JBoss 6

Merv Newell [http://community.jboss.org/people/emsien] created the discussion "Re: getSingleResult() issues in JBoss 6" To view the discussion, visit: http://community.jboss.org/message/593294#593294 -------------------------------------------------------------- Here is the SQL for the method using the getSingleResult that didn't work - note when I added your lines to the persistence.xml file I no longer see the SQL exception in the log - so it would appear as though 1 or 2 of the propery names you had me enter fixes the problem - without going through trial and error do you think its line 1 or 3 - I doubt its line 2 - or do you think something else is going on 07:38:09,695 INFO [STDOUT] select 07:38:09,695 INFO [STDOUT] silo0_.Id as Id13_, 07:38:09,695 INFO [STDOUT] silo0_.CVClientID as CVClientID13_, 07:38:09,695 INFO [STDOUT] silo0_.JNDIName as JNDIName13_, 07:38:09,695 INFO [STDOUT] silo0_.ClassName as ClassName13_, 07:38:09,695 INFO [STDOUT] silo0_.Master as Master13_, 07:38:09,695 INFO [STDOUT] silo0_.Name as Name13_, 07:38:09,695 INFO [STDOUT] silo0_.Parent as Parent13_, 07:38:09,695 INFO [STDOUT] silo0_.ScheduleID as ScheduleID13_, 07:38:09,695 INFO [STDOUT] silo0_.siloOrder as siloOrder13_ 07:38:09,695 INFO [STDOUT] from 07:38:09,695 INFO [STDOUT] Silo silo0_ 07:38:09,695 INFO [STDOUT] where 07:38:09,695 INFO [STDOUT] silo0_.Name='TransportSilo' 07:38:09,695 INFO [STDOUT] and silo0_.CVClientID=1 limit ? 07:38:09,695 INFO [STDOUT] Hibernate: 07:38:09,695 INFO [STDOUT] select 07:38:09,695 INFO [STDOUT] schedule0_.scheduleID as scheduleID46_1_, 07:38:09,695 INFO [STDOUT] schedule0_.CVClientID as CVClientID46_1_, 07:38:09,695 INFO [STDOUT] schedule0_.lastChange as lastChange46_1_, 07:38:09,695 INFO [STDOUT] schedule0_.run24Hours as run4_46_1_, 07:38:09,695 INFO [STDOUT] schedule0_.runFriday as runFriday46_1_, 07:38:09,695 INFO [STDOUT] schedule0_.runMonday as runMonday46_1_, 07:38:09,695 INFO [STDOUT] schedule0_.runSaturday as runSatur7_46_1_, 07:38:09,695 INFO [STDOUT] schedule0_.runStartTime as runStart8_46_1_, 07:38:09,695 INFO [STDOUT] schedule0_.runStopTime as runStopT9_46_1_, 07:38:09,695 INFO [STDOUT] schedule0_.runSunday as runSunday46_1_, 07:38:09,695 INFO [STDOUT] schedule0_.runThursday as runThur11_46_1_, 07:38:09,695 INFO [STDOUT] schedule0_.runTuesday as runTuesday46_1_, 07:38:09,695 INFO [STDOUT] schedule0_.runWednesday as runWedn13_46_1_, 07:38:09,695 INFO [STDOUT] schedule0_.scheduleName as schedul14_46_1_, 07:38:09,695 INFO [STDOUT] schedule0_.scope as scope46_1_, 07:38:09,695 INFO [STDOUT] schedule0_.sleepInterval as sleepIn16_46_1_, 07:38:09,695 INFO [STDOUT] client1_.CVClientID as CVClientID9_0_, 07:38:09,695 INFO [STDOUT] client1_.clientName as clientName9_0_, 07:38:09,695 INFO [STDOUT] client1_.clientShortName as clientSh3_9_0_ 07:38:09,695 INFO [STDOUT] from 07:38:09,695 INFO [STDOUT] Schedule schedule0_ 07:38:09,695 INFO [STDOUT] inner join 07:38:09,695 INFO [STDOUT] Client client1_ 07:38:09,695 INFO [STDOUT] on schedule0_.CVClientID=client1_.CVClientID 07:38:09,695 INFO [STDOUT] where 07:38:09,695 INFO [STDOUT] schedule0_.scheduleID=? 07:38:09,695 INFO [STDOUT] Hibernate: 07:38:09,695 INFO [STDOUT] select 07:38:09,695 INFO [STDOUT] params0_.SiloID as SiloID13_1_, 07:38:09,695 INFO [STDOUT] params0_.ID as ID1_, 07:38:09,695 INFO [STDOUT] params0_.ID as ID47_0_, 07:38:09,695 INFO [STDOUT] params0_.DateValue as DateValue47_0_, 07:38:09,695 INFO [STDOUT] params0_.EndDate as EndDate47_0_, 07:38:09,695 INFO [STDOUT] params0_.IntValue as IntValue47_0_, 07:38:09,695 INFO [STDOUT] params0_.JavaType as JavaType47_0_, 07:38:09,695 INFO [STDOUT] params0_.Name as Name47_0_, 07:38:09,695 INFO [STDOUT] params0_.NumValue as NumValue47_0_, 07:38:09,695 INFO [STDOUT] params0_.SiloID as SiloID47_0_, 07:38:09,695 INFO [STDOUT] params0_.StartDate as StartDate47_0_, 07:38:09,695 INFO [STDOUT] params0_.StringValue as StringV10_47_0_ 07:38:09,695 INFO [STDOUT] from 07:38:09,695 INFO [STDOUT] SiloSettings params0_ 07:38:09,695 INFO [STDOUT] where 07:38:09,695 INFO [STDOUT] params0_.SiloID=? -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/593294#593294] Start a new discussion in Beginner's Corner at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&...]