PostgreSQL Datasource

[rcracel]

I have read the excellent blog entry from Adrian Trenaman and tried to follow his steps to create my own datasource.

I created a new maven project using the 'osg.springframework.osgi' as I've done before for other projects, and modified both my bundle-context-osgi and bundle-context files... also added the dependency to my pom file (see below).

However, when I try to start my bundle I get the following error:

ERROR CommandLineExecutionFailed: org.apache.geronimo.gshell.command.CommandException: org.osgi.framework.BundleException: Unresolved constraint in bundle 95: package; (package=org.postgresql.ds)

I have done extensive search and couldn't find any more information on this, so I am here trying to see if anyone else can point me out to where I can find more information on correctly configuring my bundle/servicemix to install the postgresql driver.

Thank you in advance,

Roger

(sorry, haven't figure out yet how to mark code to be displayed properly...)

bundle-context.xml

          <property name="serverName" value="$" />

          <property name="databaseName" value="$" />

          <property name="portNumber" value="$" />

          <property name="user" value="$The specified item was not found." />

          <property name="password" value="$" />

          <property name="dataSourceName" value="$" />

          <property name="initialConnections" value="$" />

          <property name="maxConnections" value="$" />

     </bean>

</beans>

bundle-context-osgi.xml

pom.xml

...

...

[pchandler]

Roger,

There is two ways to resolve this "run-time" dependency. That I know of:

Option 1 (preferred):

a. Find a bundle that exports org.postgresql.*

b. Start it in the ServiceMix (OSGi container)

c. Add in a Import-Package: org.postgresql.* to your manifest.

d. Restart (uninstall and install -s) your bundle.

Option 2:

a. Add the PostgreSQL Driver into your bundle (jar).

b.Create Bundle-ClassPath: that references the jar. 

   http://www.aqute.biz/Snippets/BundleClassPath

Peter.

[rcracel]

Peter,

thank you for your quick response, just wanted to document my solution here. This is what did the trick for me:

osgi/install http://repository.springsource.com/ivy/bundles/external/org.postgresql/com.springsource.org.postgresql.jdbc4/8.3.604/com.springsource.org.postgresql.jdbc4-8.3.604.jar

The following is also a great resource for finding osgi bundles:

http://www.osgi.org/Repository/HomePage

thanks,

Roger