PHPMyAdmin runs on the server, so it is not helpful in this case.
You could try to connect with the MySql Query Browser from your local machine. Or setup the database connection in your IDE (which is handy anyways, especially when you use the JBoss Hibernate tools later). All IDEs have some means of database browser.
Hm.... and you have to be sure your web host allows connections from outside (i.e. applications not running on the same server) to the database. For security reasons this typically will not be the case. Then you have to setup a local database for development.
Okay if I can't link to it from the outside is there a way I can upload the .jar file of the program to the web host and run it from there? It's a console based program.
Also can you tell me what namespace I need to implement to get getSession() to work as well for my loadDatabase method?
Okay if I can't link to it from the outside is there a way I can upload the .jar file of the program to the web host and run it from there?
I doubt it. You need a shell access and Java installed. Then it is just as any other system, if you want to use it as console tool and not as a web app.
Do you have a dedicated or virtual server? Then yes, you can do whatever you want. Within the typical (cheap) web package? Next to no chance. Most probably you can run PHP there...
I've changed to using a local database within NetBeans and I've almost got it to work but I'm having some issues either regarding the mapping or the way I'm using the sessionfactory.
Configuration file, I think it's working 100% now.
The database is called AnimalsDatabase:
Table: Animals
PK: id - integer
name - varchar
type - varchar
Now the thing I'm confused about is when I created the table the names were all lowercase but on the Services database explorer they come up as full CAPS.
The Mapping File:
The save method in my program:
Here are the errors:
What do you have in that there bucket? It wouldn't be a tiny ad by any chance ...
Free, earth friendly heat - from the CodeRanch trailboss