We are facing a strange problem with Websphere Application Server Data Source. Environment: Websphere Application Server (6.1) Linux Liferay Portal (5.2) Oracle 9i Hibernate 3.0 We have datasource deployed in Application server referencing ODBC14.jar Hibernate Configuration for Datasource: <property name="connection.datasource">jd...
hi, am using this connection string to connect to mysql from java: jdbc:mysql://localhost:3306/db?noDatetimeStringSync=true&useUnicode=yes&characterEncoding=UTF-8 is it possible to set the session variable in the string so that SET UNIQUE_CHECKS=0; would be executed upon connecting to server? the obvious jdbc:mysql://localhost...
I have a Java web app using JDBC created in NetBeans deployed to Tomcat that gives a "java.sql.SQLException: No suitable driver found for ..." error. The same app works fine when I run it as a non-web Java app. I have the jar of the JDBC driver I'm using added to the libraries of the web app. ...
So I've been having issues with the MySQL Connector/J driver not correctly loading in a Java Web Start application that is running on Tomcat 6.0.20. I've copied the MySQL connector JAR file into the lib directory of Tomcat as well as the lib directory within webapps//WEB-INF. I also added a reference to the JAR file inside of the JNLP ...
So, here is the code which create the table in an Oracle 10g / UTF-8 database : CREATE TABLE TEST_SEMANTIC ( SEMANTIC_COLBYTE char(2 byte) , SEMANTIC_COLCHAR char(2 char) ); meaning, that I use two differents types of semantic for the two columns, byte and char. I then insert inside the database these corresponding data : insert in...
I need a JDBC driver for MsAccess to be used in a Unix environment I would strongly prefer it to be an open-source Also it should support SQL statements (Jackcess came close to being my choice- but it doesn't support SQL queries) http://jackcess.sourceforge.net/faq.html#query ...
Hello I am using Glassfish v2, Hibernate with Annotations+EntityManager and Postgresql 8.4. I am also using on top HibernateSpatial and PostGis. It works fine to persist entities with spatial properties ( com.vividsolutions.jts.geom.Point ) into the Postgis database. However, when trying to fetch objects using myEntityManager.find(MyCl...
Hi, we need some data which is stored on several Microsoft Access databases on our servers, and our application will be executed on a Linux machine. So, our only alternative consist in using a JDBC Type 4 driver. In our research, we found two alternatives: HXTT - http://www.hxtt.com/access.html StelsMDB - http://www.csv-jdbc.com/st...
Hi, I am using Connector/J 5.1.10 as the JDBC driver for my Database application (which uses MySQL). I have found that although the default ResultSet returned by a Statement is of type TYPE_FORWARD_ONLY, I am still able to safely call the previous() method on the ResultSet. I also looked at the source code (com.mysql.jdbc.ResultSetImp...
Hi I have a MS SQL database running (MS SQL 2005) and am connecting to it via the net.sourceforge.jtds.jdbc.Driver. The query works fine for all the columns except one that is a varchar(max). Any ideas how to get around this issues? I am using the jdbc driver to run a data index into a SOLR implementation. (I do not control the dat...
Hi all, We have a well-defined problem that points to a problem with Microsoft's JDBC 2.0 driver for JDK 1.6 ("sqljdbc4.jar"). I may be wrong. I've been wrong before. I wanted to see if I'm missing anything. any insights? Anyone seen this before? Usecase: use ant "sql" task to run a simple sql query. All queries fail jdbc driver...
Well, The question explains all, Using DB2mon tool, Is there a way to tell which client is connecting using which type of connection (type 2 jdbc or type 4 jdbc connection)? All of the connections are showing as db2jcc process which is the common driver for both type 2 and type 4. Also if there is a way to find out whether is connection...
The following works fine in CFMX 7 and CF8, and I'd assume CF9 as well: <!--- 'conn' is a JDBC connection ---> <cfset stat = conn.createStatement() /> <cfset rs = stat.executeQuery(trim(arguments.sql)) /> <!--- convert this Java resultset to a CF query recordset ---> <cfset queryTable = CreateObject("java", "coldfusion.sql.QueryTable")...
Hi, There are 1652487 rows in my table in MYSQL. I want to copy all the values corresponding to one field into a file. I wrote a java program in netbeans using jdbc driver for this. I'm unable to do this at one go. Is there a way out ? < Is there any limit on the number of rows one can select > [ EDIT ] my code : action performed when...
Hello, Is there a way to disable the Postgresql translation of messages? I´m running my appl and Postgresql on a pt_BR Windows machine and when a exception is thrown the error message is translated to Portuguese, like: Caused by: org.postgresql.util.PSQLException: ERRO: relação "unidade_federacao" não existe Posição: 25 I woul...
Is there a default classpath on Mac OS X 10.6? When I echo $CLASSPATH, nothing would show up. In my .profile, I only see PATH variable being set. My problem is that My servlet cant seem to find a suitable driver to connect to the mysql server. I use Eclipse, with Glassfish v3 and MAMP for MYSQL server. ...
Hi there. I'm packaging my open-source non-commercial java application in a .jar and I'd like to package the JDBC mysql-connector with it as it is a dependency. The issue that I am having is that I'm uncertain whether or not this is frowned upon or even illegal due to the JDBC license. I've also got the jdbc mysql-connector jar in my c...
I'm calling a stored procedure via ibatis. It works, and has worked, when using the jconn2.jar (5.5). When I swap it out for the jtds jar (1.2.5) I get an exception "Invalid SQL statement or JDBC escape, terminating '}' not found." For more transparency I'm using Spring with DBCP. Obviously the parsing of the SQL code in jTDS is not bei...
I am writing a driver to act as a wrapper around two separate MySQL connections (to distributed databases). Basically, the goal is to enable interaction with my driver for all applications instead of requiring the application to sort out which database holds the desired data. Most of the code for this is in place, but I'm having a prob...
My company uses Vertica. We have Python applications that connect to it with pyodbc. I do most of my development on a Mac (Snow Leopard) and unfortunately Vertica has not released ODBC drivers for Mac. They do have JDBC drivers though. I don't think developing in Jython is a good compromise. Is there any way to use JDBC drivers with...