Databases
StackOverflow2013
Postsdbo
POGrails table not found error on SQL 2008 legacy table
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POGrails table not found error on SQL 2008 legacy table
    text
    copied!<p>I'm trying to link a new Grails project to a pre-existing SQL server 2008 database, trouble is when I try to list/update or anything nothing works and I get an error reading </p> <blockquote> <p>Table "TEST_EXEC_QUEUE" not found; SQL statement: select top 10 this_.id as id0_0_, this_.Env as Env0_0_, this_.Priority as Priority0_0_, this_.State as State0_0_, this_.subSystem as subSystem0_0_, this_.system as system0_0_, this_.test_scenario_id as test7_0_0_ from test_exec_queue this_ [42102-164]</p> </blockquote> <p>My datasource.groovy file is: -</p> <pre><code>dataSource { pooled = false driverClassName = "net.sourceforge.jtds.jdbc.Driver" dialect = "org.hibernate.dialect.SQLServerDialect" } hibernate { cache.use_second_level_cache = true cache.use_query_cache = false cache.region.factory_class = 'net.sf.ehcache.hibernate.EhCacheRegionFactory' } // environment specific settings development { dataSource { dbCreate = "update" url = "jdbc:jtds:sqlserver://UKSQL08;databaseName=Selenium" } } </code></pre> <p>and the domain file is as follows, anyone got any ideas...?</p> <pre><code>package testexecqueue class TestExecQueueCheck { static constraints = { test_scenario_id(blank:false) myPriority() myState() myEnv() system() subSystem() } static mapping = { table "test_exec_queue" version false columns{ test_scenario_id column:"test_scenario_id" myPriority column:"Priority" myState column:"State" myEnv column:"Env" system column:"system" subSystem column:"subSystem" } } Integer test_scenario_id Integer myPriority String myState String myEnv String system String subSystem } </code></pre>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload