JDBC Questions


JDBC in SQL
Need example to retrieve data from JDBC in SQL?

Answer Question   |  March 26, 2013  5:27 PM
JDBC, SQL
asked by:
40 pts.

how to display 10records in the browser again when we press the next button it will display 10 recors
I am creating a form with three fields eno,name,salary and search button. I may or may not enter the values to the text fields and then press the search button. Here based on the values the query will generate and execute now the 10 records are display if may available otherwise it will display getting [...]

Answer Question   |  October 12, 2012  12:02 PM
JDBC, JSP, Servlet
asked by:
15 pts.

What Oracle 10g software is needed to download and install on the system for Running JDBC Programs on the system.
Sir what, Oracle 10g Software  is needed to be downloaded from the Internet, for installing it into the system for compiling JDBC java programs. Sir please tell me the reply sir, for the running JDBC java programs.

Answer Question   |  May 22, 2012  1:30 PM
JDBC, Oracle 10g
asked by:
25 pts.

Trigger over table that uses transaction inserts
I have a table that is being updated via JDBC. The program that is writing records (sql insert) is using transactions. This table has an after insert trigger on it. When the trigger is disabled the table is updates correctly. When the trigger is on we get the first record and the tigger locks the [...]

Answer Question   |  February 28, 2012  5:23 PM
iSeries, JDBC, SQL INSERT, Triggers
asked by:
KSC
90 pts.

JDBC connection thru AS/400
Hi All we are getting issue in as400 cpu utilisation. qzdasoinit jobs is getting killed after closing connection but after when we initiate a fresh connection it utlises cpu from where previous connection was closed. Suppose if previous connection was closed at cpu usage 10%, job would disappear from wrkactjob but when fresh connection is [...]

Answer Question   |  March 31, 2012  3:34 PM
AS/400 jobs, CPU Utilization, JDBC, WRKACTJOB
asked by:
35 pts.

Change password through JDBC
hi can any one help me .. how to change a password reset/ change password through JDBC connections specifications: 1)we are going to change password from front end URL 2)we need to connect through Db2 database through JDBC connections

Answer Question   |  January 25, 2011  10:19 AM
DB2, Java, Java Database, Java developers, JDBC
asked by:
15 pts.

Boomi using JDBC to access DB2 in AS/400
Want to use Boomi to access JDE DB2 What do I need to define on AS400?

Answer Question   |  December 11, 2010  6:46 PM
AS/400 administration, AS/400 DB2, Boomi, JDBC
asked by:
5 pts.

Connect JasperServer and Sql 2008
i tired these steps : # Download the Microsoft JDBC driver: Microsoft SQL Server JDBC Driver # Extract to a good location. I chose c:program files to extract to. # Copy the sqljdbc4.jar to your installation directory which by default is: c:program filesjasperserver-pro-3.5.1apache-tomcatwebappsjasperserver-proWEB-INFlib # Restart JasperServer (there is a shortcut in the start menu to [...]

Answer Question   |  September 1, 2010  4:03 AM
Jasper, JasperServer, JDBC, SQL, SQL 2008, SQL Server 2008, SQL Testing
asked by:
5 pts.

How to connect to database inside VMWare from the web applications
Hi All, I have VMWare in my desktop which contains the Oracle database. And in general my desktop is in network with the server having web based applications. Now I want to fetch the data from this VMWare database in my application. Can we establish JDBC connection from the application to this database. Can we [...]

Answer Question   |  July 21, 2010  12:34 PM
DSN connection, Java Database, JDBC, Oracle Database, VMware, Web Dynpro
asked by:
25 pts.

AS400 – ORACLE JDBC
Can we take an RPG program that reads a DB2/400 database table and without modifying its code change it to point to the “same” table in an Oracle database using JDBC?

Answer Question   |  November 28, 2011  6:10 PM
JDBC, Oracle
asked by:
5 pts.

Building an xml in java
Please give me an example of building an xml with multiple child nodes, in java. I want something like : <Parent> <Child1>something</Child1> <Child2>something else</Child2> </Parent> Now, the values for Child1 and Child2 must be picked using SQL from AS400. Picking values is where i think i am failing. My program constructs something like : <Parent> [...]

Answer Question   |  November 30, 2009  7:20 AM
AS/400, Java, JDBC, SQL Query, XML
asked by:
55 pts.

