java.sql.SQLException: ORA-00600: int

By: Muralidhar bp - pmurli
java.sql.SQLException: ORA-00600: int
2003-01-08 02:56
Hello,

I have written a simple report and a java program. when i complied it compiled properly and when i give "ant fill"
I am getting this error. Plzz help me...............
Thanx in advance.

Murli



C:\JasperReports\EPSITF\Reports\ListOfCustomerNo>ant fill

Buildfile: build.xml

fill:
[java] Before fill manager
[java] before loading driver
[java] after loading driver
[java] after getting con
[java] java.sql.SQLException: ORA-00600: internal error code, arguments: [t
tcgcshnd-1], [0], [], [], [], [], [], []

[java] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:1
68)
[java] at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
[java] at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
[java] at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)

[java] at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:889)
[java] at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleState
ment.java:1681)
[java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(Oracl
eStatement.java:1870)
[java] at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(Orac
lePreparedStatement.java:363)
[java] at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(Oracl
ePreparedStatement.java:314)
[java] at dori.jasper.engine.util.JRQueryExecuter.executeQuery(JRQueryE
xecuter.java:353)
[java] at dori.jasper.engine.util.JRQueryExecuter.executeQuery(JRQueryE
xecuter.java:131)
[java] at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:3
63)
[java] at dori.jasper.engine.fill.JRFiller.fillReport(JRFiller.java:114
)
[java] at dori.jasper.engine.JasperFillManager.fillReport(JasperFillMan
ager.java:217)
[java] at dori.jasper.engine.JasperFillManager.fillReportToFile(JasperF
illManager.java:138)
[java] at dori.jasper.engine.JasperFillManager.fillReportToFile(JasperF
illManager.java:106)
[java] at ListOfCustomerNo.main(ListOfCustomerNo.java:72)

[java] NESTED BY :
[java] dori.jasper.engine.JRException: Error executing report query :

[java] select b.BRANCH_CODE, b.BRANCH_NAME, count(c.customer_id) from TF_PA
R_BRANCH_PERSONALIZATION b,
[java] TF_M_CUSTOMER c where b.branch_code=c.branch_code group by
b.BRANCH_CODE, b.BRANCH_NAME


[java] at dori.jasper.engine.util.JRQueryExecuter.executeQuery(JRQueryE
xecuter.java:357)
[java] at dori.jasper.engine.util.JRQueryExecuter.executeQuery(JRQueryE
xecuter.java:131)
[java] at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:3
63)
[java] at dori.jasper.engine.fill.JRFiller.fillReport(JRFiller.java:114
)
[java] at dori.jasper.engine.JasperFillManager.fillReport(JasperFillMan
ager.java:217)
[java] at dori.jasper.engine.JasperFillManager.fillReportToFile(JasperF
illManager.java:138)
[java] at dori.jasper.engine.JasperFillManager.fillReportToFile(JasperF
illManager.java:106)
[java] at ListOfCustomerNo.main(ListOfCustomerNo.java:72)
[java] Java Result: 1

BUILD SUCCESSFUL
Total time: 26 seconds




By: Chuck Deal - cdeal
RE: java.sql.SQLException: ORA-00600: int
2003-01-08 05:32
If you look near the middle of the stack trace, you'll see a line labelled 'NESTED BY:'

Following this line, you will see the JasperReports exception. it is indicating that it couldn't execute your query. Perhaps, the login that you are usign in JasperReports doesn't have permission to execute that query? Perhaps you are pointing to the wrong database? Make sure that you can successfully run the query outside of JasperReports and then verify your JasperReports settings are correct (identical).