search

EnigmaBridge / hibernate4-sqlite-dialect

SQLite dialect for Hibernate 4
MIT License
18 stars 8 forks source link

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

Open chrisng0719 opened 5 years ago

chrisng0719 commented 5 years ago

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:

org.xerial sqlite-jdbc 3.8.11.2 
        <dependency>
            <groupId>com.enigmabridge</groupId>
            <artifactId>hibernate4-sqlite-dialect</artifactId>
            <version>0.1.2</version>
        </dependency>
</dependencies>
chrisng0719 commented 5 years ago

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.