Tag Info

Hot answers tagged

14

This can happen for a variety of reasons. I just saw it myself a few weeks ago but I can't remember what the fix was for me. 1) Verify the address mysql is bound to, it's probably 127.0.0.1 (only) which I believe is the default (at least on standard Ubuntu server). You'll have to comment out the bind-address parameter in my.cnf to bind to all available ...


10

I have had the same problem in two of my programs. My error was this: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. I spend some days to solve this problem. I have tested many approaches ...


5

Yes you can run the smaller drivers on newer java versions. It is just that ojdbc14.jar does not contain JDBC3 and JDBC4 features. You have to differentiate between runtime and compile time. At runtime you can use ojdbc14.jar in a JRE6 as long as your app code is not using JDBC4 features. If you want to use ojdbc14.jar in the buildpath you might experience ...


5

Well first off, JDBC and ODBC are not compatible. JDBC was Java's answer to ODBC, and they fill the same niche, but you can't connect to an ODBC data source using JDBC and vice versa. Now there IS a jdbc-odbc bridge in Java, but that is a compatibility hack, not a native connector (The translation will go JDBC->ODBC->(Target Database) rather than ...


4

Sure! Ask /proc/sys/kernel/random/entropy_avail.


3

Use sqlplus. SQL*Plus FAQ, SQL*Plus Documentation


3

The only way to get more info from haproxy than what you have, would be to use the show sess or show sess <id> command periodically to watch the state of each tcp connection, though I'm not sure if you would get any more useful information. The cD termination state is the most helpful piece of info you have. What it means exactly is that an ...


2

I'm answering for my own question. The JDBC Connection Pool's address property was wrong. It was a DNS name about which only one of three nodes knows.


2

The next course of action is to check with your provider (in this case Amazon) to see if they know anything about the issue. It seems that they do: Network connectivity We are observing an issue outside of our network that is preventing a small number of Verizon FiOS customers from reaching the US-EAST-1 Region. Connectivity within the Region as ...


2

The most likely candidates are network latency and load. Is the database server being used by any other applications? What's the latency to the database server, and how much bandwidth is available? I'd start the investigation with some query profiling on the DB server. You could easily compare query times on the production DB to your local to determine ...


2

In Oracle, LOB (including BLOB) is stored as: in-the-table LOB - if the LOB is smaller than 3900 bytes it can be stored inside the table row; by default this is enabled, unless you specify DISABLE STORAGE IN ROW normal LOB - stored in a separate segment, outside of table, you may even put it in another tablespace; for these: a minimum of CHUNK bytes are ...


2

What are the negatives of setting a high wait_timeout setting in MySQL? Idle and persistent connections will obviously take longer to expire. This may mean that you bump up against some default and sane limits. The first one will be max_connections. Then following that - because of the way which MySQL assigns memory and file descriptors to connections ...


2

Briefly, selectMethod=cursor theoretically requires more server-side resources than selectMethod=direct only loads at most batch-size records into client memory at once, resulting in a more predictable client memory footprint selectMethod=direct theoretically requires less server-side resources than selectMethod=cursor will read the entire result set ...


2

Here is a good reference to various sql utilities. Of these I've only used sqlshell and it did what you e.g. sql from the command line. It's java based so you will need a java 6 jre to use it. The jar file version has a gui for installation so you might want the zip version. Henplus also looks like it would do what you want. I've not seen any of them in ...


2

I suspect that this article will help you out: Understanding SSL Support The protocol still uses TCP port 1433, by default, irrespective of SSL being used. The client can request SSL and, if the server has a certificate installed, the server and client will negotiate SSL. The server can be configured to force SSL, which will cause clients that do not ...


1

Also, where are the connection pool details stored? domains/domain1/config/domain.xml


1

You can get the details via asadmin: asadmin get domain.resources.jdbc-connection-pool.NAME_OF_THE_CONNECTION_POOL.* e.g. asadmin get domain.resources.jdbc-connection-pool.PostgresConnectionPool.*


1

The readme is a bit long but there is a section about this: https://github.com/jprante/elasticsearch-river-jdbc#how-to-select-incremental-data-from-a-table The idea is to keep a microsecond-level timestamp of the changes of each rows, and ask for ES to query since the last river run: { "type" : "jdbc", "jdbc" : { "url" : ...


1

No. As per documentation it will have a encrypted connnection. Check http://social.msdn.microsoft.com/Forums/sqlserver/en-US/bde679d9-ff83-4fa7-b402-42e336a97106/force-encryption-on-sql-server-not-working When the Force Encryption option for the Database Engine is set to YES, all communications between client and server is encrypted no matter ...


1

The "maximum capacity" setting is per server. So the maximum outbound connections is "maximum capacity" * the number of target servers for the data source. Answer provided by oracle forums.


1

As the exception shows the error is in the SQL syntax, probably in the JDBC Url, if you read the documentation you can see that when the port isn't specifed the colon sould also be ommited, try this: .getConnection("jdbc:mysql://localhost/schema?user=user_name&password=pass_word") Hope it works.


1

Check your context.xml file. Did you embed the <Context> within the existing <Context> of the default file? Worst case scenario it to take this: <ResourceLink type="javax.sql.DataSource" name="jdbc/LocalDB" global="jdbc/DB" /> ...and ensure it is within the already existing <Context> tag and get ...


1

Typically I create context.xml.default files or even appname.xml files in the /conf/Catalina/localhost directory for such purposes. It's the right way.


1

If you are running a Linux installation, you probably have lokkit blocking incoming communications except via SSH. Log in as root, and run the command lokkit from the prompt, disable firewall and SElinux and see if you have the same problem. Also check your permissions have been set correctly, so everything can write to the correct locations.


1

I just discovered yesterday that queries that take 25 seconds or longer time out with the mysql .NET connector. Maybe there's something similar in the JDBC driver, play with the socketTimeout property perhaps(even though the docs says the default is no timeout).


1

You can add a classpath parameter to the JVM args for the specific managed node. To configure this go to the Remote Start tab for that managed node and add the new JDBC jar then the CLASSPATH variable for your OS in the Classpath parameter. And restart the node. To be more specific I would need to know you OS.


1

MySQL Connector/J supports only TCP/IP Java does not support Unix domain sockets connectivity If the MYSQL is started with skip-networking flag or if the MySQL is running behind the firewall, then TCP/IP option is disabled. So that Java cannot communicate with MySQL.


1

And check whether the application is closing connections properly, this is the programmers stuff to do, but still a common error.


1

It seems like you can't connect to Oracle server. First try to telnet your Oracle server by using the Oracle's port. Ex: telnet <Oracle Serrver IP> 1521


1

This error may occure when you: Try to connect to the different host:port. Double-check your settings. Oracle server is down. You need to start it. Your firewall blocks your connection to oracle. You need to allow access for your application.



Only top voted, non community-wiki answers of a minimum length are eligible