Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Java > Java Open Source > Apache Tomcat
|
Apache Tomcat General discussion of the Apache Tomcat servlet container. For discussions specific to the Professional Apache Tomcat book, please see the book discussion forum for that book.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Apache Tomcat section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 18th, 2005, 03:41 AM
Registered User
 
Join Date: Jun 2005
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default How to set values for String Column using ROWSET

Hello,
This is my first post to this forum.
I am trying to launch the reports developed in crystal Reports 10 in IBM Websphere 6.0 with Linux server.
I successfully launched the reports developed in Crystal Reports XI in Websphere environment.
When i am trying the same in Crystal Reports 10 version,i am facing the problem.The problem i wil explain it.
1.I am using rowset.jar file for forming disconnected recordset.
2.My data will be in XML.
3.I am trying to form an disconnected recordset using rowset.jar and assigning the values to the recordset.
4.I am able to assign values to all integer columns.When i am trying to do the same for string columns its not accepting.
5.I am using java.sql.Types for defining DataType for the columns in Disconnected recordset.
e.g.
owMeta.setColumnCount(1);
rowMeta.setColumnName(1,"empname");
//Here iam specifying java.sql.types
rowMeta.setColumnType(1,12);

CachedRowSet crs = new CachedRowSetImpl();
crs.setTableName("MyTable");
crs.setMetaData(rowMeta);
crs.setFetchDirection(ResultSet.FETCH_FORWARD);
crs.setType(ResultSet.TYPE_SCROLL_INSENSITIVE);
crs.setConcurrency(ResultSet.CONCUR_UPDATABLE);

crs.moveToInsertRow();
crs.updateString(1,"test");
6.here i am using string datatype.Now i am facing the problem.
7.If i use
rowMeta.setColumnType(1,4);//For Integer
i wont get any problem report launched with data.
Please tell me the solution if anyone knows.





Similar Threads
Thread Thread Starter Forum Replies Last Post
How to set Column width harapraveen XSLT 2 October 23rd, 2007 03:14 AM
How do you set a column to NULL in a parameter? Aaron Edwards ASP.NET 2.0 Basics 1 April 7th, 2006 11:26 PM
How do you set a column to NULL in a parameter? Aaron Edwards ADO.NET 3 April 7th, 2006 06:26 PM
How to set values for String Column using ROWSET technology Java Databases 0 June 18th, 2005 03:56 AM
Set Column Width Programmatically ritag Excel VBA 1 July 1st, 2004 01:00 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.