• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

some queries about standalone application

 
Ranch Hand
Posts: 1143
5
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
i m creating a standalone application with mysql...
how do i give that to the client??
what is required to be installed on the client machine??
also while development of application which driver i should use??(type1 or type4)??
 
Bartender
Posts: 1111
Eclipse IDE Oracle VI Editor
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
you wil need to make or buy an installer to give it to the client.
I have only ever used a type 4 driver, especially for MYSQL see no reason to use any other.
You will need to ensure mysql is installed, and your database tables are setup/created/installed, and any data that is needed initially is also there.
You will need to ensure a java jre is installed (of the correct version).
 
Punit Jain
Ranch Hand
Posts: 1143
5
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator


You will need to ensure mysql is installed, and your database tables are setup/created/installed, and any data that is needed initially is also there.



okay.. so mysql must be installed on client machine??
in case of embedded databases, i only need to attach jar file of db, can't do like this with mysql???
 
Marshal
Posts: 28193
95
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I was going to answer that question and then I noticed that Wendy had already said everything I was going to say. Not only that, you copied her answer into your post. Please take time to read and understand the answers which are given to you.
 
Punit Jain
Ranch Hand
Posts: 1143
5
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
i read the answer, and as such wendy said, mysql should installed there..??
so i m just confirming that on the client machine i have to install mysql first to use that application, isn't it??
 
Sheriff
Posts: 67746
173
Mac Mac OS X IntelliJ IDE jQuery TypeScript Java iOS
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
If that's where the database is to be running. Is it? The database server can be anywhere on the net.
 
Punit Jain
Ranch Hand
Posts: 1143
5
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
so you mean mysql be installed there..
and it's a standalone application..
 
Bear Bibeault
Sheriff
Posts: 67746
173
Mac Mac OS X IntelliJ IDE jQuery TypeScript Java iOS
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Asking again from a different viewpoint: where does the client intend to run the database?
 
Punit Jain
Ranch Hand
Posts: 1143
5
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
on his system, in which he is using that application...
 
Paul Clapham
Marshal
Posts: 28193
95
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
To put the answer in the simplest possible terms: MySQL must be installed and configured on the machine where the client intends it to run.
 
Bear Bibeault
Sheriff
Posts: 67746
173
Mac Mac OS X IntelliJ IDE jQuery TypeScript Java iOS
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Does he already have a database? Most of my clients already run a database that I simply add my tables to.

If not, is mysql the best choice? If the DB is specific to the app and the client isn't going to be dealing with it, would not a DB such as HSQLDB or H2 be more appropriate and easier to manage?
 
Punit Jain
Ranch Hand
Posts: 1143
5
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
yes earlier he was using microsoft access db..
 
Paul Clapham
Marshal
Posts: 28193
95
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Then using a different database was definitely a good choice. But it's still possible, as Bear suggests, to ask whether an embedded database would be more practical than a database which has to be installed and managed.
 
Wendy L Gibbons
Bartender
Posts: 1111
Eclipse IDE Oracle VI Editor
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Punit Jain wrote:


You will need to ensure mysql is installed, and your database tables are setup/created/installed, and any data that is needed initially is also there.



okay.. so mysql must be installed on client machine??
in case of embedded databases, i only need to attach jar file of db, can't do like this with mysql???



MySQL isn't an embedded database, so you can't just ship a jar.
 
Bear Bibeault
Sheriff
Posts: 67746
173
Mac Mac OS X IntelliJ IDE jQuery TypeScript Java iOS
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I'll refrain from commenting on real versus toy databases.
 
Wendy L Gibbons
Bartender
Posts: 1111
Eclipse IDE Oracle VI Editor
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Bear Bibeault wrote:I'll refrain from commenting on real versus toy databases.



oh please please don't, i love a good rant, also would be interested to see, which side you put each db on
 
Punit Jain
Ranch Hand
Posts: 1143
5
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
okay..so embedded db(java db) will be good choice??
 
Paul Clapham
Marshal
Posts: 28193
95
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
There are different databases. The reason for that isn't just that various ego-driven people wanted to create them (although that is part of the truth). The reason is that different databases are suitable for different purposes.

And therefore asking whether Database X would be a good choice, without saying anything about the system it would be running in or anything else, is a useless question.
 
Punit Jain
Ranch Hand
Posts: 1143
5
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
well my application is not more complex, it just login and store some information of student and then fetches some data from database also and print the report...
that's it....
i m creating this application in java..
any embedded db, which is easier to use(as such i have never used any embedded db), and have good resources and tutorials.???
 
Punit Jain
Ranch Hand
Posts: 1143
5
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
my code is working now...
but when i m opening ij(intractive sql), and firing query,
CONNECT 'jdbc:derby:newlogin';

it again showing me error

ERROR XJ040: Failed to start database 'newlogin' with class loader sun.misc.Launcher$AppClassLoader@35ce36, see the next exception for details.
ERROR XSDB6: Another instance of Derby may have already booted the database G:\eclipse projects\derby\PoonaCollegeTest\newlogin.

but no instance of my database is booted..
how do i solved this issue??
 
Wendy L Gibbons
Bartender
Posts: 1111
Eclipse IDE Oracle VI Editor
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Punit Jain wrote:well my application is not more complex, it just login and store some information of student and then fetches some data from database also and print the report...
that's it....
i m creating this application in java..
any embedded db, which is easier to use(as such i have never used any embedded db), and have good resources and tutorials.???



How can you say you have never used an embedded database when you started this thread on the 24th march:
https://coderanch.com/t/571360/JDBC/java/exception-login-page-apache-derby

 
Punit Jain
Ranch Hand
Posts: 1143
5
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator


How can you say you have never used an embedded database when you started this thread on the 24th march:



because still this problem remains with me..
this was my first application with embedded db and, and still i have not resolved all of my issues with this application..
i mean still it's not working properly...
 
You are HERE! The other map is obviously wrong. Better confirm with this tiny ad:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic