You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomee.apache.org by James Green <ja...@gmail.com> on 2013/03/08 17:56:31 UTC
Datasource ConnectionProperties
http://tomee.apache.org/containers-and-resources.html says to use:
ConnectionProperties: Format of the string must be [propertyName=property;]*
I've not found any working format so far. Anyone have an example? Sharing
on http://tomee.apache.org/common-datasource-configurations.html would be
good :-)
James
Re: Datasource ConnectionProperties
Posted by Romain Manni-Bucau <rm...@gmail.com>.
Maybe adding = after connectionproperties can help
Le 8 mars 2013 18:27, "James Green" <ja...@gmail.com> a écrit :
> The docs have the value within square brackets.
>
> Doesn't help when the first char of a property suddenly becomes an
> uppercase version without being noticed. Anyway, for the purposes of
> completeness:
>
> ConnectionProperties zeroDateTimeBehavior=convertToNull
>
> Works perfectly for the MySQL driver in our environment. Somehow ours ended
> up with a capital Z...
>
>
>
> On 8 March 2013 17:07, Jean-Louis MONTEIRO <je...@gmail.com> wrote:
>
> > Never used it to be honest.
> > What's your error?
> >
> > In my opinion, it should be something like
> >
> > <Resource id="HSQLDB Database" type="DataSource">
> > JdbcDriver org.hsqldb.jdbcDriver
> > JdbcUrl jdbc:hsqldb:file:hsqldb
> > UserName sa
> > Password
> >
> > ConnectionProperties toto=titi;foo=bar;
> >
> > </Resource>
> >
> > It does not work?
> >
> >
> > JLouis
> >
> >
> >
> > 2013/3/8 James Green <ja...@gmail.com>
> >
> > > http://tomee.apache.org/containers-and-resources.html says to use:
> > >
> > > ConnectionProperties: Format of the string must be
> > > [propertyName=property;]*
> > >
> > > I've not found any working format so far. Anyone have an example?
> Sharing
> > > on http://tomee.apache.org/common-datasource-configurations.html would
> > be
> > > good :-)
> > >
> > > James
> > >
> >
> >
> >
> > --
> > Jean-Louis
> >
>
Re: Datasource ConnectionProperties
Posted by James Green <ja...@gmail.com>.
The docs have the value within square brackets.
Doesn't help when the first char of a property suddenly becomes an
uppercase version without being noticed. Anyway, for the purposes of
completeness:
ConnectionProperties zeroDateTimeBehavior=convertToNull
Works perfectly for the MySQL driver in our environment. Somehow ours ended
up with a capital Z...
On 8 March 2013 17:07, Jean-Louis MONTEIRO <je...@gmail.com> wrote:
> Never used it to be honest.
> What's your error?
>
> In my opinion, it should be something like
>
> <Resource id="HSQLDB Database" type="DataSource">
> JdbcDriver org.hsqldb.jdbcDriver
> JdbcUrl jdbc:hsqldb:file:hsqldb
> UserName sa
> Password
>
> ConnectionProperties toto=titi;foo=bar;
>
> </Resource>
>
> It does not work?
>
>
> JLouis
>
>
>
> 2013/3/8 James Green <ja...@gmail.com>
>
> > http://tomee.apache.org/containers-and-resources.html says to use:
> >
> > ConnectionProperties: Format of the string must be
> > [propertyName=property;]*
> >
> > I've not found any working format so far. Anyone have an example? Sharing
> > on http://tomee.apache.org/common-datasource-configurations.html would
> be
> > good :-)
> >
> > James
> >
>
>
>
> --
> Jean-Louis
>
Re: Datasource ConnectionProperties
Posted by Jean-Louis MONTEIRO <je...@gmail.com>.
Never used it to be honest.
What's your error?
In my opinion, it should be something like
<Resource id="HSQLDB Database" type="DataSource">
JdbcDriver org.hsqldb.jdbcDriver
JdbcUrl jdbc:hsqldb:file:hsqldb
UserName sa
Password
ConnectionProperties toto=titi;foo=bar;
</Resource>
It does not work?
JLouis
2013/3/8 James Green <ja...@gmail.com>
> http://tomee.apache.org/containers-and-resources.html says to use:
>
> ConnectionProperties: Format of the string must be
> [propertyName=property;]*
>
> I've not found any working format so far. Anyone have an example? Sharing
> on http://tomee.apache.org/common-datasource-configurations.html would be
> good :-)
>
> James
>
--
Jean-Louis