I am running windows XP with cayenne-modeler connecting to a local MS SQL Server 2008 Express db. I set up my local datasource and when I clicked test it says successful.
I create a node and have the DataSource Factory org.apache.cayenne.conf.DriverDataSourceFactory selected. With the node selected I go to Tools -> Reengineer Database Schema. Cayenne asks me which connection to use and I choose the same one as selected in the node. Then it asks me which schema and I leave it at db_accessadmin. Cayenne thinks for a second and then generates UntitledMap which does not seem to contain any of the tables from my database. I was following the example at http://cayenne.apache.org/doc/reverse-engineer-database.html . I just started trying cayenne two weeks ago and have been thrashing with this for two weeks I have searched but have not found anything useful through google. Being new I am not sure what else to try. Here is the text in the console while I use the Reeingineer menuitem: Nov 2, 2010 5:14:47 PM INFO: --- will run 2 queries. Nov 2, 2010 5:14:47 PM INFO: --- transaction started. Nov 2, 2010 5:14:47 PM INFO: UPDATE component_geometry SET y = ?, x = ? WHERE id = ? Nov 2, 2010 5:14:47 PM INFO: [bind: 1->y:0, 2->x:0, 3->id:202] Nov 2, 2010 5:14:47 PM INFO: === updated 1 row. Nov 2, 2010 5:14:47 PM INFO: UPDATE domain_preference SET key_value_pairs = ? WHERE id = ? Nov 2, 2010 5:14:47 PM INFO: [bind: 1->key_value_pairs:'#Tue Nov 02 17:14:32 CDT 2010 ...', 2->id:201] Nov 2, 2010 5:14:47 PM INFO: === updated 1 row. Nov 2, 2010 5:14:47 PM INFO: +++ transaction committed. Nov 2, 2010 5:14:50 PM INFO: --- will run 1 query. Nov 2, 2010 5:14:50 PM INFO: --- transaction started. Nov 2, 2010 5:14:50 PM INFO: SELECT t0.key_value_pairs, t0.domain_id, t0.key, t0.id FROM domain_preference t0 JOIN domain t1 ON (t0.domain_id = t1.id) WHERE (t0.key = ?) AND (t0.domain_id = ?) ORDER BY t1.level DESC LIMIT 1 OFFSET 0 [bind: 1->key:'EmploymentApplication', 2->domain_id:221] Nov 2, 2010 5:14:50 PM INFO: === returned 1 row. - took 16 ms. Nov 2, 2010 5:14:50 PM INFO: +++ transaction committed. Nov 2, 2010 5:14:50 PM INFO: --- will run 1 query. Nov 2, 2010 5:14:50 PM INFO: --- transaction started. Nov 2, 2010 5:14:50 PM INFO: SELECT t0.parent_id, t0.level, t0.id, t0.description, t0.name, t0.version FROM domain t0 WHERE (t0.name = ?) AND (t0.level = ?) [bind: 1->name:'CayenneModeler', 2->level:0] Nov 2, 2010 5:14:50 PM INFO: === returned 1 row. - took 0 ms. Nov 2, 2010 5:14:50 PM INFO: +++ transaction committed. Nov 2, 2010 5:14:50 PM INFO: --- will run 1 query. Nov 2, 2010 5:14:50 PM INFO: --- transaction started. Nov 2, 2010 5:14:50 PM INFO: SELECT t0.key_value_pairs, t0.domain_id, t0.key, t0.id FROM domain_preference t0 JOIN domain t1 ON (t0.domain_id = t1.id) WHERE (t0.key = ?) AND (t0.domain_id = ?) ORDER BY t1.level DESC LIMIT 1 OFFSET 0 [bind: 1->key:'HMSysLocalSQLServer', 2->domain_id:200] Nov 2, 2010 5:14:50 PM INFO: === returned 1 row. - took 0 ms. Nov 2, 2010 5:14:50 PM INFO: +++ transaction committed. Nov 2, 2010 5:14:50 PM INFO: --- will run 1 query. Nov 2, 2010 5:14:50 PM INFO: --- transaction started. Nov 2, 2010 5:14:50 PM INFO: SELECT t0.parent_id, t0.level, t0.id, t0.description, t0.name, t0.version FROM domain t0 WHERE (t0.name = ?) AND (t0.level = ?) [bind: 1->name:'CayenneModeler', 2->level:0] Nov 2, 2010 5:14:50 PM INFO: === returned 1 row. - took 15 ms. Nov 2, 2010 5:14:50 PM INFO: +++ transaction committed. Nov 2, 2010 5:14:50 PM INFO: --- will run 1 query. Nov 2, 2010 5:14:50 PM INFO: --- transaction started. Nov 2, 2010 5:14:50 PM INFO: SELECT t0.domain_preference_id, t0.db_adapter, t0.user_name, t0.password, t0.url, t0.jdbc_driver, t0.id FROM db_connection_info t0 WHERE t0.id IN (?, ?, ?, ?, ?) [bind: 1->id:203, 2->id:210, 3->id:211, 4->id:220, 5->id:246] Nov 2, 2010 5:14:50 PM INFO: === returned 3 rows. - took 0 ms. Nov 2, 2010 5:14:50 PM INFO: +++ transaction committed. Nov 2, 2010 5:14:53 PM INFO: --- will run 1 query. Nov 2, 2010 5:14:53 PM INFO: --- transaction started. Nov 2, 2010 5:14:53 PM INFO: SELECT t0.parent_id, t0.level, t0.id, t0.description, t0.name, t0.version FROM domain t0 WHERE (t0.name = ?) AND (t0.level = ?) [bind: 1->name:'CayenneModeler', 2->level:0] Nov 2, 2010 5:14:53 PM INFO: === returned 1 row. - took 0 ms. Nov 2, 2010 5:14:53 PM INFO: +++ transaction committed. Nov 2, 2010 5:14:53 PM INFO: --- will run 1 query. Nov 2, 2010 5:14:53 PM INFO: --- transaction started. Nov 2, 2010 5:14:53 PM INFO: SELECT t0.parent_id, t0.level, t0.id, t0.description, t0.name, t0.version FROM domain t0 WHERE t0.parent_id = ? [bind: 1->parent_id:200] Nov 2, 2010 5:14:53 PM INFO: === returned 15 rows. - took 0 ms. Nov 2, 2010 5:14:53 PM INFO: +++ transaction committed. Nov 2, 2010 5:14:53 PM INFO: --- will run 1 query. Nov 2, 2010 5:14:53 PM INFO: --- transaction started. Nov 2, 2010 5:14:53 PM INFO: SELECT t0.key_value_pairs, t0.domain_id, t0.key, t0.id FROM domain_preference t0 JOIN domain t1 ON (t0.domain_id = t1.id) WHERE (t0.key = ?) AND (t0.domain_id = ?) ORDER BY t1.level DESC LIMIT 1 OFFSET 0 [bind: 1->key:'recent.strategies', 2->domain_id:217] Nov 2, 2010 5:14:53 PM INFO: === returned 1 row. - took 0 ms. Nov 2, 2010 5:14:53 PM INFO: +++ transaction committed. Nov 2, 2010 5:14:53 PM DEBUG: will show progress... Nov 2, 2010 5:14:55 PM INFO: --- will run 1 query. Nov 2, 2010 5:14:55 PM INFO: --- transaction started. Nov 2, 2010 5:14:55 PM INFO: SELECT t0.parent_id, t0.level, t0.id, t0.description, t0.name, t0.version FROM domain t0 WHERE (t0.name = ?) AND (t0.level = ?) [bind: 1->name:'CayenneModeler', 2->level:0] Nov 2, 2010 5:14:55 PM INFO: === returned 1 row. - took 0 ms. Nov 2, 2010 5:14:55 PM INFO: +++ transaction committed. Nov 2, 2010 5:14:55 PM INFO: --- will run 1 query. Nov 2, 2010 5:14:55 PM INFO: --- transaction started. Nov 2, 2010 5:14:55 PM INFO: SELECT t0.key_value_pairs, t0.domain_id, t0.key, t0.id FROM domain_preference t0 JOIN domain t1 ON (t0.domain_id = t1.id) WHERE (t0.key = ?) AND (t0.domain_id = ?) ORDER BY t1.level DESC LIMIT 1 OFFSET 0 [bind: 1->key:'recent.strategies', 2->domain_id:217] Nov 2, 2010 5:14:55 PM INFO: === returned 1 row. - took 0 ms. Nov 2, 2010 5:14:55 PM INFO: +++ transaction committed. Nov 2, 2010 5:14:55 PM INFO: --- will run 1 query. Nov 2, 2010 5:14:55 PM INFO: --- transaction started. Nov 2, 2010 5:14:55 PM INFO: SELECT t0.parent_id, t0.level, t0.id, t0.description, t0.name, t0.version FROM domain t0 WHERE (t0.name = ?) AND (t0.level = ?) [bind: 1->name:'CayenneModeler', 2->level:0] Nov 2, 2010 5:14:55 PM INFO: === returned 1 row. - took 0 ms. Nov 2, 2010 5:14:55 PM INFO: +++ transaction committed. Nov 2, 2010 5:14:55 PM INFO: --- will run 1 query. Nov 2, 2010 5:14:55 PM INFO: --- transaction started. Nov 2, 2010 5:14:55 PM INFO: SELECT t0.key_value_pairs, t0.domain_id, t0.key, t0.id FROM domain_preference t0 JOIN domain t1 ON (t0.domain_id = t1.id) WHERE (t0.key = ?) AND (t0.domain_id = ?) ORDER BY t1.level DESC LIMIT 1 OFFSET 0 [bind: 1->key:'recent.strategies', 2->domain_id:217] - prepared in 15 ms. Nov 2, 2010 5:14:55 PM INFO: === returned 1 row. - took 15 ms. Nov 2, 2010 5:14:55 PM INFO: +++ transaction committed. Nov 2, 2010 5:14:55 PM DEBUG: searching for resource under: org/apache/cayenne/dba/sqlserver/types.xml Nov 2, 2010 5:14:55 PM INFO: Detected and installed adapter: org.apache.cayenne.dba.sqlserver.SQLServerAdapter Nov 2, 2010 5:14:55 PM DEBUG: will show progress... Nov 2, 2010 5:14:55 PM DEBUG: task still in progress, will show progress dialog...
