DBRE - Null pointer

[plankscale]

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)

[Alan Stewart]

This should be fixed now (ROO-1557)

[plankscale]

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)

[Alan Stewart]

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

[plankscale]

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).

[newguy]

How can I put the SID of Oracle in the database.url via Roo command?

[Alan Stewart]

I use, for example,

persistence setup --provider HIBERNATE --database ORACLE --userName rootest --password rootest --databaseName XE

resulting in

database.url=jdbc\:oracle\:thin\:@localhost\:1521\:XE

[muraliweb]

I have

1. Used osgi install/start to install the Oracle Osgi driver and dependencies
2. Copied the jar files to <ROO_INSTALL>/bundle

But I am still getting the JDBC driver not available for 'oracle.jdbc.driver.OracleDriver' error.

osgi ps gives:

[ 67] [Active ] [ 1] Spring Roo - Wrapping - postgresql-jdbc3 (8.4.701.0001)
[ 68] [Active ] [ 1] Spring Roo - Shell (Eclipse Implementation) (1.1.0.RC1)
[ 96] [Active ] [ 1] Oracle JDBC Driver (10.2.0.2)
[ 97] [Active ] [ 1] Java Resource API (1.5.0)
[ 108] [Active ] [ 1] Java Transaction API (1.1.0)

domain roo> database introspect --schema dbo
No remote OBR repositories have matching add-ons matching your request
JDBC driver not available for 'oracle.jdbc.driver.OracleDriver'
com.db.gm.marketrisk roo> version
____ ____ ____
/ __ \/ __ \/ __ \
/ /_/ / / / / / / /
/ _, _/ /_/ / /_/ /
/_/ |_|\____/\____/ 1.1.0.RELEASE [rev 793f2b0]

[Alan Stewart]

Can you please try with the 1.1.1 code from Git?

[karthik7777]

I am also facing same issue. I tried to get build latest code from GIT, but then faced too many issues there too. i had Maven 3.0 but there is some issue with Maven 3.x version, I rolled back to Maven 2.x. I'm seeing below errors:
[ERROR] Error building bundle org.springframework.roo:org.springframework.roo.su pport:bundle:1.1.1.RELEASE : Error in process
ing included file: C:\AppsDev\roo-git\support\target/build-number.mf
[ERROR] Error(s) found in bundle configuration
[INFO] ------------------------------------------------------------------

I am doing a prototype, can someone please help? If someone has successfully built the latest jar, please post the link, or please email to guru4consulting(at)gmail.