Errorjava.sql.SQLException - General Error... HELP!!!
We are using JDK1.5.. MS access db. Eclipse IDE. The program has no problem retrieving data... but it gets stuck when we use executeUpdate... Showing the above error statement.
import java.sql.*;
import javax.swing.*;
import java.io.*;
public class db
{
public static void main(String args[])
{
int i,size=0,CID=0,type=0;
String lang=" ",str2,str3;
String userinput="abc";
ResultSet res1,res,res2;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection("jdbc:odbc:DatasourceDSN");
Statement stat = conn.createStatement();
Statement stat1=conn.createStatement();
Statement stat2=conn.createStatement();
String str = "Select * from ContentProfile where Location='"+userinput+"'";
res = stat.executeQuery(str);
while(res.next())
{
size=res.getInt("Size");
lang=res.getString("Language");
CID=res.getInt("ContentId");
type=res.getInt("Type");
System.out.println(size+lang+CID);
}
str2="select ClientId,DeviceId,ClientProfile.Language as cl,ClientProfile.Type as ct,Size from ClientProfile,DeviceProfile where ClientProfile.Language=DeviceProfile.Language";
res1=stat1.executeQuery(str2);
while(res1.next())
{
int cid=res1.getInt("ClientId");
int did=res1.getInt("DeviceId");
String lan =res1.getString("cl");
int typ=res1.getInt("ct");
int siz=res1.getInt("Size");
System.out.println(cid+did+lan+typ+siz);
}
str3="Insert into SourceProfile values("+CID+","+size+",'"+lang+"',"+type+")";
i = stat2.executeUpdate(str3);
if(i!=0)
{
System.out.println("inserted into Source profile"+i);
}
}
catch(Exception e)
{
System.out.println("Error" +e);
}
}
}
We have no idea what the error means!!! We tried using a finally block... but no use.Please help.. someone...!!!!!
