2.4 installation difficulties

[mwelch16]

Hello,

I am using JBOSS 4.0.4GA. I have tried using the installer version, the installer patch version and the zip version of the AS, and I get the same error in each. I am using Portal 2.4 beta with Sybase 15 and jconnect2.jar (which I believe is 5.5). I have tried using the bundled portal and the binary portal downloads (working on building from source next). I am using JDK 1.5.0_06. I have two problems. One: the hibernate logs in and creates the user tables as expected, but fails when trying to boot the portal. Two: I am getting an exception when trying to load the wsrp about the wsdl not being read, and my hibernate beans are not fully loading. I know the release notes say that wsrp is not fully functional; I wanted to know if the error was due to that or due to my ignorance. Any insight would be appreciated; I am sure I am doing something stupid.

Here is the xml in my portal-sybase-ds.xml:

<?xml version="1.0" encoding="UTF-8"?>
<datasources>
 <local-tx-datasource>
 <jndi-name>PortalDS</jndi-name>
 <connection-url>jdbc:sybase:Tds:d8loc:3025/jbossportal</connection-url>
 <driver-class>com.sybase.jdbc2.jdbc.SybDriver</driver-class>
 <user-name>portaladmin</user-name>
 <password>!jboss</password>
 <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.SybaseExceptionSorter</exception-sorter-class-name>

 <metadata>
 <type-mapping>Sybase</type-mapping>
 </metadata>
 </local-tx-datasource>
</datasources>

Here is my explicit dialect setting in all of the hibernate.cfg.xml files in the jbossportal.sar:

<property name="dialect">org.hibernate.dialect.SybaseDialect</property>

Here are my errors:

Deployment Error/Exception:

2006-06-29 07:54:32,922 DEBUG [org.jboss.util.NestedThrowable] org.jboss.util.NestedThrowable.parentTraceEnabled=true
2006-06-29 07:54:32,922 DEBUG [org.jboss.util.NestedThrowable] org.jboss.util.NestedThrowable.nestedTraceEnabled=false
2006-06-29 07:54:32,922 DEBUG [org.jboss.util.NestedThrowable] org.jboss.util.NestedThrowable.detectDuplicateNesting=true
2006-06-29 07:54:32,922 ERROR [org.jboss.deployment.MainDeployer] Could not start deployment: file:/C:/Program Files/jboss-4.0.4.GA/server/default/deploy/jboss-portal.sar/portal-wsrp.sar/portal-wsrp-client.jar
org.jboss.deployment.DeploymentException: Failed to setup client ENC; - nested throwable: (javax.naming.CommunicationException: Receive timed out [Root exception is java.net.SocketTimeoutException: Receive timed out])
 at org.jboss.deployment.ClientDeployer.start(ClientDeployer.java:171)
 at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1007)
 at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:808)
 at org.jboss.deployment.MainDeployer.addDeployer(MainDeployer.java:368)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
 at java.lang.reflect.Method.invoke(Unknown Source)
 at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
 at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
 at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
 at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
 at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
 at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
 at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
 at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
 at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
 at $Proxy80.addDeployer(Unknown Source)
 at org.jboss.deployment.SubDeployerSupport.startService(SubDeployerSupport.java:124)
 at org.jboss.deployment.ClientDeployer.startService(ClientDeployer.java:59)
 at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
 at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:196)

WSDL Exception:

