Getting data from CLOB object
[205 byte] By [kmathewma] at [2007-10-2 14:16:34] 
I have a table column whose type is a CLOB object, HOw do i fetch the values into Char [] charArray and populate String objectAny code help is greatly appreciatedthanksPM
You can tryClob clob=rs.getClob("YourlobColumnName"); String strval=clob.getSubString(1,clob.length()) OrReader reader=clob.getCharacterStream();char[] charval=new char[clob.length())];int count=rader.read(charval);
zhaoyha at 2007-7-13 12:32:51 >
Database Connectivity New Topic
- Storing an array into the database using jdbc
- UDB scalar functions and parameter markers
- DTS through JDBC
- How to use our own Primary Key generator
- JDBC DB2 connection with JCreator
- ResultSet.getBytes(...) method returns wrong number of bytes
- problem with driver for MS ACCESS."Unable to create appropriate ResultSet"
- Conversion of ArrayList to Resultset Back...
Database Connectivity Hot Topic
- previous(), beforeFirst() not working after setting TYPE_SCROLL_SENSITIVE
- Combine queries (union?) to create multiple form drop-down lists?
- Weird Invalid column type
- Not Valid password when connecting password protected MS Access
- DDL and DML
- JDBC and MySQL connectivity problem
- Resultset query
- Problem connecting to database
Database Connectivity
All Classified
- Archived Forums
- Enterprise & Remote Computing
- Java Essentials
- Desktop
- Core
- Solaris Operating System
- Security
- Database Connectivity
- Java Mobility Forums
- Web & Directory Servers
- Development Tools
- Application & Integration Servers
- Java HotSpot Virtual Machine
- Other Topics
- E-Mail, Calendar, & Collaboration
- Developer Tools
- General
- Administration Tools
- Sun Hardware
- Storage Forums
- Java Enterprise System
- StarOffice
- Open Source Technologies
- BigAdmin
- Real-Time
- Java Coding