are you still getting the "not found" error ? if you know the table or view exists in the DB, then you're probably running into tables/views which have quoted names. If they are not quoted in the db, id check the archive from about a day or so ago. it seems that recent versions of Fluent would auto-quote table names....
On Sun, Jan 24, 2010 at 8:27 AM, Gregory Kaidanov <[email protected]>wrote: > I just shortened my Entity Files names so that the combination is less > than 30 letters , but I don't think that it is a good solution . > No real alias table issue solution was found. > > On Jan 24, 1:11 pm, Gregory Kaidanov <[email protected]> wrote: > > well , I've tried to do that. > > > > HasManyToMany<YechidotDoarInGroup>(x => x.Col_yig) > > .Table("PigToYig") > > .ChildKeyColumn("YIG_GROUP_RECID") > > .ParentKeyColumn("PIG_GROUP_RECID"); > > > > but I've got > > ORA-00942: table or view does not exist > > I am trying to establish HasManyToMany connection not by ID , but by > > some other property . > > First I've got - too long message. > > When I've tried to enter my own Table name as an alias , it's not > > recognized . > > What should I do? > > > > On Jan 21, 9:30 pm, Hudson Akridge <[email protected]> wrote: > > > > > > > > > HasManyToMany().AsBag().Table("ShorterJoinTableName"); > > > > > If you're talking about the aliases that are used whenever sql is > executed, > > > that's an NHibernate question and you should probably repost your > question > > > over to the nhusers google group. FNH doesn't have any control (that > I'm > > > think of at least) over the alias names used for association joins. > > > > > If you're talking an alias in a query, you can alias joins in a > criteria or > > > HQL query by using the "AS" keyword. > > > > > On Thu, Jan 21, 2010 at 1:10 PM, sternr <[email protected]> wrote: > > > > I've got a very long table names, and since the alias FNH creates for > > > > a join is the name of both the tables, my DataBase (Oracle) gives me: > > > > "Identifier Too Long". > > > > > > Is there a way to control the Alias names FNH gives my tables\joins? > > > > If not, is there any other solution? (considering its a legacy > > > > Database...) > > > > > > Thanks ahead, > > > > > > --sternr > > > > > > -- > > > > You received this message because you are subscribed to the Google > Groups > > > > "Fluent NHibernate" group. > > > > To post to this group, send email to > [email protected]. > > > > To unsubscribe from this group, send email to > > > > [email protected]<fluent-nhibernate%[email protected]><fluent-nhibernate%2Bunsubscr > [email protected]> > > > > . > > > > For more options, visit this group at > > > >http://groups.google.com/group/fluent-nhibernate?hl=en. > > > > > -- > > > - Hudsonhttp://www.bestguesstheory.comhttp://twitter.com/HudsonAkridge > > -- > You received this message because you are subscribed to the Google Groups > "Fluent NHibernate" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]<fluent-nhibernate%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/fluent-nhibernate?hl=en. > > -- You received this message because you are subscribed to the Google Groups "Fluent NHibernate" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/fluent-nhibernate?hl=en.
