Re: Reengineer Database Schema not generating anything

From: Mark Fischer (farkmische..mail.com)
Date: Wed Nov 03 2010 - 22:19:56 UTC

  • Next message: Borut Bolčina: "Re: Reengineer Database Schema not generating anything"

    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:20:29 UTC