Base API which enables interacting with SQL database servers by executing SQL statements using the Java programming language

learn more… | top users | synonyms

0
votes
2answers
434 views

JDBC CLASSPATH Not Working

I'm setting up a simple JDBC connection to my working MySQL database on my server. I'm using the Connector-J provided by MySQL. According to their documentation, I'm suppose to create the CLASSPATH ...
0
votes
2answers
1k views

How to make a JDBC connect to Crystal Reports with Postgres

I want to create a new report using Crystal Reports. I downloaded the Postgres driver but when I want to create the connection, it shows an error "JDBC Driver not found" How can I solve it? Thanks ...
2
votes
1answer
3k views

ORA-12705: invalid or unknown NLS parameter value specified

I have a J2EE application hosted on JBoss on Linux. When I try to access the application, I see following error in the server.log file. ORA-12705: invalid or unknown NLS parameter value specified ...
1
vote
1answer
1k views

MS SQL Server configured for secure (SSL) connection allows non-secure connection from JDBC Client

I need to connect to the MS SQL Server 2008 r2 using the secure communication. I have been able to do the same using the following connection string: jdbc:sqlserver://<<db server ...
0
votes
1answer
128 views

Elasticsearch River JDBC - Avoiding 'SELECT *'

I'd like to syncronize some MySQL tables to an ElasticSearch index, you know, for search. But almost every examples I can find show a big bad fat "SELECT * FROM", it's OK for an example, but I'm in ...
0
votes
1answer
133 views

Install Apache Derby on CentOS 6.4

I'm not a Java developer, my knowledge is very limited to this topic. I want to deploy a .war webservice on my Tomcat server, which fails most likely because of its Derby dependency (just a guess from ...
0
votes
1answer
283 views

Solr: Using multiple SQL server data sources results in error: “…\sqljdbc_auth.dll already loaded in another classloader”

I have one Solr instance running in Jetty with JRE 8 with 3 collections (same as cores, yes?) and more to come. I am indexing data from SQL Server, connecting using NTLM as the identity of the Java ...
0
votes
1answer
187 views

Tomcat - JDBC Data Access Exception

My company has a web application that allows users as part of their business process to upload large documents (10+ MBs) into the application. For fast connections it works great with the document ...
0
votes
1answer
435 views

Is weblogic 10.3.6 data source connection pool maximum capacity per domain or server?

My WLS server is connecting to an Oracle DB that has a maximum concurrent connection limit of 3. I have created a data source in WebLogic and set the "Maximum Capacity" value to 3. Is this value ...
0
votes
1answer
110 views

mysql, java, and MySQLTimeoutException

I've moved the mysql server on different machine in LAN, 16 core, 8GB RAM, and the same dreaaded result. During a load test, all is going well until around 300 seconds. There are 15 persistent ...
0
votes
1answer
593 views

Tomcat - how to store sessions in DB immediately?

I'm experimenting with tomcat JDBCStore-based session persistence and wonder whether there is a way to make tomcat store sessions in DB as soon as possible? I've tried to play with minIdleSwap and ...
0
votes
1answer
672 views

FileMaker Server not listening on Port 2399 for ODBC/JDBC

I am trying to create a ODBC connection from an OSX machine to a Filemaker server 10 using a DataDirect SeQuel Link 5.5 JDBC drive. I have ODBC/JDBC enabled on the server and I followed all of the ...
0
votes
1answer
174 views

Solr could not index my table from mysql

I have ubuntu server and mysql version 5.1.41-3ubuntu12.10-log. i need to run solr on my webserver. i have installed lucidworks-enterprise-installer-1.7 and mysql-connector-java-5.1.17-bin.jar on the ...
0
votes
1answer
600 views

PostgreSQL + JDBC: parse too slow on first query

I use Aqua Data Studio in OS X to make queries in a PostgreSQL server, but the first query of the day runs too slow. It not depends on the SQL, a simple SELECT current_timestamp will parse and ...
2
votes
0answers
613 views

mysql client can't read query result?

So I have this machine running an XMPP server which connects to its MySQL database. When I start load-testing it, all goes fine up until after about 500s when I notice: Caused by: ...
1
vote
0answers
1k views

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure between Java app & database VMs

Am getting increasingly frequent JDBC Communications link failure errors between a Glassfish 3 + Java 7 server VM and a MySQL 5.6 Both VMs are hosted on the same ESXi 5.5 enterprise host (as part of a ...
1
vote
0answers
569 views

Intermittent java.sql.SQLException: ORA-03120: two-taskconversion routine: integer overflow exception

I get the following error intermittently when my spring app starts up. I am using oracle with dbcp pooling as my datasource bean in spring. Caused by: org.apache.commons.dbcp.SQLNestedException: ...
0
votes
0answers
92 views

Websphere 8.5 not instantiating jdbc connection in jndi

I am trying to create a basic connection to a remote oracle machine. I have the datasource configured in websphere console and when I test the connection, it comes back as tested good. But when I ...
0
votes
0answers
14 views

WLS: Identifying the managed server where a DB session originates from

We are using WLS servers, on which we configure data sources (DS) and managed servers. For failover reasons, our main application is depolyed on two separate managed servers (lets call them app_1 and ...
0
votes
0answers
351 views

java.lang.ClassNotFoundException: org.postgres.Driver when starting PuppetDB

When I start puppetdb I am getting the following error: cat /var/log/puppetdb/puppetdb.log 2014-08-06 11:29:50,558 ERROR [main] [utils.logging] Uncaught exception java.lang.ClassNotFoundException: ...