problems[1]........txt

This is a Rural Dispensary Management System developed in Java Swing. Liquid Aqua look and feel had

	Solved that problem of the constraints yesterday morning........ But some of the other problems are......

1. Error in insertion.... The error stack is
	java.sql.SQLException: General error
	at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6908)
	at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7036)
	at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java:3065)
	at sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcStatement.java:338)
	at sun.jdbc.odbc.JdbcOdbcStatement.executeUpdate(JdbcOdbcStatement.java:288)
	at patient.Pnl_buttons$2.mouseClicked(Pnl_buttons.java:54)
	at java.awt.AWTEventMulticaster.mouseClicked(AWTEventMulticaster.java:208)
	at java.awt.Component.processMouseEvent(Component.java:5137)
	at java.awt.Component.processEvent(Component.java:4931)
	at java.awt.Container.processEvent(Container.java:1566)
	at java.awt.Component.dispatchEventImpl(Component.java:3639)
	at java.awt.Container.dispatchEventImpl(Container.java:1623)
	at java.awt.Component.dispatchEvent(Component.java:3480)
	at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3450)
	at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3174)
	at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3095)
	at java.awt.Container.dispatchEventImpl(Container.java:1609)
	at java.awt.Window.dispatchEventImpl(Window.java:1590)
	at java.awt.Component.dispatchEvent(Component.java:3480)
	at java.awt.EventQueue.dispatchEvent(EventQueue.java:450)
	at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:197)
	at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:150)
	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:144)
	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:136)
	at java.awt.EventDispatchThread.run(EventDispatchThread.java:99)

   	My 54th line where it is showing the error is 
								stmt1.executeUpdate("INSERT INTO INPATIENT VALUES ('5', 'as', 17, 'm', 'ab', 'gdfgfh', 'gdgdfg', 982523922)");

	One more thing in that--> I've selected integer data type for the phone no. but it allows only 9digits.. Anything longer than 9digits         is rejected...........

   Though i'm getting this error at the console, the data is inserted in the table properly.....

2. How to connect through DB2 driver?

3. How to access the text field of one class in other class so that i can get the text from the tf's and    insert that in the database....

4. How to create the exact database table structure at other pc. We have copied the script and using    it... But suppose,say, we go to VKP    to show him the project then what are the things we need to do?

5. To run the project on some other pc i should have java, DB2 and my class code. Then i'll create an       bat file which run the main file    frm_main in java by the code somewhat like 
         java <path for the frm_main.class>..... 
   Should it be like that?

6. I've created one separate class for the Insert and search butttons and loaded that with the patient's    personal information, but now the    problem is how should i differentiate between the inpatient and       outpatient tab pane. I want to know which tabpane is active and then    insert values accordingly as i've separate tables for inpatient and outpatients as per thir requirement.

7. Do i need to give commit after inserting the values and before disconnecting?