No such database or table exists when schema is specified in the java class

[waiwai177]

Hi, I am using your SQLiteDialect: com.enigmabridge.hibernate.dialect.SQLiteDialect In my java code, my entity has a schema name and I am using hibernate 4. I am able to deploy my webapp into tomcat but when querying the app, it always return error message saying there is no such database or table found mySchema.myTablename

Do I need to get rid of the schema name since the SQLite doesnot support it? But my SQLite file name is the schema name, and I thought it should pick it up....? Please help. Thanks. Below is my pom file for reference:

MY pom file looks like this: <groupId>org.xerial</groupId> <artifactId>sqlite-jdbc</artifactId> 3.8.11.2 <groupId>com.enigmabridge</groupId> <artifactId>hibernate4-sqlite-dialect</artifactId> 0.1.2

[waiwai177]

Continued with the previous problem, I tried to remove the schema name from my entity java class and now everything works. So my question how to make sqlite works if the entity has a schema name defined ? (my sqlite file has already named as the same name as the schema, and it does not work. I don't want to change my java code if possible. Thanks.