This forum is now a read-only archive. All commenting, posting, registration services have been turned off. Those needing community support and/or wanting to ask questions should refer to the Tag/Forum map, and to http://spring.io/questions for a curated list of stackoverflow tags that Pivotal engineers, and the community, monitor.
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'
I looked at my pom and it has this entry
<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>
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.
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 !
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".
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.).
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'
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).