2006-06-29 07:54:42,416 DEBUG [org.jboss.system.ServiceController] Creating service jboss.web.deployment:war=portal-wsrp.war,id=-1263127798
2006-06-29 07:54:42,416 DEBUG [org.jboss.system.ServiceController] adding depends in ServiceController.register: []
2006-06-29 07:54:42,416 DEBUG [org.jboss.web.WebModule] Creating jboss.web.deployment:war=portal-wsrp.war,id=-1263127798
2006-06-29 07:54:42,416 DEBUG [org.jboss.web.WebModule] Created jboss.web.deployment:war=portal-wsrp.war,id=-1263127798
2006-06-29 07:54:42,416 DEBUG [org.jboss.system.ServiceController] Creating dependent components for: jboss.web.deployment:war=portal-wsrp.war,id=-1263127798 dependents are: []
2006-06-29 07:54:42,436 DEBUG [org.jboss.ws.metadata.JSR109ServerMetaDataBuilder] START buildMetaData: [url=file:/C:/Program Files/jboss-4.0.4.GA/server/default/tmp/deploy/portal-wsrp-exp.war/WEB-INF/webservices.xml]
2006-06-29 07:54:42,566 DEBUG [org.jboss.ws.metadata.wsdl.WSDLDefinitionsFactory] parse: file:/C:/Program Files/jboss-4.0.4.GA/server/default/tmp/deploy/portal-wsrp-exp.war/WEB-INF/wsdl/wsrp_services.wsdl
2006-06-29 07:54:43,898 ERROR [org.jboss.deployment.MainDeployer] Could not create deployment: file:/C:/Program Files/jboss-4.0.4.GA/server/default/tmp/deploy/portal-wsrp.war
org.jboss.ws.metadata.wsdl.WSDLException: WSDLException (at /wsdl:definitions/import/wsdl:definitions/import/wsdl:definitions/wsdl:types/schema/schema): faultCode=OTHER_ERROR: An error occurred trying to resolve schema referenced at 'http://www.w3.org/2001/xml.xsd', relative to 'file:/C:/Program Files/jboss-4.0.4.GA/server/default/tmp/deploy/portal-wsrp-exp.war/WEB-INF/wsdl/wsrp_v1_types.xsd'.: Cannot access imported wsdl [http://www.w3.org/2001/xml.xsd], Connection refused: connect: java.lang.RuntimeException: Cannot access imported wsdl [http://www.w3.org/2001/xml.xsd], Connection refused: connect
 at org.jboss.ws.metadata.wsdl.WSDLDefinitionsFactory$WSDLLocatorImpl.getImportInputSource(WSDLDefinitionsFactory.java:310)
 at com.ibm.wsdl.xml.WSDLReaderImpl.parseSchema(WSDLReaderImpl.java:740)
 at com.ibm.wsdl.xml.WSDLReaderImpl.parseSchema(WSDLReaderImpl.java:830)
 at com.ibm.wsdl.xml.WSDLReaderImpl.parseSchema(WSDLReaderImpl.java:620)
 at com.ibm.wsdl.xml.WSDLReaderImpl.parseTypes(WSDLReaderImpl.java:583)
 at com.ibm.wsdl.xml.WSDLReaderImpl.parseDefinitions(WSDLReaderImpl.java:302)
 at com.ibm.wsdl.xml.WSDLReaderImpl.readWSDL(WSDLReaderImpl.java:2133)
 at com.ibm.wsdl.xml.WSDLReaderImpl.parseImport(WSDLReaderImpl.java:450)
 at com.ibm.wsdl.xml.WSDLReaderImpl.parseDefinitions(WSDLReaderImpl.java:294)
 at com.ibm.wsdl.xml.WSDLReaderImpl.readWSDL(WSDLReaderImpl.java:2133)
 at com.ibm.wsdl.xml.WSDLReaderImpl.parseImport(WSDLReaderImpl.java:450)
 at com.ibm.wsdl.xml.WSDLReaderImpl.parseDefinitions(WSDLReaderImpl.java:294)
 at com.ibm.wsdl.xml.WSDLReaderImpl.readWSDL(WSDLReaderImpl.java:2133)
 at com.ibm.wsdl.xml.WSDLReaderImpl.readWSDL(WSDLReaderImpl.java:2125)
 at com.ibm.wsdl.xml.WSDLReaderImpl.readWSDL(WSDLReaderImpl.java:2150)
 at com.ibm.wsdl.xml.WSDLReaderImpl.readWSDL(WSDLReaderImpl.java:2171)
 at com.ibm.wsdl.xml.WSDLReaderImpl.readWSDL(WSDLReaderImpl.java:2201)
 at org.jboss.ws.metadata.wsdl.WSDLDefinitionsFactory.parse(WSDLDefinitionsFactory.java:144)
 at org.jboss.ws.metadata.ServiceMetaData.getWsdlDefinitions(ServiceMetaData.java:273)
 at org.jboss.ws.metadata.JSR109ServerMetaDataBuilder.buildMetaData(JSR109ServerMetaDataBuilder.java:111)
 at org.jboss.ws.server.WebServiceDeployerJSE.createWebServicesMetaData(WebServiceDeployerJSE.java:189)
 at org.jboss.ws.server.WebServiceDeployer.create(WebServiceDeployer.java:103)
 at org.jboss.ws.server.WebServiceDeployerJSE.create(WebServiceDeployerJSE.java:66)
 at org.jboss.deployment.SubDeployerInterceptorSupport$XMBeanInterceptor.create(SubDeployerInterceptorSupport.java:180)
 at org.jboss.deployment.SubDeployerInterceptor.invoke(SubDeployerInterceptor.java:91)
 at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
 at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
 at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
 at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
 at $Proxy101.create(Unknown Source)
 at org.jboss.deployment.MainDeployer.create(MainDeployer.java:953)
 at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:807)
 at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:771)

