HELP! Cannot connect jasper server to MS SQL db.

briane123 · February 18, 2010

OK, I am having LOTS of trouble. I have had success with the initial

install of JasperPro 3.7 and the mysql database.

However, I would like connect to a MS SQL database (microsoft sqlserver ).

I am running the JasperServer on a windows xp box. I'm not exactly sure

which files to update, but this is what I have done.

1. updated Jasper application context.xml file:

<Resource name="jdbc/jasperserver" auth="Container" type="javax.sql.DataSource"

maxActive="100" maxIdle="30" maxWait="10000"

username="{my user}" password="{mypassword}" driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"

url="jdbc:sqlserver://MY_IP_ADDRESS:1433;DatabaseName=jasperserver"/>

2. updated jasperserverDS-jdbc.xml file

<name>JasperServerDataBase</name>

<jdbc-driver-params>

<url>jdbc:sqlserver://MY_IP_ADDRESS:1433;DatabaseName=jasperserver</url>

<driver-name>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-name>

<value>{my username}</value>

</property>

</properties>

<password-encrypted>{my password}</password-encrypted>

</jdbc-driver-params>

3. updated hibernate.properties file

# Property that determines the Hibernate dialect

#metadata.hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect

metadata.hibernate.dialect=org.hibernate.dialect.SQLServerDialect

metadata.hibernate.dataSource.jndiName=jdbc/jasperserver

#

# default_schema setting will be uncommented if your database requires

# a schema to be specified (such as for DB2)

#

#metadata.hibernate.default_schema=${metadata.hibernate.default_schema}

4. copied sqljdbc.jar into the Tomcat common\lib directory.

5. created a JASPERSERVER database on my MSSQL box.

I restart the Jasper Server and this is the error I get. Could someone please tell me

what's wrong, or give me the exact configuration STEPS for connecting to a MSSQL server.

INFO: XML validation disabled

2010-02-18 15:02:14,231 WARN PermissionsListProtectionDomainProvider,main:61 -

A security manager has not been configured for the JVM. The protection domain se

t for the reports will NOT be effective.

2010-02-18 15:02:14,888 ERROR ContextLoader,main:215 - Context initialization fa

iled

org.springframework.beans.factory.BeanCreationException: Error creating bean wit

h name 'hibernateRepositoryService' defined in ServletContext resource [/WEB-INF

/applicationContext.xml]: Cannot resolve reference to bean 'proHibernateReposito

ryListeners' while setting bean property 'repositoryListeners'; nested exception

is org.springframework.beans.factory.BeanCreationException: Error creating bean

with name 'proHibernateRepositoryListeners' defined in ServletContext resource

[/WEB-INF/applicationContext-report-options.xml]: Cannot resolve reference to be

an 'schedulingReportDeleteListener' while setting constructor argument with key

[0]; nested exception is org.springframework.beans.factory.BeanCreationException

: Error creating bean with name 'schedulingReportDeleteListener' defined in Serv

letContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Cannot

resolve reference to bean 'reportSchedulingService' while setting bean property

'schedulingService'; nested exception is org.springframework.beans.factory.BeanC

reationException: Error creating bean with name 'reportSchedulingService': Facto

ryBean threw exception on object creation; nested exception is org.springframewo

rk.beans.factory.BeanCreationException: Error creating bean with name 'reportSch

edulingFacade' defined in ServletContext resource [/WEB-INF/applicationContext-r

eport-scheduling.xml]: Cannot resolve reference to bean 'reportScheduler' while

setting bean property 'scheduler'; nested exception is org.springframework.beans

.factory.BeanCreationException: Error creating bean with name 'reportScheduler'

defined in ServletContext resource [/WEB-INF/applicationContext-report-schedulin

g.xml]: Cannot resolve reference to bean 'reportQuartzScheduler' while setting b

ean property 'target'; nested exception is org.springframework.beans.factory.Bea

nCreationException: Error creating bean with name 'reportQuartzScheduler' define

d in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]

: Cannot resolve reference to bean 'quartzScheduler' while setting bean property

'scheduler'; nested exception is org.springframework.beans.factory.BeanCreation

Exception: Error creating bean with name 'quartzScheduler' defined in ServletCon

text resource [/WEB-INF/applicationContext-report-scheduling.xml]: Invocation of

init method failed; nested exception is org.quartz.SchedulerConfigException: Fa

ilure occured during job recovery. [see nested exception: org.quartz.impl.jdbcjo

bstore.LockException: Failure obtaining db row lock: Line 1: FOR UPDATE clause a

llowed only for DECLARE CURSOR. [see nested exception: com.microsoft.sqlserver.j

dbc.SQLServerException: Line 1: FOR UPDATE clause allowed only for DECLARE CURSO

R.]]

