Tag Info

New answers tagged

1

Not supported. If you want to send e-mails (JavaMail?) from the database, you do not need Java in the database for that, just use the UTL_MAIL package, available in XE as well.


1

No way how to do that. XE version does not support Java Stored Procedures. You have to upgrade at least to "Standard Edition One" or "Oracle Personal Edition". See edition comparsion.


0

Per screenshot is IIS 7.5 not Apache, check IIS if is running. Usually I will suggest to stop IIS and restart apache (check localhost prior connecting to phpmyadmin) ... hope helps..


0

the problem is that you need to put in a direct way the user, eliminate info DriverManager.getConnection("jdbc:orient:remote:localhost/GratefulDeadConcerts", "root", "password");


1

What is the exact type of the user_id column? It is very likely not a VARCHAR column therefore the rules of data type precedence dictate that the comparison must be done by casting the user_id to the type of the '10' literal, thus negating the possibility of an index seek and forcing a full scan. This is a very common mistake. I recommend reading How Data ...


0

Probably you have an ordinary "cold cache" case. When you INSERT 10,000 rows into a table, the rows need to be added to the appropriate place(s) in the "data". Also, 10,000 entries need to be added to each index's BTree. (How many indexes do you have? Please provide SHOW CREATE TABLE.) If you have AUTO_INCREMENT, then the rows will be "appended" to the ...


0

OP said: "However I was looking for a "just click and click" solution if you know what I mean. " You can also right click the table you are interested in via the schema inspector tab on the left, and select the option: "Select Rows - Limit 1,000" for a quick view, obviously limited to 1,000 results.



Top 50 recent answers are included