Hibernate Error:

2006-06-29 07:54:49,686 DEBUG [org.jboss.portal.cms.hibernate.jmx.HibernateStore] Starting failed portal:service=CMS,hibernateSessionFactory=CMSHibernateStoreSessionFactory
org.hibernate.HibernateException: Hibernate Dialect must be explicitly set for database: Adaptive Server Enterprise
 at org.hibernate.dialect.DialectFactory.determineDialect(DialectFactory.java:62)
 at org.hibernate.dialect.DialectFactory.buildDialect(DialectFactory.java:39)
 at org.hibernate.cfg.SettingsFactory.determineDialect(SettingsFactory.java:397)
 at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:111)
 at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1928)
 at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1211)
 at org.jboss.portal.cms.hibernate.jmx.Hibernate.buildSessionFactory(Hibernate.java:119)
 at org.jboss.portal.cms.hibernate.jmx.Hibernate.startService(Hibernate.java:109)
 at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
 at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
 at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
 at java.lang.reflect.Method.invoke(Unknown Source)
 at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
 at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
 at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
 at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
 at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
 at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978)
 at $Proxy0.start(Unknown Source)

SQLException:

com.sybase.jdbc2.jdbc.SybSQLException: Incorrect syntax near the keyword 'ROLE'.

 at com.sybase.jdbc2.tds.Tds.processEed(Tds.java:2636)
 at com.sybase.jdbc2.tds.Tds.nextResult(Tds.java:1996)
 at com.sybase.jdbc2.jdbc.ResultGetter.nextResult(ResultGetter.java:69)
 at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:204)
 at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:187)
 at com.sybase.jdbc2.jdbc.SybStatement.queryLoop(SybStatement.java:1537)
 at com.sybase.jdbc2.jdbc.SybStatement.executeQuery(SybStatement.java:1522)
 at com.sybase.jdbc2.jdbc.SybPreparedStatement.executeQuery(SybPreparedStatement.java:72)
 at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:236)
 at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
 at org.hibernate.loader.Loader.getResultSet(Loader.java:1669)
 at org.hibernate.loader.Loader.doQuery(Loader.java:662)
 at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
 at org.hibernate.loader.Loader.doList(Loader.java:2145)
 at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
 at org.hibernate.loader.Loader.list(Loader.java:2024)
 at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:392)
 at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:333)
 at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
 at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1114)
 at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)

Thanks you for your help in advance, and I hope I am doing something wrong that is easily fixed.

Thanks,
Mark

[claprun]

