#4 Missing case for java.sql.Types.OTHER

[Michael D Simpson]

Using the 1.6.5 version against Posgresql I got this exception:

java.sql.SQLException: Unsupported JDBC-Type: 1111
at de.simplicit.vjdbc.serial.RowPacket.populate(RowPacket.java:222)
at de.simplicit.vjdbc.serial.StreamingResultSet.populate(StreamingResultSet.java:126)
at de.simplicit.vjdbc.server.command.ConnectionEntry.handleResultSet(ConnectionEntry.java:281)
at de.simplicit.vjdbc.server.command.ConnectionEntry.executeCommand(ConnectionEntry.java:183)
at de.simplicit.vjdbc.server.command.CommandProcessor.process(CommandProcessor.java:158)
at de.simplicit.vjdbc.server.servlet.ServletCommandSink.handleRequest(ServletCommandSink.java:146)
at de.simplicit.vjdbc.server.servlet.ServletCommandSink.doPost(ServletCommandSink.java:119)

Investigating further, I see that "JDBC-Type: 1111" is actually java.sql.Types.OTHER.
In the class:
de.simplicit.vjdbc.serial.RowPacket
method:
public boolean populate(ResultSet rs) throws SQLException
there is a big switch statement
switch (_columnTypes[internalIndex])
that has cases for many java.sql.Types but does NOT have one for java.sql.Types.OTHER.
So I added the case:
case Types.OTHER:
_flattenedColumnsValues[internalIndex].setObject(_rowCount, rs.getObject(i));
break;
And it seems my code seems to work fine now.

[Michael D Simpson]

I see this is the same thing mentioned in the "Dirty hack for postgis users" post