Getting sql error [Microsoft ][odbc microsoft access driver]numeric index out of range

[navinsingh dalal]

I am using MS ACCESS as a data base to insert some text into the table and getting this error.If i do not add alphanumeric character in the text field than its working , but when i am writing alphanumeric character in this address field than i am getting this error.

import javax.swing.*;
import java.awt.event.*;
import java.awt.*;
import java.sql.*;
class add implements ActionListener
{
	        JFrame f1;
			JPanel p1;
			JLabel l1;
			JLabel l2;
			JTextField tf1;
			JLabel l3;
			JTextField tf2;
			JLabel l4;
			JTextField tf3;
			JLabel l5;
			JTextField tf4;
			JButton b1;
			
	add()
{
f1= new JFrame("add");
p1=new JPanel();
l1=new JLabel("--------CUSTOMER DETAILS-------------");	
l2= new JLabel("NAME ");
l3= new JLabel("ADDRESS");
l4= new JLabel("PHONE NUMBER");
l5= new JLabel("RANK");
tf1=new JTextField(10);
tf2 =new JTextField(10);
tf3 =new JTextField(10);
tf4 =new JTextField(10);
b1=new JButton("SUBMIT");
f1.getContentPane().add(p1);
p1.add(l1);
p1.add(l2);
p1.add(tf1);
p1.add(l3);
p1.add(tf2);
p1.add(l4);
p1.add(tf3);
p1.add(l5);
p1.add(tf4);
p1.add(b1);
p1.setLayout(null);
l1.setBounds(480,15,500,25);
l2.setBounds(355,45,100,25);
tf1.setBounds(450,45,200,25);
l3.setBounds(355,95,100,25);
tf2.setBounds(450,95,200,25);
l4.setBounds(355,150,100,25);
tf3.setBounds(450,150,200,25);
l5.setBounds(355,200,100,25);
tf4.setBounds(450,200,200,25);
b1.setBounds(480,270,100,25);
f1.setSize(1280,768);
f1.setVisible(true);
b1.addActionListener(this);
}
public void actionPerformed (ActionEvent e)
		{
		try
		{
		if(e.getSource()==b1)
		{
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	   Connection con = DriverManager.getConnection("jdbc:odbc:prashant","","");
	   PreparedStatement st = con.prepareStatement("insert into customerdetails values(?,?,?,?)");
       st.setString(1,tf1.getText());
	   st.setString(2,tf2.getText());
	   st.setString(3,tf3.getText());
	   st.setString(4,tf4.getText());
	   st.executeUpdate();
	   JOptionPane.showMessageDialog(f1,"THANX FOR INPUT");
	}
		}
		catch(Exception r)
		{
		System.out.println(r);
		}
		}
public static void main(String ss[])
{
add a1= new add();

}
}

[navinsingh dalal]

Please someone help me regarding this.

[Jeanne Boyarsky]

Navin,
Note that this is an international forum. Due to work hours/sleep schedules, it can take up to 24 hours for people to see your post.

What does the DDL for customerdetails look like? In particular, how many columns and what types. Also, I recommend adding explicit column names to your query. That way you know Access is inserting the values in the order you intended.

insert into customerdetails (name, address, ...) values(?,?,?,?)

[Tom Reilly]

Which line of code produces the error?

[navinsingh dalal]

I have a table of customer details which have four column.name(text),address(memo(alphanumeric)),phone number(number),rank(text).When i am entering text in the address field ,its working fine,but when i am using text and numeric its giving this error.I don't know resolve it .I have google it but got found nothing about how to resolve this error.please help.

[navinsingh dalal]

Jenne,

IF you don't write the column name it will select all the column.

Tom,

Its a run time error and it says sql error [Microsoft ][odbc microsoft access driver]numeric index out of range.And it comes when i am adding alphanumeric character to address field and it works fine when i am just entering text in address field.

[navinsingh dalal]

Thanks guys for your efforts .The problem is solved now .Its a mistake done by me as i have selected wrong data type in database.

[Jeanne Boyarsky]

navinsingh dalal wrote:Jenne,

IF you don't write the column name it will select all the column.

Yes. In the order defined in the DDL. This means if that order cvhanges, the code won't work. Not something that happens often, but listing the columns is a good habit to get into. It also helps with readability.