aspose file tools*
The moose likes Java in General and the fly likes Please help me need urgent help on JPA connection Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Java in General
Bookmark "Please help me need urgent help on JPA connection" Watch "Please help me need urgent help on JPA connection" New topic
Author

Please help me need urgent help on JPA connection

Bhakta Pradhan
Greenhorn

Joined: Nov 26, 2010
Posts: 22
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


Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

Can you connect TopLink to Access? Access is an odd choice.



JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Raza Mohd
Ranch Hand

Joined: Jan 20, 2010
Posts: 247

hi..

you might be using a wrong transaction type...

Thanks..


Good luck!!
A small leak can sink a Gigantic ship.>
Matthew Brown
Bartender

Joined: Apr 06, 2010
Posts: 4392
    
    8

If the Access database is set up as an ODBC data source then the JDBC/ODBC driver can connect to it.

That connection URL looks strange, though. I'd expect it to be in the format jdbc:odbc:DataSourceName. I'd suggest trying that.

(Edited to disable Smilies - does weird things to that URL!)
Bhakta Pradhan
Greenhorn

Joined: Nov 26, 2010
Posts: 22

Hi all thanks for your quick replies. Hi Mathew the connection URL i have used is what you have mentioned above it got edited automatically while posting this thread.

However I have created a UserDSN named ds_userdsn of type Microsoft Access Driver(*mdb).

Please suggest if i'm doing something wrong here. I would appreciate if anybody can post here sample persistence.xml file required.
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 38902
    
  23
Welcome to the Ranch

Please always indent any code and use the code button, which woul dhave made your code easier to read.
Bhakta Pradhan
Greenhorn

Joined: Nov 26, 2010
Posts: 22
Thank you very much Campbell for this info...........any idea for my issue ???
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Please help me need urgent help on JPA connection