permaculture playing cards*
The moose likes JDBC and the fly likes Telnet Disconnecting from Client app when executing query. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Telnet Disconnecting from Client app when executing query." Watch "Telnet Disconnecting from Client app when executing query." New topic
Author

Telnet Disconnecting from Client app when executing query.

Daniel Pride
Greenhorn

Joined: May 09, 2008
Posts: 11
I'm doing a project in NetBeans using the persistence API and a MySQL Database. I have already created a persistence unit with the proper connection information and an entity class for the table I am doing.

My main program is a server and I can request to add, remove, modify, or list the items in that table. I have no problem entering adding or removing data, but the problem is when I request "list" through telnet. The thread starts and executes this piece of code

<blockquote>code:
<pre name="code" class="core">
private void printUsers(PrintWriter p)
{
EntityManagerFactory emf = Persistence.createEntityManagerFactory("User_Database_TesterPU");
EntityManager em = emf.createEntityManager();

Query q = em.createQuery("SELECT p FROM users p");
List<Users> users = q.getResultList();

for(Users u : users)
{
p.println(u.toString());
p.flush();
}
}
</pre>
</blockquote>

There are 1000 elements in that table, but before it finishes printing, I get a "Connection to host lost".

Is this a problem with telnet or a problem with the way I'm using sockets and printwriter.

Also on a side note, why do I not see my input(on telnet) when connected to this application?
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Telnet Disconnecting from Client app when executing query.
 
Similar Threads
c:forEach builds s:selectMany
Keep getting NullPointerException
doubt in select statement in mysql database
JQuery fade problems
SimpleJdbcDaoSupport