You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@cayenne.apache.org by Mark Fischer <fa...@gmail.com> on 2010/11/02 23:16:46 UTC

Reengineer Database Schema not generating anything

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...

Re: Reengineer Database Schema not generating anything

Posted by Andrus Adamchik <an...@objectstyle.org>.

What you describe now sounds about right. Not sure why it works like that (I am not a SQLServer admin, and don't use it for anything real), but "dbo" being a user default schema in SQLServer rings a bell to me. Glad you found a solution. I ran out of ideas of why that might be failing.

Andrus


On Nov 11, 2010, at 11:41 AM, Mark Fischer wrote:
> That did it!!!  I must admit that maybe because I am from a visual studio or
> windows background I have never had to "Select Schema" like I do with
> Cayenne and so I had to idea what to pick 3-4 weeks ago when I first tried
> Cayenne.  When you connect from visual studio you just give the url and
> username and password, there is no schema to select from.  Also, when I
> wrote the small jdbc program to check my connection it did not ask me for a
> schema.  What does the schema do?
> 
> When I first tried this 3-4 weeks ago  I started at the top with
> "db_accessadmin" and worked my way down through the 13 options to "db_owner"
> and gave up.  There were still 5 choices left but I figured that if
> "db_owner" did not have the proper rights then none of the others would.  I
> went into SQL Server and made sure that "db_owner" was assigned full rights
> before I gave up.  Turns out if I pick "sys" I get a Map with all the tables
> including the system tables and if I pick "dbo" I get all the non system
> tables.  Any idea why "dbo" works but "db_owner" does not?  My knowledge of
> databases is not extensive so I must admit I do not know much about how the
> schemas work in SQL Server.
> 
> Sorry if this was a dumb error and wasting everyones time.  Thanks for
> sticking it out with me!!!
> 
> Mark
> 
> On Wed, Nov 10, 2010 at 2:22 PM, bogdan_voloshincu <
> bogdan_voloshincu@yahoo.com> wrote:
> 
>> 
>> take a look :
>> 
>> http://cayenne.195.n3.nabble.com/Help-cdbimport-Oracle-td1876015.html#a1876015
>> --
>> View this message in context:
>> http://cayenne.195.n3.nabble.com/Reengineer-Database-Schema-not-generating-anything-tp1831261p1878441.html
>> Sent from the Cayenne - User mailing list archive at Nabble.com.
>>

Re: Reengineer Database Schema not generating anything

Posted by Mark Fischer <fa...@gmail.com>.

That did it!!!  I must admit that maybe because I am from a visual studio or
windows background I have never had to "Select Schema" like I do with
Cayenne and so I had to idea what to pick 3-4 weeks ago when I first tried
Cayenne.  When you connect from visual studio you just give the url and
username and password, there is no schema to select from.  Also, when I
wrote the small jdbc program to check my connection it did not ask me for a
schema.  What does the schema do?

When I first tried this 3-4 weeks ago  I started at the top with
"db_accessadmin" and worked my way down through the 13 options to "db_owner"
and gave up.  There were still 5 choices left but I figured that if
"db_owner" did not have the proper rights then none of the others would.  I
went into SQL Server and made sure that "db_owner" was assigned full rights
before I gave up.  Turns out if I pick "sys" I get a Map with all the tables
including the system tables and if I pick "dbo" I get all the non system
tables.  Any idea why "dbo" works but "db_owner" does not?  My knowledge of
databases is not extensive so I must admit I do not know much about how the
schemas work in SQL Server.

Sorry if this was a dumb error and wasting everyones time.  Thanks for
sticking it out with me!!!

Mark

On Wed, Nov 10, 2010 at 2:22 PM, bogdan_voloshincu <
bogdan_voloshincu@yahoo.com> wrote:

>
> take a look :
>
> http://cayenne.195.n3.nabble.com/Help-cdbimport-Oracle-td1876015.html#a1876015
> --
> View this message in context:
> http://cayenne.195.n3.nabble.com/Reengineer-Database-Schema-not-generating-anything-tp1831261p1878441.html
> Sent from the Cayenne - User mailing list archive at Nabble.com.
>

Re: Reengineer Database Schema not generating anything

Posted by bogdan_voloshincu <bo...@yahoo.com>.

take a look :
http://cayenne.195.n3.nabble.com/Help-cdbimport-Oracle-td1876015.html#a1876015
-- 
View this message in context: http://cayenne.195.n3.nabble.com/Reengineer-Database-Schema-not-generating-anything-tp1831261p1878441.html
Sent from the Cayenne - User mailing list archive at Nabble.com.

Re: Reengineer Database Schema not generating anything

Posted by Borut Bolčina <bo...@gmail.com>.

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 <fa...@gmail.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 <fa...@gmail.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 <
> andrus@objectstyle.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...
> >>
> >>
> >
>

Re: Reengineer Database Schema not generating anything

Posted by Mike Kienenberger <mk...@gmail.com>.

Here's another possibility that might reveal something with a little
less effort:

Install the P6Spy jdbc driver and point it at your Mysql driver.

This pass-through driver will log all traffic to and from the database
at the JDBC level.

http://www.p6spy.com/

Note that p6spy hasn't been maintained (as far as I know) for quite
some time.   The binaries typically work, but you might have to figure
out how to compile it from source.   I think I had to do that the last
time I used it.


On Sun, Nov 7, 2010 at 8:41 PM, Mark Fischer <fa...@gmail.com> wrote:
> Thanks for putting up with me.  If I have time I will run the debug
> tonight.  We will see if I am smart enough to figure it out.
> On Nov 7, 2010 6:04 PM, "Andrus Adamchik" <an...@objectstyle.org> wrote:
>> Hi Mark,
>>
>> Your test indicates that JDBC part is ok, but still the Modeler somehow
> ignores your tables... I am a bit at a loss what to recommend now. It all
> works on my own tests. The only way to gather insight into what's really
> going on is running the Modeler in Eclipse debugger and stepping through
> org.apache.cayenne.access.DbLoader.loadDataMapFromDB(..) method. This setup
> took me just a few minutes, but if you haven't done it before, this may be
> more challenging:
>>
>> 1. Get the right version of the source code via SVN and import
> 'cayenne-jdk1.5-unpublished' in Eclipse:
> http://svn.apache.org/repos/asf/cayenne/main/tags/3.0.1/framework/cayenne-jdk1.5-unpublished/
>>
>> 2. Run the Windows or generic Modeler from the command line in debug mode:
>>
>> java -Xdebug -Xrunjdwp:server=y,transport=dt_socket,address=4142,suspend=n
> -jar CayenneModeler.jar
>>
>> 3. In Eclipse go to "Run > Debug Configurations", add a new "Remote Java
> Application" setting the project and port as shown on the screenshot, click
> "Debug":
>>
>> http://people.apache.org/~aadamchik/debug/screen1.png
>>
>> 4. Open org.apache.cayenne.access.DbLoader class and add a breakpoint on
> line 795:
>>
>> http://people.apache.org/~aadamchik/debug/screen2.png
>>
>> (doubleclick on the left of the code editor to do that).
>>
>> 5. Start reverse engineering in the Modeler and when it hits the
> breakpoint, go through it line by line to see what tables it gets and why
> they are excluded.
>>
>> Let us know if you stumble on any of the steps.
>>
>> Cheers,
>> Andrus
>>
>> On Nov 5, 2010, at 12:38 PM, Mark Fischer wrote:
>>> Okay I setup and ran this code that I found thru google:
>>>
>>> *
>>>
>>> public* *void* displayDbProperties(){
>>>
>>> java.sql.DatabaseMetaData dm = *null*;
>>>
>>> java.sql.ResultSet rs = *null*;
>>>
>>> *try*{
>>>
>>> con= *this*.getConnection();
>>>
>>> *if*(con!=*null*){
>>>
>>> dm = con.getMetaData();
>>>
>>> System.*out*.println("Driver Information");
>>>
>>> System.*out*.println("\tDriver Name: "+ dm.getDriverName());
>>>
>>> System.*out*.println("\tDriver Version: "+ dm.getDriverVersion ());
>>>
>>> System.*out*.println("\nDatabase Information ");
>>>
>>> System.*out*.println("\tDatabase Name: "+ dm.getDatabaseProductName());
>>>
>>> System.*out*.println("\tDatabase Version: "+
>>> dm.getDatabaseProductVersion());
>>>
>>> System.*out*.println("Avalilable Catalogs ");
>>>
>>> rs = dm.getCatalogs();
>>>
>>> *while*(rs.next()){
>>>
>>> System.*out*.println("\tcatalog: "+ rs.getString(1));
>>> }
>>>
>>>
>>> String[] types = {"TABLE", "VIEW"};
>>>
>>> rstables = dm.getTables(*null*, "%", "%", types);
>>>
>>> *while*(rstables.next()){
>>>
>>> System.*out*.println("\ttables: " + rstables.getString(3) + "\t" +
>>> rstables.getString(2) + "\t" + rstables.getString(1) + "\t" +
>>> rstables.getString(4) );
>>>
>>> }
>>>
>>> rs.close();
>>>
>>> rs = *null*;
>>>
>>> closeConnection();
>>>
>>> }*else* System.*out*.println("Error: No active Connection");
>>>
>>> }*catch*(Exception e){
>>>
>>> e.printStackTrace();
>>>
>>> }
>>>
>>> dm=*null*;
>>>
>>> }
>>> This took some googling for me as I am a Visual Studio Developer and
>>> Eclispe, Java, jdbc, Cayenne, etc are all new to me but I got it to run.
> I
>>> got these results using the same connection string that I copy and pasted
>>> out of Cayenne:
>>>
>>>
>>> Connection Successful!
>>>
>>> Driver Information
>>>
>>> Driver Name: Microsoft SQL Server JDBC Driver 3.0
>>>
>>> Driver Version: 3.0.1301.101
>>>
>>> Database Information
>>>
>>> Database Name: Microsoft SQL Server
>>>
>>> Database Version: 10.00.1600
>>>
>>> Avalilable Catalogs
>>>
>>> ***Here I get a list of all the catalogs and then I get a list of all of
> the
>>> tables in all of the catalogs***
>>> Is this what you were asking me to test? What do I try next??
>>>
>>>
>>> On Wed, Nov 3, 2010 at 5:36 PM, Andrus Adamchik <andrus@objectstyle.org
>>wrote:
>>>
>>>> At the end reverse engineering in Cayenne is based on JDBC API. More
>>>> specifically it invokes DatabaseMetaData.getTables(..) method:
>>>>
>>>>
>>>>
> http://download.oracle.com/javase/6/docs/api/java/sql/DatabaseMetaData.html#getTables%28java.lang.String,%20java.lang.String,%20java.lang.String,%20java.lang.String[]%29
>>>>
>>>> with catalog parameter set to NULL, schema and table patterns set to
> your
>>>> selections, and "types" set to { "TABLE", "VIEW" }. Then it processes
>>>> whatever is returned by this method.
>>>>
>>>> I guess one way to debug it is to write a simple JDBC test to see if the
>>>> above returns any data.
>>>>
>>>> Andrus
>>>>
>>>>
>>>>
>>>> On Nov 3, 2010, at 6:19 PM, Mark Fischer wrote:
>>>>
>>>>> 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 <fa...@gmail.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 <
>>>> andrus@objectstyle.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...
>>>>>>>
>>>>>>>
>>>>>>
>>>>
>>>>
>>
>

Re: Reengineer Database Schema not generating anything

Posted by Mark Fischer <fa...@gmail.com>.

Thanks for putting up with me.  If I have time I will run the debug
tonight.  We will see if I am smart enough to figure it out.
On Nov 7, 2010 6:04 PM, "Andrus Adamchik" <an...@objectstyle.org> wrote:
> Hi Mark,
>
> Your test indicates that JDBC part is ok, but still the Modeler somehow
ignores your tables... I am a bit at a loss what to recommend now. It all
works on my own tests. The only way to gather insight into what's really
going on is running the Modeler in Eclipse debugger and stepping through
org.apache.cayenne.access.DbLoader.loadDataMapFromDB(..) method. This setup
took me just a few minutes, but if you haven't done it before, this may be
more challenging:
>
> 1. Get the right version of the source code via SVN and import
'cayenne-jdk1.5-unpublished' in Eclipse:
http://svn.apache.org/repos/asf/cayenne/main/tags/3.0.1/framework/cayenne-jdk1.5-unpublished/
>
> 2. Run the Windows or generic Modeler from the command line in debug mode:
>
> java -Xdebug -Xrunjdwp:server=y,transport=dt_socket,address=4142,suspend=n
-jar CayenneModeler.jar
>
> 3. In Eclipse go to "Run > Debug Configurations", add a new "Remote Java
Application" setting the project and port as shown on the screenshot, click
"Debug":
>
> http://people.apache.org/~aadamchik/debug/screen1.png
>
> 4. Open org.apache.cayenne.access.DbLoader class and add a breakpoint on
line 795:
>
> http://people.apache.org/~aadamchik/debug/screen2.png
>
> (doubleclick on the left of the code editor to do that).
>
> 5. Start reverse engineering in the Modeler and when it hits the
breakpoint, go through it line by line to see what tables it gets and why
they are excluded.
>
> Let us know if you stumble on any of the steps.
>
> Cheers,
> Andrus
>
> On Nov 5, 2010, at 12:38 PM, Mark Fischer wrote:
>> Okay I setup and ran this code that I found thru google:
>>
>> *
>>
>> public* *void* displayDbProperties(){
>>
>> java.sql.DatabaseMetaData dm = *null*;
>>
>> java.sql.ResultSet rs = *null*;
>>
>> *try*{
>>
>> con= *this*.getConnection();
>>
>> *if*(con!=*null*){
>>
>> dm = con.getMetaData();
>>
>> System.*out*.println("Driver Information");
>>
>> System.*out*.println("\tDriver Name: "+ dm.getDriverName());
>>
>> System.*out*.println("\tDriver Version: "+ dm.getDriverVersion ());
>>
>> System.*out*.println("\nDatabase Information ");
>>
>> System.*out*.println("\tDatabase Name: "+ dm.getDatabaseProductName());
>>
>> System.*out*.println("\tDatabase Version: "+
>> dm.getDatabaseProductVersion());
>>
>> System.*out*.println("Avalilable Catalogs ");
>>
>> rs = dm.getCatalogs();
>>
>> *while*(rs.next()){
>>
>> System.*out*.println("\tcatalog: "+ rs.getString(1));
>> }
>>
>>
>> String[] types = {"TABLE", "VIEW"};
>>
>> rstables = dm.getTables(*null*, "%", "%", types);
>>
>> *while*(rstables.next()){
>>
>> System.*out*.println("\ttables: " + rstables.getString(3) + "\t" +
>> rstables.getString(2) + "\t" + rstables.getString(1) + "\t" +
>> rstables.getString(4) );
>>
>> }
>>
>> rs.close();
>>
>> rs = *null*;
>>
>> closeConnection();
>>
>> }*else* System.*out*.println("Error: No active Connection");
>>
>> }*catch*(Exception e){
>>
>> e.printStackTrace();
>>
>> }
>>
>> dm=*null*;
>>
>> }
>> This took some googling for me as I am a Visual Studio Developer and
>> Eclispe, Java, jdbc, Cayenne, etc are all new to me but I got it to run.
I
>> got these results using the same connection string that I copy and pasted
>> out of Cayenne:
>>
>>
>> Connection Successful!
>>
>> Driver Information
>>
>> Driver Name: Microsoft SQL Server JDBC Driver 3.0
>>
>> Driver Version: 3.0.1301.101
>>
>> Database Information
>>
>> Database Name: Microsoft SQL Server
>>
>> Database Version: 10.00.1600
>>
>> Avalilable Catalogs
>>
>> ***Here I get a list of all the catalogs and then I get a list of all of
the
>> tables in all of the catalogs***
>> Is this what you were asking me to test? What do I try next??
>>
>>
>> On Wed, Nov 3, 2010 at 5:36 PM, Andrus Adamchik <andrus@objectstyle.org
>wrote:
>>
>>> At the end reverse engineering in Cayenne is based on JDBC API. More
>>> specifically it invokes DatabaseMetaData.getTables(..) method:
>>>
>>>
>>>
http://download.oracle.com/javase/6/docs/api/java/sql/DatabaseMetaData.html#getTables%28java.lang.String,%20java.lang.String,%20java.lang.String,%20java.lang.String[]%29
>>>
>>> with catalog parameter set to NULL, schema and table patterns set to
your
>>> selections, and "types" set to { "TABLE", "VIEW" }. Then it processes
>>> whatever is returned by this method.
>>>
>>> I guess one way to debug it is to write a simple JDBC test to see if the
>>> above returns any data.
>>>
>>> Andrus
>>>
>>>
>>>
>>> On Nov 3, 2010, at 6:19 PM, Mark Fischer wrote:
>>>
>>>> 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 <fa...@gmail.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 <
>>> andrus@objectstyle.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...
>>>>>>
>>>>>>
>>>>>
>>>
>>>
>

Re: Reengineer Database Schema not generating anything

Posted by Andrus Adamchik <an...@objectstyle.org>.

Hi Mark,

Your test indicates that JDBC part is ok, but still the Modeler somehow ignores your tables... I am a bit at a loss what to recommend now. It all works on my own tests. The only way to gather insight into what's really going on is running the Modeler in Eclipse debugger and stepping through org.apache.cayenne.access.DbLoader.loadDataMapFromDB(..) method. This setup took me just a few minutes, but if you haven't done it before, this may be more challenging:

1. Get the right version of the source code via SVN and import 'cayenne-jdk1.5-unpublished' in Eclipse: http://svn.apache.org/repos/asf/cayenne/main/tags/3.0.1/framework/cayenne-jdk1.5-unpublished/

2. Run the Windows or generic Modeler from the command line in debug mode:

java -Xdebug -Xrunjdwp:server=y,transport=dt_socket,address=4142,suspend=n -jar CayenneModeler.jar 

3. In Eclipse go to "Run > Debug Configurations", add a new "Remote Java Application" setting the project and port as shown on the screenshot, click "Debug":

http://people.apache.org/~aadamchik/debug/screen1.png

4. Open org.apache.cayenne.access.DbLoader class and add a breakpoint on line 795:

http://people.apache.org/~aadamchik/debug/screen2.png

(doubleclick on the left of the code editor to do that).

5. Start reverse engineering in the Modeler and when it hits the breakpoint, go through it line by line to see what tables it gets and why they are excluded.

Let us know if you stumble on any of the steps.

Cheers,
Andrus

On Nov 5, 2010, at 12:38 PM, Mark Fischer wrote:
> Okay I setup and ran this code that I found thru google:
> 
> *
> 
> public* *void* displayDbProperties(){
> 
> java.sql.DatabaseMetaData dm = *null*;
> 
> java.sql.ResultSet rs = *null*;
> 
> *try*{
> 
> con= *this*.getConnection();
> 
> *if*(con!=*null*){
> 
> dm = con.getMetaData();
> 
> System.*out*.println("Driver Information");
> 
> System.*out*.println("\tDriver Name: "+ dm.getDriverName());
> 
> System.*out*.println("\tDriver Version: "+ dm.getDriverVersion ());
> 
> System.*out*.println("\nDatabase Information ");
> 
> System.*out*.println("\tDatabase Name: "+ dm.getDatabaseProductName());
> 
> System.*out*.println("\tDatabase Version: "+
> dm.getDatabaseProductVersion());
> 
> System.*out*.println("Avalilable Catalogs ");
> 
> rs = dm.getCatalogs();
> 
> *while*(rs.next()){
> 
> System.*out*.println("\tcatalog: "+ rs.getString(1));
> }
> 
> 
> String[] types = {"TABLE", "VIEW"};
> 
> rstables = dm.getTables(*null*, "%", "%", types);
> 
> *while*(rstables.next()){
> 
> System.*out*.println("\ttables: " + rstables.getString(3) + "\t" +
> rstables.getString(2) + "\t" + rstables.getString(1) + "\t" +
> rstables.getString(4) );
> 
> }
> 
> rs.close();
> 
> rs = *null*;
> 
> closeConnection();
> 
> }*else* System.*out*.println("Error: No active Connection");
> 
> }*catch*(Exception e){
> 
> e.printStackTrace();
> 
> }
> 
> dm=*null*;
> 
> }
> This took some googling for me as I am a Visual Studio Developer and
> Eclispe, Java, jdbc, Cayenne, etc are all new to me but I got it to run.  I
> got these results using the same connection string that I copy and pasted
> out of Cayenne:
> 
> 
> Connection Successful!
> 
> Driver Information
> 
> Driver Name: Microsoft SQL Server JDBC Driver 3.0
> 
> Driver Version: 3.0.1301.101
> 
> Database Information
> 
> Database Name: Microsoft SQL Server
> 
> Database Version: 10.00.1600
> 
> Avalilable Catalogs
> 
> ***Here I get a list of all the catalogs and then I get a list of all of the
> tables in all of the catalogs***
> Is this what you were asking me to test?  What do I try next??
> 
> 
> On Wed, Nov 3, 2010 at 5:36 PM, Andrus Adamchik <an...@objectstyle.org>wrote:
> 
>> At the end reverse engineering in Cayenne is based on JDBC API. More
>> specifically it invokes DatabaseMetaData.getTables(..) method:
>> 
>> 
>> http://download.oracle.com/javase/6/docs/api/java/sql/DatabaseMetaData.html#getTables%28java.lang.String,%20java.lang.String,%20java.lang.String,%20java.lang.String[]%29
>> 
>> with catalog parameter set to NULL, schema and table patterns set to your
>> selections, and "types" set to { "TABLE", "VIEW" }. Then it processes
>> whatever is returned by this method.
>> 
>> I guess one way to debug it is to write a simple JDBC test to see if the
>> above returns any data.
>> 
>> Andrus
>> 
>> 
>> 
>> On Nov 3, 2010, at 6:19 PM, Mark Fischer wrote:
>> 
>>> 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 <fa...@gmail.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 <
>> andrus@objectstyle.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...
>>>>> 
>>>>> 
>>>> 
>> 
>>

Re: Reengineer Database Schema not generating anything

Posted by Mark Fischer <fa...@gmail.com>.

Okay I setup and ran this code that I found thru google:

*

public* *void* displayDbProperties(){

java.sql.DatabaseMetaData dm = *null*;

java.sql.ResultSet rs = *null*;

*try*{

con= *this*.getConnection();

*if*(con!=*null*){

dm = con.getMetaData();

System.*out*.println("Driver Information");

System.*out*.println("\tDriver Name: "+ dm.getDriverName());

System.*out*.println("\tDriver Version: "+ dm.getDriverVersion ());

System.*out*.println("\nDatabase Information ");

System.*out*.println("\tDatabase Name: "+ dm.getDatabaseProductName());

System.*out*.println("\tDatabase Version: "+
dm.getDatabaseProductVersion());

System.*out*.println("Avalilable Catalogs ");

rs = dm.getCatalogs();

*while*(rs.next()){

System.*out*.println("\tcatalog: "+ rs.getString(1));
}


String[] types = {"TABLE", "VIEW"};

rstables = dm.getTables(*null*, "%", "%", types);

*while*(rstables.next()){

System.*out*.println("\ttables: " + rstables.getString(3) + "\t" +
rstables.getString(2) + "\t" + rstables.getString(1) + "\t" +
rstables.getString(4) );

}

rs.close();

rs = *null*;

closeConnection();

}*else* System.*out*.println("Error: No active Connection");

}*catch*(Exception e){

e.printStackTrace();

}

dm=*null*;

}
This took some googling for me as I am a Visual Studio Developer and
Eclispe, Java, jdbc, Cayenne, etc are all new to me but I got it to run.  I
got these results using the same connection string that I copy and pasted
out of Cayenne:


Connection Successful!

Driver Information

Driver Name: Microsoft SQL Server JDBC Driver 3.0

Driver Version: 3.0.1301.101

Database Information

Database Name: Microsoft SQL Server

Database Version: 10.00.1600

Avalilable Catalogs

***Here I get a list of all the catalogs and then I get a list of all of the
tables in all of the catalogs***
Is this what you were asking me to test?  What do I try next??


On Wed, Nov 3, 2010 at 5:36 PM, Andrus Adamchik <an...@objectstyle.org>wrote:

> At the end reverse engineering in Cayenne is based on JDBC API. More
> specifically it invokes DatabaseMetaData.getTables(..) method:
>
>
> http://download.oracle.com/javase/6/docs/api/java/sql/DatabaseMetaData.html#getTables%28java.lang.String,%20java.lang.String,%20java.lang.String,%20java.lang.String[]%29
>
> with catalog parameter set to NULL, schema and table patterns set to your
> selections, and "types" set to { "TABLE", "VIEW" }. Then it processes
> whatever is returned by this method.
>
> I guess one way to debug it is to write a simple JDBC test to see if the
> above returns any data.
>
> Andrus
>
>
>
> On Nov 3, 2010, at 6:19 PM, Mark Fischer wrote:
>
> > 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 <fa...@gmail.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 <
> andrus@objectstyle.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...
> >>>
> >>>
> >>
>
>

Re: Reengineer Database Schema not generating anything

Posted by Andrus Adamchik <an...@objectstyle.org>.

At the end reverse engineering in Cayenne is based on JDBC API. More specifically it invokes DatabaseMetaData.getTables(..) method:

http://download.oracle.com/javase/6/docs/api/java/sql/DatabaseMetaData.html#getTables%28java.lang.String,%20java.lang.String,%20java.lang.String,%20java.lang.String[]%29

with catalog parameter set to NULL, schema and table patterns set to your selections, and "types" set to { "TABLE", "VIEW" }. Then it processes whatever is returned by this method. 

I guess one way to debug it is to write a simple JDBC test to see if the above returns any data.

Andrus



On Nov 3, 2010, at 6:19 PM, Mark Fischer wrote:

> 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 <fa...@gmail.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 <an...@objectstyle.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...
>>> 
>>> 
>>

Re: Reengineer Database Schema not generating anything

Posted by Mark Fischer <fa...@gmail.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 <fa...@gmail.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 <an...@objectstyle.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...
>>
>>
>

Re: Reengineer Database Schema not generating anything

Posted by Mark Fischer <fa...@gmail.com>.

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 <an...@objectstyle.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...
>
>

Re: Reengineer Database Schema not generating anything

Posted by Andrus Adamchik <an...@objectstyle.org>.

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...