John,
  Looks like a visual web issue, can you evaluate it ? If so, please update the categories.
thanks

Insert,Edit,Delete in Database DB2 works in 6.1.  I'll attach a similar project.

Created attachment 59436 [details]
Sample DB2 project

Most likely, the problem is you need to upgrade the DB2 driver
See
http://wiki.netbeans.org/DatabasesAndDrivers#section-DatabasesAndDrivers-IBMDriverForTheDB2Database

Also, you may need to copy a native library to the classpath of your Application Server, On Windows, the library is
db2jcct2.dll  and it is copied to the lib directory of your Application Server

After updating the DB2 driver and the project still doesn't work, if you can attach your project I'll evaluate

Hi Thanks For the Response.
U r right , i am working using the Visual Web application.
and i have worked according to ur reference.
but still i am facing the same problem.

I am enclosing my Test Application to u that has 2 pages  ConstantsView and ConstantsEdit.

My Constants View Use to call Constants Edit Page.

My Table Structure is :
CREATE TABLE "DB2ADMIN"."CONSTANTS"  (
		  "ID" DECIMAL(31,0) NOT NULL , 
		  "GROUPNAME" VARCHAR(64) , 
		  "VALUE" VARCHAR(64) , 
		  "DESCRIPTION" VARCHAR(64) , 
		  "SEQUENCE" DECIMAL(22,0) )   
		 IN "USERSPACE1" ; 

ALTER TABLE "DB2ADMIN"."CONSTANTS" 
	ADD CONSTRAINT "SYS_C0057446" PRIMARY KEY("ID");


And One thing that i left to tell u :
While Deploying my application i am getting the trace :::::

PWC2768: IOException while loading persisted sessions: java.io.EOFException
java.io.EOFException
        at java.io.ObjectInputStream$PeekInputStream.readFully(ObjectInputStream.java:2237)
        at java.io.ObjectInputStream$BlockDataInputStream.readShort(ObjectInputStream.java:2703)
        at java.io.ObjectInputStream.readStreamHeader(ObjectInputStream.java:760)
        at java.io.ObjectInputStream.<init>(ObjectInputStream.java:278)
        at org.apache.catalina.session.StandardManager.doLoad(StandardManager.java:428)
        at org.apache.catalina.session.StandardManager.load(StandardManager.java:372)
        at org.apache.catalina.session.StandardManager.start(StandardManager.java:764)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:5130)
        at com.sun.enterprise.web.WebModule.start(WebModule.java:326)
        at com.sun.enterprise.web.LifecycleStarter.doRun(LifecycleStarter.java:58)
        at com.sun.appserv.management.util.misc.RunnableBase.runSync(RunnableBase.java:304)
        at com.sun.appserv.management.util.misc.RunnableBase._submit(RunnableBase.java:176)
        at com.sun.appserv.management.util.misc.RunnableBase.submit(RunnableBase.java:192)
        at com.sun.enterprise.web.VirtualServer.startChildren(VirtualServer.java:1672)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1231)
        at org.apache.catalina.core.StandardHost.start(StandardHost.java:955)
        at com.sun.enterprise.web.LifecycleStarter.doRun(LifecycleStarter.java:58)
        at com.sun.appserv.management.util.misc.RunnableBase.runSync(RunnableBase.java:304)
        at com.sun.appserv.management.util.misc.RunnableBase.run(RunnableBase.java:341)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417)
        at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269)
        at java.util.concurrent.FutureTask.run(FutureTask.java:123)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
        at java.lang.Thread.run(Thread.java:595)
