Re: openJPA Connection String for Microsoft Access

[Rick Curtis]

Per our documentation [1] the Sun JDBC-ODBC connection isn't supported. I'd
suggest digging in to the reason you can't connect using SequeLinkDriver.

[1]
http://openjpa.apache.org/builds/latest/docs/manual/manual.html#dbsupport_access

On Fri, Jul 8, 2011 at 10:26 AM, thopkins <thopk...@sdlcpartners.com> wrote:

> Does anyone have a working example of the connection string to connect
> openJPA to a Microsoft Access (don't ask why) database.
>
> I've been able to get connected by using a regular jdbc connection string
> (shown below).
> &lt;property name=&quot;openjpa.ConnectionURL&quot;
> value=&quot;jdbc:odbc:Driver={Microsoft Access Driver
> (*.mdb)};DBQ=C:\\temp\\&lt;database_name&gt;.mdb;}"/>
>                        <property name="openjpa.ConnectionDriverName"
> value="sun.jdbc.odbc.JdbcOdbcDriver" />
>
> The with this is that when I go to persist and object using this connection
> I get the following error (which I have no idea what i means) --
> [Microsoft][ODBC Microsoft Access Driver]Optional feature not implemented.
> This error kicks off a rollback of the database and doesn't persist the
> object.
>
> I tried to use the recommended sequelink connection string (as shown below)
> but I could never get it to connect to my database.
>
> &lt;property name=&quot;openjpa.ConnectionURL&quot;
> value=&quot;jdbc:sequelink://C:\temp\&lt;database_name&gt;.mdb"/>
> <property name="openjpa.ConnectionDriverName"
> value="com.ddtek.jdbc.sequelink.SequeLinkDriver" />
>
>
> Thanks for any help anyone can provide.
>
>
-- 
*Rick Curtis*