SQL Address book

> Hi,
>
> I've just started to look at OPS interacting with a mysql database by
> looking at the documentation and SQL Address Book sample available here :
> http://www.orbeon.com/ops/xforms-sql-address-book/
>
> I've seen that this application uses a
> ops/WEB-INF/resources/config/datasource-sql.xml configuration file,
> where the default is the embedded hsqldb configuration.
> I tried to configure a mysql jdbc connection :
> 1. downloaded mysql-connector.jar
> 2. put it in ops/WEB-INF/lib
> 3. created the "ops" database
> 4.
> modified datasource-sql.xml as follows :
> <datasource>
>    <driver-class-name>com.mysql.jdbc.Driver</driver-class-name>
>    <uri>jdbc:mysql://localhost:3306/ops</uri>
>    <username>root</username>
>    <password></password>
> </datasource>
>
> I could check that the jdbc connection was ok, but the sample doesn't
> seem to be working anymore, no tables are created (database is empty).
>
> Is the application still supposed to work with this new configuration or
> did I miss something ?
>
> Thanks for your help.
>

> The answer is that it *should* work, but I don't think we ever tested
> this example with MySQL.
>
> Just a note in passing about datasource-sql.xml: this is really
> designed for sample applications and demos, because this doesn't make
> use of JDBC connection pooling, for example. Ideally you should later
> migrate to declaring your datasource in your web.xml, configure it in
> your app server / servlet container, and the refer to it with the
> <sql:datasource> element in the SQL processor configuration.
>
> This said, this is probably not the cause of your problem.
>
> Maybe the SQL that creates the tables works with HSQLDB but not with
> MySQL? If not, you should see an error somewhere in the logs. Can you
> see something?
>
> -Erik
>
> Kim-Vân Ho-Dac wrote:
>> Hi,
>>
>> I've just started to look at OPS interacting with a mysql database by
>> looking at the documentation and SQL Address Book sample available
>> here :
>> http://www.orbeon.com/ops/xforms-sql-address-book/
>>
>> I've seen that this application uses a
>> ops/WEB-INF/resources/config/datasource-sql.xml configuration file,
>> where the default is the embedded hsqldb configuration.
>> I tried to configure a mysql jdbc connection :
>> 1. downloaded mysql-connector.jar
>> 2. put it in ops/WEB-INF/lib
>> 3. created the "ops" database
>> 4.
>> modified datasource-sql.xml as follows :
>> <datasource>
>>    <driver-class-name>com.mysql.jdbc.Driver</driver-class-name>
>>    <uri>jdbc:mysql://localhost:3306/ops</uri>
>>    <username>root</username>
>>    <password></password>
>> </datasource>
>>
>> I could check that the jdbc connection was ok, but the sample doesn't
>> seem to be working anymore, no tables are created (database is empty).
>>
>> Is the application still supposed to work with this new configuration
>> or did I miss something ?
>>
>> Thanks for your help.
>>
>
>