Java - Oracle connection

1 отговора 100 прегледа
#1

Java - Oracle connection

Kogato se svarzvam s bazata (Oracle) danni poluchavam tova saobshtenie:
D:\oracle\ora90\Apache\jdk\bin>java JDBCVersion
waw: java.sql.SQLException: ORA-00600: internal error code, arguments: [ttcgcshn
d-1], [0], [], [], [], [], [], []

ako sql-a mi ne sadarja VARCHAR2 pole (pri men to e "name") niamam problemi. Da rechem taka: "select id from names1". Problema e samo ako izvikvam i pole ot tip varchar2. Kak da resha tozi problem?

A eto i koda mi:

import java.sql.*;
import oracle.jdbc.driver.*;
class JDBCVersion
{
public static void main (String args[])
throws SQLException
{

try {
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn = DriverManager.getConnection
("jdbc:oracle:thin:@localhost:1521:CORETREK","scott","tiger");
Statement statement = conn.createStatement();
ResultSet rs = statement.executeQuery("select * from names1");

while(rs.next()){
System.out.print(rs.getInt(1)+"+\n");
System.out.print(rs.getInt(2)+"v\n");
System.out.print(rs.getInt(3)+"r\n");
System.out.print(rs.getString(1)+"++\n\n");
}

} catch (SQLException sqle) {
System.err.println("waw: " + sqle);
} catch (ClassNotFoundException cnfe) {
System.err.println("qqq: " + cnfe);
}
}
}

Отговор
в отговор на vladi #2

Re: Java - Oracle connection

Hi,
Daj si celia stack-trace na exception-a ta da ti kazha kyde e greshkata.
Zasega moga da ti kazha da si poglednesh alert.log i trace.log na oracle (pri verison 8 i 9 v dir udump/). Tam triabva da ima poveche info.

Probval li si "select name from names1"?

Burn baby!
Отговор