Hello Mark,
try with different database, just to narrow down the problem. Install, for
example, MySQL and create some InnoDB tables with MySQL Workbench and then
try to reverse engineer the tables with the modeler.
-Borut
2010/11/3 Mark Fischer <farkmische..mail.com>
> I tried working this a different way around. I created a test database and
> table by using Cayenne to map things out and then generate the table. Then
> I opened Cayenne with a new project and tried to reverse engineer the table
> that Cayenne created. I still get an empty usermap. Is there a log file I
> could look in for an error of some explination of what is going wrong? The
> show console log shows nothing helpful as far as I am able to see. I wish
> it would at least give me something to go on.
> On Wed, Nov 3, 2010 at 2:50 PM, Mark Fischer <farkmische..mail.com>
> wrote:
>
> > I have tried checking that I don't have a permissions problem. I have
> > tried loggin into SQL Server with SQL Server Management Studio using the
> > same username and password and I can see all of the tables. What
> > permissions is Cayenne looking for from the database. I'm not sure what
> I
> > am checking for.
> >
> > Thanks,
> > Mark
> >
> > On Tue, Nov 2, 2010 at 9:17 PM, Andrus Adamchik <
> andru..bjectstyle.org>wrote:
> >
> >> Hi Mark,
> >>
> >> I can only think of two reasons - a given schema has no tables or views,
> >> or permissions for a given user won't let him see those tables. I am not
> a
> >> SQL Server expert to comment on the specific schema though...
> >>
> >> Andrus
> >>
> >>
> >> On Nov 2, 2010, at 6:16 PM, Mark Fischer wrote:
> >>
> >> > 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...
> >>
> >>
> >
>
This archive was generated by hypermail 2.0.0 : Wed Nov 03 2010 - 22:26:08 UTC