user « oracle « Java Database Q&A

1. how to access multiple users' database via JDBC stackoverflow.com

I have an account in oracle database. I can connect it via jdbc in my java code. When I access database from Oracle SQL Developer, under "Connections"->"Other Users", I can access to ...

2. How do I unlock an Oracle user's account from Java? stackoverflow.com

I'm trying to figure out why my application is unable to unlock a user's Oracle account successfully. Here's a snippet from my code:

OracleDataSource ods = new oracle.jdbc.pool.OracleDataSource();

Properties props = new Properties();
props.put("user", ...

3. Switching users on a JDBC Connection stackoverflow.com

I am writing a Java JDBC database application that connects to an Oracle 11g database and am using a c3p0 connection pool. For the purposes of an example, I have 3 ...

4. Oracle - Hudson Jobs : Schema vs User stackoverflow.com

we have different hudson jobs that interact with the database. Because they all write to the database and delete data, we could not run 2 jobs at the same time, fearing ...

5. Weblogic 11g Create new User exception stackoverflow.com

I'm trying to create new user in WebLogic 11g security realm.

InitialContext ctx = new InitialContext(env);
wls = (MBeanServer) ctx.lookup("java:comp/env/jmx/runtime");
//userEditor is SqlAuthenticator provider.
wls.invoke(userEditor, "addMemberToGroup", new Object[] { groupName, username}, new String[] {"java.lang.String", "java.lang.String"});

while ...

6. Email Alerting System based on User preferences stackoverflow.com

Any ideas around designing and/or implementing Java based Email alerting system (similar to RSS) which would let users pick the frequency, application type, email content and based on their preferences the ...

7. When will Java 7 be pushed out to users as an update? stackoverflow.com

Has Oracle announced a schedule for when Java 7 will be pushed out via Java Update to end-users? 75% of our applet's users are generally at the auto-update level, so that ...

8. How do I get all indices on a Table in Oracle via JDBC, even if they are owned by different users? stackoverflow.com

Yes, I know about DatabaseMetadata.getIndexInfo, but it doesn't seem to do what I want. I've got two users/schemas, let's call them A and B. There's a table in A called TAB. ...

9. How to Recompile Invalid Java Class Objects in SYS user in an Oracle 10g DB? stackoverflow.com

I need to upgrade an ORACLE 10g db to 11g, but have tons invalid JAVA CLASS object type objects in an user schema, and 30 invalid JAVA CLASS object type objects ...

10. What presentation for a local Oracle User Group? stackoverflow.com

I can do a presentation on a java related technology on the local Oracle User Group (OUG). The last several times I talked about Java 7 (two or three times) and DVCS. ...

11. How to display user's profile photo in custom Oracle WebCenter template? stackoverflow.com

I'm working on a custom template for Oracle WebCenter, created from the scratch in JDeveloper. I woudl like to display a logged-in user avatar (or profile photo) in the upper right ...

12. how to create users and roles in oracle? coderanch.com

13. how to get user creatd tables only from databasemetadata in oracle coderanch.com

14. How Would You Setup Oracle User Accounts coderanch.com

My application consists of struts+servlet in web tier. The biz logic is in POJOs inside web container (no ejb). Database is accessed by JDBC (no OR mapping). Database is Oracle9i. Some persistence logic is written in PLSQL stored proc+trigger. Could anyone share the way they create user account(s) in Oracle to store the tables, packages, procedures, functions and triggers. Since user ...

15. Create more than one user id to the same DB schema in Oracle 10g coderanch.com

I know it is a DBA question: I have a DB schema, called abc, in Oracle 10g. When a user login as abc, he/she can update/delete/query the data. I'm asked to create another user id (e.g., xyz) who can do the same thing on the same schema. Could anyone show me how to do it? I know I need login as ...

16. user authentication in Oracle DB through java coderanch.com

17. Creating user in Oracle through JDBC coderanch.com

Hello Friends, I m trying to create a user in oracle through jdbc. When I m creating user through SQL plus I m able to do it successfully but when I m doing it through java code there is some problem. I can see that users entry in dba_users & dba_role_privs tables.But when I am trying to drop that user I ...

18. Oracle acts out. Can't drop a user. coderanch.com

Hi, Here is what I am trying to do. I just want to drop the damn schema. C:\>sqlplus /nolog SQL*Plus: Release 11.1.0.6.0 - Production on Mon Nov 17 16:19:34 2008 Copyright (c) 1982, 2007, Oracle. All rights reserved. SQL> conn / as sysdba Connected. SQL> drop user ABC cascade; drop user ABC cascade * ERROR at line 1: ORA-01940: cannot drop ...

19. What is in DBVisualizer for us Oracle users what other tools don't deliver? coderanch.com

Rainer, It is quite difficult to specifically say why someone should pick one tool over another. It is much a matter of personal taste and corporate decisions. The simple ad message is that DbVisualizer is great for developers and DBAs whereas the user need to access databases from several vendors. DbVisualizer may be used with all of them. Combine this with ...

20. Calling Oracle User Define funcation from java coderanch.com

21. oracle enterprise user coderanch.com

22. Oracle User Session ID through JDBC API? coderanch.com

I would like to get an Oracle session ID in my Java app. When I say Oracle session ID, I mean the users session ID on the Oracle DB, not the DB SID. For example, I know I can get the users ID by executing "SELECT sys_context('USERENV','SID') from dual;" but rather than executing this query I was wondering if there is ...

23. How to display queries results from Oracle according to user input? java-forums.org

Java Code: import java.sql.*; import java.util.logging.Level; import java.util.logging.Logger; import javax.swing.*; import java.awt.*; import java.awt.event.*; import javax.swing.border.*; import javax.swing.JTextArea; public class execute_sql extends JApplet{ private JTextArea sql_query = new JTextArea ("Type in your query statements here.",15, 20); private JButton enter = new JButton("Submit Query"); private JTextArea output = new JTextArea ( 5, 20); private String results =""; private Statement stmt; public void ...

24. how to create web application and user oracle 11g db java-forums.org

hi. i am newbie in java. i install netbeans 7 and want to use oracle 11g db with it. i can create connection in drivers database but when i want to create web application or java ee application, i dont know to select witch server in the 'choose server' section. please guide me

25. Creating user in oracle through JDBC forums.oracle.com

/** * * @param s Username * @param s1 Indentified by * @param s2 tablespace * @param s3 * @return * @throws SQLException * @throws ClassNotFoundException */ public String createUserOracle(String s, String s1, String s2, String s3) throws SQLException, ClassNotFoundException { System.out.println("Creating user method "); String s4 = ""; if (!s2.equals("")) { if (!s3.equals("")) { s4 = new String("CREATE USER \"" ...