This is the mail archive of the
xsl-list@mulberrytech.com
mailing list .
Re: Extending xsltproc?
My sincere apologies for placing this under a wrong subject. But, I did get a
reply and it worked. The solution is this:
if(rsa != null) //this did the trick
{
while(rsa.next())
{
//this is where the error took place
String dbremarks=rsa.getString(1);
}
}
Mathy
Mathy V Arumugam wrote:
> Any help is appreciated!!!
>
> I know this is not an appropriate place to ask this question but, have
> anyone experienced the following:
>
> I have SQL exception error on trying to access a MS Access memo field.
> I have defined remarks as a MEMO datatype and using JDBC-ODBC driver (JDK1.3)
> to access data.
> Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
> Connection con = DriverManager.getConnection(url,uid,passwd);
> Statement stmt = con.createStatement();
>
> qryb="select remarks " +"from definition_tbl where desc_id= "+descId+
> " ORDER BY definition_tbl.rowId,definition_tbl.subId";
> rsa = stmt.executeQuery(qryb);
> while(rsa.next())
> {
> //this is where the error takes place
> String dbremarks=rsa.getString(1);
> }
>
> error:
> --- SQLException caught---
>
> Message: null
> SQLState: null
> ErrorCode: 0
>
> I have tried this...
> Clob dbremarks=rsa.getClob(1);
> getting UnsupportedOperationException error at runtime...
> java.lang.UnsupportedOperationException
> at sun.jdbc.odbc.JdbcOdbcResultSet.getClob(JdbcOdbcResultSet.java:4224)
>
> Thanks a lot for any advice!!!
>
> Mathy
>
> XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list