Hi there
I am using NetBeans6.5,SQL 2000 and GlassFish server to develop the following
@onetoOne mapping.
Entitys:
@Entity
@Table(name = "Shipments")
@NamedQueries({@NamedQuery(name = "Shipments.findAll", query = "SELECT s FROM Shipments s")})
public class Shipments implements Serializable {
private static final long serialVersionUID = 1L;
@Id
@Basic(optional = false)
@Column(name = "ShpmentId")
private
String shpmentId;
@Column(name = "City")
private String city;
public Shipments() {
}
public Shipments(String shpmentId) {
this.shpmentId = shpmentId;
}
public String getShpmentId() {
return shpmentId;
}
public void setShpmentId(String shpmentId) {
this.shpmentId = shpmentId;
}
public String getCity() {
return city;
}
public void setCity(String city) {
this.city = city;
}
}
another entity:
@Entity
@Table(name = "Orders")
@NamedQueries({@NamedQuery(name = "Orders.findAll", query = "SELECT o FROM Orders o")})
public class Orders implements Serializable {
private static final long serialVersionUID = 1L;
@Id
@Basic(optional = false)
@Column(name = "OrderId")
private String orderId;
@Column(name = "OrderName")
private String orderName;
private Shipments objShipment;
public Orders() {
}
public String getOrderId() {
return orderId;
}
public void setOrderId(String orderId) {
this.orderId = orderId;
}
public String getOrderName() {
return orderName;
}
public void setOrderName(String orderName) {
this.orderName = orderName;
}
@OneToOne(cascade={CascadeType.PERSIST})
public Shipments getObjShipment()
{
return objShipment;
}
public void setObjShipment(Shipments objShipment) {
this.objShipment = objShipment;
}
}
Session Bean:
@Stateless
public class NewSessionBean implements NewSessionLocal {
@PersistenceContext
EntityManager em;
public void doSomeStuff()
{
Shipments objs=new Shipments();
objs.setShpmentId("1001");
objs.setCity("Bangalore");
Orders ord=new Orders();
ord.setOrderId("1001");
ord.setOrderName("Software");
ord.setObjShipment(objs);
em.persist(ord);
}
}
Jsp File
<%@page import="javax.ejb.*,
javax.naming.*,java.util.*,
com.sisl.ejb.NewSessionLocal;"
%>
<%!
NewSessionLocal objHello;
public void jspInit()
{
try
{
Context ctx=new InitialContext();
objHello=(NewSessionLocal)ctx.lookup("java:comp/env/ejb/NewSessionBean");
}
catch(Exception e)
{
System.out.println("Exception thrown...............");
e.printStackTrace();
}
}
%>
<html>
<body>
Send Data
<%
objHello.doSomeStuff();
%>
</body>
</html>
Persistence.xml
<?xml version="1.0" encoding="UTF-8"?>
<persistence version="1.0" xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/persistence
http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd">
<persistence-unit name="EnterpriseApplication6-ejbPU" transaction-type="JTA">
<jta-data-source>dsncity</jta-data-source>
<class>com.sisl.ejb.Shipments</class>
<class>com.sisl.ejb.Orders</class>
</persistence-unit>
</persistence>
Error log in GlassFish:
javax.ejb.EJBException: nested exception is: java.rmi.ServerException: RemoteException occurred in server
thread; nested exception is:
java.rmi.RemoteException: null; nested exception is:
Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2.0.1 (Build b04-fcs (04/11/2008))): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Error in allocating a connection. Cause: sun.jdbc.odbc.JdbcOdbcDriver cannot be cast to javax.sql.DataSource
