[Logo] Terracotta Discussion Forums (LEGACY READ-ONLY ARCHIVE)
  [Search] Search   [Recent Topics] Recent Topics   [Members]  Member Listing   [Groups] Back to home page 
[Register] Register /  [Login] Login 
[Expert]
How to set schema name for PostgreSQL database?  XML
Forum Index -> Terracotta for Spring
Author Message
[Post New]03/02/2010 05:56:47
    Subject: How to set schema name for PostgreSQL database?
[Up]
Serg

neo

Joined: 02/17/2010 03:55:20
Messages: 6
Offline
The Quartz does not get schema name from datasource for PostgreSQL database and try to access to PUBLIC schema.

Is it possible to set schema name manually?
[Post New]03/11/2010 02:15:19
    Subject: Re:How to set schema name for PostgreSQL database?
[Up]
Serg

neo

Joined: 02/17/2010 03:55:20
Messages: 6
Offline
Solution:

<bean id="scheduler" class="org.springframework.scheduling.quartz.SchedulerFactoryBean">
<property name="quartzProperties">
<props>
<prop key="org.quartz.jobStore.tablePrefix">myschema.QRTZ_</prop>
</props>
</property>
<property name="dataSource" ref="dataSource"/>
</bean>

P.S. Schema name could be set from *.property file by ant or maven during building.
[Post New]07/12/2010 09:24:40
    Subject: Re:How to set schema name for PostgreSQL database?
[Up]
apaliwal

praetor

Joined: 01/05/2010 20:52:24
Messages: 223
Offline
Is this still an issue?
cheers
ashish
 
Forum Index -> Terracotta for Spring
Go to:   
Powered by JForum 2.1.7 © JForum Team