5 messages in com.mysql.lists.javaRe: "SELECT x FROM a WHERE y IN list"...
FromSent OnAttachments
Christofer Dutz17 Aug 2005 09:36 
Alan Williamson17 Aug 2005 10:07 
Christofer Dutz18 Aug 2005 04:32 
Alan Williamson18 Aug 2005 04:38 
Shankar Unni19 Aug 2005 13:28 
Subject:Re: "SELECT x FROM a WHERE y IN list"-Type queries?
From:Alan Williamson (al@blog-city.com)
Date:08/18/2005 04:38:18 AM
List:com.mysql.lists.java

I allready stumbled over this alternative. But I think passing a string representation of the IN-String is not quite what I wanted, since this list can contain a very large amount of entries. My Idea was to pass a real Java-List to MySQL and let MySQL operate on this. But I think I already found out that this doesn't seem to be possible :(

You will *always* have to deal with STRINGs if you plan to go direct through the JDBC layer. There is no getting around it.

If however you wish to work within Java objects, then consider using a framework to abstract all this work away from you; Hibernate for example is a popular layer for database operations.

Depends on your underlying application and how close you want to get to the database.