Hi , I am new to SQLite. I am trying to run the statements on Spring using SQLite data source in a web application. When i am trying to connect to database it's giving the following problem. 16 Nov 2009 18:34:41,554 WARN [Thread-1] XSnapshotRegistry | No such snapshot or helper class: com.signifo.webapp.form.UserForm, com.signifo.webapp.form.UserFormHelper 16 Nov 2009 18:34:42,726 WARN [Thread-1] SQLErrorCodesFactory | Error while extracting database product name - falling back to empty error codes org.springframework.jdbc.support.MetaDataAccessException: Could not access DatabaseMetaData method 'getDatabaseProductName'; nested exception is java.lang.IllegalAccessException: Class org.springframework.jdbc.support.JdbcUtils$1 can not access a member of class org.sqlite.MetaData with modifiers "public" java.lang.IllegalAccessException: Class org.springframework.jdbc.support.JdbcUtils$1 can not access a member of class org.sqlite.MetaData with modifiers "public" at sun.reflect.Reflection.ensureMemberAccess(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.jdbc.support.JdbcUtils$1.processMetaData (JdbcUtils.java:209) at org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData (JdbcUtils.java:174) at org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData (JdbcUtils.java:204) at org.springframework.jdbc.support.SQLErrorCodesFactory.getErrorCodes (SQLErrorCodesFactory.java:185) at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.setDataSource (SQLErrorCodeSQLExceptionTranslator.java:126) at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.<init> (SQLErrorCodeSQLExceptionTranslator.java:92) at org.springframework.orm.hibernate3.SessionFactoryUtils.newJdbcExceptionTranslator (SessionFactoryUtils.java:133) at org.springframework.orm.hibernate3.HibernateAccessor.getJdbcExceptionTranslator (HibernateAccessor.java:235) at org.springframework.orm.hibernate3.HibernateTemplate.getSession (HibernateTemplate.java:412) at org.springframework.orm.hibernate3.HibernateTemplate.execute (HibernateTemplate.java:354) at org.springframework.orm.hibernate3.HibernateTemplate.loadAll (HibernateTemplate.java:515) at com.signifo.dao.hibernate.BaseDAOHibernate.getObjects (BaseDAOHibernate.java:59) at com.signifo.service.impl.BaseServiceImpl.getObjects (BaseServiceImpl.java:51) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection (AopUtils.java:335) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint (ReflectiveMethodInvocation.java:181) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed (ReflectiveMethodInvocation.java:148) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke (TransactionInterceptor.java:96) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed (ReflectiveMethodInvocation.java:170) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke (JdkDynamicAopProxy.java:176) at $Proxy4.getObjects(Unknown Source) at com.signifo.webapp.listener.StartupListener.setupContext (StartupListener.java:104) at com.signifo.webapp.listener.StartupListener.contextInitialized (StartupListener.java:90) at org.apache.catalina.core.StandardContext.listenerStart (StandardContext.java:3843) at org.apache.catalina.core.StandardContext.start (StandardContext.java:4342) at org.apache.catalina.core.ContainerBase.addChildInternal (ContainerBase.java:791) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java: 771) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java: 525) at org.apache.catalina.startup.HostConfig.deployDescriptor (HostConfig.java:627) at org.apache.catalina.startup.HostConfig.deployDescriptors (HostConfig.java:553) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java: 488) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149) at org.apache.catalina.startup.HostConfig.lifecycleEvent (HostConfig.java:311) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent (LifecycleSupport.java:117) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java: 1053) at org.apache.catalina.core.StandardHost.start(StandardHost.java:719) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java: 1045) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java: 443) at org.apache.catalina.core.StandardService.start (StandardService.java:516) at org.apache.catalina.core.StandardServer.start(StandardServer.java: 710) at org.apache.catalina.startup.Catalina.start(Catalina.java:578) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
If any body knows how to solve this problem please help me on this. Here i am using spring - hibernate - sqlite. i have strucked in middle because of this. Thanks in advance, Sailaja --~--~---------~--~----~------------~-------~--~----~ Mailing List: http://groups.google.com/group/sqlitejdbc?hl=en To unsubscribe, send email to sqlitejdbc-unsubscr...@googlegroups.com -~----------~----~----~----~------~----~------~--~---