at org.springframework.beans.factory.support.BeanDefinitionValueResolver

.resolveReference(BeanDefinitionValueResolver.java:275)

at org.springframework.beans.factory.support.BeanDefinitionValueResolver

.resolveValueIfNecessary(BeanDefinitionValueResolver.java:104)

at org.springframework.beans.factory.support.AbstractAutowireCapableBean

Factory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1245)

at org.springframework.beans.factory.support.AbstractAutowireCapableBean

Factory.populateBean(AbstractAutowireCapableBeanFactory.java:1010)

at org.springframework.beans.factory.support.AbstractAutowireCapableBean

Factory.doCreateBean(AbstractAutowireCapableBeanFactory.java:472)

at org.springframework.beans.factory.support.AbstractAutowireCapableBean

Factory$1.run(AbstractAutowireCapableBeanFactory.java:409)

at java.security.AccessController.doPrivileged(Native Method)

at org.springframework.beans.factory.support.AbstractAutowireCapableBean

Factory.createBean(AbstractAutowireCapableBeanFactory.java:380)

at org.springframework.beans.factory.support.AbstractBeanFactory$1.getOb

ject(AbstractBeanFactory.java:264)

at org.springframework.beans.factory.support.DefaultSingletonBeanRegistr

y.getSingleton(DefaultSingletonBeanRegistry.java:222)

at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBe

an(AbstractBeanFactory.java:261)

at org.springframework.beans.factory.support.AbstractBeanFactory.getBean

(AbstractBeanFactory.java:185)

at org.springframework.beans.factory.support.AbstractBeanFactory.getBean

(AbstractBeanFactory.java:164)

at org.springframework.beans.factory.support.DefaultListableBeanFactory.

preInstantiateSingletons(DefaultListableBeanFactory.java:429)

at org.springframework.context.support.AbstractApplicationContext.finish

BeanFactoryInitialization(AbstractApplicationContext.java:728)

at org.springframework.context.support.AbstractApplicationContext.refres

h(AbstractApplicationContext.java:380)

at org.springframework.web.context.ContextLoader.createWebApplicationCon

text(ContextLoader.java:255)

at org.springframework.web.context.ContextLoader.initWebApplicationConte

xt(ContextLoader.java:199)

at org.springframework.web.context.ContextLoaderListener.contextInitiali

zed(ContextLoaderListener.java:45)

at org.apache.catalina.core.StandardContext.listenerStart(StandardContex

t.java:3763)

at org.apache.catalina.core.StandardContext.start(StandardContext.java:4

211)

at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase

.java:759)

at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:73

9)

at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)

at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.jav

a:904)

at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.j

ava:867)

at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:474

)

at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1122)

at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java

:310)

at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(Lifecycl

eSupport.java:119)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1021)

at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1013)

at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442

)

at org.apache.catalina.core.StandardService.start(StandardService.java:4

50)

at org.apache.catalina.core.StandardServer.start(StandardServer.java:709

)

at org.apache.catalina.startup.Catalina.start(Catalina.java:551)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.

java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces

sorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:585)

at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:294)

at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:432)

Caused by: org.springframework.beans.factory.BeanCreationException: Error creati

ng bean with name 'proHibernateRepositoryListeners' defined in ServletContext re

source [/WEB-INF/applicationContext-report-options.xml]: Cannot resolve referenc

e to bean 'schedulingReportDeleteListener' while setting constructor argument wi

th key [0]; nested exception is org.springframework.beans.factory.BeanCreationEx

ception: Error creating bean with name 'schedulingReportDeleteListener' defined

in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]:

Cannot resolve reference to bean 'reportSchedulingService' while setting bean pr

operty 'schedulingService'; nested exception is org.springframework.beans.factor

y.BeanCreationException: Error creating bean with name 'reportSchedulingService'

: FactoryBean threw exception on object creation; nested exception is org.spring

framework.beans.factory.BeanCreationException: Error creating bean with name 're

portSchedulingFacade' defined in ServletContext resource [/WEB-INF/applicationCo

ntext-report-scheduling.xml]: Cannot resolve reference to bean 'reportScheduler'

while setting bean property 'scheduler'; nested exception is org.springframewor

k.beans.factory.BeanCreationException: Error creating bean with name 'reportSche

duler' defined in ServletContext resource [/WEB-INF/applicationContext-report-sc

heduling.xml]: Cannot resolve reference to bean 'reportQuartzScheduler' while se

tting bean property 'target'; nested exception is org.springframework.beans.fact

ory.BeanCreationException: Error creating bean with name 'reportQuartzScheduler'

defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduli

ng.xml]: Cannot resolve reference to bean 'quartzScheduler' while setting bean p

roperty 'scheduler'; nested exception is org.springframework.beans.factory.BeanC

