Hibernate Community • View topic - problem using "select *..."

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

problem using "select *..."

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

thelime

Post subject: problem using "select *..."

Posted: Mon Aug 07, 2006 11:45 am

Newbie

Joined: Wed Jul 26, 2006 10:14 am
Posts: 4

hi,

i'm trying to get an ArrayList of objects from my database.

Code:

lender.setLicenses((ArrayList)sess.createQuery("select * from "+LoanDBConstants.BANK_CL_LICENSE_TABLE+" where BNK_CL_ID='"+corrId+"'").list());

it doesn't like the * in select *, how else can i do this without using the *???

thanks in advance

Top

bkmr_77

Post subject:

Posted: Mon Aug 07, 2006 11:55 am

Expert

Joined: Tue Apr 25, 2006 12:04 pm
Posts: 260

Instead of using table_name you can use mapping class name in your hql.

so your line of code becomes

Code:

lender.setLicenses( (ArrayList) sess.createQuery(" from BankClLicense bcl where bcl.bnkClId = ? ").setParameter( 0, corrId ).list());

where BANK_CL_LICENSE_TABLE mapping class is BankClLicense and bnkClId is the property for the column BNK_CL_ID

However, if you want SQL itself, use createSQLQuery()

Code:

lender.setLicenses((ArrayList)sess.createSQLQuery("select * from "+LoanDBConstants.BANK_CL_LICENSE_TABLE+" where BNK_CL_ID='"+corrId+"'").list());

Top

thelime

Post subject:

Posted: Mon Aug 07, 2006 12:07 pm

Newbie

Joined: Wed Jul 26, 2006 10:14 am
Posts: 4

well i used the SQLquery and it works...thanks...

Top

Page 1 of 1

[ 3 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum