- This topic has 11 replies, 7 voices, and was last updated 18 years, 5 months ago by
.
-
Posts
-
I’ve looked in Help Topics, I’ve done a search on the forum. Other than mentioning that hibernate support has been added, I can’t find any information on HOW to use the new features.
Lee
Lee,
We haven’t written any documentation for it yet but I have asked our Hibernate dev to take a look at this and see if he can provide some tips for you.Lee –
Create a java project
Right-click on it in package navigator -> MyEclipse ->Add Hibernate Support
Wizard that comes up allows you to define a hibernate nature for your project, setup libs, and create a basic hibernate config and sessionfactory class
From the DB Explorer, open a connection, navigate to a table, right click -> Export through Hibernate to create a POJO and mapping file (currently not updating the config, unfortunately, but this is coming soon)jeff
Ok — I found the DB perspective. I tried to set up an Oracle setting. I used values from a hand coded hibernate setup that DID work. When I try to connect from the db perspective I get an error: oracle.jdbc.driver.OracleDriver
that’s it — that’s all the message says.
Lee
Have you registered that driver? Is that driver a type-II driver? If necessary have you placed any DLL’s it needs in the system library path?
Here is a little more info on how to set this up (in this case for a MySQL DB). First download the latest MySQL driver (mysql-connector-java-3.0.14-production-bin.jar) and put this in a directory on one of your drives. Then with the DB Browser window up create a new Profile. When you get to selecting the driver to use click on the ‘New Driver…’ button. In that dialog box click on the Extra Class Path tab and then the Add button. Navigate to the directory where you installed the driver (the jar file listed above) and select it. Then click on the List Drivers button and the MySQL drivers will now show up in the Driver Class Name selection list. I selected com.mysql.jdbc.Driver in this case. Then you fill in the Name and Example URL text boxes (an Example URL for MySQL would be jdbc:mysql://localhost:3306/<database>). Click on Ok, fill out the rest of the Profile information and click on Ok. Now provided that the database server is up and running and the database you entered in the URL text box was correct you will be connected to the database.
fburke –
A question for you specifically as a mysql user…When you open a connection to your mysql database, do you get errors in eclipse? Browsing the conenction tree, do you get any more than just tables listed? Are you using the InnoDB engine within mysql? All these questions to try to help some other users who are having problems with the DB Explorer and mysql.
Thanx!
Better make sure your driver jar is not in the user home under Windows. A path that contains spaces will not work and it will not be obvious why.
i could’nt fine the DB browser in open perspective, this is first tieme i had installed my eclipse on my Pc.
And give the criteria which i need to follow to configure tomcat to myeclipse
