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
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3954351#3954351
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3954351
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
_______________________________________________
JBoss-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/jboss-user
