When I compile and run the java prog it says "1 record inserted.." but when I open my table in SQLdeveloper I dont find any updates in the table. They are all null! I have also set the classpath for ojdbc-6.jar. What mistake am I doing herE? Are there any other files that I should copy and paste? I am just a beginner so kindly please help. And how does my program in the Editplus direct the updates directly into the table created in SQL. What path does it follow?
Yes ive tried the program with autocommit too..and yes ive changed the string to the number thankyou. Can you kindly tell me what softwares do i need for jdbc? I have jdk 1.6, JdbcOdbc driver,Oracle SQL developer. Are there any jar files required?
saikrishn viru wrote:Yes ive tried the program with autocommit too..and yes ive changed the string to the number thankyou. Can you kindly tell me what softwares do i need for jdbc? I have jdk 1.6, JdbcOdbc driver,Oracle SQL developer. Are there any jar files required?
You are using ODBC-JDBC bridge driver? In java you should use a purse JDBC driver. Depending on what DB you are using, you can google the jar file. For example Oracle will be file ojdbc6.jar and mysql is mysql-connector-java-xxx.jar (xxx is the version).
K. Tsang is right about not using the JDBC-ODBC bridge. You can find links to JDBC drivers for Oracle at our Oracle FAQ. I'd suggest switching to Oracle driver immediately, it will save you a lot of trouble.
Unfortunately, I don't see a clear problem in your code. It does look like a forgotten commit, but autocommit is the default in JDBC, so it probably isn't the reason. Are you sure you're looking into the right table in SQL Developer?
I have a few lesser points, though:
1) You're using the SYSTEM account for your application. It is not a good practice. In real environment, it is outright impossible, as it would bring terrible security issues. But even for small learning project it is not appropriate (you might run into issues allocating too much space in the SYSTEM tablespace, for example). The best is to learn from your first day that SYSTEM is just for administering the database. You need to learn how to create users (look up the CREATE USER command in Oracle documentation) and grant them necessary privileges (the GRANT command). You'll do this using your SYSTEM account, but then you'll use the newly created user in your application.
If you don't know how to start, try this book. It doesn't teach you to create a new account, just to unlock and use an existing one, but still far better than using SYSTEM. And perhaps it might be useful to you for other reasons as well.
2) Learn how to use PreparedStatements. All of the reasons mentioned in the article apply fully to Oracle database.
3) Specify target column in the insert into statement (here is why).
I understand that. Please take my other notes as an advice for your longer term.
As I've said, I don't see why your code behaves the way you're describing. So my immediate advice would be:
1) Stop using ODBC and switch to Oracle's JDBC driver. I've given the necessary links in my earlier post. This is not probably the problem, but the JDBC-ODBC bridge is known to have some problems, and also while configuring the ODBC datasource a mistake can be made. Without completing this step, I won't be able to assist you further.
2) Make sure your program and the SQL Developer are connecting to the same database/user. When you switch to Oracle JDBC driver, you'll be able to use the exact same connect string in your application and in SQL Developer, so we'll all know they are connecting to the same DB.
How many rows do you see in the A1 table? Isn't it possible that the new rows are at the bottom, and you just haven't scrolled down enough?
3) Add a con.commit() after st.executeUpdate(). It's probably not the problem, but it can't hurt, and we'll eliminate another possible source of uncertainty.