There's nothing MySQL-specific in the latest blojsom.
Blojsom uses Hibernate
as the ORM, so any database-specifics as far as SQL are
handled by
Hibernate. All that needs to be configured with regards to
Hibernate is the
correct "dialect" that Hibernate should use for
your particular database.
The only other changes that might be required depending on
the database
(these will be noted in the installation instructions for a
given database):
- There are 3 named SQL queries in the Hibernate files (2 in
Entry.hbm.xml
and 1 in Blog.hbm.xml). I've written these very generically
so they should
work across any database. But, if need be, they can be
changed w/o having to
change any code in the application.
- There is one query in the blojsom-helper-beans-include.xml
file that may
need to change depending on the database used.
And no, there are no usernames appended to the tables that
blojsom creates.
This was only specific to the setup on that person's
hosting environment.
So, blojsom can accommodate that by changing the Hibernate
mapping files to
use the appropriately named tables for that environment.
On 5/18/06 11:33 AM, "ogjunk-blojsom yahoo.com" <ogjunk-blojsomyahoo.com>
wrote:
> Hi,
>
> Related question:
>
> I saw http://wiki.blojsom.com/wiki/display/blojsom3/Installa
tion and see a
> mention of PostgreSQL at the bottom. Is there anything
MySQL-specific in the
> new Blojsom? It all works via Hibernate, right? If
so, only DDL might be
> different...
>
> Also, below I see a mention of tables having usernames
appended. Is this
> true?
>
> Thanks,
> Otis
>
> ----- Original Message ----
> From: Graham Reeds <grahamrntlworld.com>
> To: blojsom-userslists.sourceforge.net
> Sent: Thursday, May 18, 2006 2:58:46 AM
> Subject: [Blojsom-users] Re: Does MySQL5 have to be
used with Blojsom 3.0?
>
>> If there are other major changes for MySQL 4.x, I
can certainly add another
>> table creation script into the mix for folks using
MySQL 4.x.
>
> I tried briefly last night, but though I have shell
access to my
> webspace, I don't have root access to mysql.
>
> I can create databases via the web interfaces (though
it appends my
> username to all tables). I can also log into the
database via the SSH
> applet but can (seemingly) only view and drop - not
create! However it
> was only a limited test.
>
> Thanks, Graham Reeds.
>
>
>
> -------------------------------------------------------
> Using Tomcat but need to do more? Need to support web
services, security?
> Get stuff done quickly with pre-integrated technology
to make your job easier
> Download IBM WebSphere Application Server v.1.0.1 based
on Apache Geronimo
> http://sel.as-us.falkag.net/
sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> Blojsom-users mailing list
> Blojsom-userslists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/blojsom-u
sers
>
>
>
>
>
> -------------------------------------------------------
> Using Tomcat but need to do more? Need to support web
services, security?
> Get stuff done quickly with pre-integrated technology
to make your job easier
> Download IBM WebSphere Application Server v.1.0.1 based
on Apache Geronimo
> http://sel.as-us.falkag.net/
sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> Blojsom-users mailing list
> Blojsom-userslists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/blojsom-u
sers
--
David Czarnecki
http://www.blojsom.com/b
log/ | http://blojsom.sf.net
-------------------------------------------------------
Using Tomcat but need to do more? Need to support web
services, security?
Get stuff done quickly with pre-integrated technology to
make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on
Apache Geronimo
http://sel.as-us.falkag.net/
sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Blojsom-users mailing list
Blojsom-userslists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/blojsom-u
sers
|