Hello friends,
I am changing my database from PostgreSQL to Oracle 11g. I am using hibernate 3.0 with Java and Struts.
Everything is working fine with PostgreSQL.
I have changed following in hibernate.cfg.xml file.
<property name="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
<property name="hibernate.connection.password">mypassword</property>
<property name="hibernate.connection.url">jdbc:Oracle:thin:@192.168.1.1:1521/mydb</property>
<property name="hibernate.connection.username">my_user</property>
<property name="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect</property>
Everything else is same as that was in Postgresql.
I am using ojdbc5.jar
Now when I run my page it gives me following error.
ORA-00903: invalid table name
Can any one help me regarding the matter?
Thanks.