3 Replies Latest reply on Oct 14, 2005 11:15 AM by Alejandro Guizar

    Striggling to generate DB2 SQL Scrips

    Silas Mhalngu Newbie

      Hi all I'm new with DB2 and hibernate. My hirbenate.properties is as follows:

      hibernate.dialect=org.hibernate.dialect.DB2Dialect
      hibernate.connection.driver_class=com.ibm.db2.jcc.DB2Driver
      hibernate.connection.url=jdbc:db2://localhost:50000/jbmptest

      hibernate.connection.username=
      hibernate.connection.password=

      hibernate.show_sql=true
      hibernate.c3p0.min_size=1
      hibernate.c3p0.max_size=3


      I have copied the relevant jar files to jbmp-db/db2/lib

      I also created an emptyDB in DB2.

      when I run ant -p I still cannot generate SQL scripts for DB2

      I don't know what I'm doing wrong.

      thanks

        • 1. Re: Striggling to generate DB2 SQL Scrips
          Alejandro Guizar Master

          Neither do us :-) Please post your error output.

          • 2. Re: Striggling to generate DB2 SQL Scrips
            Silas Mhalngu Newbie


            C:\>cd C:\JBOSSJBMP\jbpm-db

            C:\JBOSSJBMP\jbpm-db>ant db2.scripts
            Buildfile: build.xml

            db2.scripts:

            prepare:

            compile.jbpm:

            compile.jbpm.test:

            compile.identity:

            compile.webapp:

            compile.identity.test:

            compile.examples:

            compile:

            db.scripts:
            [delete] Deleting directory C:\JBOSSJBMP\jbpm-db\build\db2\scripts
            [mkdir] Created dir: C:\JBOSSJBMP\jbpm-db\build\db2\scripts
            [java] java.lang.UnsupportedClassVersionError: org/jbpm/db/JbpmSchema (Unsu
            pported major.minor version 49.0)
            [java] at java.lang.ClassLoader.defineClass0(Native Method)
            [java] at java.lang.ClassLoader.defineClass(ClassLoader.java:539)
            [java] at java.security.SecureClassLoader.defineClass(SecureClassLoader
            .java:123)
            [java] at java.net.URLClassLoader.defineClass(URLClassLoader.java:251)
            [java] at java.net.URLClassLoader.access$100(URLClassLoader.java:55)
            [java] at java.net.URLClassLoader$1.run(URLClassLoader.java:194)
            [java] at java.security.AccessController.doPrivileged(Native Method)
            [java] at java.net.URLClassLoader.findClass(URLClassLoader.java:187)
            [java] at java.lang.ClassLoader.loadClass(ClassLoader.java:289)
            [java] at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:274)

            [java] at java.lang.ClassLoader.loadClass(ClassLoader.java:235)
            [java] at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302)

            [java] Exception in thread "main"
            [java] Java Result: 1

            BUILD SUCCESSFUL
            Total time: 7 seconds
            C:\JBOSSJBMP\jbpm-db>

            • 3. Re: Striggling to generate DB2 SQL Scrips
              Alejandro Guizar Master

              The 3.0.1 releases were compiled with JDK 1.5, a problem that has been widely discussed in this forum. You may either upgrade or apply the solution proposed in topic connecting with oracle db.