0 Replies Latest reply on Sep 14, 2007 1:46 PM by Jon Whitmore

    Can't build hypersonic DB after upgrading.

    Jon Whitmore Newbie

      Hello

      I have successfully upgraded our application from AS 4.0.5 with portal 2.4 to AS 4.2.0 with portal 2.6. I run on XP and use the hypersonic database without modifications.

      Trouble is my coworker's machine isn't able to properly create the hypersonic database and deploy JBoss Portal, let alone deploy our application. If I give her a copy of my working server she can run without error. As soon as she changes our *-object.xml file and deletes the /default/data directory she runs into problems.

      The server.log has few errors, but there is a stacktrace early on that I have never seen:

      ...
      Caused by: java.lang.UnsatisfiedLinkError: no tcnative-1 in java.library.path, no libtcnative-1 in java.library.path(C:\Program Files\Java\jdk1.5.0_08\bin;.;C:\WINDOWS\system32;C:\WINDOWS;C:\Program Files\Common Files\Affymetrix\AffyShared;C:\PROGRAM FILES\AFFYMETRIX\GENECHIP;C:\ORACLE\ORA81\BIN;C:\PROGRAM FILES\ORACLE\JRE\1.1.7\BIN;C:\WINDOWS\SYSTEM32;C:\WINDOWS;C:\WINDOWS\SYSTEM32\WBEM;C:\PROGRAM FILES\PUTTY;C:\PROGRAM FILES\SUBVERSION\BIN;C:\PROGRAM FILES\MICROSOFT SQL SERVER\80\TOOLS\BINN\;C:\apache-ant-1.6.5-bin\apache-ant-1.6.5\bin;C:\Program Files\QuickTime\QTSystem\;C:\Sun\jwsdp-2.0\jwsdp-shared\bin)
       at org.apache.tomcat.jni.Library.<init>(Library.java:56)
       at org.apache.tomcat.jni.Library.initialize(Library.java:157)
       ... 116 more


      Further down we have plenty of these:
      2007-09-14 12:37:40,000 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] schema export unsuccessful
      java.sql.SQLException: You cannot commit during a managed transaction!
       at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.jdbcCommit(BaseWrapperManagedConnection.java:543)
       at org.jboss.resource.adapter.jdbc.WrappedConnection.commit(WrappedConnection.java:334)
       at org.hibernate.tool.hbm2ddl.ManagedProviderConnectionHelper.prepare(ManagedProviderConnectionHelper.java:30)
       at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:180)
       at org.hibernate.tool.hbm2ddl.SchemaExport.create(SchemaExport.java:133)
      ...

      and these
      java.sql.SQLException: Table not found in statement [select top ? portalobje0_.PK as PK64_, portalobje0_.LISTENER as LISTENER64_, portalobje0_4_.INSTANCE_REF as INSTANCE2_71_, case when portalobje0_1_.PK is not null then 1 when portalobje0_2_.PK is not null then 2 when portalobje0_3_.PK is not null then 3 when portalobje0_4_.PK is not null then 4 when portalobje0_.PK is not null then 0 end as clazz_ from JBP_PORTAL_OBJECT portalobje0_ left outer join JBP_CONTEXT portalobje0_1_ on portalobje0_.PK=portalobje0_1_.PK left outer join JBP_PORTAL portalobje0_2_ on portalobje0_.PK=portalobje0_2_.PK left outer join JBP_PAGE portalobje0_3_ on portalobje0_.PK=portalobje0_3_.PK left outer join JBP_WINDOW portalobje0_4_ on portalobje0_.PK=portalobje0_4_.PK]
       at org.hsqldb.jdbc.Util.throwError(Unknown Source)
       at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
       at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
       at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.doPrepareStatement(BaseWrapperManagedConnection.java:349)
       at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.prepareStatement(BaseWrapperManagedConnection.java:344)
       at org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:187)
       at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:505)


      Does anyone have any hints for me? At this point I'm assuming it's a library/path/classpath issue but that's just a best guess. Nothing is jumping out at me.

      Nollie