On Windows

Help
Ted
2008-01-24
2013-04-30
  • Ted

    Ted - 2008-01-24

    All:
    Thank you so much for providing the source!!!!!
    I'd like to get discussion started for getting all this running on Windows.
    Perhaps we can build a webpage or other file that could be another Install file.

    I got part of the way today, but hit some issues.

    The line about loading the sql scripts is Unix based (cat ...), so I did this manually.

    Next, I don't know how to run a Unix shell script (runjava) in dos, so I created a batch file full of hard coding.

    When I got it to run, the language loader failed, see stack below.  It might be an issue with my classpath/properties in my new batch file.  Any ideas?

    ....
    16:42:18,552  WARN JDBCExceptionReporter:71 - SQL Error: 1146, SQLState: 42S02
    16:42:18,552 ERROR JDBCExceptionReporter:72 - Table 'sor.hib_languages' doesn't exist
    16:42:18,562  INFO DefaultLoadEventListener:109 - Error performing load command
    org.hibernate.exception.SQLGrammarException: could not load an entity: [perseus.util.Language#1]
            at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
            at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
            at org.hibernate.loader.Loader.loadEntity(Loader.java:1798)
            at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:48)
            at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:42)
            at org.hibernate.loader.entity.BatchingEntityLoader.load(BatchingEntityLoader.java:82)
            at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:
    2977)
            at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListe
    ner.java:393)
            at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:374
    )
            at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:137)
            at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.jav
    a:193)
            at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:101
    )
            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 perseus.util.HibernateLanguageDAO.getById(HibernateLanguageDAO.java:25)
            at perseus.util.LanguageLoader.load(LanguageLoader.java:39)
            at perseus.util.LanguageLoader.main(LanguageLoader.java:82)
    Caused by: java.sql.SQLException: Table 'sor.hib_languages' doesn't exist
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2921)
            at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1570)
            at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
            at com.mysql.jdbc.Connection.execSQL(Connection.java:2978)
            at com.mysql.jdbc.Connection.execSQL(Connection.java:2902)
            at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:930)
            at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1024)
            at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
            at org.hibernate.loader.Loader.getResultSet(Loader.java:1668)
            at org.hibernate.loader.Loader.doQuery(Loader.java:662)
            at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
            at org.hibernate.loader.Loader.loadEntity(Loader.java:1784)
            ... 15 more
    Exception in thread "main" org.hibernate.exception.SQLGrammarException: could not load an entity: [p
    erseus.util.Language#1]
            at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
            at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
            at org.hibernate.loader.Loader.loadEntity(Loader.java:1798)
            at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:48)
            at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:42)
            at org.hibernate.loader.entity.BatchingEntityLoader.load(BatchingEntityLoader.java:82)
            at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:
    2977)
            at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListe
    ner.java:393)
            at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:374
    )
            at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:137)
            at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.jav
    a:193)
            at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:101
    )
            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 perseus.util.HibernateLanguageDAO.getById(HibernateLanguageDAO.java:25)
            at perseus.util.LanguageLoader.load(LanguageLoader.java:39)
            at perseus.util.LanguageLoader.main(LanguageLoader.java:82)
    Caused by: java.sql.SQLException: Table 'sor.hib_languages' doesn't exist
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2921)
            at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1570)
            at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
            at com.mysql.jdbc.Connection.execSQL(Connection.java:2978)
            at com.mysql.jdbc.Connection.execSQL(Connection.java:2902)
            at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:930)
            at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1024)
            at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
            at org.hibernate.loader.Loader.getResultSet(Loader.java:1668)
            at org.hibernate.loader.Loader.doQuery(Loader.java:662)
            at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
            at org.hibernate.loader.Loader.loadEntity(Loader.java:1784)
            ... 15 more
    16:42:18,552  WARN JDBCExceptionReporter:71 - SQL Error: 1146, SQLState: 42S02
    16:42:18,552 ERROR JDBCExceptionReporter:72 - Table 'sor.hib_languages' doesn't exist
    16:42:18,562  INFO DefaultLoadEventListener:109 - Error performing load command
    org.hibernate.exception.SQLGrammarException: could not load an entity: [perseus.util.Language#1]
            at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
            at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
            at org.hibernate.loader.Loader.loadEntity(Loader.java:1798)
            at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:48)
            at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:42)
            at org.hibernate.loader.entity.BatchingEntityLoader.load(BatchingEntityLoader.java:82)
            at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:
    2977)
            at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListe
    ner.java:393)
            at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:374
    )
            at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:137)
            at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.jav
    a:193)
            at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:101
    )
            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 perseus.util.HibernateLanguageDAO.getById(HibernateLanguageDAO.java:25)
            at perseus.util.LanguageLoader.load(LanguageLoader.java:39)
            at perseus.util.LanguageLoader.main(LanguageLoader.java:82)
    Caused by: java.sql.SQLException: Table 'sor.hib_languages' doesn't exist
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2921)
            at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1570)
            at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
            at com.mysql.jdbc.Connection.execSQL(Connection.java:2978)
            at com.mysql.jdbc.Connection.execSQL(Connection.java:2902)
            at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:930)
            at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1024)
            at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
            at org.hibernate.loader.Loader.getResultSet(Loader.java:1668)
            at org.hibernate.loader.Loader.doQuery(Loader.java:662)
            at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
            at org.hibernate.loader.Loader.loadEntity(Loader.java:1784)
            ... 15 more
    Exception in thread "main" org.hibernate.exception.SQLGrammarException: could not load an entity: [p
    erseus.util.Language#1]
            at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
            at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
            at org.hibernate.loader.Loader.loadEntity(Loader.java:1798)
            at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:48)
            at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:42)
            at org.hibernate.loader.entity.BatchingEntityLoader.load(BatchingEntityLoader.java:82)
            at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:
    2977)
            at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListe
    ner.java:393)
            at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:374
    )
            at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:137)
            at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.jav
    a:193)
            at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:101
    )
            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 perseus.util.HibernateLanguageDAO.getById(HibernateLanguageDAO.java:25)
            at perseus.util.LanguageLoader.load(LanguageLoader.java:39)
            at perseus.util.LanguageLoader.main(LanguageLoader.java:82)
    Caused by: java.sql.SQLException: Table 'sor.hib_languages' doesn't exist
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2921)
            at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1570)
            at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
            at com.mysql.jdbc.Connection.execSQL(Connection.java:2978)
            at com.mysql.jdbc.Connection.execSQL(Connection.java:2902)
            at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:930)
            at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1024)
            at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
            at org.hibernate.loader.Loader.getResultSet(Loader.java:1668)
            at org.hibernate.loader.Loader.doQuery(Loader.java:662)
            at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
            at org.hibernate.loader.Loader.loadEntity(Loader.java:1784)
            ... 15 more

     
    • Rashmi S

      Rashmi S - 2008-01-25

      Yes, there are a number of issues with installing the hopper on Windows.  We are in the process testing this in order to do it successfully.  I have been testing this out using Eclipse and the Windows command line prompt.  Still trying to figure out how to successfully use runjava in Eclipse (it is possible though our script may need to be tweaked).

      The error you are getting makes me think you didn't do ant schema-export and then add the tables in the resulting hibernate.sql.

      FYI, to add tables from .sql files in the windows command line, you should type:
      type hibernate.sql | mysql -uusername -p databasename
      or
      type sql\*.sql | mysql -uusername -p databasename

       
    • Ted

      Ted - 2008-01-31

      Correct, I missed the ant hibernate setup step.

      On a separate note, I had to edit the file: sgml\reading\buildFiles\common.xml
      to override the tomcat.home property to do the builds, since the path to the tomcat directory on my windows box was different than the default linux path.

      What are you using to run the shell script in eclipse?

      I am at the point where I'm hitting class path issues during runjava that are likely caused by my hacked win batch file:

      Exception in thread "main" java.lang.IllegalArgumentException: java.io.FileNotFoundException: build/
      document/catalog.xsl
              at perseus.document.StyleTransformer.getTranslet(StyleTransformer.java:102)
              at perseus.document.StyleTransformer.doTransform(StyleTransformer.java:339)
              at perseus.document.StyleTransformer.transform(StyleTransformer.java:266)
              at perseus.document.MetadataLoader.loadUncachedCatalog(MetadataLoader.java:203)
              at perseus.document.MetadataLoader.loadCatalog(MetadataLoader.java:186)
              at perseus.document.MetadataLoader.load(MetadataLoader.java:81)
              at perseus.document.MetadataLoader.main(MetadataLoader.java:488)

       
    • Rashmi S

      Rashmi S - 2008-02-01

      Running the shell script was proving to be more complicated than necessary.  We are in the process of writing ant tasks for the various steps, rather than using the script.  These tasks can be run in the Windows command line or through Eclipse, Cygwin, etc.  We hope to release a new version in the next month, so if you are unable to get it to work on your machine, there will be a solution soon!

       

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks