Ok I don't have the tables so I try to create them using the link
http://localhost:8080/jmx-console/HtmlAdaptor?action=inspectMBean&name=portal%3Aservice%3DHibernate
I then get the following.
17:59:48,912 INFO [DatasourceConnectionProvider] Using datasource:
java:PortalDS
17:59:48,922 ERROR [SchemaExport] Unsuccessful: create table jbp_roles (jbp_rid
integer not null auto_incremen
t, jbp_name varchar(255) unique, jbp_displayname varchar(255) unique, primary
key (jbp_rid))
17:59:48,922 ERROR [SchemaExport] Unexpected token: AUTO_INCREMENT in statement
[create table jbp_roles (jbp_r
id integer not null auto_increment]
17:59:48,922 ERROR [SchemaExport] Unsuccessful: create table jbp_user_pref
(jbp_id integer not null auto_incre
ment, jbp_name varchar(255) not null, jbp_type integer, jbp_set_id integer,
primary key (jbp_id))
17:59:48,922 ERROR [SchemaExport] Unexpected token: AUTO_INCREMENT in statement
[create table jbp_user_pref (j
bp_id integer not null auto_increment]
17:59:48,922 ERROR [SchemaExport] Unsuccessful: create table jbp_user_pref_set
(jbp_id integer not null auto_i
ncrement, jbp_parent_id integer, name varchar(255) not null, primary key
(jbp_id))
17:59:48,922 ERROR [SchemaExport] Unexpected token: AUTO_INCREMENT in statement
[create table jbp_user_pref_se
t (jbp_id integer not null auto_increment]
17:59:48,922 ERROR [SchemaExport] Unsuccessful: create table jbp_users (jbp_uid
integer not null auto_incremen
t, jbp_root_pref_set_id integer, jbp_uname varchar(255) unique, jbp_givenname
varchar(255), jbp_familyname var
char(255), jbp_password varchar(255), jbp_realemail varchar(255), jbp_fakeemail
varchar(255), jbp_regdate date
time, jbp_viewrealemail bit, jbp_enabled bit, primary key (jbp_uid))
17:59:48,922 ERROR [SchemaExport] Unexpected token: AUTO_INCREMENT in statement
[create table jbp_users (jbp_u
id integer not null auto_increment]
17:59:48,922 ERROR [SchemaExport] Unsuccessful: alter table jbp_role_membership
add index FKF4101738E70E4BD7 (
jbp_uid), add constraint FKF4101738E70E4BD7 foreign key (jbp_uid) references
jbp_users (jbp_uid)
17:59:48,922 ERROR [SchemaExport] Wrong data type: FKF4101738E70E4BD7 in
statement [alter table jbp_role_membe
rship add index FKF4101738E70E4BD7]
17:59:48,922 ERROR [SchemaExport] Unsuccessful: alter table jbp_role_membership
add index FKF4101738A7430374 (
jbp_rid), add constraint FKF4101738A7430374 foreign key (jbp_rid) references
jbp_roles (jbp_rid)
17:59:48,922 ERROR [SchemaExport] Wrong data type: FKF4101738A7430374 in
statement [alter table jbp_role_membe
rship add index FKF4101738A7430374]
17:59:48,932 ERROR [SchemaExport] Unsuccessful: alter table jbp_user_pref add
index FK93CC44D0AF499A90 (jbp_se
t_id), add constraint FK93CC44D0AF499A90 foreign key (jbp_set_id) references
jbp_user_pref_set (jbp_id)
17:59:48,932 ERROR [SchemaExport] Table not found: JBP_USER_PREF in statement
[alter table jbp_user_pref]
17:59:48,932 ERROR [SchemaExport] Unsuccessful: alter table
jbp_user_pref_prop_value add index FKC4963064D50D5
281 (jbp_prop_id), add constraint FKC4963064D50D5281 foreign key (jbp_prop_id)
references jbp_user_pref (jbp_i
d)
17:59:48,932 ERROR [SchemaExport] Wrong data type: FKC4963064D50D5281 in
statement [alter table jbp_user_pref_
prop_value add index FKC4963064D50D5281]
17:59:48,932 ERROR [SchemaExport] Unsuccessful: alter table jbp_user_pref_set
add index FK97AA4873E3AFC41A (jb
p_parent_id), add constraint FK97AA4873E3AFC41A foreign key (jbp_parent_id)
references jbp_user_pref_set (jbp_
id)
17:59:48,932 ERROR [SchemaExport] Table not found: JBP_USER_PREF_SET in
statement [alter table jbp_user_pref_s
et]
17:59:48,932 ERROR [SchemaExport] Unsuccessful: alter table jbp_user_prop add
index FK93CC4610E70E4BD7 (jbp_ui
d), add constraint FK93CC4610E70E4BD7 foreign key (jbp_uid) references
jbp_users (jbp_uid)
17:59:48,932 ERROR [SchemaExport] Wrong data type: FK93CC4610E70E4BD7 in
statement [alter table jbp_user_prop
add index FK93CC4610E70E4BD7]
17:59:48,932 ERROR [SchemaExport] Unsuccessful: alter table jbp_users add index
FKF6060141FD4AFF8F (jbp_root_p
ref_set_id), add constraint FKF6060141FD4AFF8F foreign key
(jbp_root_pref_set_id) references jbp_user_pref_set
(jbp_id)
17:59:48,932 ERROR [SchemaExport] Table not found: JBP_USERS in statement
[alter table jbp_users]
17:59:48,932 INFO [SchemaExport] schema export complete
17:59:52,838 INFO [SessionFactoryBinder] Creating database content
17:59:52,918 WARN [JDBCExceptionReporter] SQL Error: -22, SQLState: S0002
17:59:52,918 ERROR [JDBCExceptionReporter] Table not found in statement [insert
into jbp_roles (jbp_name, jbp_
displayname) values (?, ?)]
17:59:52,918 ERROR [SessionFactoryBinder] Error in the bsh script
Sourced file: inline evaluation of: ``// This bsh script setup the default
content of the portal. // It is ca
lled whe . . . '' : Method Invocation session.save : at Line: 39 : in file:
inline evaluation of: ``// This bs
h script setup the default content of the portal. // It is called whe . . . ''
: session .save ( adminRole )
Target exception: org.hibernate.exception.SQLGrammarException: could not
insert: [org.jboss.portal.core.impl.r
ole.RoleImpl]
at bsh.BSHMethodInvocation.eval(Unknown Source)
at bsh.BSHPrimaryExpression.eval(Unknown Source)
at bsh.BSHPrimaryExpression.eval(Unknown Source)
at bsh.BSHBlock.evalBlock(Unknown Source)
at bsh.BSHBlock.eval(Unknown Source)
at bsh.BSHBlock.eval(Unknown Source)
at bsh.BSHTryStatement.eval(Unknown Source)
at bsh.Interpreter.eval(Unknown Source)
at bsh.Interpreter.eval(Unknown Source)
at bsh.Interpreter.eval(Unknown Source)
at
org.jboss.portal.core.hibernate.SessionFactoryBinder.createContent(SessionFactoryBinder.java:330)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
at
org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:118)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
at
org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:
127)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
at
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
at org.jboss.jmx.adaptor.control.Server.invokeOpByName(Server.java:243)
at org.jboss.jmx.adaptor.control.Server.invokeOp(Server.java:208)
at
org.jboss.jmx.adaptor.html.HtmlAdaptorServlet.invokeOp(HtmlAdaptorServlet.java:247)
at
org.jboss.jmx.adaptor.html.HtmlAdaptorServlet.processRequest(HtmlAdaptorServlet.java:85)
at
org.jboss.jmx.adaptor.html.HtmlAdaptorServlet.doPost(HtmlAdaptorServlet.java:67)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at
org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)
at
org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:159)
at
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.ja
va:744)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at
org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
at java.lang.Thread.run(Thread.java:534)
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3919156#3919156
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3919156
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642
_______________________________________________
JBoss-user mailing list
JBoss-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jboss-user
