JDBC :: Uploading Template File Into Database Using SetBlob Or SetBinaryStream

Jun 1, 2015

I have a template file which I'm tring to upload into a database using setBlob or setBinaryStream but I'm getting the following error:
 
java.lang.AbstractMethodError: setBlob
  at weblogic.jdbc.wrapper.PreparedStatement.setBlob(PreparedStatement.java:1005)
  at com.capitalone.citrix.ssp.dao.KatetDaoImpl.uploadReport(KatetDaoImpl.java:1697)
  at com.capitalone.citrix.ssp.services.FileOpsImpl.generateDownload(FileOpsImpl.java:648)
  at com.capitalone.citrix.ssp.controller.JSONController.display(JSONController.java:61)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

[Code] .....
 
I'm using :

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
Weblogic Server Versions: 10.3.0.0 with Java 1.6.0_05

The driver class name for the weblogic datasource: weblogic.jdbcx.oracle.OracleDataSource
 
Initially, I tried:
     
           sqlQuery = new StringBuffer();
                ps = null;
                sqlQuery.append("insert into KATET_REPORTS (FILE_DATA)");

[Code] ....
 
This failed, so I changed ps.setBlob(1,is)
to
ps.setBinaryStream(1,is). This failed as well with teh same error, just for setBinaryStream instead of setBlob.
 
Is there a known inconsistency between that driver and this Weblogic version? Is there something else going on? If I haven't given enough data to debug the issue here, what other data should I gather?

View Replies


ADVERTISEMENT

JSF :: Using JQuery In Template File With Single And Double Quotes

Jan 5, 2015

I'm learning jQuery to integrate into a JSF application but finding some confusion on the correct syntax especially when it comes to combining double and single quotes in the jQuery scripts. So for this particular page I want jQuery to traverse through a list of documents and put icons next to each document to state what type of document each is (ie: PDF, doc, xls). I can get this to work using normal html markup but I get a Syntax Error - Unexpected Token exception in the browser.

I'm confused about whether this means I need to use the right html references for the JSF element I wish to traverse or whether this is a problem with the way I'm using my quotes.

Also I'm not sure how to correctly reference jsf tags inside jQuery scripts. So for an ordinary html page I execute the following jQuery script:

<script type="text/javascript">
$("document").ready(function () {
$("li a[href = ' .pdf']").after("<img src='myImage'/>");
});
</script>

</code>

Then I have a JSF page with the following commandLink:

<p:column>
<p:commandLink class="downLoadLink" value="Download" ajax="false">
<p:fileDownload value="#{projectDocBean.downloadedFile}"
contentDisposition="attachment"/>
</p:commandLink>
</p:column>

For this page I try to execute the following script:

<script type="text/javascript">
$("document").ready(function () {
$("#downLoadLink = ' .pdf']").after("<img src='myImage'/>");
});
</script>

I get the same syntax error no matter what I put into the script of the JSF page. How to correctly integrate jQuery with JSF.

View Replies View Related

Simple Ftp Server For Uploading And Downloading File

Jan 25, 2014

I want to create a simple ftp server which can upload and download a single file. i found code from google search but its showing error : connection refused . here is my server code n client code.

//server code

[highlight = java]
import java.io.*;
import java.net.*;

[Code].....

View Replies View Related

JDBC :: How To Retrieve Just One Value From Database

Nov 25, 2014

I wish to retrieve just one value from db;
 
so I use this code:

