• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

EJB and Excel Urgent

 
Ranch Hand
Posts: 62
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi,
We are developing a system in which we have to insert the data in a excel sheet(server side) then that sheet should be downloadble at client side.
we have created the connection pool for the excel sheet.The properties file setting in weblogic(5.1) are as follows.
weblogic.jdbc.connectionPool.ExcelPool=\
url=jdbc dbc:JavaExcel,\
driver=sun.jdbc.odbc.JdbcOdbcDriver,\
loginDelaySecs=1,\
initialCapacity=10,\
maxCapacity=50,\
capacityIncrement=10,\
allowShrinking=true,\
shrinkPeriodMins=15,\
refreshMinutes=10,\
#testTable=dual,\
props=user=;password=;server=DEMO
# Add a TXDataSource for the connection pool:
weblogic.jdbc.TXDataSource.weblogic.jdbc.jts.ExcelPool=ExcelPool
#
# Add an ACL for the connection pool:
weblogic.allow.reserve.weblogic.jdbc.connectionPool.ExcelPool=everyone
JavaExcel is the system DSN.
When we start the weblogic it creates 10 pools.
When we run the servlet it retrieves the data from the Oracle 8i database and adds the data to the excel sheet attached to the DSN only if the sheet is open.If the sheet is closed then the data is not inserted in the sheet.Message at the weblogic server is that the connection pool is not available (connection not available).If the sheet is open then it can insert as many records as requests from client.But if the sheet is closed then the connection is lost. Please help me out of this query.Is there any other way to create Excel downloadable file from the data available in the database(Oracle 8i)?.If I create a file DSN will it be helpful?.
Thanx
Mahesh
 
Consider Paul's rocket mass heater.
reply
    Bookmark Topic Watch Topic
  • New Topic