Hi!
Glad to know you get things working. Could you describe your complete
solution (what driver version, where did you put JAR files, step-by-step
server-side configuration, persistence.xml, and sample java code for
accessing the MS SQL Server), so somebody at Glassfish project could
document it on WIKI? This will avoid another user take so long to get
things working!
About the other problem you described, try to add following code just
before executing the query (this will avoid TopLink cache, to know if
this is the problem):
Query q = em.createQuery("select O from USERS O");
q.setHint(TopLinkQueryHints.REFRESH, HintValues.TRUE);
return q.getResultList();
(I did expect sintax is correct, since I just copy/paste then adapt from
my real code)
Regards,
Edson Richter
glassfish_at_javadesktop.org escreveu:
> Hi,
>
> I have solved the problem.
>
> I am able to create users.....and also view.
>
> But I am confused about one thing....whatever I have inserted in the Users table I am not able to view it. After inserting values from my program I opened SQL Server Enterprise Manager to see if the values are there. But I am not able to see the values there.
>
> When I select the values from the program I can see the values. And what ever values I have inserted manually in the Users table, I cant view it when I select it in the program. Sounds very funny.
>
> Can anyone please explain the mystery.
> [Message sent by forum member 'deepak1234' (deepak1234)]
>
> http://forums.java.net/jive/thread.jspa?messageID=216111
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe_at_glassfish.dev.java.net
> For additional commands, e-mail: users-help_at_glassfish.dev.java.net
>
>
>
>
>