blojsom 3 issues: CGLIB Enhancement failed & sql error on: DEFAULT CHARSET=utf8

Hi all,

I'm trying to run blojsom and I'm stuck on 2 issues:

First there is an sql error:
ERROR main org.blojsom.util.database.DatabaseLoader -
java.sql.SQLException: Syntax error or access violation, 
message from
server: "You have an error in your SQL syntax.  Check
the manual that
corresponds to your MySQL server version for the right
syntax to use
near 'DEFAULT CHARSET=utf8' at line 1"

I haven't really looked into that one yet, but I suppose I
have an old
MySQL version that doesn't support the syntax, so some
tweaking of the
sql files should solve it.

I'm more worried about the second error. For pretty much
every class
in the org.blojsom.blog.database package I get the following
error:

ERROR main org.hibernate.proxy.BasicLazyInitializer - CGLIB
Enhancement failed: org.blojsom.blog.database.DatabaseEntry
java.lang.NoClassDefFoundError
	at
org.hibernate.proxy.CGLIBLazyInitializer.getProxyFactory(CGL
IBLazyInitializer.java:116)
	at
org.hibernate.proxy.CGLIBProxyFactory.postInstantiate(CGLIBP
roxyFactory.java:41)
	at
org.hibernate.tuple.PojoEntityTuplizer.buildProxyFactory(Poj
oEntityTuplizer.java:161)
[... many many more ... available upon request  ...]

I've checked and the cglib jar is in the WEB-INF/lib
directory, the
blojsom-core jar is there too with the classes. Any one have
any
ideas?



Peter

------------------------------------------------------------
-------------
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

On 10/17/06 3:48 AM, "Peter Backx"
<peter.backxgmail.com> wrote:

> Hi all,
> 
> I'm trying to run blojsom and I'm stuck on 2 issues:
> 
> First there is an sql error:
> ERROR main org.blojsom.util.database.DatabaseLoader -
> java.sql.SQLException: Syntax error or access
violation,  message from
> server: "You have an error in your SQL syntax. 
Check the manual that
> corresponds to your MySQL server version for the right
syntax to use
> near 'DEFAULT CHARSET=utf8' at line 1"

I forget what version of MySQL introduced the charset, but
it can be left
out if you know you're not going to be using international
characters in
your blog postings. Otherwise they're going to be munged if
you're not using
UTF-8. 

> 
> I haven't really looked into that one yet, but I
suppose I have an old
> MySQL version that doesn't support the syntax, so some
tweaking of the
> sql files should solve it.
> 
> I'm more worried about the second error. For pretty
much every class
> in the org.blojsom.blog.database package I get the
following error:
> 
> ERROR main org.hibernate.proxy.BasicLazyInitializer -
CGLIB
> Enhancement failed:
org.blojsom.blog.database.DatabaseEntry
> java.lang.NoClassDefFoundError
> at 
>
org.hibernate.proxy.CGLIBLazyInitializer.getProxyFactory(CGL
IBLazyInitializer.
> java:116)
> at 
>
org.hibernate.proxy.CGLIBProxyFactory.postInstantiate(CGLIBP
roxyFactory.java:4
> 1)
> at 
>
org.hibernate.tuple.PojoEntityTuplizer.buildProxyFactory(Poj
oEntityTuplizer.ja
> va:161)
> [... many many more ... available upon request  ...]
> 
> I've checked and the cglib jar is in the WEB-INF/lib
directory, the
> blojsom-core jar is there too with the classes. Any one
have any
> ideas?

Are you using Jboss? I found something that might be related
here:

<http://opensource.atlassian.com/projects/hi
bernate/browse/HHH-810>

" The problem had to do with a conflict of cglib jars
that are included in
JBOSS.

./server/all/deploy/jboss-hibernate.deployer/cglib-full-2.0.
1.jar
./server/default/deploy/jboss-hibernate.deployer/cglib-full-
2.0.1.jar

These jars contain code that are incompatible with latest
release of
Hibernate. Once deleted, JBoss startup worked fine without
errors."

> 
> 
> 
> Peter
> 
>
------------------------------------------------------------
-------------
> 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

I know this has been a long long time, but I finally had
some time to
look into the problems again. I'm trying to deploy Blojsom
on
GoDaddy's Java hosting.

On 10/17/06, David Czarnecki <davidblojsom.com> wrote:
> I forget what version of MySQL introduced the charset,
but it can be left
> out if you know you're not going to be using
international characters in
> your blog postings. Otherwise they're going to be
munged if you're not using
> UTF-8.
Apart from that there were some other minor changes that
were needed
to make it work with the older MySQL version. I needed to
define a key
on every foreign relation (this was a problem for the Entry
table)

> > ERROR main
org.hibernate.proxy.BasicLazyInitializer - CGLIB
> > Enhancement failed:
org.blojsom.blog.database.DatabaseEntry
> > java.lang.NoClassDefFoundError
I'm not sure what exactly is causing this issue. Probably
some
incompatibilities between jars, but my access to system
files at
GoDaddy is limited (ie. none). But it can be circumvented by
turning
of lazy loading.


I'm now at the next roadblock, but at least I already get to
see the
default blog 
GoDaddy always forwards requests for directories or .html
files to the
apache server. There really is nothing I can do to change
this. I'm
now trying to just put an "index.jsp" at the end
of all urls, this
seems to give some trouble in the admin console, but I'm
still
experimenting.


Hope this can help some one else too,
Peter

------------------------------------------------------------
-------------
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