Hi Romano,
I'm do not think that the JDBC driver will understand the cocoon://
protocol.
But you could try it anyway, because i'm not sure if the cocoon protocol
is translated before going to the jdbc driver.
It should be like:
<dburl>jdbc:hsqldb:file:cocoon://WEB-INF/db/example</dburl>
I think you will have to do with the hsqldb specific parameters.
According to the hsqldb documentation: "When using relative paths, these
paths will be taken relative to the directory in which the shell command
to start the Java Virtual Machine was executed. Refer to Javadoc for
jdbcConnection for more details."
I hope this helps.
Jeroen Reijn
[EMAIL PROTECTED] wrote:
Hi to all,
I want to use a hsqldb database within cocoon. I've set the following in
cocoon.xconf:
<jdbc name="example">
<dburl>jdbc:hsqldb:file:${context-root}/WEB-INF/db/example</dburl>
<user>sa</user>
<password/>
</jdbc>
but the database file are written in the default directory (i.e. in a
random direcory as /eclipse/..../${context-root}/WEB-INF/db/example) and
not the directory where the application is deployed. The same if I write
<dburl>jdbc:hsqldb:file:WEB-INF/db/example</dburl>
I don't want using the preconfigured hsqldb server because the
application has to be installed by "no skilled people" and I just need
they unzip-and-run on computers that could have a firewall set up (also
for local applications on localhost). For that I have to access the
database with "file".
There's a way to have the context directory as a parameter inside
cocoon.xconf? I've seen somewhere in the configurazione file something
like:
<abcd src="context://WEB-INF/...." />
but how to use that syntax for a datasource?
thank's a lot
romano
----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
