I have a case where a connection is opened, (from a connection pool) then a "long computation" occurs for about 4 hours, during which the connection is not used. The server is a virtual machine running under qemu-kvm on a centos 6.2 host. I have a new tomcat application server running on tomcat 6, java 6 (openjdk), centos 6.2. | Version | Description | Installed on | State | : the flyway script for linux has a bug in the following lines JAVA_ARGS="=file:/dev/./dev/urandom $JAVA_ARGS" you need to append $JAVA_ARGS to not be overwrittenĮdit a file in your project folder named as you wish for example nf Put flyway folder (where you find flyway cli script) in path (es: on linux export PATH=/home/matteo/opt/flywayĮdit the flyway binary /home/matteo/opt/flyway/flyway putting in JAVA_ARGS="_admin= pointing to the folders containing the tnsnames.ora Put the file in the drivers dir into the flyway folder I can successfully connect to oracle via tnsnames.ora in the following wayĭownload latests ojdbcX.jar from oracle site ORA-01033: ORACLE initialization or shutdown in progressĭoes the Oracle thin client require the first database to be working on connect and only failover if something goes wrong during the connection? What I want is for the application to try the next server if the connection to the first server fails (which I could do usingĪpplication logic but would prefer the driver to take care of the details for me). In my list then I get a connection (just like I'd expect if I just tried to connect toįirst I get the same error as if I tried to connect directly to
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |