• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

sql execution problem

 
Igbe Jr. Chukwudi
Greenhorn
Posts: 12
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi friends,wrote some sql code 2 create a table and insert some data into the table.when i executed the command in netbeans 5.5,it executed,created the table and wn i viewed the data in the tabe,it showed the table with the data.but when i used netbeans 6.5,the same sql command executes,but does not show the table or any data,it show SELECT FROM*tablename.throwing a compiler error
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

throwing a compiler error

What does that error say?
 
Igbe Jr. Chukwudi
Greenhorn
Posts: 12
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
the error says: Error code -1, SQL state 42x01:syntax error: encountered 'public' at line 1, column 15. It shows the statement on command page: select * from PUBLIC.ITEM
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic