• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

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

 
Greenhorn
Posts: 27
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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]
 
Marshal
Posts: 79177
377
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Don't know. The Exception would appear to be occurring somewhere else.
 
Java Cowboy
Posts: 16084
88
Android Scala IntelliJ IDE Spring Java
  • Likes 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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?
 
Rancher
Posts: 4801
50
  • Likes 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
Marshal
Posts: 79177
377
  • Likes 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Whoever got anywhere by being normal? Just ask this exceptional tiny ad:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic