Eclipse Community Forums: EclipseLink

Help

Home

Home » Eclipse Projects » EclipseLink » MySQL JDBC URL

Show: Today's Messages :: Show Polls :: Message Navigator

MySQL JDBC URL [message #665659]

Fri, 15 April 2011 12:07

Pavel Zelenka

Messages: 61
Registered: July 2009

Member

Hi,

I need to set some parameters in persistence.xml JDBC URL. But if I pass more than 1 parameter I got exception.

This works fine:

<persistence-unit name="myPU" transaction-type="RESOURCE_LOCAL">
        <provider>org.eclipse.persistence.jpa.PersistenceProvider</provider >
        <exclude-unlisted-classes>true</exclude-unlisted-classes>
        <properties>
            <property name="eclipselink.jdbc.driver" value="com.mysql.jdbc.Driver"/>
            <property name="eclipselink.jdbc.url" value="jdbc:mysql://192.168.1.14:3306/autodily_3?zeroDateTimeBehavior=convertToNull"/>
            <property name="eclipselink.jdbc.user" value="..."/>
            <property name="eclipselink.jdbc.password" value="..."/>
        </properties>

This doesn't

    <persistence-unit name="myPU" transaction-type="RESOURCE_LOCAL">
        <provider>org.eclipse.persistence.jpa.PersistenceProvider</provider >
        <exclude-unlisted-classes>true</exclude-unlisted-classes>
        <properties>
            <property name="eclipselink.jdbc.driver" value="com.mysql.jdbc.Driver"/>
            <property name="eclipselink.jdbc.url" value="jdbc:mysql://192.168.1.14:3306/autodily_3?zeroDateTimeBehavior=convertToNull&characterEncoding=Cp1252&useUnicode=false"/>
            <property name="eclipselink.jdbc.user" value="..."/>
            <property name="eclipselink.jdbc.password" value="..."/>
        </properties>

What's the right format for URL parameters?

Thanks

[Updated on: Fri, 15 April 2011 12:11]

Report message to a moderator