how to insert date to the database using jdbc

[Arun raghvan]

Could some help me out ,with this .

i'm unable to insert date to the date field of EMP table

  

package com.cluster.simplejdbcodbc;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;


public class Simplejdbcodbc {
	public static void main(String[] args) {
		try {
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			try {
				Connection connection=DriverManager.getConnection("jdbc:odbc:arun","scott","tiger");
				Statement statement=connection.createStatement();
				System.out.print(connection);
				int a=statement.executeUpdate("insert into emp values(1,'eee','clrk',666,TO_CHAR('05/05/2007',DD/MM/YYYY),1500,700,30)"); //unable to insert Date 
				ResultSet resultSet=statement.executeQuery("select 	EMPNO,ENAME from emp");
				
				
				while(resultSet.next())
				{
					System.out.print(resultSet.getInt(1)+"\t");
					System.out.print(resultSet.getString(2));
					System.out.println("\n");
				}
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		


	}

}

  

[Paul Sturrock]

Use a PreparedStatement.

Also - unless you are using Access as your database you probably don't want to use the JDBC-ODBC bridge.

[Gian Franco]

Hi Arun,

Try

TO_DATE('05/05/2007',DD/MM/YYYY)

instead of

TO_CHAR('05/05/2007',DD/MM/YYYY)

[Gian Franco]

...additionally the names scott and tiger reveal that it is most probably an Oracle database.

Personally I would always put the list of column names in the INSERT statement as well and not rely
on the default order of the columns.

HTH

[Nir Tal]

try inserting the system date by using sysdate instead of the to_char. If this works, I will let you know how to insert the user specific one.