Hi, I have been trying to use the JDBCDescriptor store and SQL Server 2000 along with:
Microsoft SQL Server 2000 Driver for JDBC
(Service Pack 1) Version 2.2.0029
During the domain initialisation the following exception
SQLException is thrown @ line 1597:
"ResultSet can not re-read row data for column 4"
The cause is an attempt to read the result columns
out of order i.e. PROPERTY_NAMESPACE is column 5,
PROPERTY_VALUE is column 4.
To fix replace the body of the while loop with:
String propertyName = res.getString(PROPERTY_NAME);
String propertyValue = res.getString(PROPERTY_VALUE);
String propertyNamespace = res.getString(PROPERTY_NAMESPACE);
String propertyType = res.getString(PROPERTY_TYPE);
boolean propertyProtected = (res.getInt(PROPERTY_PROTECTED) == 1);
NodeProperty property =
new NodeProperty(propertyName,
propertyValue,
propertyNamespace,
propertyType,
propertyProtected);
properties.put(propertyNamespace + propertyName, property);
I have attatched the patched file.
Cheers
Rob Tomlin
JDBCDescriptorsStore.zip
Description: JDBCDescriptorsStore.zip
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
