Subject: Re: [xsl] Extending xsltproc? From: Mathy V Arumugam <mathy.v.arumugam@xxxxxxxxxxxx> Date: Fri, 26 Apr 2002 08:55:49 -0700 |
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
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
Re: [xsl] Extending xsltproc?, Mathy V Arumugam | Thread | Re: [xsl] Extending xsltproc?, David Carlisle |
[xsl] [Announce] XT Version 2002042, Bill Lindsey | Date | RE: [xsl] Design problem - print he, Zarella Rendon |
Month |