Jump to content
JasperReports Library 7.0 is now available ×

java.sql.SQLException: ORA-00600: int


Recommended Posts

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:JasperReportsEPSITFReportsListOfCustomerNo>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).

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...