Thread: Need urgent help to connect to Database

Hi,
In my current assignment I'm trying to connect a remote MS Access database using JPA. But I'm not able to connect to database in my desktop itself .

Below is my code let me know if I'm doing something wrong.


persistence.xml
=========
<?xml version="1.0" encoding="UTF-8"?>
<persistence version="1.0" xmlns="http://java.sun.com/xml/ns/persistence">
<persistence-unit name="hello-world" transaction-type="RESOURCE_LOCAL">
<provider>oracle.toplink.essentials.ejb.cmp3.Entit yManagerFactoryProvider</provider>
<class>Dao.UserDetails</class>
<properties>
<property name="toplink.jdbc.user" value=""/>
<property name="toplink.jdbc.password" value=""/>
<property name="toplink.jdbc.url" value="jdbc:odbc:ds_userdsn"/>
<property name="toplink.jdbc.driver" value="sun.jdbc.odbc.JdbcOdbcDriver"/>
<property name="toplink.ddl-generation" value="create-tables"/>
</properties>
</persistence-unit>
</persistence>


UserAuth.java
=========

package DaoLayer;
 
import javax.persistence.EntityManager;
import javax.persistence.EntityManagerFactory;
import javax.persistence.Persistence;
 
import Dao.UserDetails;
 
public class UserAuth {
 
public static void main(String[] args) {
	String UserId="system1";
	String password="t12121";
	EntityManager em = null;
	try {
		EntityManagerFactory emf=Persistence.createEntityManagerFactory("hello-world");
		em = emf.createEntityManager();
		em.getTransaction().begin();
		UserDetails us=new UserDetails();
		us.setUserId(UserId);
		us.setPassword(password);
		em.persist(us);
		em.getTransaction().commit();	
		em.close();
		System.out.println("Persisted");
	}
	finally{
	if(em != null){
		System.out.println("hi");
 
	}
	}
 
 
}
}

• ds_userdsn is the user dsn created

================
I'm getting the below error

[TopLink Info]: 2010.11.26 04:08:32.846--ServerSession(2773808)--TopLink, version: Oracle TopLink Essentials - 2.0.1 (Build b04-fcs (04/11/2008))
Exception in thread "main" Local Exception Stack:
Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2.0.1 (Build b04-fcs (04/11/2008))): oracle.toplink.essentials.exceptions.DatabaseExcep tion
Internal Exception: java.sql.SQLException: No data found

What is UserDetails? What line is the exception thrown on? What is the database scema?

In MS Access it's not asking for user credential ...........also I've not created any schema ......

Originally Posted by The Vicky

In MS Access it's not asking for user credential ...........also I've not created any schema ......

You first must create the schema which corresponds to the entity bean mapping, otherwise there is no place to enter the data.