RE: openJPA Connection String for Microsoft Access

2011-07-08 Thread Jason Pyeron 
> -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 x333Baltimore, Maryland 21218   -
-   -
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
This message is copyright PD Inc, subject to license 20080407P00.

Re: openJPA Connection String for Microsoft Access

2011-07-08 Thread thopkins 
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

2011-07-08 Thread 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  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).
>  value="jdbc:odbc:Driver={Microsoft Access Driver
> (*.mdb)};DBQ=C:\\temp\\.mdb;}"/>
> 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.
>
>  value="jdbc:sequelink://C:\temp\.mdb"/>
>  value="com.ddtek.jdbc.sequelink.SequeLinkDriver" />
>
>
> Thanks for any help anyone can provide.
>
>
-- 
*Rick Curtis*

openJPA Connection String for Microsoft Access

2011-07-08 Thread thopkins 
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;}"/>


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"/>



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.