![]() ![]() You can easily translate the Oracle, native PL/SQL TABLE CREATE scripts into T-SQL. I chose to use Microsoft’s own JDBC driver.īefore connecting to SQL Server using Microsoft’s JDBC driver, you need to create a SQL Server database, mirroring the database schema in Blaise’s blog post. Of course there are alternative third-party SQL Server drivers, including those from DataDirect, i-net software, and so forth. It includes the ability to interface with Microsoft’s new SQL Server 2012, and is also backwards compatible to SQL Server 2005. The 4.0 version of the driver was just released in March of 2012. Using the Java EE technology stack, but switching the data source to SQL Server was relatively easy using Microsoft JDBC Driver 4.0 for SQL Server. However, Blaise’s blog series example uses Oracle Database XE. ![]() In my current position, I work regularly with Microsoft’s relational database, SQL Server 2008 R2. His blog is overflowing with a wealth of information on a number of Java EE technologies, including Java Persistence Architecture (JPA), Java Architecture for XML Binding (JAXB), Enterprise JavaBeans (EJB), Java API for RESTful Web Services (JAX-RS), and Oracle’s GlassFish application server. According to his blog, Blaise is the Team lead for the TopLink / EclipseLink JAXB & SDO implementations, and the Oracle representative on those specifications. In this post, I detail changes I made to the series’ example project to work with SQL Server, using Microsoft’s JDBC Driver SQL Server.īlaise’s blog, Java XML & JSON Binding (Object-to-XML and object-to-JSON mapping using JAXB and EclipseLink MOXy), is located at. However, I wanted to use Microsoft’s SQL Server instead of Oracle as the data source. I was interested in working through the sample project the series is based on. The series of posts demonstrate the effective use of JPA, JAXB with MOXy ( JPA Entities to XML), EJB, and JAX-RS. Although Blaise’s series was written in 2010, the information it has is still quite relevant and insightful. ![]() Recently, I read a very good five-part blog series, Creating a RESTful Web Service, by Blaise Doughan. ![]() It will help me post more files to DropBox for future posts. If you like DropBox, please use this link to sign up for a free 2 GB account. Connect Microsoft SQL Server to Java EE JPA and JAXB with MOXy technologies using Microsoft’s JDBC Driver 4.0.Ī t-sql script to create the three database tables used in this post is available on DropBox. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |