Getting Timestamp results in java.sql.SQLException: General error

Question

I have a problem with fetching a timestamp from an Oracle database.

The table is created as follows:

create table csi(start_time timestamp);

Then I selected the value as follows:

import java.sql.*;

public class hel
{
    public static void main(String args[])
    {
        try
        {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection con=DriverManager.getConnection("jdbc:odbc:mohit","system","rock");
            PreparedStatement ps=con.prepareStatement("select * from csi");
            ResultSet rs=ps.executeQuery();
            while(rs.next())
            {
                //System.out.println(rs.getString(4));
            }
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }

    }
}

But it throws the following exception:

java.sql.SQLException: General error
     at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
     at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
     at sun.jdbc.odbc.JdbcOdbc.SQLPrepare(Unknown Source)
     at sun.jdbc.odbc.JdbcOdbcConnection.prepareStatement(Unknown Source)
     at sun.jdbc.odbc.JdbcOdbcConnection.prepareStatement(Unknown Source)
     at hel.main(hel.java:10)

How is this caused and how can I solve it?

BalusC · Accepted Answer · 2011-10-06 16:14:05Z

2

Here's a simple translation of the first few lines of the trace (read comments from bottom to top):

java.sql.SQLException: General error
  at sun.jdbc.odbc.JdbcOdbc.createSQLException         // I have to create and throw the SQL exception!
  at sun.jdbc.odbc.JdbcOdbc.standardError              // Uuuh, something failed?
  at sun.jdbc.odbc.JdbcOdbc.SQLPrepare                 // Let's start preparing it.
  at sun.jdbc.odbc.JdbcOdbcConnection.prepareStatement // Ah, a prepared statement is been requested.

It look like that the JDBC ODBC bridge driver doesn't understand how to create prepared statements for an Oracle 10g database.

Just do not use that lousy driver. You're not the first one who encounters DB-specific problems with it. Use a real Oracle JDBC driver instead.

edited Oct 6, 2011 at 16:14

answered Oct 6, 2011 at 15:57

BalusC

1.1m377 gold badges3.7k silver badges3.6k bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Sanjay T. Sharma · Accepted Answer · 2011-10-06 15:40:19Z

0

Please post the exact error. Also, why are you trying to retrieve a string from something which contain a timestamp? Look into the getTimestamp method of the ResultSet object for your needs.

answered Oct 6, 2011 at 15:40

Sanjay T. Sharma

23.3k4 gold badges63 silver badges72 bronze badges

4 Comments

user925689 Over a year ago

it will throw the error on executing the PreparedStatement. getTimeStamp() is the next thing to execute after PreparedStatement.

Sanjay T. Sharma Over a year ago

Need more info; what kind of database is this? Also, the table you create is called "store" whereas in the query you use "csi". Are you sure the table "csi" exists and the query in consideration returns result when fired from a SQL editor?

user925689 Over a year ago

Oh sorry it's a mistake i have created the table named csi it's not store.As i said earlier i am using oracle(10g exp).

Sanjay T. Sharma Over a year ago

SQLException supports chaining. Can you specifically catch SQLException and call its nextException() method to see if there are any other exceptions in there. Or better yet, use the iterator to print out all the chained exceptions. Read: download.oracle.com/javase/6/docs/api/java/sql/… . Also as already mentioned, use a real driver provided by oracle instead of the historical JDBC-ODBC bridge.

Collectives™ on Stack Overflow

Getting Timestamp results in java.sql.SQLException: General error

2 Answers 2

Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related