Sharing DB connection between Page Bean and GUI

I've successfully tied a component on the screen to a database data provider. To do this I had to create a PostgresQL data source. Now I would like to use this same data source in my page bean code to perform a complicated query. How can I access that data source from the page bean?

[299 byte] By [tgeliot] at [2007-11-26 7:23:06]

«« Problems with sun update connection server ?
»» Installing N1 System Manager on Tadpole Laptop fails

# 1

I'm not 100% sure what you mean.

Do you just want to run some plain old JDBC - and not use a dataprovider with cachedRowSet?

If so, see:

http://blogs.sun.com/roller/page/jfbrown?entry=using_jdbc_in_creator

It's example code shows how to get a db connection from the data source.

-Tub

TubahBrown at 2007-7-6 19:07:53 >