This week's giveaway is in the JDBC forum.
We're giving away four copies of Java Database Connections & Transactions (e-book only) and have Marco Behler on-line!
See this thread for details.
Win a copy of Java Database Connections & Transactions (e-book only) this week in the JDBC forum!

Jehan Jaleel

Ranch Hand
+ Follow
since Jan 16, 2001
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Jehan Jaleel

To use the dynamic query service it seems we need to install the query.ear file into our WAS? Does anyone know where we can get this ear from?

Thanks,
Jehan
14 years ago
When the report is designed, how do we create column names that Excel will recognize?

For example when we try to Subtotal the Data the names we give the columns must show up in the window for sub-totals.

I currently place column names in the Title band and it is not being recognized by Excel.

thanks for any help.
Does anyone know which version of WAS and which version of WSAD support Last Particpant Support for transcations?

I am currently running WSAD 5.1 with WAS 5.1 and I can not see where in the IDE or the admin console to configure LPS.

Any help would be appreciated.
14 years ago
I think I may be able to do it with Last Participant Support. Does anyone know how to configure this in WSAD? A document I have says it is in the Extended Services tab of the Application Deployment descriptor tab but I did not see it.

Thanks for any help.
14 years ago
Joseph,
I am currently on WAS 5.1 and to the best of my knowledge there is no DataSource for text files now. The only way I can access it now is through straight JDBC connection, I would like to create a data source for it in WAS so I can have a connection pool and not have to create a connection each time I use it.
Jeanne,
That sounds like a good idea. I only wonder if EJBs support having a single static class that can be accessed by all beans?
I have a JDBC driver which I must use in a transcation but the driver currently does not support transcations. When I use it in WAS now it gives me the following error....

" An illegal attempt to enlist a one phase capable resource with existing two phase capable resources has occurred"

I was wondering if there is any way I could configure WAS to make this work.

Any help would be appreciated.
14 years ago
I created a "User defined data source" and I got the folowing error when I tried to do a JNDI lookup for it...

Caused by: com.ibm.ws.exception.WsException: DSRA8050W: Unable to find the DataStoreHelper class specified:

This is for a 3rd party JDBC provider which only has an implementation class. What can I tell WAS is the data source helper class if I do not have one?

Thanks in advance for any help.
14 years ago
The problem is even if I create an object that gives and takes back Connections, that object must still be accessed from my EJBs, so I need a way to persist it for the life of the application.

Thanks again for any help.
Are there any methods like getAttribute and setAttribute off the EJB Context object like there is for Servlet context?

Currently I did not see any in the API. How then are we supposed to store objects that we want to exist for the life of the app server and to be accesible by our beans?

Thanks for any suggestions.
Jeanne,
The data source I am using is tab-delimeted text file and my app server (WAS) does not allow me to create a data source for it?

Alternatively do you know of any good JDBC drivers that can read text files and work with WAS?

Thanks,
Jehan
" by opening a connection and then using it and returning it to the pool without closing it."

Anton,
How exactly would I return the Connection to the pool? What exactly is the pool? Is it an object by itself? Usually when I get a connection it is like this...

Class.forName("com.hxtt.sql.text.TextDriver");
Connection conn = DriverManager.getConnection("jdbc:Text...");Statement stmt = conn.createStatement();

Can you please shed some light on this?

Thanks,
Jehan
I have to run a macro on the XLS file that is generated from my Jasper report to calculate some subtotals from the data. Is there any ways this can be done?

Would it possible to start with a template and fill in the data?

Thanks for any help.
Once a Connection has been created to a JDBC data store, is there any
way to store this Connection object in memory so it does not have to
be created for each request.

I know this is what Data Sources a for, but suppose we could not
create a data source through the app server. Can it still be done
through code?

Thanks for any help,
Jehan
14 years ago
Once a Connection has been created to a JDBC data store, is there any
way to store this Connection object in memory so it does not have to
be created for each request.

I know this is what Data Sources a for, but suppose we could not
create a data source through the app server. Can it still be done
through code?

Thanks for any help,
Jehan