StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>Well if you put the database inside the jar like this:</p> <pre><code><property name="url" value="jdbc:hsqldb:res:/data/images" /> </code></pre> <p>You only can use it as read only, if you try to insert or modify the database if will fail.</p> <p>One solution is to put a listener in the web.xml so when the application start it will ce initialize with the root path of the application web.</p> <pre><code><?xml version="1.0" encoding="UTF-8"?> <web-app version="2.4" xmlns="http://java.sun.com/xml/ns/j2ee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd"> <display-name>maf</display-name> <session-config> <session-timeout> 30 </session-timeout> </session-config> <welcome-file-list> <welcome-file>index.jsp</welcome-file> </welcome-file-list>  <listener> <listener-class> org.atoms.HsqlDatabaseListener </listener-class> </listener>  <listener> <listener-class> org.springframework.web.context.ContextLoaderListener </listener-class> </listener> </web-app> </code></pre> <p>The listener:</p> <pre><code>package org.atoms; import javax.servlet.ServletContext; import javax.servlet.ServletContextEvent; import javax.servlet.ServletContextListener; /** * * @author atomsfat */ public class HsqlDatabaseListener implements ServletContextListener { private ServletContext context = null; public void contextInitialized(ServletContextEvent event) { context = event.getServletContext(); String prefix = event.getServletContext().getRealPath("/"); System.out.println("database root " + prefix); com.atoms.HsqlDatabasePathResolver.getInstance(prefix); } public void contextDestroyed(ServletContextEvent event) { context = event.getServletContext(); } </code></pre> <p>The other class:</p> <pre><code>package com.atoms; /** * * @author atomsfat */ public class HsqlDatabasePathResolver { private static HsqlDatabasePathResolver instance ; private static String applicationPath = ""; private HsqlDatabasePathResolver() { } /** Get Instance. */ static public synchronized HsqlDatabasePathResolver getInstance(String applicationPath) { if (instance == null) { HsqlDatabasePathResolver.applicationPath = HsqlDatabasePathResolver.normalizePath(applicationPath); instance = new HsqlDatabasePathResolver(); System.out.println("Inizalizando path : " + HsqlDatabasePathResolver.applicationPath); } return instance; } public String getApplicationPath() { return applicationPath; } public String getUrlDatabase(String urlDatabase) { return HsqlDatabasePathResolver.replaceAll(urlDatabase,"{apppath}", applicationPath); } /** * * replace the "\" character by "/" and remove relative paths * * @param path * @return */ public static String normalizePath(String path) { if (path == null) { return null; } String normalized = path; if (normalized.equals("/.")) { return "/"; } if (normalized.indexOf('\\') >= 0) { normalized = normalized.replace('\\', '/'); } if (!normalized.startsWith("/") && normalized.indexOf(':') < 0) { normalized = "/" + normalized; } do { int index = normalized.indexOf("//"); if (index < 0) { break; } normalized = normalized.substring(0, index) + normalized.substring(index + 1); } while (true); do { int index = normalized.indexOf("/./"); if (index < 0) { break; } normalized = normalized.substring(0, index) + normalized.substring(index + 2); } while (true); do { int index = normalized.indexOf("/../"); if (index >= 0) { if (index == 0) { return null; } int index2 = normalized.lastIndexOf('/', index - 1); normalized = normalized.substring(0, index2) + normalized.substring(index + 3); } else { return normalized; } } while (true); } public static String replaceAll(String str, String match, String replace) { if (match == null || match.length() == 0) { return str; } if (replace == null) { replace = ""; } if(match.equals(replace))return str; StringBuffer ret=new StringBuffer(); int i = str.indexOf(match); int y = 0; while (i >= 0) { //System.out.println("i:"+i+" y:"+y); ret.append(str.substring(y, i)); ret.append(replace); //str = str.substring(y, i) + replace + str.substring(i + match.length()); y = i + match.length(); i = str.indexOf(match,y); } ret.append(str.substring(y)); return ret.toString(); } } </code></pre> <p>And this the configuration that I use in spring:</p> <pre><code> <?xml version="1.0" encoding="UTF-8"?> <beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context" xmlns:jee="http://www.springframework.org/schema/jee" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-2.5.xsd http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee-2.5.xsd">  <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" lazy-init="true" destroy-method="close"> <property name="driverClassName" value="org.hsqldb.jdbcDriver" /> <property name="url"> <ref bean="dataBaseUrl"/> </property> <property name="username" value="sa" /> <property name="password" value="" /> </bean>  <bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean" lazy-init="false"> <property name="dataSource" ref="dataSource" /> <property name="hibernateProperties"> <props> <prop key="hibernate.dialect"> org.hibernate.dialect.HSQLDialect </prop> <prop key="hibernate.show_sql">true</prop> <prop key="hibernate.format_sql">true</prop> </props> </property> <property name="mappingResources"> <list> <value>Atoms.hbm.xml</value> </list> </property> </bean>  <bean id="hibernateTemplate" class="org.springframework.orm.hibernate3.HibernateTemplate"> <property name="sessionFactory"> <ref bean="sessionFactory" /> </property> </bean>  <bean id="ipBlancaDao" class="org.atoms.impl.AtomsDaoHibernateImpl"> <property name="hibernateTemplate" ref="hibernateTemplate" /> </bean>  <bean class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"/> <bean id="hsqlDatabasePathResolver" class="com.atoms.HsqlDatabasePathResolver" factory-method="getInstance" lazy-init="false"> <constructor-arg> <value>${user.dir}</value> </constructor-arg> </bean>  <bean id="dataBaseUrl" class="java.lang.String" factory-bean="hsqlDatabasePathResolver" lazy-init="false" factory-method="getUrlDatabase"> <constructor-arg> <value>jdbc:hsqldb:mem:{apppath}/WEB-INF/data/maf</value> </constructor-arg> </bean> </beans> </code></pre> <p>And yes this work but is a mess , I think that the solution is the listener, with it you can get the path of the appWeb. if somebody can make this simple, please post the answer.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload