retrieve multivalued field using JDBC?

[Paul]

Hi,

I have an entry, called UserIDs. It is a multivalue entry (the new
type from Access 2007).
The entries look like
1; 5; 332; 28
3; 1; 557; 2; 47

However when I try to retrieve it using JDBC:
myResultSet.getMetaData().getColumnType(1)
this returns java.sql.Type of -1
Any ideas how I can retrieve this value - or is it not possible to use
multivalued fields with JDBC?

Thanks!

[Tom van Stiphout]

On 3 Mar 2007 18:03:38 -0800, "Paul" <pa*******@hotmail.comwrote:

If you are using a driver that ostensibly does not know about a
certain data type, you could not expect to retrieve its value
successfully. Software is rarely forward-compatible.

Of course multivalued fields can be avoided by creating the M:M
relationship yourself, the old-fashioned way.

-Tom.

>Hi,

I have an entry, called UserIDs. It is a multivalue entry (the new
type from Access 2007).
The entries look like
1; 5; 332; 28
3; 1; 557; 2; 47

However when I try to retrieve it using JDBC:
myResultSet.getMetaData().getColumnType(1)
this returns java.sql.Type of -1
Any ideas how I can retrieve this value - or is it not possible to use
multivalued fields with JDBC?

Thanks!