By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,480 Members | 2,192 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,480 IT Pros & Developers. It's quick & easy.

retrieve multivalued field using JDBC?

P: n/a
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!

Mar 4 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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!
Mar 4 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.