JDBC connection to DB2/400
Hi, We have application which runs on Java Server connects DB2/400 using JDBC connection. would like to know what is the maximumnumber of database connections supported on DB2/400 and how can I adjust this connection activity so that it is not impacting our application running on as/400 i.e. how to imrpove the performance of as/400 [...]

Answer Question   |  June 30, 2010  11:32 AM
DB/400, DB2/400, JDBC
asked by:
105 pts.

JDBC Connection from JAVA to iSeries DB
I have a simple class that resides on my local drive. I am attempting to connect to iSeries I5V4 environment and do “select” from one of the DB files. When I run my .class file in Rational Application Development I ghet a “class not found” exception. How do I set classpath in RAD? Should my [...]

Answer Question   |  June 30, 2010  6:39 PM
Java, Java Database Connectivity, JDBC, Rational Developer for IBM i
asked by:
115 pts.

Difference between ODBC and JDBC?
I’m writing a Java application. In short, this application needs to connect to DB2 on an AS/400 for some SQL data. I cannot find a straightforward comparison of ODBC and JDBC. Do any of you know where I can find one? Or, have any of you done java programming with the intent to connect to [...]

Answer Question   |  April 19, 2013  1:49 PM
AS/400, Database, DB2, Development, Java applications, JDBC, ODBC, SQL
asked by:
11,205 pts.

Connectivity between Oracle BI Publisher and Microsoft Access
I need to make a connection from BI Publisher to an MS Access database. Anyone can help me with the connect string and database driver class details for setting up a JDBC?

Answer Question   |  May 27, 2009  11:52 AM
Database connectivity, JDBC, Microsoft Access, OBIEE, Oracle BI Publisher, Oracle Business Intelligence
asked by:
115 pts.

How to install the MySQL JDBC connector?
Can anybody tell me how to install the MYSQL JDBC connector. I am getting error “java.sql.SQLException: No suitable driver “. I placed the driver in the java-jrelib folder also in the shared folder of tomcat 5.0. Even in the lib folder of WEB-INF. But I am getting the same error.

Answer Question   |  March 4, 2009  6:32 AM
Apache Tomcat, Database connectivity, Java, Java Database Connectivity, java.sql.SQLException, JDBC, JSP, Linux hosting, MySQL, Tomcat hosting, Web developers, Web development
asked by:
25 pts.

Slow JDBC DB2 Connection
Hello, Having an issue with a new server we are setting up. The server is Linux RHE 4, running DB2 8.1 and Domino 7.03. Our DB2 databases reside an a separate dedicated DB2 server and are cataloged on our new server. Connections to these databases are working fine using SQL tools and from the server [...]

Answer Question   |  January 8, 2009  9:12 PM
DB2, DB2 8.1, DB2 8.x, DB2 Performance, Domino 7.0.3, Domino 7.x, JDBC, Linux RHE 4
asked by:
5 pts.

SQL query error: token DATA
I am new to Db2 on iSeries. I am running some SQL script files using JDBC to create a repository on DB2 for my project. The query is of the form: Create table tbl_name(col1 datatype(size),…… ,coln datatype(size)) DATA CAPTURE NONE; I am getting error on token DATA.. I tried to execute this query on iSeries [...]

Answer Question   |  September 23, 2009  5:54 PM
AS/400, DB2, JDBC, SQL Query
485 pts.

JDBC/ODBC to Excel 2007 getting Exception
Iam getting the SQLexception by trying to connect using JDBC/ODBC to Excel 2007 through Java. Any Guys can tell abt this problem. java.sql.SQLException: [Microsoft][ODBC Excel Driver] External table is not in the expected format. at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source) at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source) at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(Unknown Source) at sun.jdbc.odbc.JdbcOdbcConnection.initialize(Unknown Source) at sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) [...]

Answer Question   |  November 3, 2008  1:14 PM
Excel 2007, Java, JDBC, Microsoft Excel, ODBC, SQL Exception
asked by:
15 pts.

jasper server with sql server
does jasper server allow you to use sql server as your database server..if yes can you guys help me out…im stuck with this for almost a week. thanks in advance…

Answer Question   |  August 11, 2009  7:51 AM
JasperServer, JDBC, SQL Server
asked by:
10 pts.