reationException: Error creating bean with name 'quartzScheduler' defined in Ser

vletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Invoca

tion of init method failed; nested exception is org.quartz.SchedulerConfigExcept

ion: Failure occured during job recovery. [see nested exception: org.quartz.impl

.jdbcjobstore.LockException: Failure obtaining db row lock: Line 1: FOR UPDATE c

lause allowed only for DECLARE CURSOR. [see nested exception: com.microsoft.sqls

erver.jdbc.SQLServerException: Line 1: FOR UPDATE clause allowed only for DECLAR

E CURSOR.]]

at org.springframework.beans.factory.support.BeanDefinitionValueResolver

.resolveReference(BeanDefinitionValueResolver.java:275)

at org.springframework.beans.factory.support.BeanDefinitionValueResolver

.resolveValueIfNecessary(BeanDefinitionValueResolver.java:104)

at org.springframework.beans.factory.support.BeanDefinitionValueResolver

.resolveManagedList(BeanDefinitionValueResolver.java:287)

at org.springframework.beans.factory.support.BeanDefinitionValueResolver

.resolveValueIfNecessary(BeanDefinitionValueResolver.java:126)

at org.springframework.beans.factory.support.ConstructorResolver.resolve

ConstructorArguments(ConstructorResolver.java:495)

at org.springframework.beans.factory.support.ConstructorResolver.autowir

eConstructor(ConstructorResolver.java:162)

at org.springframework.beans.factory.support.AbstractAutowireCapableBean

Factory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:925)

at org.springframework.beans.factory.support.AbstractAutowireCapableBean

Factory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:835)

at org.springframework.beans.factory.support.AbstractAutowireCapableBean

Factory.doCreateBean(AbstractAutowireCapableBeanFactory.java:440)

at org.springframework.beans.factory.support.AbstractAutowireCapableBean

Factory$1.run(AbstractAutowireCapableBeanFactory.java:409)

at java.security.AccessController.doPrivileged(Native Method)

at org.springframework.beans.factory.support.AbstractAutowireCapableBean

Factory.createBean(AbstractAutowireCapableBeanFactory.java:380)

at org.springframework.beans.factory.support.AbstractBeanFactory$1.getOb

ject(AbstractBeanFactory.java:264)

at org.springframework.beans.factory.support.DefaultSingletonBeanRegistr

y.getSingleton(DefaultSingletonBeanRegistry.java:222)

at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBe

an(AbstractBeanFactory.java:261)

at org.springframework.beans.factory.support.AbstractBeanFactory.getBean

(AbstractBeanFactory.java:185)

at org.springframework.beans.factory.support.AbstractBeanFactory.getBean

(AbstractBeanFactory.java:164)

at org.springframework.beans.factory.support.BeanDefinitionValueResolver

.resolveReference(BeanDefinitionValueResolver.java:269)

... 42 more

Caused by: org.springframework.beans.factory.BeanCreationException: Error creati

ng bean with name 'schedulingReportDeleteListener' defined in ServletContext res

ource [/WEB-INF/applicationContext-report-scheduling.xml]: Cannot resolve refere

nce to bean 'reportSchedulingService' while setting bean property 'schedulingSer

vice'; nested exception is org.springframework.beans.factory.BeanCreationExcepti

on: Error creating bean with name 'reportSchedulingService': FactoryBean threw e

xception on object creation; nested exception is org.springframework.beans.facto

ry.BeanCreationException: Error creating bean with name 'reportSchedulingFacade'

defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduli

ng.xml]: Cannot resolve reference to bean 'reportScheduler' while setting bean p

roperty 'scheduler'; nested exception is org.springframework.beans.factory.BeanC

reationException: Error creating bean with name 'reportScheduler' defined in Ser

vletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Cannot

resolve reference to bean 'reportQuartzScheduler' while setting bean property '

target'; nested exception is org.springframework.beans.factory.BeanCreationExcep

tion: Error creating bean with name 'reportQuartzScheduler' defined in ServletCo

ntext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Cannot resol

ve reference to bean 'quartzScheduler' while setting bean property 'scheduler';

nested exception is org.springframework.beans.factory.BeanCreationException: Err

or creating bean with name 'quartzScheduler' defined in ServletContext resource

[/WEB-INF/applicationContext-report-scheduling.xml]: Invocation of init method f

ailed; nested exception is org.quartz.SchedulerConfigException: Failure occured

during job recovery. [see nested exception: org.quartz.impl.jdbcjobstore.LockExc

eption: Failure obtaining db row lock: Line 1: FOR UPDATE clause allowed only fo

r DECLARE CURSOR. [see nested exception: com.microsoft.sqlserver.jdbc.SQLServerE

xception: Line 1: FOR UPDATE clause allowed only for DECLARE CURSOR.]]