Re: [sqlite] Java Database Access Code Generator
Actually, Firestorm DAO pretty much does what I want. The problem with that solution is that it would leave me with the dilemma of limiting myself to 20 tables or paying for a $1000 license. I have sqlite-jdbc. It works fine. But using raw jdbc is pretty painful. I am surprised there are not more tools like this for java. I know there are some good ones for .Net. Thomas DILIGENT wrote: > Hello, > > In one hand, object persistence framework provide solutions starting from a > description of your DB - object mapping. > Unfortunately, these solutions are not easy to deploy. Does not seem to fit > your need. > > In the other hand, if you just want java database access, you can have a > look at sqlitejdbc. > Simple to use and fits jdbc standard. I successfully used it. > > >> -Original Message- >> From: sqlite-users-boun...@sqlite.org >> [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Mark Fraser >> Sent: Thursday, January 08, 2009 12:24 AM >> To: sqlite-users@sqlite.org >> Subject: [sqlite] Java Database Access Code Generator >> >> Hello, >> >> I am looking for suggestions on a simple tool to generate >> java db access code that works with SQLite. >> >> Ideally what I want is something that will take a database >> schema file with create table statements as input and will >> generate the java classes necessary to encapsulate basic >> operations on the database. >> >> Obviously I have done a lot of searching already but have not >> found anything current that has the simplicity and >> functionality I am hoping for. >> >> Has anyone here successfully used such a tool with java/SQLite? >> >> Thanks. >> >> ___ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> >> > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Java Database Access Code Generator
Hello, I am looking for suggestions on a simple tool to generate java db access code that works with SQLite. Ideally what I want is something that will take a database schema file with create table statements as input and will generate the java classes necessary to encapsulate basic operations on the database. Obviously I have done a lot of searching already but have not found anything current that has the simplicity and functionality I am hoping for. Has anyone here successfully used such a tool with java/SQLite? Thanks. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] using Mac osx to update sqlite
Jay, Thanks for your reply. >It might make more sense to install a newer version in /usr/local > rather than /usr. That way you can use the updated version for your That is what I did. I downloaded and extracted the .bin file and copied it to /usr/local/bin. Then after chmod +x it I ran it and got the Bus error. By what you are saying it appears that the one I already had in /usr/local/bin was not the original OS X version, so maybe it was installed by another application. I do have an older version in /usr/bin which is ostensibly the OS X delivered version. Any other suggestions? Thanks, Mark Jay A. Kreibich wrote: > On Sat, Jan 03, 2009 at 02:44:59PM -0500, Mark Fraser scratched on the wall: > >> I am trying to update the version 3.4.0 that came with my Mac OSX x86 >> Tiger installation. >> >> Any suggestions on the best way to do this? >> > > Mac OS X, by default, dynamically links just about everything, so it > is no surprise that Apple has chosen to build SQLite this way as well. > Apple's version of sqlite3 (/usr/bin/sqlite3) really is just the CLI > code, and doesn't contain the core SQLite engine. If you want to > upgrade the whole thing you need to upgrade both the CLI application > at /usr/bin/sqlite3 and the library at /usr/lib/libsqlite3.0.dylib. > > > > I'd be very cautious about doing that, however, as Apple uses SQLite > for many thing, including the Core Data framework. It is considered > part of the core OS. That also means System Updates may over-write > your changes. > > It might make more sense to install a newer version in /usr/local > rather than /usr. That way you can use the updated version for your > own projects and applications, but leave the OS version alone. That > also protects against Apple "updating" your installed version. > >-j > > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] using Mac osx to update sqlite
I am trying to update the version 3.4.0 that came with my Mac OSX x86 Tiger installation. Any suggestions on the best way to do this? If I just install the binary from the download page and try to execute it I get "Bus error". thanks, Mark ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users