Is IBatis / MyBatis ORM Framework supports SQLite Client Database

[Hari Hara Sudhan Ramachandran]

Hi All,

please guide me to resolve the below issue.

We have an web application developed on Oracle Mobile server architecture.

We are using oracle 10G with Oracle Lite as an Client Database. 

Application developed using JSF + Spring + Ibatis (ORM) framework.

We are using Windows Handheld machines ( Small size Laptop) having tomcat server which is capable of running our web application pointing to Client Database reside in the Handheld machine. so, users will use our web application and do the changes and sync back the data at end of the day.

Oracle & Oracle client Database we are using are very old version.

as part of upgrade, we are planning to move to Oracle 11g + SQLite.

i am getting the below exception, when i tried to establish Database connection using Mybatis ( IBatis ) framework.

Feb 13, 2014 12:51:59 PM org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions

INFO: Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]

Feb 13, 2014 12:52:00 PM org.springframework.jdbc.support.SQLErrorCodesFactory <init>

INFO: SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase]

Feb 13, 2014 12:52:00 PM org.springframework.jdbc.support.SQLErrorCodesFactory getErrorCodes

WARNING: Error while extracting database product name - falling back to empty error codes

org.springframework.jdbc.support.MetaDataAccessException: Could not get Connection for extracting meta data; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: java.sql.SQLException: SQLite.Exception: unknown error in open

Please guide me.

is i am missing any Libraries or Mybatis is not supporting SQLite Database.

if so, what are the other well developed ORM framework supports SQLite Database.

i am waiting for your earliest reply.

Thanks,

Hari

[Guy Rouillier]

You don't show your config file, where you define how you are attempting
to connect to SQLite. At any rate, see here:
http://devtrigger.blogspot.com/2013/06/mybatis-datasource-jndi-hsql-oracle.html.

On 2/14/2014 11:46 AM, Hari Hara Sudhan Ramachandran wrote:
> Hi All,
>
> please guide me to resolve the below issue.
>
> We have an web application developed on Oracle Mobile server architecture.
> We are using oracle 10G with Oracle Lite as an Client Database.
> Application developed using JSF + Spring + Ibatis (ORM) framework.
>
> We are using Windows Handheld machines ( Small size Laptop) having
> tomcat server which is capable of running our web application pointing
> to Client Database reside in the Handheld machine. so, users will use
> our web application and do the changes and sync back the data at end of
> the day.
>
> Oracle & Oracle client Database we are using are very old version.
> as part of upgrade, we are planning to move to Oracle 11g + SQLite.
>
> i am getting the below exception, when i tried to establish Database
> connection using Mybatis ( IBatis ) framework.
>

> /Feb 13, 2014 12:51:59 PM
> org.springframework.beans.factory.xml.XmlBeanDefinitionReader
> loadBeanDefinitions/
>
> /INFO: Loading XML bean definitions from class path resource
> [org/springframework/jdbc/support/sql-error-codes.xml]/
>
> /Feb 13, 2014 12:52:00 PM
> org.springframework.jdbc.support.SQLErrorCodesFactory <init>/
>
> /INFO: SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL,
> MySQL, Oracle, PostgreSQL, Sybase]/
>
> /Feb 13, 2014 12:52:00 PM
> org.springframework.jdbc.support.SQLErrorCodesFactory getErrorCodes/
>
> /WARNING: Error while extracting database product name - falling back to
> empty error codes/
>
> /org.springframework.jdbc.support.MetaDataAccessException: Could not get

> Connection for extracting meta data; nested exception is
> org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get
> JDBC Connection; nested exception is java.sql.SQLException:

> java.sql.SQLException: SQLite.Exception: unknown error in open/
>
> /
> /

>
>
> Please guide me.
> is i am missing any Libraries or Mybatis is not supporting SQLite Database.
>
> if so, what are the other well developed ORM framework supports SQLite
> Database.
>
> i am waiting for your earliest reply.
>
> Thanks,
> Hari
>

> --
> You received this message because you are subscribed to the Google
> Groups "mybatis-user" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to mybatis-user...@googlegroups.com.
> For more options, visit https://groups.google.com/groups/opt_out.


--
Guy Rouillier

---
This email is free from viruses and malware because avast! Antivirus protection is active.
http://www.avast.com