You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomee.apache.org by AndrewG <an...@cognisolve.com> on 2013/08/26 16:49:10 UTC

Access microsoft sql with sqljdbc4 driver

Hi,

i'm wondering if anyone has has any luck connecting to a microsoft sql
server.

I've set everything up in my application as I would when accessing a mysql
server (which i've done many times) except for the specific persistence
information. The result is my application deploys fine, no errors on the
tomee server, but when I try and hit one of my resources the entitymanager
defined by the @PersistenceContext is null. 

I'm using the microsoft sqljdbc4.jar driver. I've added it to my libs folder
on Tomee and in my application. I've defined my resource as below:

<Resource id="MYAPP-sql" type="DataSource">
    JdbcDriver  com.microsoft.sqlserver.jdbc.SQLServerDriver
    JdbcUrl jdbc:sqlserver://localhost\SQLEXPRESS;databaseName=MYDB
    UserName    theuser
    Password     thepassword
</Resource>

I'm not necessarily looking for a solution to my problem (which would be
nice), but would actually just like to know if anyone has connected to
microsoft sql from Tomee as I found no mention in the forum.

Thank you,
Andrew





--
View this message in context: http://openejb.979440.n4.nabble.com/Access-microsoft-sql-with-sqljdbc4-driver-tp4664834.html
Sent from the OpenEJB User mailing list archive at Nabble.com.

Re: Access microsoft sql with sqljdbc4 driver

Posted by AndrewG <an...@cognisolve.com>.
Thank you Romain, that's good to know. I'll keep working at it.

Andrew



--
View this message in context: http://openejb.979440.n4.nabble.com/Access-microsoft-sql-with-sqljdbc4-driver-tp4664834p4664836.html
Sent from the OpenEJB User mailing list archive at Nabble.com.

Re: Access microsoft sql with sqljdbc4 driver

Posted by Romain Manni-Bucau <rm...@gmail.com>.
Hi,

i never used it personally but i know some users rely on it, even on Azure
IIRC.

*Romain Manni-Bucau*
*Twitter: @rmannibucau <https://twitter.com/rmannibucau>*
*Blog: **http://rmannibucau.wordpress.com/*<http://rmannibucau.wordpress.com/>
*LinkedIn: **http://fr.linkedin.com/in/rmannibucau*
*Github: https://github.com/rmannibucau*



2013/8/26 AndrewG <an...@cognisolve.com>

> Hi,
>
> i'm wondering if anyone has has any luck connecting to a microsoft sql
> server.
>
> I've set everything up in my application as I would when accessing a mysql
> server (which i've done many times) except for the specific persistence
> information. The result is my application deploys fine, no errors on the
> tomee server, but when I try and hit one of my resources the entitymanager
> defined by the @PersistenceContext is null.
>
> I'm using the microsoft sqljdbc4.jar driver. I've added it to my libs
> folder
> on Tomee and in my application. I've defined my resource as below:
>
> <Resource id="MYAPP-sql" type="DataSource">
>     JdbcDriver  com.microsoft.sqlserver.jdbc.SQLServerDriver
>     JdbcUrl jdbc:sqlserver://localhost\SQLEXPRESS;databaseName=MYDB
>     UserName    theuser
>     Password     thepassword
> </Resource>
>
> I'm not necessarily looking for a solution to my problem (which would be
> nice), but would actually just like to know if anyone has connected to
> microsoft sql from Tomee as I found no mention in the forum.
>
> Thank you,
> Andrew
>
>
>
>
>
> --
> View this message in context:
> http://openejb.979440.n4.nabble.com/Access-microsoft-sql-with-sqljdbc4-driver-tp4664834.html
> Sent from the OpenEJB User mailing list archive at Nabble.com.
>