List Info

Thread: about Fetchsize of Query




about Fetchsize of Query
user name
2007-11-06 20:30:39
Hi, Guru

[Environment]

-Solaris9
-Glassfish V2 b58g

[Question 1]

Can I use  the Array fetch with toplink essentials.
I  tested the below coding and it seem to be OK.
I  can't find a document about fetchsize of Toplink
Essentials.
If it don't be supported,  is there another method?


<snipped>
Query queryEmployees
	 = entityManager.createQuery("SELECT OBJECT(employee)
FROM Employee employee");
queryEmployees.setHint("fetchSize ", 100);
(List) queryEmployees.getResultList();

<snipped>


[Question 2]
What is  the "toplink.jdbc.bind-parameters"
property?
Please inform me information about the sample program.

Thank you very much.
[Message sent by forum member 'wildrose99' (wildrose99)]

http://forums.java.net/jive/thread.jspa?messageID=244216


------------------------------------------------------------
---------
To unsubscribe, e-mail: users-unsubscribeglassfish.dev.java.net
For additional commands, e-mail: users-helpglassfish.dev.java.net


Re: about Fetchsize of Query
user name
2007-11-07 09:43:44
> Hi, Guru
> 
> [Environment]
> 
> -Solaris9
> -Glassfish V2 b58g
> 
> [Question 1]
> 
> Can I use  the Array fetch with toplink essentials.
> I  tested the below coding and it seem to be OK.
> I  can't find a document about fetchsize of Toplink
> Essentials.
> If it don't be supported,  is there another method?
> 
> 
> <snipped>
> Query queryEmployees
> = entityManager.createQuery("SELECT
> CT OBJECT(employee) FROM Employee employee");
> queryEmployees.setHint("fetchSize ", 100);
> (List) queryEmployees.getResultList();
> 
> <snipped>
> 
> 
> [Question 2]
> What is  the "toplink.jdbc.bind-parameters"
> property?
> Please inform me information about the sample
> program.
> 
> Thank you very much.
Please see  http:
//www.oracle.com/technology/products/ias/toplink/JPA/essenti
als/toplink-jpa-extensions.html#QueryHints
[Message sent by forum member 'lancea' (lancea)]

http://forums.java.net/jive/thread.jspa?messageID=244303


------------------------------------------------------------
---------
To unsubscribe, e-mail: users-unsubscribeglassfish.dev.java.net
For additional commands, e-mail: users-helpglassfish.dev.java.net


[1-2]

about | contact  Other archives ( Real Estate discussion Medical topics )