PWC2773: Exception loading sessions from persistent storage
java.io.EOFException
        at java.io.ObjectInputStream$PeekInputStream.readFully(ObjectInputStream.java:2237)
        at java.io.ObjectInputStream$BlockDataInputStream.readShort(ObjectInputStream.java:2703)
        at java.io.ObjectInputStream.readStreamHeader(ObjectInputStream.java:760)
        at java.io.ObjectInputStream.<init>(ObjectInputStream.java:278)
        at org.apache.catalina.session.StandardManager.doLoad(StandardManager.java:428)
        at org.apache.catalina.session.StandardManager.load(StandardManager.java:372)
        at org.apache.catalina.session.StandardManager.start(StandardManager.java:764)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:5130)
        at com.sun.enterprise.web.WebModule.start(WebModule.java:326)
        at com.sun.enterprise.web.LifecycleStarter.doRun(LifecycleStarter.java:58)
        at com.sun.appserv.management.util.misc.RunnableBase.runSync(RunnableBase.java:304)
        at com.sun.appserv.management.util.misc.RunnableBase._submit(RunnableBase.java:176)
        at com.sun.appserv.management.util.misc.RunnableBase.submit(RunnableBase.java:192)
        at com.sun.enterprise.web.VirtualServer.startChildren(VirtualServer.java:1672)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1231)
        at org.apache.catalina.core.StandardHost.start(StandardHost.java:955)
        at com.sun.enterprise.web.LifecycleStarter.doRun(LifecycleStarter.java:58)
        at com.sun.appserv.management.util.misc.RunnableBase.runSync(RunnableBase.java:304)
        at com.sun.appserv.management.util.misc.RunnableBase.run(RunnableBase.java:341)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417)
        at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269)
        at java.util.concurrent.FutureTask.run(FutureTask.java:123)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
        at java.lang.Thread.run(Thread.java:595)

do u have some idea what can be the Reason 

I have Downloaded Netbeans6.1 beta and Test the same.
Still having the same problem.

Please Check My problem.

Thanks
Praveen Rohilla

Created attachment 59477 [details]
My Application Source

One setting is not correct:

In SessionBean1, you return a constant value for the data source name

 public String getDataProviderName() {
        return "jdbc/DB2_NT";
 }


Instead, the constant should be

"java:comp/env/jdbc/DB2_NT"

 public String getDataProviderName() {
        return "java:comp/env/jdbc/DB2_NT";
 }

thanks for response but 
have u verified this Bug beforeinvalidation this bug, and with the solution provided to me ??????????

After changing the Constant String to "java:comp/env/jdbc/DB2_NT" instead of "jdbc/DB2_NT", still i am facing the same
problem.

Sir,
How can u say -- This problem is related to "Datasource" String.
If I am able to Create Rowset and DataProvider For Displaying data According to DataSource "jdbc/DB2_NT".
then How can u say this problem is related to "DataSource" String.
DataProvider is Same in Every case, for View and Edit both.

Please Recheck this Issue.

I think this may be issue of DB2 Compatibility.

I will be thankful to u if
 u provide me the DB2 jars U r using( If my project is working properly with u )

I am using Driver jars :
C:\Program Files\IBM\SQLLIB\java\Common.jar
C:\Program Files\IBM\SQLLIB\java\db2fs.jar
C:\Program Files\IBM\SQLLIB\java\db2jcc.jar
C:\Program Files\IBM\SQLLIB\java\db2jcc_javax.jar
C:\Program Files\IBM\SQLLIB\java\db2jcc_license_cisuz.jar
C:\Program Files\IBM\SQLLIB\java\db2jcc_license_cu.jar
C:\Program Files\IBM\SQLLIB\java\db2policy.jar
C:\Program Files\IBM\SQLLIB\java\db2qgjava.jar

and i have placed my db2jcct2.dll in my ${JAVA_HOME}\jre\bin  folder.

and with this Configuration , i am able to connect with database.
I have not done any other Configuration to Connect with DB2.

if anything is wrong here , then please tell me.
I will be thankful to u.

I am waiting for ur response.......

Thanks
Praveen Rohilla.

thanks for response but 
have u verified this Bug beforeinvalidation this bug, and with the solution provided to me ??????????

After changing the Constant String to "java:comp/env/jdbc/DB2_NT" instead of "jdbc/DB2_NT", still i am facing the same
problem.

Sir,
How can u say -- This problem is related to "Datasource" String.
If I am able to Create Rowset and DataProvider For Displaying data According to DataSource "jdbc/DB2_NT".
then How can u say this problem is related to "DataSource" String.
DataProvider is Same in Every case, for View and Edit both.

Please Recheck this Issue.

I think this may be issue of DB2 Compatibility.

