File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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 Soft Skills this week in the Jobs Discussion 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.