Generate > Types from DB Schema

Discussions about modeling, execution and management of process/application data.
Forum rules
Make sure every topic contains information about your LSPS version and if relevant also your server OS, client OS, database name and version, and application server name and version.
Byron Glueck
 
Posts: 85
Joined: Thu Apr 26, 2012 8:17 pm

Generate > Types from DB Schema

Wed Aug 28, 2013 3:35 pm

Greetings,

We are experiencing some issues using this feature.

Using SQL Server 2008 and sqljdbc4-4.0.jar driver, the basic table structure and columns do get created.

However, the primary key column is created but the pk constraint is not being set. Also, no foreign key constraints are being generated.

Please advise. We can provide sample datatype file and DDL statements for db objects upon request.

Thanks!

Maros Bajtos
 
Posts: 145
Joined: Mon Feb 27, 2012 2:52 pm

Re: Generate > Types from DB Schema

Wed Aug 28, 2013 3:45 pm

Byron, please provide us with sample DDLs so that we can reproduce your error. After we get the DDLs, we will investigate and let you know where the problem is.

Byron Glueck
 
Posts: 85
Joined: Thu Apr 26, 2012 8:17 pm

Re: Generate > Types from DB Schema

Wed Aug 28, 2013 4:14 pm

Attached is simplified version, using 2 tables.

Thanks again.
Attachments
BusinessUnit-Merchant.DDL.sql
(2.41 KiB) Downloaded 314 times

Maros Bajtos
 
Posts: 145
Joined: Mon Feb 27, 2012 2:52 pm

Re: Generate > Types from DB Schema

Fri Aug 30, 2013 12:45 pm

Thanks Byron, we've been able to reproduce the behaviour. We are working on fix now.

Maros Bajtos
 
Posts: 145
Joined: Mon Feb 27, 2012 2:52 pm

Re: Generate > Types from DB Schema

Fri Aug 30, 2013 3:06 pm

Byron, thanks for reporting issue. The issue has been fixed, it will be delivered to you in the next eclipse update. The problem was caused by inconsistent character case of returned object names by different jdbc driver versions.

Return to Data modeling

Who is online

Users browsing this forum: No registered users and 1 guest