Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

java.sql.SQLSyntaxErrorException: ORA-00904: "SO2_"."JENISTRANSAKSI": invalid identifier

 
Irliyanti Rahmadhani Lubis
Greenhorn
Posts: 27
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello guys,
I want to ask what the mean of "java.sql.SQLSyntaxErrorException: ORA-00904: "SO2_"."JENISTRANSAKSI": invalid identifier"
because I have explain that in every Class Model, on DTO FilterCriteria but, why is still "invalid identifier".

I want to make like image desain.
that column
Jenis Transaksi
, is not getting from table, but I'm making it like :


i'm make that for everi class, and I want to get the value of
jenisTransaksi
to my view JSP.
but, the error is "jenisTransaksi is invalid identifier"


Thanks advance
desain.PNG
[Thumbnail for desain.PNG]
 
Campbell Ritchie
Sheriff
Posts: 51439
87
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Don't know. The Exception would appear to be occurring somewhere else.
 
Jesper de Jong
Java Cowboy
Saloon Keeper
Posts: 15642
47
Android IntelliJ IDE Java Scala Spring
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
That is an error message that is coming from the Oracle database that you are using.

Are you doing an SQL query or insert from your Java code? Can you show us the code that does that database action?

The error message means that there is an error in the SQL statement you're trying to execute. Maybe you made a mistake so that it isn't a valid SQL statement, or you're trying to access a table or column that doesn't exist in the database. Specifically, the database is telling you that it doesn't know what "SO2_"."JENISTRANSAKSI" is. Are you sure that you have a table named "SO2_" with a column named "JENISTRANSAKSI" in the database?
 
Dave Tolls
Ranch Hand
Posts: 2110
16
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"SO2_" is the alias given by Hibernate, or some other similar framework.
The key is the column name, JENISTRANSAKSI, and whether that exists in whatever table is being queried.
 
Campbell Ritchie
Sheriff
Posts: 51439
87
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Not a “beginning” question. Let's try the Hibernate forum first. (Also our databases forum.)
 
Irliyanti Rahmadhani Lubis
Greenhorn
Posts: 27
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Jesper de Jong wrote:That is an error message that is coming from the Oracle database that you are using.
The error message means that there is an error in the SQL statement you're trying to execute. Maybe you made a mistake so that it isn't a valid SQL statement, or you're trying to access a table or column that doesn't exist in the database. Specifically, the database is telling you that it doesn't know what "SO2_"."JENISTRANSAKSI" is. Are you sure that you have a table named "SO2_" with a column named "JENISTRANSAKSI" in the database?


Dave Tolls wrote:"SO2_" is the alias given by Hibernate, or some other similar framework.
The key is the column name, JENISTRANSAKSI, and whether that exists in whatever table is being queried.


Campbell Ritchie wrote:Not a “beginning” question. Let's try the Hibernate forum first. (Also our databases forum.)



Thank's all to replay my question.
But, it solved now.
The error because I don't make my
as or .
But, I wan't to make it table, so I put . There's no error again, but the value String can getting in to JSP file.

So, in every class model, for attribute GET in the return value, I give "Kupu Incoming", "Kupu Outgoing", etc.
On JSP, I call that atributte.
and it Done.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic