Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. KrisSimonis

    JDBC Driver converting unicode to utf8 in clobs

    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...
  2. KrisSimonis

    JDBC Driver, catalogs and tablspaces.. I'm confused

    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
  3. KrisSimonis

    JDBC Driver, catalogs and tablspaces.. I'm confused

    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...
  4. KrisSimonis

    Problem with SQL statement and Java.

    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...
  5. KrisSimonis

    Object Name size question

    I did something like that, I build a numeric translator that turned the name into a digital code which should produce unique numbers based on that name.(technicly I believe it's still possible to generate non-unique names but the chance is very slim) The algorith I used is based on position and...
  6. KrisSimonis

    Object Name size question

    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...
  7. KrisSimonis

    Object Name size question

    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...
  8. KrisSimonis

    Accessing Objects

    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...
  9. KrisSimonis

    Hi There, I've got some problems

    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
  10. KrisSimonis

    Hi There, I've got some problems

    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...
  11. KrisSimonis

    Associated statement is not prepared ???

    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!!!" -...
  12. KrisSimonis

    Ambiguous Statement?

    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(); }...
  13. KrisSimonis

    Object Name size question

    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...
  14. KrisSimonis

    Update dates in table

    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
  15. KrisSimonis

    Problem opening IMAP folders with Javamail

    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
  16. KrisSimonis

    Unique combination for column values

    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
  17. KrisSimonis

    Problem opening IMAP folders with Javamail

    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...
  18. KrisSimonis

    To find n th Maximum

    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...
  19. KrisSimonis

    Oracle Datatypes vs. Java datatypes in resultset

    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...
  20. KrisSimonis

    Problem when altering tables in PL/SQL

    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...

Part and Inventory Search

Back
Top