Problem with JBuilder2005 and Oracle 9i on Windows 2000 workstation

From: nemrod2100 <nemrod2100_at_yahoo.com>
Date: Wed, 24 Nov 2004 20:19:39 +0100
Message-ID: <41a4dec6$0$25140$8fcfb975_at_news.wanadoo.fr>

Problem with JBuilder2005 and Oracle 9i on Windows 2000 workstation

Hello I tried to test a basic classe connecting to Oracle 9i However I obtained this strange error message

java.sql.SQLException: ORA-00600: internal code error, arguments : [ttcgcshnd-1], [0], [], [], [], [], [], []

 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
 at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
 at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:542)
 at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1311)
 at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:797)

 at
oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:1608)  at oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.java:1758)  at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java :1807)
 at
oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:411)  at
monbabarpremier.MaTroisiemeClasseOracle.main(MaTroisiemeClasseOracle.java:26 )
Exception in thread "main"
The classe is very basic and database is also

My classe is

package monbabarpremier;
import java.sql.*;
import oracle.jdbc.driver.*;
import java.util.*;
public class MaTroisiemeClasseOracle
{

public static void main(String[] args)
throws SQLException, ClassNotFoundException, java.io.IOException
{

  String uneUrl = "jdbc:oracle:thin:_at_piv3ghz:1521:BDSOUTOU";   String uneUrl02 = "jdbc:oracle:thin:_at_169.254.164.254:1521:BDSOUTOU";

  String loginUser02 ="moustac";
  String passwordLoginUser02 = "0123456789";

{

Class.forName("oracle.jdbc.driver.OracleDriver"); Connection uneConnexion = DriverManager.getConnection( "jdbc:oracle:thin:_at_169.254.164.254:1521:bdsoutou","moustac","0123456789"); Statement unEnonceSQL = uneConnexion.createStatement(); String uneRequete02 ="select nomsegment from segments"; String uneRequete01= "select sysdate from dual";

//select nomsegment from segments
//"SELECT NOMSEGMENT FROM SEGMENTS "
//select * from dept;

ResultSet unCurseur = unEnonceSQL.executeQuery("select nomsegment from segments");
while(unCurseur.next())

     {
     //NOMSEGMENT
     String unNomDeSegment = unCurseur.getString("nomsegment");
     System.out.println(" "+ unNomDeSegment);
     }

//unEnonceSQL.close();
uneConnexion.close();
}
//catch(SQLException)
{

}
}
}

This is strange because when I apply this request "select sysdate from dual" it gave me the good result. It seems that JBuilder can connect to Oracle but not abble to reach my BDSOUTOU database .
I actived all Oracle services on Windows. Untill now without results.
Jbuilder shows me that the problem came from this line
at
monbabarpremier.MaTroisiemeClasseOracle.main(MaTroisiemeClasseOracle.java:26 )
matches with this line
ResultSet unCurseur = unEnonceSQL.executeQuery("select nomsegment from segments");

I tried other request on other tables, spelling several times ("nomsegment") or the name of this colunn without results. getString("nomsegment");I know this is a common mistakes

What's happened???
I don't know if problems comes from JBuilder or Oracle 9i or Windows2000 workstation, or bad services which parasytes the connection. Of course I loaded the true ojdbc14.jar or classe12.jar. I added as new librarie, with tools/configuration etc... Can somebody help me.I worked on Windows 2000 workstation. Best regards. Received on Wed Nov 24 2004 - 20:19:39 CET