[jboss-user] [JBoss Portal] - Re: Installed JbossAS+Portal 2.4.1 Bundle what to convert to
We are having same problem. This happens after about 10-15 minutes when a hit on portal would return this exception and a re-start would make it work. We are using Oracle. Any solution? java.sql.SQLException: Stream has already been closed | oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) | oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179) | oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269) | oracle.jdbc.dbaccess.DBDataSetImpl.getStreamItem(DBDataSetImpl.java:1596) | oracle.jdbc.driver.OracleStatement.getBytesInternal(OracleStatement.java:3456) | oracle.jdbc.driver.OracleStatement.getBytesValue(OracleStatement.java:4747) | oracle.jdbc.driver.OracleResultSetImpl.getBytes(OracleResultSetImpl.java:632) | oracle.jdbc.driver.OracleResultSet.getBytes(OracleResultSet.java:1650) | org.jboss.resource.adapter.jdbc.WrappedResultSet.getBytes(WrappedResultSet.java:464) | org.hibernate.type.AbstractBynaryType.get(AbstractBynaryType.java:78) | org.hibernate.type.NullableType.nullSafeGet(NullableType.java:163) | org.hibernate.type.NullableType.nullSafeGet(NullableType.java:154) | org.hibernate.type.AbstractType.hydrate(AbstractType.java:81) | org.hibernate.persister.entity.AbstractEntityPersister.hydrate(AbstractEntityPersister.java:2101) | org.hibernate.loader.Loader.loadFromResultSet(Loader.java:1380) | org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1308) | org.hibernate.loader.Loader.getRow(Loader.java:1206) | org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:580) | org.hibernate.loader.Loader.doQuery(Loader.java:701) | org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236) | org.hibernate.loader.Loader.loadEntity(Loader.java:1860) | org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:48) | org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:42) | org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3049) | org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:399) | org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:375) | org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:139) | org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:195) | org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:103) | org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:878) | org.hibernate.impl.SessionImpl.get(SessionImpl.java:815) | org.hibernate.impl.SessionImpl.get(SessionImpl.java:808) View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4205153#4205153 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4205153 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JBoss Portal] - Re: Installed JbossAS+Portal 2.4.1 Bundle what to convert to
sorry forgot to mention environment details JBoss Portal Version: jboss-portal-2.7.0.GA Did you get Portal from CVS? or download it?: Download JBoss AS Version: i downloaded bundled version of JBP Database Vendor and Version: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 JDBC Connector and Version: Oracle JDBC Driver version - 9.0.2.0.0 OS Platform: Mac OS X 10.5.6,i386 View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4205157#4205157 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4205157 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JBoss Portal] - Re: Installed JbossAS+Portal 2.4.1 Bundle what to convert to
Hi, I am getting an error similar to what is described in this thread. Queries that read binary data throw 'Stream already closed exception'. This happens after about 10-15 minutes when a hit on portal would return this exception and a re-start would make it work. What I noticed that hibernate identifies database dialect as OracleDialect and not Oracle9Dialect. Could it be the reason? Linux bplinux51 2.4.21-4.EL #1 Fri Oct 3 18:13:58 EDT 2003 i686 i686 i386 GNU/Linux jboss-4.2.0.GA Default configuration java version 1.5.0_12-b04 HotSpot(TM) Client VM Oracle 9i Enterprise ed (9.2.0.4) Apparently it hits jbp_instance.ser_state that is of type LONG (raw data in oracle) =Exception Stack Trace=== 20:01:23,456 INFO [Http11Protocol] Starting Coyote HTTP/1.1 on http-192.168.8.161-8080 20:01:23,585 INFO [AjpProtocol] Starting Coyote AJP/1.3 on ajp-192.168.8.161-8009 20:01:23,639 INFO [Server] JBoss (MX MicroKernel) [4.2.0.GA (build: SVNTag=JBoss_4_2_0_GA date=200705111440)] Started in 3m:19s:470ms 21:55:37,376 INFO [BinaryType] could not read column value from result set: SER5_59_1_; Stream has already been closed 21:55:37,390 WARN [JDBCExceptionReporter] SQL Error: 17027, SQLState: null 21:55:37,390 ERROR [JDBCExceptionReporter] Stream has already been closed 21:55:37,392 INFO [DefaultLoadEventListener] Error performing load command org.hibernate.exception.GenericJDBCException: could not load an entity: [org.jboss.portal.core.impl.model.instance.persistent.PersistentInstanceDefinition#9] at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103) at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.loader.Loader.loadEntity(Loader.java:1874) at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:48) at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:42) at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3042) at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:395) at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:375) at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:139) at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:195) at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:103) at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:878) at org.hibernate.impl.SessionImpl.get(SessionImpl.java:815) at org.hibernate.impl.SessionImpl.get(SessionImpl.java:808) at org.jboss.portal.core.impl.model.instance.persistent.PersistentInstanceContainerContext.getInstanceDefinition(PersistentInstanceContainerContext.java:174) at org.jboss.portal.core.impl.model.instance.InstanceContainerImpl.org$jboss$portal$core$impl$model$instance$InstanceContainerImpl$getDefinition$aop(InstanceContainerImpl.java:242) at org.jboss.portal.core.impl.model.instance.InstanceContainerImpl$getDefinition_7158034184799190936.invokeNext(InstanceContainerImpl$getDefinition_7158034184799190936.java) at org.jboss.aspects.tx.TxPolicy.invokeInCallerTx(TxPolicy.java:126) at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:195) at org.jboss.portal.core.impl.model.instance.InstanceContainerImpl$getDefinition_7158034184799190936.invokeNext(InstanceContainerImpl$getDefinition_7158034184799190936.java) at org.jboss.aspects.tx.TxPolicy.invokeInCallerTx(TxPolicy.java:126) at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:195) at org.jboss.portal.core.impl.model.instance.InstanceContainerImpl$getDefinition_7158034184799190936.invokeNext(InstanceContainerImpl$getDefinition_7158034184799190936.java) at org.jboss.portal.core.impl.model.instance.InstanceContainerImpl.getDefinition(InstanceContainerImpl.java) at org.jboss.portal.core.impl.model.CustomizationManagerService.getInstance(CustomizationManagerService.java:173) at org.jboss.portal.core.impl.model.content.portlet.InternalPortletContentProvider.getPortletInstance(InternalPortletContentProvider.java:193) at org.jboss.portal.core.impl.model.content.InternalContentProvider.renderWindow(InternalContentProvider.java:169) at org.jboss.portal.core.model.portal.command.render.RenderWindowCommand.execute(RenderWindowCommand.java:88) at org.jboss.portal.core.controller.ControllerCommand$1.invoke(ControllerCommand.java:68) at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:131)
[jboss-user] [JBoss Portal] - Re: Installed JbossAS+Portal 2.4.1 Bundle what to convert to
Just to try it out I went from the non-working Oracle back to Hypersonic. Portal Works without error. I then made it go to MySQL which I also have installed local to JBoss and it also works fine. Switch back to Oracle CMS error. View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4021087#4021087 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4021087 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JBoss Portal] - Re: Installed JbossAS+Portal 2.4.1 Bundle what to convert to
Did you start again with a clean jbossportal database on your Oracle server ? View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4021091#4021091 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4021091 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JBoss Portal] - Re: Installed JbossAS+Portal 2.4.1 Bundle what to convert to
I basically started with a fresh machine and redownloaded everything, JBoss AS, JBoss Portal, JDK, Oracle JDBC and that is what ended up making it work. The old server that I was trying to get working was a development machine and I think that probably someone made a modification for a project at one point and when I dropped in JBoss Portal in it didn't like whatever they did. Thanks a lot guys, on a clean system it is that easy to get working! ;-) John View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4021207#4021207 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4021207 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JBoss Portal] - Re: Installed JbossAS+Portal 2.4.1 Bundle what to convert to
Glad it worked. We run portal with different databases and we never had any problem like what you were seeing. View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4021210#4021210 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4021210 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JBoss Portal] - Re: Installed JbossAS+Portal 2.4.1 Bundle what to convert to
Deleted gthe entire Data directory and restarted. JBoss recreated the directory but while the error message looks different it's still the same I think. 2007-02-22 08:33:02,676 ERROR [org.jboss.deployment.scanner.URLDeploymentScanner] Incomplete Deployment listing: --- MBeans waiting for other MBeans --- ObjectName: portal:service=CMS State: FAILED Reason: javax.jcr.NamespaceException: failed to register namespace portalcms - http://jboss.org/jcr/portalcms: mapping already exists I Depend On: jboss.jca:service=DataSourceBinding,name=PortalDS portal:service=JAASLoginModule portal:service=Hibernate,type=CMS Depends On Me: portal:commandFactory=CMSObject cms.pm.cache:service=TreeCache --- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM --- ObjectName: portal:service=CMS State: FAILED Reason: javax.jcr.NamespaceException: failed to register namespace portalcms - http://jboss.org/jcr/portalcms: mapping already exists I Depend On: jboss.jca:service=DataSourceBinding,name=PortalDS portal:service=JAASLoginModule portal:service=Hibernate,type=CMS Depends On Me: portal:commandFactory=CMSObject cms.pm.cache:service=TreeCache View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4020537#4020537 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4020537 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JBoss Portal] - Re: Installed JbossAS+Portal 2.4.1 Bundle what to convert to
I know that this shouldn't matter at all because it should just be a JDBC connection but unlike in the documentation or the sample portal-oracle-ds.xml file my Oracle database is not local to the JBoss Portal server it is on it's own server. View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4020610#4020610 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4020610 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JBoss Portal] - Re: Installed JbossAS+Portal 2.4.1 Bundle what to convert to
As Thomas suggested, please make sure you have the latest jdbc driver etc. You would still need hypersonic dabase config (hsqldb-ds.xml) because some other components of JBoss such as JMS uses this to create its tables but please make sure that you don't have PortalDS configuration in this file. Now for portal, you do need oracle-ds.xml (name can be *-ds.xml) which has PortalDS configuration. I would suggest to give it another try and start from scractch. 1. Stop the running portal sever. 2. Unzip portal or clean data tmp work folders in server/default dir. 2. Clean up the database-probably nuke portal database in oracle 3. Start it again. View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4019974#4019974 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4019974 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JBoss Portal] - Re: Installed JbossAS+Portal 2.4.1 Bundle what to convert to
OK, I'll do that but before I do do I need to use the Oracle OCI connections because currently I'm using thin driver connections in my Orale-ds.xml file Thanks, John View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4020180#4020180 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4020180 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JBoss Portal] - Re: Installed JbossAS+Portal 2.4.1 Bundle what to convert to
nataleja- restart the portal again after deleting the data directory in your server configuration. Thanks View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4020259#4020259 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4020259 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JBoss Portal] - Re: Installed JbossAS+Portal 2.4.1 Bundle what to convert to
You do not need both oracle-ds.xml and portal-oracle-ds.xml, one or the other will suffice. I always also download the portal binary because in the 'setup' directory there are a series of *-ds.xml files ready for use with the portal, simply replace the user-name and password entries, and the database name in the connection-url. (I don't use Oracle, but I have used both MySQL and PostgreSQL with the Portal.) Oh, almost forgot, make sure you copy the JDBC driver jar file for your database to jboss_home/server/xxx/lib, where xxx is the configuration name. View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4019417#4019417 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4019417 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JBoss Portal] - Re: Installed JbossAS+Portal 2.4.1 Bundle what to convert to
I thought it would be that easy as well but when I go from Hypersonic to Oracle, I see it create the database objects and I see multiple sessions connected to the Oracle Database but I get a portlet CMS null pointer exception. If I go back to hypersonic everything is fine. There must be something for Oracle that isn't configured or installed right. View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4019496#4019496 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4019496 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JBoss Portal] - Re: Installed JbossAS+Portal 2.4.1 Bundle what to convert to
Can you please post the stacktrace from server.log? We have run portal testsuite with oracle and they went find with 2.4.1.Ga. View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4019498#4019498 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4019498 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JBoss Portal] - Re: Installed JbossAS+Portal 2.4.1 Bundle what to convert to
Make sure you have the very latest Oracle driver of the Oracle 10 branch. It's the less broken driver. View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4019499#4019499 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4019499 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JBoss Portal] - Re: Installed JbossAS+Portal 2.4.1 Bundle what to convert to
It looks like it's still trying to use Hypersonic DB for some things. View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4019545#4019545 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4019545 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user