Todd F. Smithe

Greenhorn
+ Follow
since Jul 08, 2003
Merit badge: grant badges
For More
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 Todd F. Smithe

Anyone have a recommendation for a good java rule engine?
I only know of JESS http://herzberg.ca.sandia.gov/jess/
I'd like to split out a lot of picky rules involving water quality data from my general program logic and allow the end user to modify them.
Thanks!
20 years ago
Anyone have a recommendation for a good java rule engine?
I only know of JESS http://herzberg.ca.sandia.gov/jess/
I'd like to split out a lot of picky rules involving water quality data from my general program logic and allow the end user to modify them.
Thanks!
20 years ago
I've carved out a hopfully secure little niche with a small ( less than 75 people) company as the "IT Department". Doing Network Admin/Systems Admin (Linux,Solaris,Windows)/Programming (Java,C++)/DBA (MySQL, Oracle)
It wasn't an advertised position. I was working with them on a programming project and pitched the idea of molding all of these tasks that were currently being contracted out into one MeCentric position. They're happy. I'm happy. Pays 80K in the SF Bay Area. Which is pretty OK in this post boom economy. I think one of the safer places these days is in smaller companies. The more diverse and solid your skill set is the better you'll do.
20 years ago
I�ve been in the IT field for about 23 years. I started in �Operations� mounting tapes and disks (ye olde CDC drives) and toggling octals on PDP-11�s. Then I moved into programming C, C++, Fortran and Macro-32 on vaxen. After that I had a boatload of Oracle training and spent a few years as an Oracle DBA. Insert dark and evil time as an IT Manager here - best forgotten. Retooled myself and worked on numerous Java programming projects. During the tail end of the dot.bomb boom I was a Senior Systems Administrator managing ~50 Sun and Linux servers for ridiculous $$$,$$$�s. After that went splat hitting the pavement in a messy way I secured my current position with a smallish engineering firm as a Programmer (Mostly Java)/Systems Administrator (Sun/Linux/Windows)/DBA (mostly Oracle but moving it to MYSQL). I guess my long rambling point is that IT is a huge tent within which you can have an almost endless variety of, I guess you�d call them, sub-careers. I�m still learning new stuff. Still having a whole lot of fun. And it *still* beats digging up old sewer lines (did that one summer in high school � it�s my bench mark for crappy jobs).
20 years ago
arg - hit post before I had finished.
Perhaps there could be a "schema=" property in the properties file and a notation in the sample.properties that Oracle users may want to set this to the DBMS user they're trying to generate for. If it doesn't exist then set it to null as before.
It seems that with Oracle that SCHEMA is analogous to the DBMS user.
So changing line 341 in Jenny.java.
From:
ResultSet results = metaData.getTables( null , null , "%" , new String[]{"TABLE"} );
To:
ResultSet results = metaData.getTables( null , userName , "%" , new String[]{"TABLE"} );
limited Jenny to the tables for the specified userName instead of trying to parse through all tables for all users.
I was wondering if there was a way to limit the tables that Jenny tries to generate classes for. When I run it against an Oracle user it seems to be trying to generate java classes for *all* tables for a user including system tables. Quite a few of the tables have characters that Jenny doesn't like. For instance:
***
XDB$ACL
attribute data 'XDB$ACL' contains characters that Jenny doesn't like
attribute data 'SYS_NC_ROWINFO$' contains characters that Jenny doesn't like
XDB$ALL_MODEL
attribute data 'XDB$ALL_MODEL' contains characters that Jenny doesn't like
***
and before it gets to the tables that I actually want to generate classes for it dies with the following exception:
Exception in thread "main" java.sql.SQLException: ORA-01000: maximum open cursors exceeded
Is there someway to have it pattern match table names? For instance tbl_* or something.
Thanks
Todd