Java App using SQL Database  
Author Message
Thinker





PostPosted: Sun May 20 22:31:54 CDT 2007 Top

SQL Server >> Java App using SQL Database

I have a beginners question, I am learning Java, databases and trying
to create a Java application that talks to a SQL server. My question
is typically when I would like to install the application, Is there a
way one can get away without installing the SQL server, in other words
can one store the data in some manner (files..etc) and then use the
same application which internally uses SQL queries to query the data.
An example situation is I want to give this application to somebody
and they do not have SQL server...

Any help/suggestions will be greatly appreciated..
Thanks

SQL Server171  
 
 
Greg





PostPosted: Sun May 20 22:31:54 CDT 2007 Top

SQL Server >> Java App using SQL Database

>I have a beginners question, I am learning Java, databases and trying
> to create a Java application that talks to a SQL server. My question
> is typically when I would like to install the application, Is there a
> way one can get away without installing the SQL server, in other words
> can one store the data in some manner (files..etc) and then use the
> same application which internally uses SQL queries to query the data.
> An example situation is I want to give this application to somebody
> and they do not have SQL server...

Why not give them SQL Server?

For small applications, this is exactly what SQL Server Express is good for.


>
> Any help/suggestions will be greatly appreciated..
> Thanks
>

--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html


 
 
jhagens14





PostPosted: Sun May 20 22:50:31 CDT 2007 Top

SQL Server >> Java App using SQL Database On May 20, 10:31 pm, "Greg D. Moore \(Strider\)"


>

>
> >I have a beginners question, I am learning Java, databases and trying
> > to create a Java application that talks to a SQL server. My question
> > is typically when I would like to install the application, Is there a
> > way one can get away without installing the SQL server, in other words
> > can one store the data in some manner (files..etc) and then use the
> > same application which internally uses SQL queries to query the data.
> > An example situation is I want to give this application to somebody
> > and they do not have SQL server...
>
> Why not give them SQL Server?
>
> For small applications, this is exactly what SQL Server Express is good for.
>
>
>
> > Any help/suggestions will be greatly appreciated..
> > Thanks
>
> --
> Greg Moore
> SQL Server DBA Consulting Remote and Onsite available!
> Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

Do you know how much it costs? My initial thoughts were that I just
didn't want to buy the SQL server and distribute alongwith the
application...

 
 
amish





PostPosted: Mon May 21 03:11:38 CDT 2007 Top

SQL Server >> Java App using SQL Database
> On May 20, 10:31 pm, "Greg D. Moore \(Strider\)"
>
>
>
>
>


>

>
> > >I have a beginners question, I am learning Java, databases and trying
> > > to create a Java application that talks to a SQL server. My question
> > > is typically when I would like to install the application, Is there a
> > > way one can get away without installing the SQL server, in other words
> > > can one store the data in some manner (files..etc) and then use the
> > > same application which internally uses SQL queries to query the data.
> > > An example situation is I want to give this application to somebody
> > > and they do not have SQL server...
>
> > Why not give them SQL Server?
>
> > For small applications, this is exactly what SQL Server Express is good for.
>
> > > Any help/suggestions will be greatly appreciated..
> > > Thanks
>
> > --
> > Greg Moore
> > SQL Server DBA Consulting Remote and Onsite available!
> > Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html
>
> Do you know how much it costs? My initial thoughts were that I just
> didn't want to buy the SQL server and distribute alongwith the
> application...- Hide quoted text -
>
> - Show quoted text -

SQL Server Express is free. You can distribute it with your
application.


 
 
Greg





PostPosted: Mon May 21 06:29:46 CDT 2007 Top

SQL Server >> Java App using SQL Database

> On May 20, 10:31 pm, "Greg D. Moore \(Strider\)"


>>

>>
>> >I have a beginners question, I am learning Java, databases and trying
>> > to create a Java application that talks to a SQL server. My question
>> > is typically when I would like to install the application, Is there a
>> > way one can get away without installing the SQL server, in other words
>> > can one store the data in some manner (files..etc) and then use the
>> > same application which internally uses SQL queries to query the data.
>> > An example situation is I want to give this application to somebody
>> > and they do not have SQL server...
>>
>> Why not give them SQL Server?
>>
>> For small applications, this is exactly what SQL Server Express is good
>> for.
>>
>>
>>
>> > Any help/suggestions will be greatly appreciated..
>> > Thanks
>>
>> --
>> Greg Moore
>> SQL Server DBA Consulting Remote and Onsite available!
>> Email: sql (at) greenms.com
>> http://www.greenms.com/sqlserver.html
>
> Do you know how much it costs? My initial thoughts were that I just
> didn't want to buy the SQL server and distribute alongwith the
> application...
>

As I said, "give them SQL Server". SQL Server Express is free.

It has limits on size of the database, can only use on CPU, etc. But for
the size project you seem to be discussing, I'd bet it's perfect.





--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html