DBRE - Null pointer

[mduduzik]

Yes. .jtds to .jtds.jdbc

[Alan Stewart]

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

[mduduzik]

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

[plankscale]

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

[Alan Stewart]

Yes mduduzik - nice work.

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

[markdsmith]

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?

[mduduzik]

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.

[markdsmith]

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.

[Alan Stewart]

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 !

[xgrigoriadis]

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