Kevin Wright

You can also use .netrc to store usernames and password. The rest appears easy to script using *nix tools.

Hi,
I have an Oracle 9i db with an assortment of tables, indices, and constraints that we want to export for use on another computer( minus data ).

What do you recommend for exporting said information in an easy-to-read format? The EXP utility supplied with oracle appears to require that each row and index be typed in individually and it doesn't present an easy-to-read output.

Is there a particular way to use EXP or a utility program out there that will do this for me? Bonus points if it can compare two and SQL Scripts and output the difference.

Thanks ahead of time,
Kevin Wright

Hi, I'm having some trouble setting up my JDBC Provider on WAS 6.0 to connect to an Oracle 9i DB. Here's what I've done, minus actual hostnames/usernames/passwords:

Scope: Server
- Created "Oracle JDBC Provider"
Classpath: ${ORACLE_JDBC_DRIVER_PATH}/ojdbc14.jar
Implementation Class: oracle.jdbc.pool.OracleCOnnectionPoolDataSource

- Saved that
- Created a new Data Source
JNDI Name: jdbc/data_source
Data Store: Oracle 9i and prior data store helper
- Set up J2C Authentication Alias with db username/password
URL:
jdbc racle ci8:@oracle_database (I've tried it with a number of variations)

- Tested that - get errors like:
Test connection failed for data source data_source_name on server server_name at node node_name with the following exception: javax.management.RuntimeMBeanException: null nested runtime exception is com.ibm.ws.exception.WsRuntimeException: java.lang.IllegalArgumentException: resolve against non-hierarchical or relative base.

I really don't get what the "non-hierarchical or relative base" stuff means.

Any help would be greatly appreciated.

Thanks,
Kevin
[ December 08, 2005: Message edited by: Kevin Wright ]

Does anybody have any advice on how to run SQL against .csv files using Java? It seems to me i just need a driver similar to the Microsoft Text Driver but i'd like some reccomendations.
Thanks,
Kevin

Hi,
I'm looking for a resource in dealing with CSV files and java, with the ultimate purpose of placing all the values into a database. I would like something like Database TextDriver for Visual Basic.
Thanks,
Kevin Wright

I have a web page that is dynamically generated...for each project (generally from 1-8) there is a graph, which i have as an applet right now. The Bean generates the in parameter and it shows the value in my (very simple) applet. (it's really just a verticle JProgressBar). So, When i load it all up and view it, the applets don't come in right...they have blank lines, you can't scroll with them on the page (etc., etc.). I don't normally use applets much, but i felt they were warrented in this situation. Please Help me to improve the performance of these applets.
Thank you,
Kevin Wright

I believe you do have to pay to use MySql for a commercial use. However, it's pretty cheap.
Kevin

Personally, hate Access with JDBC...But another alternative is Xindice, located at the apache.org website. It's Free, and XML-based.
Kevin
[ September 18, 2002: Message edited by: Kevin Wright ]

Thanks, i think i have a solution.
Kevin

Thanks, that worked for me...yeah, i really don't care how i deal with the proxies as long as i can get messages out.
Kevin

Hi,
I'm trying to send SOAP messages from inside my company's intranet, but I can't seem to by-pass the proxy servers and get to anything outside of my company's network. Any suggestions?
Thanks,
Kevin Wright

Any ideas on how i can bypass the proxy servers at my company? I can't recognize something as simple as "http://www.cnn.com", or anything like that (i.e., of that commonality).
Thank you.

Thanks, but does anybody reccommend an already-created service. My ideal solution takes in a city and state or a city and country and goes from there...I found something at capescience.com, but am still up to suggestions.
Thanks again,
Kevin

I'm looking for a service that will accept a value that is a string, like "city,state", or "city,country", and return current weather for that place. Can anybody help? Thanks
Kevin Wright

I'm doing an app with a GUI, and I want a spash screen to show up for a few seconds when the user starts the program - any help on how to do it?
Thanks,
Kevin Wright