Announcement Announcement Module
Collapse
No announcement yet.
DBRE - Null pointer Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • #31
    Yes. .jtds to .jtds.jdbc

    Comment


    • #32
      Thanks. It appears to work with Sybase. I checked the change in Git ID f8877afdc79aa7ae9665a0171d635ec48d73509d. Would you all please test this with MS SQL?

      Comment


      • #33
        Thanks Alan. I have tested with MSSQL Server 2008.
        -Mdu

        Comment


        • #34
          dbre introspect (MSSQL) successful

          Nice sleuthing, mduduzik. Alan, I've verified your fix here too. Thank you both.


          com.blah roo> database introspect --schema dbo
          <?xml version="1.0" encoding="UTF-8" standalone="no"?>
          <database name="Test" schema="dbo">
          <table name="A_TEST_TABLE">
          ...

          Comment


          • #35
            Yes mduduzik - nice work.

            I'll mark the bug as resolved as it also works with Sybase.

            Comment


            • #36
              not working on db2

              I'm getting
              roo> database introspect --schema vap
              No Spring Roo add-ons were found that offer a similar JDBC driver
              JDBC driver not available for 'com.ibm.db2.jcc.DB2Driver'
              roo>

              I looked at my pom and it has this entry
              <build>
              <plugins>
              <plugin>
              <groupId>org.apache.felix</groupId>
              <artifactId>maven-bundle-plugin</artifactId>
              <configuration>
              <instructions>
              <Import-Package>*,net.sourceforge.jtds;resolution:=optiona l,com.mysql.jdbc;resolution:=optional,org.apache.d erby.jdbc;resolution:=optional,oracle.jdbc;resolut ion:=optional,org.h2;resolution:=optional,org.hsql db;resolution:=optional,org.postgresql;resolution: =optional</Import-Package>
              </instructions>
              </configuration>
              </plugin>
              </plugins>
              </build>

              will the new pom fix my problem with db2 also?

              Comment


              • #37
                Resolution of the issue in this thread addresses using JTDS driver (supports MSSQL and Sybase). I'm sure if DB2 is readily supported by Roo - i.e. if there's an addon for DB2 jdbc driver.

                If not, you'd have to 1) obtain DB2 driver (see http://numberformat.wordpress.com/20...-jdbc-drivers/ for a guide on this) and 2) Get it wrapped for OSGI container.

                Comment


                • #38
                  db2 support

                  I have a roo application currently running against my legacy database. For what I wanted it's work as is so far. But now I need to begin adding my databases tables to my app that have multiple column primary keys. I was hoping to generate those entities. So I have it working and talking to db2 for almost two months now. I have the db2 jdbc jars.

                  Wrapping them in OSGI, that I don't know how to do. Is there documentation on this some where.

                  Comment


                  • #39
                    I believe there are at least two DB2 jars to wrap - db2jcc.jar and db2jcc_license_cu.jar. An example can be found in the Roo wrapping directory if you get the code from Git. We also can't host the wrapped jars in any of SpringSource's public Maven repos, as DB2 is a licensed product. Of course you won't find any of the DB2 jars in any public Maven repo either.

                    DB2 was always going to be the most difficult to support due to their licensing restrictions and the number of jars required. I will try to get the community edition and see about wrapping the jars and if successful, will post the procedure here or in a blog. Also, if you have a support contract with IBM perhaps you can get them to provide OSGi-enabled jars - IBM are one of the OSGi member companies afterall !

                    Comment


                    • #40
                      I am working daily with Oracle "full version" databases. Believe me, you are allowed to download and use any Oracle product for evaluation and development purposes. Please read the "OTN Developer Licence Terms".
                      Last edited by xgrigoriadis; Oct 10th, 2010, 04:01 AM.

                      Comment


                      • #41
                        JTDS issue back in 1.1.RC?

                        Hello all,

                        I had recently eval'd M3 and was able to overcome the "driver unavailable" issue for wrapped JTDS driver by building out of git (9/05 - "dbre introspect (MSSQL) successful"). However, it (or a similar issue) seems to have reappeared in 1.1.0.RC1 that I downloaded today . Any one else notice this? Are there any steps I need to carry out (same machine, same maven, etc.).


                        Thank you.

                        roo> database introspect --schema dbo
                        No remote OBR repositories have matching add-ons matching your request
                        JDBC driver not available for 'net.sourceforge.jtds.jdbc.Driver'

                        roo> osgi ps
                        ...
                        [ 13] [Active ] [ 1] Spring Roo - Addon - Database Reverse Engineering (1.1.0.RC1)
                        [ 20] [Active ] [ 1] Spring Roo - Addon - JDBC Driver Acquisition (1.1.0.RC1)
                        [ 69] [Active ] [ 1] Spring Roo - Wrapping - jtds (1.2.4.0001)

                        Comment


                        • #42
                          This should be fixed now (ROO-1557)

                          Comment


                          • #43
                            Thanks Alan...just getting back to it. Didn't want to open a new post but I seem to have a similar issue now on roo-1.1.0.RELEASE (STS 2.5.0.RELEASE); the wrapped jtds jar doesn't seem to be available after setting up MSSQL hibernate provider (see below).


                            ____ ____ ____
                            / __ \/ __ \/ __ \
                            / /_/ / / / / / / /
                            / _, _/ /_/ / /_/ /
                            /_/ |_|\____/\____/ 1.1.0.RELEASE [rev 793f2b0]
                            ….
                            roo> persistence setup --provider HIBERNATE --database MSSQL
                            ...
                            Managed ROOT/pom.xml [Added dependency net.sourceforge.jtds:jtds:1.2.4]

                            roo> database introspect --schema dbo
                            No remote OBR repositories have matching add-ons matching your request
                            JDBC driver not available for 'net.sourceforge.jtds.jdbc.Driver'

                            roo> osgi ps
                            START LEVEL 99
                            ID State Level Name
                            [ 0] [Active ] [ 0] System Bundle (2.0.4)
                            [ 1] [Active ] [ 1] jansi (1.4)
                            [ 2] [Active ] [ 1] file:/Users/xxx/springsource2.5.0.RELEASE/roo-1.1.0.RELEASE/bundle/jsr250-api-1.0.jar
                            [ 3] [Active ] [ 1] Apache Felix Bundle Repository (1.4.3)
                            [ 4] [Active ] [ 1] Apache Felix iPOJO (1.4.0)
                            [ 5] [Active ] [ 1] Apache Felix Log Service (1.0.0)
                            [ 6] [Active ] [ 1] Apache Felix Declarative Services (1.4.0)
                            [ 7] [Active ] [ 1] Apache Felix Shell Service (1.4.2)
                            [ 8] [Active ] [ 1] Spring Roo - Addon - Backup (1.1.0.RELEASE)
                            [ 9] [Active ] [ 1] Spring Roo - Addon - JavaBean Information (1.1.0.RELEASE)
                            [ 10] [Active ] [ 1] Spring Roo - Addon - @Configurable Support (1.1.0.RELEASE)
                            [ 11] [Active ] [ 1] Spring Roo - Addon - Creator (1.1.0.RELEASE)
                            [ 12] [Active ] [ 1] Spring Roo - Addon - Database Reverse Engineering (1.1.0.RELEASE)
                            [ 13] [Active ] [ 1] Spring Roo - Addon - Test Data On Demand (1.1.0.RELEASE)
                            [ 14] [Active ] [ 1] Spring Roo - Addon - Email (1.1.0.RELEASE)
                            [ 15] [Active ] [ 1] Spring Roo - Addon - Entity (1.1.0.RELEASE)
                            [ 16] [Active ] [ 1] Spring Roo - Addon - Finder (1.1.0.RELEASE)
                            [ 17] [Active ] [ 1] Spring Roo - Addon - Google Web Toolkit (1.1.0.RELEASE)
                            [ 18] [Active ] [ 1] Spring Roo - Addon - JavaBean Method Manager (1.1.0.RELEASE)
                            [ 19] [Active ] [ 1] Spring Roo - Addon - JDBC Driver Acquisition (1.1.0.RELEASE)
                            [ 20] [Active ] [ 1] Spring Roo - Addon - JMS (1.1.0.RELEASE)
                            [ 21] [Active ] [ 1] Spring Roo - Addon - JPA (1.1.0.RELEASE)
                            [ 22] [Active ] [ 1] Spring Roo - Addon - JSON (1.1.0.RELEASE)
                            [ 23] [Active ] [ 1] Spring Roo - Addon - Logging (1.1.0.RELEASE)
                            [ 24] [Active ] [ 1] Spring Roo - Addon - Maven (1.1.0.RELEASE)
                            [ 25] [Active ] [ 1] Spring Roo - Addon - Plural Details (1.1.0.RELEASE)
                            [ 26] [Active ] [ 1] Spring Roo - Addon - Property Editor (1.1.0.RELEASE)
                            [ 27] [Active ] [ 1] Spring Roo - Addon - Property Files (1.1.0.RELEASE)
                            [ 28] [Active ] [ 1] Spring Roo - Addon - RooBot Client (1.1.0.RELEASE)
                            [ 29] [Active ] [ 1] Spring Roo - Addon - Spring Security (1.1.0.RELEASE)
                            [ 30] [Active ] [ 1] Spring Roo - Addon - Serializable (1.1.0.RELEASE)
                            [ 31] [Active ] [ 1] Spring Roo - Addon - Solr (1.1.0.RELEASE)
                            [ 32] [Active ] [ 1] Spring Roo - Addon - Automated Integration Testing (1.1.0.RELEASE)
                            [ 33] [Active ] [ 1] Spring Roo - Addon - toString (1.1.0.RELEASE)
                            [ 34] [Active ] [ 1] Spring Roo - Addon - Web - Flow (1.1.0.RELEASE)
                            [ 35] [Active ] [ 1] Spring Roo - Addon - Web MVC Controller (1.1.0.RELEASE)
                            [ 36] [Active ] [ 1] Spring Roo - Addon - Web MVC Embedded Extensions (1.1.0.RELEASE)
                            [ 37] [Active ] [ 1] Spring Roo - Addon - Web MVC JSP View (1.1.0.RELEASE)
                            [ 38] [Active ] [ 1] Spring Roo - Addon - Web Selenium Test Generator (1.1.0.RELEASE)
                            [ 39] [Active ] [ 1] Spring Roo - Classpath (1.1.0.RELEASE)
                            [ 40] [Active ] [ 1] Spring Roo - Classpath (JavaParser Implementation) (1.1.0.RELEASE)
                            [ 41] [Active ] [ 1] Spring Roo - Felix Interoperability (1.1.0.RELEASE)
                            [ 42] [Active ] [ 1] Spring Roo - File Monitor (1.1.0.RELEASE)
                            [ 43] [Active ] [ 1] Spring Roo - File Monitor - Polling (1.1.0.RELEASE)
                            [ 44] [Active ] [ 1] Spring Roo - File Monitor - Polling (Roo Launcher) (1.1.0.RELEASE)
                            [ 45] [Active ] [ 1] Spring Roo - File Undo (1.1.0.RELEASE)
                            [ 46] [Active ] [ 1] Spring Roo - Metadata (1.1.0.RELEASE)
                            [ 47] [Active ] [ 1] Spring Roo - Model (1.1.0.RELEASE)
                            [ 48] [Active ] [ 1] Spring Roo - OBR Services (1.1.0.RELEASE)
                            [ 49] [Active ] [ 1] Spring Roo - Process Manager (1.1.0.RELEASE)
                            [ 50] [Active ] [ 1] Spring Roo - Project (1.1.0.RELEASE)
                            [ 51] [Active ] [ 1] Spring Roo - Shell (1.1.0.RELEASE)
                            [ 52] [Active ] [ 1] Spring Roo - Shell - JSON Support (1.1.0.RELEASE)
                            [ 53] [Active ] [ 1] Spring Roo - Shell (OSGi Launcher) (1.1.0.RELEASE)
                            [ 54] [Active ] [ 1] Spring Roo - OSGi Start Level Control (1.1.0.RELEASE)
                            [ 55] [Active ] [ 1] Spring Roo - Support (1.1.0.RELEASE)
                            [ 56] [Active ] [ 1] Spring Roo - Support for OSGi Features (1.1.0.RELEASE)
                            [ 57] [Active ] [ 1] Spring Roo - URL Stream API Contract (1.1.0.RELEASE)
                            [ 58] [Active ] [ 1] Spring Roo - URL Stream - JDK (1.1.0.RELEASE)
                            [ 59] [Active ] [ 1] Spring Roo - Wrapping - bcpg-jdk15 (1.45.0.0001)
                            [ 60] [Active ] [ 1] Spring Roo - Wrapping - bcprov-jdk15 (1.45.0.0001)
                            [ 61] [Active ] [ 1] Spring Roo - Wrapping - hapax (2.3.4.0002)
                            [ 62] [Active ] [ 1] Spring Roo - Wrapping - inflector (0.7.0.0001)
                            [ 63] [Active ] [ 1] Spring Roo - Wrapping - javaparser (1.0.7.0001)
                            [ 64] [Active ] [ 1] Spring Roo - Wrapping - jline (0.9.94.0001)
                            [ 65] [Active ] [ 1] Spring Roo - Wrapping - json-simple (1.1.0.0001)
                            [ 66] [Active ] [ 1] Spring Roo - Wrapping - mysql-connector-java (5.1.13.0001)
                            [ 67] [Active ] [ 1] Spring Roo - Wrapping - postgresql-jdbc3 (8.4.701.0001)
                            [ 68] [Active ] [ 1] Spring Roo - Shell (Eclipse Implementation) (1.1.0.RELEASE)

                            Comment


                            • #44
                              Did you run the script --file install-jdbc-drivers.roo command first?

                              Comment


                              • #45
                                No, I hadn't...I knew I had already gotten behind! The drivers were indeed installed after running the script (and a restart the shell).

                                Comment

                                Working...
                                X