LLBLGen.com Forums Designer feed

New Table Name Dialog for Oracle has Catalog name disabled by Otis

Otis — Tue, 07 Sep 2010 10:07:06 GMT

Fixed in next build (September 7th)
- Default catalog for creating new target in UI is now set to the existing one
- Renaming default catalog is now allowed
- When choosing 'auto-map unmapped entities', the system always picked the default schema even though there was already an existing schema for databases which don't support multiple catalogs.

New Table Name Dialog for Oracle has Catalog name disabled by Otis

Otis — Tue, 07 Sep 2010 09:16:22 GMT

TomDog wrote:

Otis wrote:

That's because Oracle doesn't have the concept of a 'catalog', hence it's disabled (as in: you don't have to fill it in). If you really want to rename it, you can, do it in the catalog explorer, but it's really not used for Oracle.

The reason it's not editable is also because if you would have the choice, you might be able to specify different catalogs, which would be a bad thing as Oracle works with schemas.

Sure but why does it create a 'catalog' node called 'default' rather than use my existing '//vm-dt-sora10/AQDDesignMaster' 'catalog' node that the rest of my AQD schema is under.

Ok, _that_'s not what it should do. Will look into that.

New Table Name Dialog for Oracle has Catalog name disabled by TomDog

TomDog — Tue, 07 Sep 2010 08:50:59 GMT

Otis wrote:

Sure but why does it create a 'catalog' node called 'default' rather than use my existing '//vm-dt-sora10/AQDDesignMaster' 'catalog' node that the rest of my AQD schema is under.

New Table Name Dialog for Oracle has Catalog name disabled by Otis

Otis — Tue, 07 Sep 2010 07:30:09 GMT

New Table Name Dialog for Oracle has Catalog name disabled by Walaa

Walaa — Tue, 07 Sep 2010 07:18:27 GMT

Reproduced.
We will investigate this and get back to you a.s.a.p.

New Table Name Dialog for Oracle has Catalog name disabled by TomDog

TomDog — Tue, 07 Sep 2010 04:04:45 GMT

daelmo wrote:

I can't reproduce that. Could you please tell us the steps to reproduce it?

Which part can't you repro?
Anyway...
Open the attached project
edit any entity
In field mappings click 'new target'

New Table Name Dialog for Oracle has Catalog name disabled by daelmo

daelmo — Tue, 07 Sep 2010 02:24:19 GMT

I can't reproduce that. Could you please tell us the steps to reproduce it?

New Table Name Dialog for Oracle has Catalog name disabled by TomDog

TomDog — Tue, 07 Sep 2010 00:32:51 GMT

The 'New Table Name' Dialog for creating a new Oracle target has Catalog name disabled and set to 'Default'. When I click OK the table is created under a new Catalog 'Default' rather than the Catalog I want e.g '//vm-dt-sora10/AQDDesignMaster'.

Still happening in the August 30th release.

Reverse-engineer ResultSet to TypeView disabled by Otis

Otis — Mon, 06 Sep 2010 07:52:13 GMT

Isz wrote:

Hi Frans...

I figured it out. I had recalled that my original sp had dummy data for @accountId and @searchString which happened to allow the sp to actually bring back results. So it seems the designer requires an actual set of results in order to allow a TypedView to be mapped. Once I was able to create my TypedView again, I went back to the sp and replaced the dummy data back with the sql variables.

By "last tab" I believe you mean the last page where it warns you about running against a production database. Yes, there I did select my sp, but the TypedView was still disabled. With some actual data returned however, the option became present.

If this isn't desired, and you still want my project, let me know.

Thanks!

It indeed has to return an actual resultset. What the driver does is executing the proc inside a transaction and rolling the transaction back when done. It can only determine what columns there are in the resultset if the resultset is actually returned. The trick for SQL Server, by using SET FMTONLY ON; exec proc ;SET FMTONLY OFF; not always works (temp table using procs fail for example). So your conclusion is correct: if the proc doesnt return a resultset, the columns can't be determined and thus you can't map a typed view onto a resultset (as the designer doesn't know which view fields to create )

Reverse-engineer ResultSet to TypeView disabled by Isz

Isz — Sun, 05 Sep 2010 16:02:52 GMT