Halcon Guatemala

Hi Kai, could you be sure this line is in your hibernate configuration file:

<property name = "hibernate.query.factory_class">org.hibernate.hql.classic.ClassicQueryTranslatorFactory</property> ?

Thanks

Hi Jazzy, could you post your entire trace... Is Hibernate generating a valid query You can run in another place.

Thanks

Hi Andy, could you show us more about your design or mapping resources?
Thanks in advance

Can you provide additional info about your problem? Thanks

Hi Mallik, can you explain us, how are you adding your mapping resource? is it in your hibernate.cfg.xml? are you indicating the path of your mapping resource from classpath?

Thanks in advance

Hi madhuchilipi, do you want to retrieve your entire table content inside one resultset? or you want to retrieve a single value inside your string?

Thanks

Hi again Somak, sorry but I didn't know about your 2 criterias You want to do "or" between. It seems any case of sql "union" clause, You know it isn't supported by Criteria API, You might considerate to use SQLQuery for it...

I hope this helps

Hi Somak, I suggest You use Restrictions instead Expression. You must remember Expression supports nested Expression(s):

Expression.or(Expression1, Expression2);


I hope it helps

Hi again, I hope it could be helpful. I don't think you must remove the mentioned code lines, I think if Sponsor has each one an Main, why must you repeat relationship for add another attribute to Main class.

Hi again Somak, your foreign key attribute is'nt primary key, is it? I believe You could omit an sponsorId in MainModel, it is redundant statement:

model.setSponsorId(350);

Regards

Hi Somak, could you provide us with info about relationships between entities in your database model.

Thanks

Hi to @ll, Mark, could you illustrate it? Could We nest distinct queries attaching criterias repeteadly?

Thanks in advance

Hi Stan, I'm facing a similar problem, and I want to know what are you referring about when you say

Everything works fine, just as long as you don't use SSL.

Where are you using SSL?

Thanks in advance

Hi again aadhar, thanks for explaining.

I believe both, cases 2 and 3 are possible because Restrictions.like is traduced as SQL like and it supports '%' wildcards to discover string patterns.

Respect to case 1, I don't know about how it can be done with Criteria API, I have worked in HQL combination with SUBSTR because my database supports it, like something:

cadenaQuery = "SELECT COUNT(ABM.numeroman) " + " FROM AdBitacoraEmanDto ABM" " WHERE ABM.fechaingreso = To_Date( '" +format.format(pFecha) + "', 'dd/MM/yyyy')" + " AND [B]SUBSTRING[/B](ABM.numeromanifiesto,1,1) IN ('0','1','2','3','4','5','6','7','8','9')";

Hi aadhar, could You specify more precisely? What kind of wild card search do you refer?