JNDI Datasource unavailable at application startup causing problems

[gulcher]

Hi,

I have a JNDI Datasource with a (non required) database behind it. This Database is sometimes offline. This causes an exception on startup and my application is not started, because of this exception.

Is there a way to specify that the datasource is not required on startup, so that I can always startup my application?

Of course, I am aware that I have to catch exceptions when calling the datasource at a later time in my application, but I already handled that, because the database already goes down sometimes after my application started up.

Thanks in advance!

Theo Gülcher

[sheetal]

hello,
though i'm a newbie myself, hope this would help u.
u can use this instead of jndi in cases where datasource is not already present

<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverM anagerDataSource">

<property name="driverClassName" value="${driverName}"/>
<property name="url" value="${yoururl}"/>
<property name="username" value="${yourUsername}"/>
<property name="password" value="${yourPassword}"/>
</bean>

let, u r using mysql, then it would be

<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverM anagerDataSource">

<property name="driverClassName">
<value>com.mysql.jdbc.Driver</value>
</property>
<property name="url">
<value>jdbc:mysql://localhost:3306/${YourDb}</value>
</property>
<!-- Provide username and password for mysql -->
<property name="username" value="root"/>
<property name="password" value=""/>


</bean>

[mpetrashev]

Did you try lazy-init attribute for your datasource bean? can you provide exception that you get on it?

[gulcher]

mpetrashev: your lazy-init suggestion gave me the information I needed to get the solution myself. lazy-init is not available on jee:jndi-lookup tags....but.....

the datasource should specify the 'lookup-on-startup' attribute with value false.

Like this:

    <!-- Data source for Adam -->
    <jee:jndi-lookup id="adamDataSource" jndi-name="jdbc/adam" resource-ref="true" proxy-interface="javax.sql.DataSource" lookup-on-startup="false"/>

NB jee:jndi-lookup tag is available from Spring 2.0. Don't forget to add the following bold text on top of your bean XML:

<beans xmlns="http://www.springframework.org/schema/beans"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns:aop="http://www.springframework.org/schema/aop"
    xmlns:jee="http://www.springframework.org/schema/jee"
    xmlns:tx="http://www.springframework.org/schema/tx"
    xmlns:util="http://www.springframework.org/schema/util"
    xsi:schemaLocation="
        http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.0.xsd
        http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd
        http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee-2.0.xsd
        http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.0.xsd
        http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-2.0.xsd">

NB proxy-interface="javax.sql.DataSource" is required when setting the cache or lookup-on-startup attribute! This is mentioned when starting up without the proxy-interface attribute added.... ;-)