Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PreparedStatements - issue with grabbing metadata with Spring

843859Nov 18 2009 — edited Nov 19 2009
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 17 2009
Added on Nov 18 2009
3 comments
603 views