I will be thankful to u if
 u provide me the DB2 jars U r using( If my project is working properly with u )

I am using Driver jars :
C:\Program Files\IBM\SQLLIB\java\Common.jar
C:\Program Files\IBM\SQLLIB\java\db2fs.jar
C:\Program Files\IBM\SQLLIB\java\db2jcc.jar
C:\Program Files\IBM\SQLLIB\java\db2jcc_javax.jar
C:\Program Files\IBM\SQLLIB\java\db2jcc_license_cisuz.jar
C:\Program Files\IBM\SQLLIB\java\db2jcc_license_cu.jar
C:\Program Files\IBM\SQLLIB\java\db2policy.jar
C:\Program Files\IBM\SQLLIB\java\db2qgjava.jar

and i have placed my db2jcct2.dll in my ${JAVA_HOME}\jre\bin  folder.

and with this Configuration , i am able to connect with database.
I have not done any other Configuration to Connect with DB2.

if anything is wrong here , then please tell me.
I will be thankful to u.

I am waiting for ur response.......

Thanks
Praveen Rohilla.

Hi Praveen,

I am certain that DB2 works with Visual Web.  I have attached a project you can use to try out.
Also I will attach the sql used to generate the table.

In your code the rowset was set to the wrong data source value.  I provided the correct value.

Please make sure you are using the DB2 JDBC driver version Redistributable DB2 JDBC Type 4 driver v8 fixpack 13 
as I mentioned at this link 
http://wiki.netbeans.org/DatabasesAndDrivers#section-DatabasesAndDrivers-IBMDriverForTheDB2Database

Created attachment 59589 [details]
SQL script

Also in the attached project, you'll need to edit sun-resources.xml by replacing
your server name with the one listed

Praveen,  I see you're using a lot of session APIs to do the Inserts.

I suggest to take a look at the attached project to see the recommended way to Insert data.

Also, I will attach the driver jars I'm using for my DB2 project since the URL to download had changed on IBM's site.

Also, I cannot open CONSTANTSview.jsp.  There are some exceptions.  I filed another issue for this one
http://www.netbeans.org/issues/show_bug.cgi?id=131894

Created attachment 59594 [details]
unzip the jars then Add New Driver in NetBeans Services tab

I'm going to mark this INCOMPLETE for now until I hear back 

Regarding this error message:  "No columns in table: USER"  I think the reason is the connection to the database had
been closed at the moment the insert was attempted.

I think the reason the connection was closed is because your code uses the Session APIs instead of following the
JSF lifecycle.  The attached example uses the JSF lifecycle.

Instead of declaring and using the rowset in CONSTANTSedit, instead, use the rowset in SessionBean1

Is there any particular reason for using the rowset in page scope?
Typically the rowset is used in session scope

Hi
U r right, there is problem in opening project of version 6.0 in 6.1
but i have checked the project by recreating the project in 6.1 and apply the same source code to project. 
u can check by creating new project in 6.1 and apply my source.
Actully i Have send u the RAR file.
I think now u will be able to open and run my project properly n any of the version.
netbeans version does not matter, if it works in 6.1 then i will use 6.1 , if in 6.0 then i will use 6.0 to create my
whole application.

I am creating an application that create -- jsp page,Java Class and Navigation Rules according to table selected from
database(means like creating master Pages Only).

can u tell me why we should creating our row set in session scope ??
if i am going to create a large application(having 1000 rowset) then is it right to  write every rowset in session bean.
my single page can use 6-7 rowset at a single time.

I have send u only the single -(basic and simplest) File of my requirement.

in that case what should i do.
thanks for help.
I am finding solution for it since last 10 days.
but still in same stage.
i think only u peoples can help me in solving the problem.

waiting for response + solution.

Praveen Rohilla

If the rowset is put in Page1 then the application ...
- doesn't scale for multiple users accessing the same page
- the database connection can be closed when there's a postback (such as clicking a link or button)
- constricts the application to one page.  If in the future multiple pages are added then they can't use the rowset properly

For help with your application, please work with our Support team
http://developers.sun.com/services/expertassistance/index.jsp?intcmp=1365

Thank you