@Transactional
    public long getSequenceSedeB(Long id) {
        BigDecimal seqValue = nu
        String sql = "SELECT MAX(ID) FROM SEDE_B_ALLEGATI_A WHERE ID_SEDE=:id";
        SQLQuery query = getSession().createSQLQuery(sql);

[Code] ....

But it do not works; this is the log.

type.NullableType (NullableType.java:182) - could not read column value from result set: ID; Invalid column name

2014-11-25 14:45:14,476 WARN  [btpool0-2] util.JDBCExceptionReporter (JDBCExceptionReporter.java:77) - SQL Error: 17006, SQLState: null
2014-11-25 14:45:14,478 ERROR [btpool0-2] util.JDBCExceptionReporter (JDBCExceptionReporter.java:78) - Invalid column name

 But in the database the query
 
SELECT MAX(ID) FROM SEDE_B_ALLEGATI_A WHERE ID_SEDE=:id
 
run correctly;
 
Also I need to rewrite the statement
   query.setParameter("id", 923);
in this way
   query.setParameter("id", AAA);
 
where AAA is gotten from out of the procedure;

View Replies View Related

JDBC :: Restore Database In Java

Feb 26, 2015

I'm having problem with my code when it comes to Restore Database in Java. This is my code:

public boolean restoreDB(String dbUserName, String dbPassword, String source) {
String[] executeCmd = new String[]{"C:Program Files (x86)MySQLMySQL Server 5.1inmysqldump ", "--user=" + "root", "--password=" + "1234" + source};
Process runtimeProcess;
try {
runtimeProcess = Runtime.getRuntime().exec(executeCmd);
int processComplete = runtimeProcess.waitFor();

[Code] ....

View Replies View Related

JDBC Connectivity With MySQL Database

Apr 24, 2014

I created a database in mysql, but I have problems communicating with the DB in java.

Here is the error :

java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/books
at java.sql.DriverManager.getConnection(DriverManager.java:604)
at java.sql.DriverManager.getConnection(DriverManager.java:221)
at displayauthors.DisplayAuthors.main(DisplayAuthors.java:30)
java.lang.NullPointerException

[Code] ....
 
HERE IS THE CODE 

public class DisplayAuthors {   
// database URL                             
   static final String DATABASE_URL = "jdbc:mysql://localhost:3306/books";
   // launch the application
   public static void main( String args[] )

[Code] ....

View Replies View Related

JDBC :: Storing Images To MySQL Database?

Mar 13, 2015

This question is not about syntax but a best way to handle something. What is the best way to store a image into a database? For example converting it into binary etc. I just wanted to get some opinions.

View Replies View Related

JDBC Delete Command Locking Database?

Aug 27, 2014

I have a problem where i cant seem to get this simple delete command working. Everytime i run it it just locks the database and crashes

The id parameter exists in the database the database is small. Only a few tables. update commands work completely fine.

The id is an in and resulting command is - DELETE from Employees where ID = 2;

public static void EmployeeDeleteByID(int idIn){
Connection c = null;
Statement stmt = null;
try {
c = Connect();
c.setAutoCommit(false);
System.out.println("Opened database successfully");

[code]....

Error after running : java.sql.SQLException: database is locked

View Replies View Related

Trying To Add Database Driver (JDBC) - Not In CLASSPATH Warning?

Jun 23, 2015

This the output of java from my PC under linux platform (rhel 6.5).
 
[pentaho@vertica-srv1 Downloads]$ java -version
java version "1.7.0_79"
Java(TM) SE Runtime Environment (build 1.7.0_79-b15)
Java HotSpot(TM) 64-Bit Server VM (build 24.79-b02, mixed mode)
 
[Code] ....
 
But the problem is while trying to open ETL program under linux platform [pentaho@vertica-srv1 data-integration]$ ./spoon.sh .... I received the following error messages.
 
[pentaho@vertica-srv1 data-integration]$ ./spoon.sh
 
Trying to add database driver (JDBC): RmiJdbc.RJDriver - Warning, not in CLASSPATH?
Trying to add database driver (JDBC): jdbc.idbDriver - Warning, not in CLASSPATH?
Trying to add database driver (JDBC): org.gjt.mm.mysql.Driver - Warning, not in CLASSPATH?
Trying to add database driver (JDBC): com.mckoi.JDBCDriver - Warning, not in CLASSPATH?
[KnowledgeFlow] Loading properties and plugins...

View Replies View Related

JDBC :: Correct URL To Connect To Database Using IPC Protocol

Dec 19, 2014

What is correct url to connect to db with orcl SID using IPC protocol? Couldn't find this in documentation....
 
jdbc:oracle:oci:@[WHAT GOES HERE?]

View Replies View Related

JDBC :: How To Add Database To NetBeans Project When Making Setup

Aug 21, 2014

I have completed an assignment for my university in which I had to make a Java NetBeans project. My project is now completed but now I have to make a setup of my NetBeans project and give the university the setup file, only.

My question is, the software I made has a database attached to it, meaning the purpose of the software is to be used with the database. Values must be saved in the database, deleted from the database etc.. I have used MySQL database connections with the JDBC driver

I have used exe4j to make the .exe file and Setup Factory to make the exe file and setup file respectively. Once I make the setup and run the setup, the application works, ON MY COMPUTER. The computer which made the software. But once I take it to a computer in which MySQL was not installed, the setup installed, but the software did not work.

View Replies View Related

JDBC :: No Suitable Driver Found For Oracle Database Connection

Jul 10, 2015

I have small Java code, which execute every day and checks for data in database using Cronj Schedular and everything works fine, but recently I have observed that, it is failing due to
  
    java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:@160.110.xx.xxx:1521/test
 
At the same time, when I run my test code to check Database connectivity that works fine without above exception. I'm unable to figure it out. Although, there was just slight code change, but that was nowhere related to Database or Database connection.  
 
dbconf.java
    public class dbconf {
    private Connection connect;
    private String connstr;
    public Connection getConnection() throws SQLException {
    connstr = "jdbc:oracle:thin:@160.110.xx.xxx:1521/test";

[Code] .... 
 
Application Log file
 
    Wed Jul 01 09:25:17 IST 2015:------- Initializing -------------------
    Wed Jul 01 09:25:17 IST 2015:------- Scheduling Jobs ----------------
    Wed Jul 01 09:25:17 IST 2015:------- Job Started Running ----------------
    Thu Jul 02 06:00:00 IST 2015 : Job Executed..!! Bschedularv2.2
    java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:@160.xxx.67.xxx:1521/test
    Sat Jul 04 06:00:00 IST 2015 : Job Executed..!! Bschedularv2.2
    Sun Jul 05 06:00:00 IST 2015 : Job Executed..!! Bschedularv2.2
    java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:@160.xxx.67.xxx:1521/test
 
So, you can see, It failed on 3rd of July and 5th July as well. But, in between it ran fine.

View Replies View Related

Connect To MySQL Database And Print Out Some Fields - Cannot Find JDBC Driver

Aug 17, 2014

I am trying to run a simple program that connects to a mysql database and prints out some fields. I am using Eclipse.

THe problem I am having is on the following line of code.

Class.forName("com.mysql.jdbc.Driver");

I get an error:

java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
at java.net.URLClassLoader$1.run(Unknown Source)
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)

[Code] ....

I have done some research and from what I have found is that I need to alter the class path to pick up the driver. When I downloaded the .msi I ran it and then the program closed. Where the files are ??? How to locate and import the file so I need to get my program to run?

I have included all the of the source code below.

package mySQLConnect;
import java.sql.*;
public class Connect {
// JDBC Driver name and database URL
static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";
static final String BD_URL = "jdbc:mysql://localhost/sstbde";

[Code] .....

View Replies View Related

JDBC :: Options Required For DB Schema Password Encryption - Connecting To Backend Database

Jul 9, 2015

We currently have an application which uses JDBC to connect to the backend database (DB version - 11.2.0.3 ). The application uses a properties file in which the password for the db schema is hardcoded in plain text format. Due to security restrictions we have been asked to make sure the password is encrypted in the file and no direct access is made to the schema using the plain text password. Best options we can use to make this password encrypted both at Oracle DB side and Java side.

View Replies View Related

JDBC :: How To Call Parameterized Stored Procedure In Jdbc

May 17, 2014

calling a parameterized stored procedure in java jdbc from sql server.The stored procedure goes like this in sql

create proc patientreg
@id int
as
begin
select [patient_id],[Psurname], [pFirstname], [pMiddlename], [reg_date], [DOB], [Sex], [Phone_num], [Addr],[Email],[dbo].[fncomputeage](DOB) from [dbo].[Patient_registration] where [patient_id] = @id
end
please note dbo.fncompute(DOB) is a function

To call it in jdbc it goes like this

try{
String str = "{call patientreg(?)}";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbcdbc:GeneralHospit al");
cstmt = con.prepareCall(str);
cstmt.setInt(1, Integer.parseInt(t.getText()));

[code]....

after doing it this way it throwing an exception: Error:java.sql.SQLException: Parameter 1 is not an OUTPUT parameter.

View Replies View Related

Create XML Based On XSD Template In Java?

Apr 17, 2015

I need to generate XML file based on XSD template in Java, I can parse the XSD file, but don’t know after parsing, how to generate XML file.

View Replies View Related

Initial Template Which Converts Fahrenheit To Celsius

Oct 20, 2014

I am new to Java, programming, and intelliJ. I am trying to make a BMI Calculator using this code as my initial template which converts Fahrenheit to Celsius.

import javax.swing.JFrame;
public class Fahrenheit
{
//-----------------------------------------------------------------
// Creates and displays the temperature converter GUI.
//-----------------------------------------------------------------

[code]....

I created a local field within BMIButtonListener for weight, height, resultLabel, and was able to compile but it did not calculate and listed exceptions.

View Replies View Related

JSP :: Would Template Based Framework Generates A Lot Of Request Traffic?

Nov 29, 2014

If I have a web page with a lot of data to show, say a lot of tables and graphics, would using non JSP based frameworks result in a lot more individual AJAX requests? For example if the page have 5 tables, with JSP the whole page will be returned to the browser with data for all 5 tables already. But if this is a pure HTML / Javascript based view, then we need to have each of the 5 tables to make individual AJAX requests in order to render the page. Is this indeed the down side for not using JSP?

The reason I'm asking is because I'm considering moving away from JSP to a template based framework such as Thymeleaf or Freemarker.

View Replies View Related

Servlets :: Uploading And Downloading Files Using JSP

Aug 18, 2014

I would like to know what is the best way to upload & download files using Servlets/Jsp's . In some websites I have seen example using third party API(by oreilly). Is it better to follow any third party or can we do it just by using I/O streams. What are the steps of uploading files. And where do we need to store files once the user uploads ,Database or server??

View Replies View Related

Web Services :: Add Uploading Image Feature To Form

Apr 21, 2015

I'm using json to submit form from web and mobile, I want to add uploading image feature to this form. How can I do that with code if possible?

View Replies View Related

JSF :: Way To Reload Page After Uploading Files With Command

Aug 23, 2014

Is there a way to reload the page after uploading the files with the command

<p:fileUpload value="#{excursion_type.main_photo}" mode="advanced" allowTypes="/(.|/)(gif|jpe?g|png)$/" auto="false"
fileUploadListener="#{excursion_type.uploadMultiple}" update="msg" />

Cause the user does not see the lattest photos after uploading need to do reload to see them cause ajax request.

View Replies View Related

Web Services :: How To Add Uploading Image To Service Using Json

Mar 11, 2015

i have a service to save some form fields from the client and i need to add uploading image to that service using json. the service consumes json and produces json.

View Replies View Related

PDF Uploading / Downloading And Report Generation Source Code In JSP

Sep 5, 2014

I am developing an inhouse project in my organization. I unable to implement the pdf uploading, downloading, report generation logic as i am totally new to this implementation.

View Replies View Related

I/O / Streams :: Select Multiple Files And Uploading Using Single Browse Option?

May 22, 2014

My requirement is - I need to browse the folder and select multiples and upload all the selected files at once. note that here i need to use single browse button ONLY.

View Replies View Related

Servlets :: How To Get Result When Website Initially Uploading Rather Than Pressing Button For Action

Oct 28, 2014

I am learning how to program in JAVA servlet+MySQL. Decided to make a simple program where it shows who is celebrating birthday today by retrieving data from database. At the moment I managed to get it working by loading a form.html and pressing the button in it which gets to the result.jsp and shows results there.

My plan was to get a list of people who are celebrating there birthdays initially when the website is loaded/being loaded, I mean when you enter URL into your web browser and you get it instantly in browser. Is there a way to do it the way I want (JAVA+servlet+MySQL) instead of pressing a button/link?

View Replies View Related

I/O / Streams :: How To Use Java To Generate Word Document From A Word Template

Aug 19, 2014

I am looking for java codes to generate a word document based on a word template, basically, I have a word template created and in my local path, the template has a proper format with some fields which will be filled in after java codes ran. The java codes will fetch one record from a table, and open the word template and then fill the fields in the word template, and created a new word document and save it in another folder.

I found this example: [URL] which is similar except it uses xml template instead of word template, how to make it work to change the template from xml to word (docx) template?

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved