db error

db error

View Answers

May 5, 2009 at 10:28 AM

hello,
you have to change the datatype of the field in which you are inserting your text area
content. if you are using mysql then put the datatype as "longtext".

repply your feedback.

May 5, 2009 at 11:33 AM

Hi Friend,

Try the following code:

import java.awt.*;
import java.sql.*;
import javax.swing.*;
import java.awt.event.*;

class Form extends JFrame {
Form() {
JLabel label = new JLabel();
label.setText("Enter Description:");
JButton ADD=new JButton("Insert");
final JTextArea area =new JTextArea(10,25);

final JPanel panel=new JPanel(new GridLayout(2,2));
panel.add(label);
panel.add(area);
panel.add(ADD);

add(panel,BorderLayout.CENTER);
ADD.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent ae){
String value=area.getText();
Connection con = null;
String url = "jdbc:mysql://192.168.10.126/";;
String db = "roseindia";
String driver = "com.mysql.jdbc.Driver";
String user = "root";
String pass = "root";
try{
Class.forName(driver);
con = DriverManager.getConnection(url+db, user, pass);
Statement st = con.createStatement();
int i= st.executeUpdate("Insert into Description(description) values('"+value+"')");
JOptionPane.showMessageDialog(null,"Data is successfully inserted into the database." );
st.close();
con.close();
}
catch(Exception e){
System.out.println(e);
}
}
});
}
}
class InsertTextArea{
public static void main(String arg[]) {
try {
Form frame=new Form();
frame.setSize(300,100);
frame.setVisible(true);
}
catch(Exception e) {}
}
}
You have to put the 'text' or 'longtext' datatype for the textarea field in the database table.

Thanks









Related Tutorials/Questions & Answers:
ERRor in executing DB program
ERRor in executing DB program  While executing following code an Error was generated.can any one help me for this. LiveDB liveDBObj...=pstmt.executeUpdate(qry); ---------- **ERROR:java.sql.SQLException: You have
Zend Db error - WebSevices
Zend Db error  Hello friends, How i get the values from the database using zend framework Any one know the code. Help me
Advertisements
db error - Java Beginners
db error  Hi, how to insert text area content into database...://192.168.10.126/"; String db = "roseindia"; String driver = "com.mysql.jdbc.Driver...(driver); con = DriverManager.getConnection(url+db, user, pass
error
error  while iam compiling iam getting expected error
Error-
Error-   Hello, I would like to know about XSD file. I try to print XML file but I am getting error SAXException-- says Content is not allowed in prolog. Please help me
error
error  i have 404 error in my program plz tell me yhe solution about
error
error  i have 404 error in my program plz tell me yhe solution about
error
/ServletUserEnquiryForm.shtml getting an error given below SQLException caught: [Microsoft][ODBC SQL Server Driver]COUNT field incorrect or syntax error please suggest
Error
Error  I have created ajax with php for state and city. When I change state then city will not come in dropdown list and it give me error as 'Unknown Runtime Error'. This error come only in IE browser, but in other brower
error
error  java.lang.unsupportedclassversionerror:bad major version at offset 6 how to solve this????   Hi, Please check the version of framework used and also the JDK version.ADS_TO_REPLACE_1 This type error also comes
error
error
error
error  When I deploye the example I have this message cannot Deploy HelloWorld Deployment Error for module: HelloWorld: Error occurred during deployment: Exception while deploying the app [HelloWorld
error!!!!!!!!!
error!!!!!!!!!   st=con.createStatement(); int a=Integer.parseInt(txttrno.getText()); String b=txttname.getText(); String c=txtfrom.getText(); String d=txtto.getText
error!!!!!!!!!
error!!!!!!!!!   st=con.createStatement(); int a=Integer.parseInt(txttrno.getText()); String b=txttname.getText(); String c=txtfrom.getText(); String d=txtto.getText
error!!!!!!!!!
error!!!!!!!!!   st=con.createStatement(); int a=Integer.parseInt(txttrno.getText()); String b=txttname.getText(); String c=txtfrom.getText(); String d=txtto.getText
Error
Error  Hi. I am getting error in the following code after the line I have commented as ERROR. How to solve this. Thanks in advance. package...;"); // ERROR out.println(" var pattern
Error
Error  Hi. I am getting error in the following code after the line I have commented as ERROR. How to solve this. Thanks in advance. package...;"); // ERROR out.println(" var pattern
Error
Error  Hi. I am getting error in the following code after the line I have commented as ERROR. How to solve this. Thanks in advance. package...;"); // ERROR out.println(" var pattern
Error
Error  Hi. I am getting error in the following code after the line I have commented as ERROR. How to solve this. Thanks in advance. package...;"); // ERROR out.println(" var pattern = /^\d{3,5
error
"+it); } } this is my program i am getting an error saying cannot find symbol class stringADS
error
error  whats the error.............. import java.util.Scanner; public class g { public static void main(String[] args) { Scanner s=new Scanner(System.in); int d,x,y; System.out.println("Enter the first number
ModuleNotFoundError: No module named 'db'
is throwing following error: ModuleNotFoundError: No module named 'db' How to remove the ModuleNotFoundError: No module named 'db' error...: No module named 'db' error will be solved. Thanks
JSF error
JSF error  some of the users are not able to update the db. getting the error "An Error Occurred: Error calling action method of component with id CreateorManageOffer:jidjsp134312524923 Caused by: java.lang.NullPointerException
DB connectivity - EJB
DB connectivity  DB connectivity
DB Insert
DB Insert  How to insert XML data into a database column? Column data type is CLOB
ModuleNotFoundError: No module named 'cnx-db'
, ModuleNotFoundError: No module named 'cnx-db' error will be solved. Thanks...ModuleNotFoundError: No module named 'cnx-db'  Hi, My Python program is throwing following error: ModuleNotFoundError: No module named 'cnx
ModuleNotFoundError: No module named 'atom-db'
, ModuleNotFoundError: No module named 'atom-db' error will be solved...ModuleNotFoundError: No module named 'atom-db'  Hi, My Python program is throwing following error: ModuleNotFoundError: No module named 'atom
ModuleNotFoundError: No module named 'binance-db'
;binance-db' error? Thanks   Hi, In your python environment you...ModuleNotFoundError: No module named 'binance-db'  Hi, My Python program is throwing following error: ModuleNotFoundError: No module named
ModuleNotFoundError: No module named 'cnx-db'
, ModuleNotFoundError: No module named 'cnx-db' error will be solved. Thanks...ModuleNotFoundError: No module named 'cnx-db'  Hi, My Python program is throwing following error: ModuleNotFoundError: No module named 'cnx
ModuleNotFoundError: No module named 'cnx-db'
, ModuleNotFoundError: No module named 'cnx-db' error will be solved. Thanks...ModuleNotFoundError: No module named 'cnx-db'  Hi, My Python program is throwing following error: ModuleNotFoundError: No module named 'cnx
ModuleNotFoundError: No module named 'connect-db'
;connect-db' error? Thanks   Hi, In your python environment you...ModuleNotFoundError: No module named 'connect-db'  Hi, My Python program is throwing following error: ModuleNotFoundError: No module named
ModuleNotFoundError: No module named 'courts-db'
-db' error? Thanks   Hi, In your python environment you... python library, ModuleNotFoundError: No module named 'courts-db' error...ModuleNotFoundError: No module named 'courts-db'  Hi, My Python
ModuleNotFoundError: No module named 'cuckoo-db'
-db' error? Thanks   Hi, In your python environment you... python library, ModuleNotFoundError: No module named 'cuckoo-db' error...ModuleNotFoundError: No module named 'cuckoo-db'  Hi, My Python
ModuleNotFoundError: No module named 'db_class'
ModuleNotFoundError: No module named 'db_class'  Hi, My Python program is throwing following error: ModuleNotFoundError: No module named 'db... library, ModuleNotFoundError: No module named 'db_class' error
ModuleNotFoundError: No module named 'db-commuter'
ModuleNotFoundError: No module named 'db-commuter'  Hi, My Python program is throwing following error: ModuleNotFoundError: No module named 'db-commuter' How to remove the ModuleNotFoundError: No module named 'db
ModuleNotFoundError: No module named 'db_dumper'
ModuleNotFoundError: No module named 'db_dumper'  Hi, My Python program is throwing following error: ModuleNotFoundError: No module named 'db... python library, ModuleNotFoundError: No module named 'db_dumper' error
ModuleNotFoundError: No module named 'db_export'
ModuleNotFoundError: No module named 'db_export'  Hi, My Python program is throwing following error: ModuleNotFoundError: No module named 'db... python library, ModuleNotFoundError: No module named 'db_export' error
ModuleNotFoundError: No module named 'db-logger'
ModuleNotFoundError: No module named 'db-logger'  Hi, My Python program is throwing following error: ModuleNotFoundError: No module named 'db... python library, ModuleNotFoundError: No module named 'db-logger' error
ModuleNotFoundError: No module named 'db-logger'
ModuleNotFoundError: No module named 'db-logger'  Hi, My Python program is throwing following error: ModuleNotFoundError: No module named 'db... python library, ModuleNotFoundError: No module named 'db-logger' error
ModuleNotFoundError: No module named 'db-playmate'
ModuleNotFoundError: No module named 'db-playmate'  Hi, My Python program is throwing following error: ModuleNotFoundError: No module named 'db-playmate' How to remove the ModuleNotFoundError: No module named 'db
ModuleNotFoundError: No module named 'db-prob'
ModuleNotFoundError: No module named 'db-prob'  Hi, My Python program is throwing following error: ModuleNotFoundError: No module named 'db..., ModuleNotFoundError: No module named 'db-prob' error will be solved
ModuleNotFoundError: No module named 'db-prob'
ModuleNotFoundError: No module named 'db-prob'  Hi, My Python program is throwing following error: ModuleNotFoundError: No module named 'db..., ModuleNotFoundError: No module named 'db-prob' error will be solved
ModuleNotFoundError: No module named 'db_refresh'
ModuleNotFoundError: No module named 'db_refresh'  Hi, My Python program is throwing following error: ModuleNotFoundError: No module named 'db_refresh' How to remove the ModuleNotFoundError: No module named 'db
ModuleNotFoundError: No module named 'db-report'
ModuleNotFoundError: No module named 'db-report'  Hi, My Python program is throwing following error: ModuleNotFoundError: No module named 'db... python library, ModuleNotFoundError: No module named 'db-report' error
ModuleNotFoundError: No module named 'db-sheet'
ModuleNotFoundError: No module named 'db-sheet'  Hi, My Python program is throwing following error: ModuleNotFoundError: No module named 'db... library, ModuleNotFoundError: No module named 'db-sheet' error
ModuleNotFoundError: No module named 'db-sheet'
ModuleNotFoundError: No module named 'db-sheet'  Hi, My Python program is throwing following error: ModuleNotFoundError: No module named 'db... library, ModuleNotFoundError: No module named 'db-sheet' error
ModuleNotFoundError: No module named 'db-sync'
ModuleNotFoundError: No module named 'db-sync'  Hi, My Python program is throwing following error: ModuleNotFoundError: No module named 'db..., ModuleNotFoundError: No module named 'db-sync' error will be solved
ModuleNotFoundError: No module named 'db_util'
ModuleNotFoundError: No module named 'db_util'  Hi, My Python program is throwing following error: ModuleNotFoundError: No module named 'db..., ModuleNotFoundError: No module named 'db_util' error will be solved
ModuleNotFoundError: No module named 'db-utils'
ModuleNotFoundError: No module named 'db-utils'  Hi, My Python program is throwing following error: ModuleNotFoundError: No module named 'db... library, ModuleNotFoundError: No module named 'db-utils' error
ModuleNotFoundError: No module named 'dima-db'
, ModuleNotFoundError: No module named 'dima-db' error will be solved...ModuleNotFoundError: No module named 'dima-db'  Hi, My Python program is throwing following error: ModuleNotFoundError: No module named 'dima

Ads