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
403 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
615 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
38 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
104 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
122 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
217 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
85 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
507 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
605 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
161 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
529 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
485 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
622 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
509 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
27 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: ...
0
votes
0answers
13 views

configure hibernate.cfg.xml for MySQL on Ubuntu 12.04

I tried to rebuild project settings from SQL Server to Apache 2 with MySQL. I newly at JDBC and can't figure out all aspects. I installed according this tutorial MySQL/JDBC Driver Setting Up ...
0
votes
0answers
150 views

Remove default and timerpool jdbc-resources from glassfish

Glassfish 3 internally uses derby database for JavaEE EJB timerservice via the jdbc/__TimerPool resource using the same named connection pool. I configured EJB timerservic to use a physical database, ...
0
votes
0answers
865 views

Connecting to MySQL server via SSL using JDBC

I'm trying to set up access to remote mysql server secured by SSL. So far mysql client works flawlessly but I get exception when connecting via JDBC. For now I'm testing it on my local machine. ...