Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Exception in thread "main" java.lang.ArrayIndexOutOfBoundsException: 7

791261Aug 30 2011 — edited Oct 15 2014
Hi friends i am using Oracle Express 10g 2
in the XE database i am having a table USERS +(USER_ID USER_NAME USER_LEVEL_CODE USER_BRANCH_CODE USER_DEPT_CODE USER_PASSWORD USER_ENTD_BY USER_AUTH_BY)+ when i try to Connect with Java or Jasper Report i am getting Errors.
In Java

With Classes12, ojdbc6 and ojdbc12 Jar's
package jdbcEX1;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import oracle.jdbc.*;

public class Ex1 {

public static void main(String args[]) throws ClassNotFoundException,
SQLException {

Class.forName("oracle.jdbc.driver.OracleDriver");
// DriverManager.registerDriver(
// new oracle.jdbc.driver.OracleDriver());
Connection conn = DriverManager.getConnection(
*"jdbc:oracle:thin:@localhost:1521:XE", "uthaya", "password");*

Statement stmt = conn.createStatement();
ResultSet rset = stmt.executeQuery("select * from users");
while (rset.next())
{
System.out.println(rset.getInt(1));
System.out.println(rset.getString(2));
System.out.println(rset.getString(3));
System.out.println(rset.getInt(4));
System.out.println(rset.getString(5));
System.out.println(rset.getString(6));
System.out.println(rset.getString(7));
System.out.println(rset.getString(8));

}

rset.close();
stmt.close();
conn.close();
}
}

The Error is
Exception in thread "main" java.lang.ArrayIndexOutOfBoundsException: 7
at oracle.security.o3logon.C0.r(C0)
at oracle.security.o3logon.C0.l(C0)
at oracle.security.o3logon.C1.c(C1)
at oracle.security.o3logon.O3LoginClientHelper.getEPasswd(O3LoginClientHelper)
at oracle.jdbc.ttc7.O3log.<init>(O3log.java:289)
at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:251)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:246)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:365)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:260)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at jdbcEX1.Ex1.main(Ex1.java:18)



I tried with
Connection conn = DriverManager.getConnection(
"jdbc:oracle:thin:@localhost:8080:XE", "uthaya", "password");
too ..

Please help me to fix it ...

Thanks in Advance .
Uthaya

Edited by: Uthaya on Aug 30, 2011 5:50 AM
This post has been answered by Joe Weinstein-Oracle on Aug 30 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 27 2011
Added on Aug 30 2011
3 comments
583 views