It seems that you are experiencing network problems... Notice the socket time out: [Root exception is java.net.SocketTimeoutException: Receive timed out]. Same with the WSRP module: java.lang.RuntimeException: Cannot access imported wsdl [http://www.w3.org/2001/xml.xsd], Connection refused: connect

[mwelch16]

I am sitting behind a proxy here at work, but am using JSR-109 web services on jboss 4.0.2 with no problem. Is there a configuration setting that can help me so I can download the schema at http://www.w3.org/2001/xml.xsd through my proxy?

[mwelch16]

So does 4.0.4GA require internet connectivity in order to boot and run?

[mwelch16]

rather wsrp?

[claprun]

hmm the xml parser used by the WS stack might not like the proxy indeed...

[mwelch16]

I backed up to the 2.2sp3 version of Portal and am now just dealing with hibernate errors. Is this a known issue in wsrp? I would think that I should be able to access remote portlets on my network without having internet connectivity at least have a way to configure for a proxy. (I am using 4.0.4 AS with the 1.0.0 WS stack no problem.)

Any insight on my hibernate errors would help me out (the dialect configuration is in the first post). I don't know if this is sybase or user error.

2006-06-29 15:50:59,199 INFO [org.hibernate.util.NamingHelper] JNDI InitialContext properties:{}
2006-06-29 15:50:59,199 INFO [org.hibernate.connection.DatasourceConnectionProvider] Using datasource: java:PortalDS
2006-06-29 15:50:59,209 DEBUG [org.jboss.resource.connectionmanager.IdleRemover] internalRegisterPool: registering pool with interval 900000 old interval: 9223372036854775807
2006-06-29 15:50:59,209 DEBUG [org.jboss.resource.connectionmanager.IdleRemover] internalRegisterPool: about to notify thread: old next: 1151611109209, new next: 1151611109209
2006-06-29 15:50:59,700 DEBUG [org.hibernate.cfg.SettingsFactory] could not get database version from JDBC metadata
2006-06-29 15:50:59,710 INFO [org.hibernate.cfg.SettingsFactory] RDBMS: Adaptive Server Enterprise, version: Adaptive Server Enterprise/15.0/EBF 13244 ESD#1 ONE-OFF/P/Sun_svr4/OS 5.8/ase150eap/2169/64-bit/FBO/Wed Jan 11 05:02:51 2006
2006-06-29 15:50:59,710 INFO [org.hibernate.cfg.SettingsFactory] JDBC driver: jConnect (TM) for JDBC (TM), version: jConnect (TM) for JDBC(TM)/5.5(Build 25152)/P/EBF10106/JDK12/Mon Feb 25 19:10:53 2002
2006-06-29 15:50:59,710 ERROR [org.jboss.portal.cms.hibernate.HibernateStore] failed to initialize file system
org.hibernate.HibernateException: Hibernate Dialect must be explicitly set for database: Adaptive Server Enterprise
 at org.hibernate.dialect.DialectFactory.determineDialect(DialectFactory.java:62)
 at org.hibernate.dialect.DialectFactory.buildDialect(DialectFactory.java:39)
 at org.hibernate.cfg.SettingsFactory.determineDialect(SettingsFactory.java:397)
 at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:111)
 at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1928)
 at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1211)
 at org.jboss.portal.cms.hibernate.HibernateStore.init(HibernateStore.java:251)

2006-06-29 15:50:37,918 DEBUG [org.jboss.system.ServiceConfigurator] ExternalPermissionTypes set to [Ljava.lang.Class;@4cd580 in jboss.security:service=JaccPolicyProvider
2006-06-29 15:50:37,918 DEBUG [org.jboss.system.ServiceCreator] About to create xmbean object: portal:service=SecurityProvider with code: org.jboss.portal.security.impl.jacc.JBossSecurityProviderImpl with embedded descriptor
2006-06-29 15:50:37,938 DEBUG [org.jboss.mx.server.AbstractMBeanInvoker] Setter not found: setObjectName(class javax.management.ObjectName)
java.lang.NoSuchMethodException: org.jboss.portal.security.impl.jacc.JBossSecurityProviderImpl.setObjectName(javax.management.ObjectName)
 at java.lang.Class.getMethod(Unknown Source)
 at org.jboss.mx.server.AbstractMBeanInvoker.inject(AbstractMBeanInvoker.java:948)
 at org.jboss.mx.server.AbstractMBeanInvoker.preRegister(AbstractMBeanInvoker.java:662)
 at org.jboss.mx.server.registry.BasicMBeanRegistry.invokePreRegister(BasicMBeanRegistry.java:697)
 at org.jboss.mx.server.registry.BasicMBeanRegistry.registerMBean(BasicMBeanRegistry.java:211)
 at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
 at java.lang.reflect.Method.invoke(Unknown Source)
 at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
 at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
 at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
 at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)

