Search results for query: *

When inserting large amounts of unicode text into a clob through a prepared statement, I'm getting an SQLException from the driver about the character converter's arry being too small. Is this a known bug or does anybody have a workaround/solution to this problem? Right now, I can't insert large...

Is there any way I can retrieve this information from the connection meta data object? Kris Simonis Topdesk Information Systems, Application Server Development "You haven't seen the last of Meeaaaarrrrghh!!!" - Several bad guys in several bad movies

Ok, Oracle has tablespaces to put tables in, is there any way I can ask a connection to an Oracle database for any information on them? Like which tablespaces exist for instance, through metadata? Kris Simonis Topdesk Information Systems, Application Server Development "You haven't seen...

Ok, here is the situation: I'm using an oracle 9.0.something database and connecting to it using the jdbc drivers. This works fine however, when I try to execute a create tablespace statement through the connection object, I'm getting an error that the MAXSIZE is incorrect or missing. However...

...names but the chance is very slim) The algorith I used is based on position and ascii code. ( ie. ABC would translate into 65x1 + 66x2 + 67 * 3 = 398 ) Kris Simonis Topdesk Information Systems, Application Server Development "You haven't seen the last of Meeaaaarrrrghh!!!" -...

Well, like you said yourself, the keyword there is dodgy. Also, changing such code that it complies with the new standard wouldn't be that much work. (though I do admit that if it's somewhere DEEP it might take a while if the structure of your code is rather 'obfuscated'). Though 30 chars is a...

I don't really see how backward compatibility would generate a problem with extending those object name sizes. ( unless ofcourse you want the new database version to be still useable by an older version ofcourse ) Kris Simonis Topdesk Information Systems, Application Server Development...

The swing components like panel etc. have several methods to get any childobjects. If that doesn't help, declare some private global variables at the beginning of your class and point them to the various objects in your code so you can reference them directly. Not very pretty but it works...

Sorry to correct you Hava, but you can pass null as a string. Kris Simonis Topdesk Information Systems, Application Server Development "You haven't seen the last of Meeaaaarrrrghh!!!" - Several bad guys in several bad movies

Since you didn't give the full code, I can't say for certain, but did you make sure that your class imports the ButtonData class properly? Kris Simonis Topdesk Information Systems, Application Server Development "You haven't seen the last of Meeaaaarrrrghh!!!" - Several bad guys in...

The error probably isn't in the sp, it's in your web assistant or whatever program fires the statement that executes your sp. Try looking there. [hammer] Kris Simonis Topdesk Information Systems, Application Server Development "You haven't seen the last of Meeaaaarrrrghh!!!" -...

somewhere else you probably imported a different object that is also called Statement ( something I've got here aswell ) so java doesn't know which type you want. ie: import java.sql.Statement; import mycode.something.Statement; public void aMethod() { Statement stat = new Statement(); }...

Heya, Does anyone know if there is a way to get past the 30 character limit for objects in Oracle? Or if this limit will be lengthened in the future? I'm having a serious problem generating unique names for foreign keys based on table names and field names in my database( mostly due to the size...

I take it the date that is handed to your procedure is a string? In that case, you just use the convert function to convert it to a date and enter the proper format in the convert. Kris Simonis Topdesk Information Systems

Thanks, but the problem wasn't with the java. Our "friendly" system administrators had forgotten to give me write access to those folders I wanted to access. (Which just shows how big a hole there is in our mail server/outlook) Kris Simonis Topdesk Information Systems

Another possibility is to add one table UNIQUE constraint on those 2 fields, if you don't want the primairy key to be those 2 fields. [bigglasses] Kris Simonis Topdesk Information Systems

At the moment I've got a service running that connects to an IMAP server, opens a designated folder and reads the mail, processes unread mail and marks them as read. The problem I'm having is that this works fine when opening the INBOX, however, when I try to open a different IMAP folder on the...

That would be rather difficult, though TOP is a very usefull statement to use in queries, several large database packages implement diffferent variations on it. ( for instance, under Oracle you can achieve the same effect using ROWNUM ) If you want to use a query like this on a different...

I know it should be somewhere in the manual, however, I can't seem to find it anywhere. Can anyone point me to the table that says which Oracle datatype in the database corresponds to what java type a resultset? I need to do a comparison of the database meta data column info to what I've got in...

I've got the following PL/SQL code: DECLARE counter NUMBER(4); BEGIN SELECT count(*) INTO counter from all_constraints where constraint_name = 'FK_persoon_afdelingid'; IF counter > 0 THEN ALTER TABLE PERSOON DROP CONSTRAINT FK_persoon_afdelingid; END IF; END; Basicly, seek and destroy a...