You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openjpa.apache.org by thopkins <th...@sdlcpartners.com> on 2011/07/08 17:26:26 UTC
openJPA Connection String for Microsoft Access
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).
<property name="openjpa.ConnectionURL"
value="jdbc:odbc:Driver={Microsoft Access Driver
(*.mdb)};DBQ=C:\\temp\\<database_name>.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.
<property name="openjpa.ConnectionURL"
value="jdbc:sequelink://C:\temp\<database_name>.mdb"/>
<property name="openjpa.ConnectionDriverName"
value="com.ddtek.jdbc.sequelink.SequeLinkDriver" />
Thanks for any help anyone can provide.
--
View this message in context: http://openjpa.208410.n2.nabble.com/openJPA-Connection-String-for-Microsoft-Access-tp6562910p6562910.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.
RE: openJPA Connection String for Microsoft Access
Posted by Jason Pyeron <jp...@pdinc.us>.
> -----Original Message-----
> From: thopkins
> Sent: Friday, July 08, 2011 11:41
> To: users@openjpa.apache.org
> Subject: Re: openJPA Connection String for Microsoft Access
>
> Rick that was what I trying to do but I haven't had any luck
> figuring out what the magical connectionURL is supposed to be
May I suggest trying with db visulizer first, it will allow you to experiment
with the JDBC settings more easiliy and with feedback.
> to properly access my database. I've even read the
> documentation about the SequeLinkDriver on the oracle site
> but haven't been able to figure it out. I was just hoping
> someone had an example of what I should be doing to connect
> to such a database.
>
> Thanks.
>
> --
> View this message in context:
> http://openjpa.208410.n2.nabble.com/openJPA-Connection-String-
> for-Microsoft-Access-tp6562910p6562963.html
> Sent from the OpenJPA Users mailing list archive at Nabble.com.
>
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
- Principal Consultant 10 West 24th Street #100 -
- +1 (443) 269-1555 x333 Baltimore, Maryland 21218 -
- -
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
This message is copyright PD Inc, subject to license 20080407P00.
Re: openJPA Connection String for Microsoft Access
Posted by thopkins <th...@sdlcpartners.com>.
Rick that was what I trying to do but I haven't had any luck figuring out
what the magical connectionURL is supposed to be to properly access my
database. I've even read the documentation about the SequeLinkDriver on the
oracle site but haven't been able to figure it out. I was just hoping
someone had an example of what I should be doing to connect to such a
database.
Thanks.
--
View this message in context: http://openjpa.208410.n2.nabble.com/openJPA-Connection-String-for-Microsoft-Access-tp6562910p6562963.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.
Re: openJPA Connection String for Microsoft Access
Posted by Rick Curtis <cu...@gmail.com>.
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 <th...@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).
> <property name="openjpa.ConnectionURL"
> value="jdbc:odbc:Driver={Microsoft Access Driver
> (*.mdb)};DBQ=C:\\temp\\<database_name>.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.
>
> <property name="openjpa.ConnectionURL"
> value="jdbc:sequelink://C:\temp\<database_name>.mdb"/>
> <property name="openjpa.ConnectionDriverName"
> value="com.ddtek.jdbc.sequelink.SequeLinkDriver" />
>
>
> Thanks for any help anyone can provide.
>
>
--
*Rick Curtis*