google that…

More often i heard someone saying “google that” (or in german “google das mal…”). Not that problem with current smart phones or iphone and a mobile flatrate. Short look with opera mini or opera mobile and the discussion can go on. In the IT world is it more important to know where the details are written then to know everything in mind. Everyday start more people surfing the net. You don’t need a drivers license to start using. Normally i would say it’s not necessary, but today i get an reason to have such a entry access check.

Hoax are really old and comes mostly in conjunction with chain mails. On the first look it sounds like good behaviour to forward such help requests. Looking deeper shows trojaner, virus, and other crap contained in that email or in links inside. Not really difficult to determine if a email is a hoax. Just take the subject of the email and google that… Mostly you get in the first ten hits pages about current hoax floating around. The evil does not sleep so these hoax mails become more professional. You get emails about a cancer case with a complete patient address. These address may exists because the writers took the original hoax, translate them in good native language and insert real people. Not a problem to get such data. Not only head hunter use the net to retrieve private information about real people.

Hoax are spam, not more or less.

To have a PC, a DSL connection and a browser does not mean that you are fully prepared for surfing the net. It’s like having a drill machine and you want to make a hole for a screw. You can have luck and hit no cable or pipe. But it can happen to hit. As mention in the adverts “ask someone who knows it” or google that…

jdbc DataBaseMetaData + oracle 10g + dbunit + username..

If you are using DBUnit as tool for set up test environment in your oracle 10g then you have to provide the username of course. Normally it isn’t case sensitive in most tools. The jdbc driver or sqlplus let you create connection with lower case. DBUnit ask the DataBaseMetaData to get the defined tables in the schema. Schema and username are the same in the oracle world. So in DBUnit the source is

DatabaseMetaData databaseMetaData = jdbcConnection.getMetaData();
ResultSet resultSet = databaseMetaData.getTables(null, schema, "%", tableType);

where tableType is the String[] {“table”}. with schema == username lower case i get in my oracle 10.2 db nothing back. With upper case username et voila! Don’t know if this is really an standard behaviour….

JDBC Connection + Oracle 10g + recycle bin…

Since Oracle 10g dropped tables goes into a recycle bin: http://orafaq.com/node/968. These tables aren’t visible inside the admin site under the user but if you are using JDBC to access the schema. Thought first of a bug in SQL Explorer when i saw the huge list of tables starting with BIN$… Every time you drop tables more BIN$ you get… If someone needs such a future… I’m more a friend of the “know what i’m doing’ approach. The good thing is that this is a feature which you can disable:

  1. sqlplus sys/<your password> as sysdba
  2. SQL> purge dba_recyclebin;
  3. SQL> alter system set recyclebin = OFF scope=both;