[mwelch16]

I'll go post my hibernate error in the hibernate forum (just noticed it). Thanks for your help. Please let me know if there is a solution that will allow wsrp to run behind a proxy.

Thanks again,

Mark

[plegrain]

I am experiencing the same difficulties sitting behind a proxy with authentication:

org.jboss.deployment.DeploymentException: Could not create deployment: file:/C:/DEV/jboss-4.0.4.GA/server/myconfig/tmp/deploy/portal-wsrp.war; - nested throwable: (org.jboss.ws.metadata.wsdl.WSDLException: WSDLException (at /wsdl:definitions/import/wsdl:definitions/import/wsdl:definitions/wsdl:types/schema/schema): faultCode=OTHER_ERROR: An error occurred trying to resolve schema referenced at 'http://www.w3.org/2001/xml.xsd', relative to 'file:/C:/DEV/jboss-4.0.4.GA/server/myconfig/tmp/deploy/portal-wsrp-exp.war/WEB-INF/wsdl/wsrp_v1_types.xsd'.: Cannot access imported wsdl [http://www.w3.org/2001/xml.xsd], Server returned HTTP response code: 407 for URL: http://www.w3.org/2001/xml.xsd: java.lang.RuntimeException: Cannot access imported wsdl [http://www.w3.org/2001/xml.xsd], Server returned HTTP response code: 407 for URL: http://www.w3.org/2001/xml.xsd
 at org.jboss.ws.metadata.wsdl.WSDLDefinitionsFactory$WSDLLocatorImpl.getImportInputSource(WSDLDefinitionsFactory.java:310)
 at com.ibm.wsdl.xml.WSDLReaderImpl.parseSchema(WSDLReaderImpl.java:740)
 at com.ibm.wsdl.xml.WSDLReaderImpl.parseSchema(WSDLReaderImpl.java:830)
 at com.ibm.wsdl.xml.WSDLReaderImpl.parseSchema(WSDLReaderImpl.java:620)
 at com.ibm.wsdl.xml.WSDLReaderImpl.parseTypes(WSDLReaderImpl.java:583)

Since 407 is Proxy Authentication Required:
I've set correctly the proxy settings in the run.bat, but it doesn't seem to help:

16:32:18,156 DEBUG [ServerInfo] Full System Properties Dump
16:32:18,156 DEBUG [ServerInfo] java.vendor: Sun Microsystems Inc.
16:32:18,156 DEBUG [ServerInfo] http.proxyPassword: [...]

16:32:18,156 DEBUG [ServerInfo] http.proxyPort: 8080
16:32:18,156 DEBUG [ServerInfo] http.nonProxyHosts: localhost|10.*
16:32:18,156 DEBUG [ServerInfo] http.proxyUserName: [...]
16:32:18,156 DEBUG [ServerInfo] http.proxySet: true
16:32:18,156 DEBUG [ServerInfo] http.proxyHost: 10.255.170.65
...

Anyone has a solution for that? Many thanks

[claprun]

We have determined that there is a problem with resoution of XML entities and we are working to fix the issue.

[antoine_h]

Hi,

I am experiencing the same problem, about resolution of XML entities.
did you opened a JIRA ?
is there a work around ? or resolution in CVS ?

many thanks

[antoine_h]

found a solution in this post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&t=88830

as far as we don't need the WSRP feature.
or to go in updating the JBoss AS WS feature....

Thanks for the answers found.