Hello every body. I wrote a program with a database using netbeans when i build it on the system it works fine but when i run it on another system it seem not to recognise the database please can anyone give me tips. I used mysql dbms. Thanks
Well, look. If you are a beginner with databases (and it seems like you are) then it's far too soon for you to think about distributing your application. So don't ask that question yet. Instead go back and find out what your actual problem is.
Remember, you still haven't posted any details at all about your problem. So how about if you start there?
Joined: Jul 16, 2009
Am nt new to database. I have written a database program running perfectly wel on the source machine but now i want to distribute it dat is where the problem is. So if you can help.
Should all clients access the same central DB, or should each have its own instance? If the former, then the DB needs to be installed on a machine that all clients can access, and the JDBC connection URL will need to contain the IP address (or machine name) of that DB server.
If, on the other hand, each client should have its own DB instance, then you could look into Java DBs that can be embedded in the client, like HSQLDB or Derby.
Really the systems is not on a network. They are different systems
Joined: Mar 22, 2005
I can't tell from your reply whether there should be one central DB, or one for each client. If the clients are not all on the same network (in other words, we're talking about an internet scenario), then I'd advise against using JDBC to connect to a central DB for security reasons.
Also, as Paul said, you still haven't told us what exactly the problem is.
Joined: Jul 16, 2009
Now guys let me repost my question. I have a program, a database(mysql) program. Now it works well on my system but when i run it on other system it gives null statement. Well maybe because the database service is not runing on the other system. Now how can i embed the database into the program so that it runs as a full standalone program ready for deployment