2013年7月29日星期一

hibernate error: Table 'I am using the database. all_sequences'doesn't exist. well unpopular estimated that the issue can not find theanswer in this life

hibernate error: Table 'I am using the database. all_sequences' doesn't exist.

This is how it was. I am useless to all_sequences this table.

introduce all_sequences some information:
ALL_SEQUENCES describes all sequences accessible to the current user.
Baidu translate what is this mean: all_sequences describes all the current user's access sequence.


Why hibernate find this table. I use reverse engineering to generate the two tables po and configuration files.

id generator using native
------ Solution ---------------------------- ----------------
generated key all_sequences this time by trying to find whether there is this sequence, which is trying to oracle comes with the system does not exist, you are not not using it with oracle hibernate but became oracle
------ Solution ----------------------------- ---------------
put your hibernate.cfg.xml configuration and id generator stickers out, you will not be dialect configuration error
- ---- For reference only ---------------------------------------
Floor the powerful. It gave you found. I use the mysql database, ask this question how to solve it?
------ For reference only -------------------------------------- -
update <>
I configured this it automatically updates.
can connect to the mysql database. Time seems to be reported in the updated fault.
If configured as the oracle of the words should be connected are not open fishes.
This is what happens
------ For reference only ------------------------------ ---------

org.hibernate.dialect.Oracle10gDialect <>
question should be here, dialect forget changed, tomorrow back to the company try.

should be changed org.hibernate.dialect.MySQLDialect
------ For reference only ------------------------ ---------------
problem has been resolved. Is because I use the mysql database and then configure the oracle dialect dialect.

Thank you upstairs to answer

1 条评论: