-
-
-
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@10.81.7.169:1521:PTS", "TESTPTS", "TESTPTS");
System.out.println("connection established");
PreparedStatement ps = conn.prepareStatement("insert into DEMOBLOB values(?)");
System.out.println("insert executed");
File photo= new File("D:/Thinkingjava.pdf");
System.out.println("image loaded ");
FileInputStream photostream= new FileInputStream(photo);
System.out.println("photo taken");
ps.setBinaryStream(1,photostream,(int)photo.length());
ps.executeUpdate();
photostream.close();
}
catch(Exception e)
{
e.printStackTrace();
}
}
}
above is the code which iam using and below is the exception i am getting
ORA-01460: unimplemented or unreasonable conversion requested
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:542)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1311)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:738)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1313)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1232)
at oracle.jdbc.driver.OracleStatement.doExecuteWithBatch(OracleStatement.java:1353)
at oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.java:1760)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1807)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:332)
at PDFConnect.main(PDFConnect.java:24)">When iam tring to insert a pdf of 2mb in to oracle database.This is my source code.import java.io.File;import java.io.FileInputStream;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;public class PDFConnect { public static void main(String args[]) { try{ Class.forName("oracle.jdbc.driver.OracleDriver"); Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@10.81.7.169:1521:PTS", "TESTPTS", "TESTPTS"); System.out.println("connection established"); PreparedStatement ps = conn.prepareStatement("insert into DEMOBLOB values(?)"); System.out.println("insert executed"); File photo= new File("D:/Thinkingjava.pdf"); System.out.println("image loaded "); FileInputStream photostream= new FileInputStream(photo); System.out.println("photo taken"); ps.setBinaryStream(1,photostream,(int)photo.length()); ps.executeUpdate(); photostream.close(); } catch(Exception e) { e.printStackTrace(); } } }above is the code which iam using and below is the exception i am gettingORA-01460: unimplemented or unreasonable conversion requested at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:542) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1311) at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:738) at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1313) at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1232) at oracle.jdbc.driver.OracleStatement.doExecuteWithBatch(OracleStatement.java:1353) at oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.java:1760) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1807) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:332) at PDFConnect.main(PDFConnect.java:24)
-
import java.awt.BorderLayout;
import java.awt.Container;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTree;
import javax.swing.tree.DefaultMutableTreeNode;
import javax.swing.tree.DefaultTreeModel;
public class ModelJTree extends JFrame {
private JTree tree;
private DefaultTreeModel model;
private DefaultMutableTreeNode rootNode,Medievel,Ancient,Philosophers;
public ModelJTree() {
DefaultMutableTreeNode philosophersNode = getPhilosopherTree();
model = new DefaultTreeModel(philosophersNode);
tree = new JTree(model);
JButton addButton = new JButton("Add Philosopher");
addButton.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent event) {
addPhilosopher();
}
});
JButton removeButton = new JButton("Remove Selected Philosopher");
removeButton.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent event) {
removeSelectedPhilosopher();
}
});
JPanel inputPanel = new JPanel();
inputPanel.add(addButton);
inputPanel.add(removeButton);
Container container = getContentPane();
container.add(new JScrollPane(tree), BorderLayout.CENTER);
container.add(inputPanel, BorderLayout.SOUTH);
setDefaultCloseOperation(EXIT_ON_CLOSE);
setSize(400, 300);
setVisible(true);
}
private void addPhilosopher() {
DefaultMutableTreeNode parent = getSelectedNode();
System.out.println(parent);
if (parent == null) {
JOptionPane.showMessageDialog(ModelJTree.this, "Select an area.", "Error",
JOptionPane.ERROR_MESSAGE);
return;
}
String name = JOptionPane.showInputDialog(ModelJTree.this, "Enter Name:");
model.insertNodeInto(new DefaultMutableTreeNode(name), parent, parent.getChildCount());
}
private void removeSelectedPhilosopher() {
DefaultMutableTreeNode selectedNode = getSelectedNode();
if (selectedNode != null)
model.removeNodeFromParent(selectedNode);
}
private DefaultMutableTreeNode getSelectedNode() {
return (DefaultMutableTreeNode) tree.getLastSelectedPathComponent();
}
private DefaultMutableTreeNode getPhilosopherTree() {
DefaultMutableTreeNode rootNode = new DefaultMutableTreeNode("Philosophers");
DefaultMutableTreeNode ancient = new DefaultMutableTreeNode("Ancient");
rootNode.add(ancient);
ancient.add(new DefaultMutableTreeNode("Socrates"));
DefaultMutableTreeNode medieval = new DefaultMutableTreeNode("Medieval",true);
rootNode.add(medieval);
return rootNode;
}
public static void main(String args[]) {
new ModelJTree();
}
}
">Hi....My question is In a JTree i want to add nodes to only the nodes whose parent is root node.Please help me with this.In the following code it should be possible to add node to "Medieval" but not "socrates.import java.awt.BorderLayout;import java.awt.Container;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import javax.swing.JButton;import javax.swing.JFrame;import javax.swing.JOptionPane;import javax.swing.JPanel;import javax.swing.JScrollPane;import javax.swing.JTree;import javax.swing.tree.DefaultMutableTreeNode;import javax.swing.tree.DefaultTreeModel;public class ModelJTree extends JFrame { private JTree tree; private DefaultTreeModel model; private DefaultMutableTreeNode rootNode,Medievel,Ancient,Philosophers; public ModelJTree() { DefaultMutableTreeNode philosophersNode = getPhilosopherTree(); model = new DefaultTreeModel(philosophersNode); tree = new JTree(model); JButton addButton = new JButton("Add Philosopher"); addButton.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent event) { addPhilosopher(); } }); JButton removeButton = new JButton("Remove Selected Philosopher"); removeButton.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent event) { removeSelectedPhilosopher(); } }); JPanel inputPanel = new JPanel(); inputPanel.add(addButton); inputPanel.add(removeButton); Container container = getContentPane(); container.add(new JScrollPane(tree), BorderLayout.CENTER); container.add(inputPanel, BorderLayout.SOUTH); setDefaultCloseOperation(EXIT_ON_CLOSE); setSize(400, 300); setVisible(true); } private void addPhilosopher() { DefaultMutableTreeNode parent = getSelectedNode(); System.out.println(parent); if (parent == null) { JOptionPane.showMessageDialog(ModelJTree.this, "Select an area.", "Error", JOptionPane.ERROR_MESSAGE); return; } String name = JOptionPane.showInputDialog(ModelJTree.this, "Enter Name:"); model.insertNodeInto(new DefaultMutableTreeNode(name), parent, parent.getChildCount()); } private void removeSelectedPhilosopher() { DefaultMutableTreeNode selectedNode = getSelectedNode(); if (selectedNode != null) model.removeNodeFromParent(selectedNode); } private DefaultMutableTreeNode getSelectedNode() { return (DefaultMutableTreeNode) tree.getLastSelectedPathComponent(); } private DefaultMutableTreeNode getPhilosopherTree() { DefaultMutableTreeNode rootNode = new DefaultMutableTreeNode("Philosophers"); DefaultMutableTreeNode ancient = new DefaultMutableTreeNode("Ancient"); rootNode.add(ancient); ancient.add(new DefaultMutableTreeNode("Socrates")); DefaultMutableTreeNode medieval = new DefaultMutableTreeNode("Medieval",true); rootNode.add(medieval); return rootNode; } public static void main(String args[]) { new ModelJTree(); }}
-
-
What is Java Mail. What extra package is needed to write a java mail program and how can i get it from where. Thank U.
mk pal
- Sep 28th, 2006
java mail API package is needed to write the program for mail in javaAnd also need one mail server for ex. M ServerIt is used POP protocolIn this way? u can establish the connection and make maximum t...
-
-
What is java webservice and how does it work.
santh kumar
- Jan 31st, 2007
A web service is a collection of protocols and standards used for exchanging data between applications or systems. Software applications written in various programming languages and running on variou...
-
-
-
Can I write a return statement in the catch clause,which is followed by a finally block?Will the code compile?How is the code executed?
aravindhan.c
- Feb 10th, 2007
Yes we can write a return statement in a catch followed by finally.The code will compile and run. If we have a statment like return 0 in catch block and return 1 in the finally block then 1 will be returned to the calling method.Otherwise, 0 will be returned.
-
Can a servlet page serve more than one client requests?how
suman
- Feb 13th, 2007
HI Santh Kumar, As u said servlets have multiple instances(it is wrong) each servle has one instance only, when a new request comes it does not create an instance but it creates a thread to the request.remaing answer is ok, Thanks
santh kumar
- Jan 31st, 2007
It's True that a servlet can process multiple requests at a time.this can be application specific and the server specific. Concerns to Servers : servers can maintain a numorous instances of a serv...
-
-
Processing XML Data with Java
What is XML and when it will be used in Realtime project? can any one give me example of transfering the data with xml with java?
kiran.pathipaka
- Feb 15th, 2007
XML is used like java where java is platform independent where as xml is data independent.xml is used in webservices where different platform services can transfor data between them.examplein distr...
-
-
-
Simple API for XML (SAX) interfaces
Of the four Simple API for XML (SAX) interfaces that handle parsing events, which allows custom handling of external entities?A: DocumentHandler B: DTDHandler C: ErrorHandler D: EntityResolver
-
How to configure MQ-series ?
lhariPrasad
- Feb 23rd, 2007
For ex., if you want to use ibm mq series, place the ibm.zip file into your lib folder and just follow the following steps. 1. set the MQEnvironment.hostname,channel, port2. create an instance of MQQu...
-
What is Persistent Base Class in Hibernate? Give me a example of one-to-many mapping using person and address in Hibernate.
deepakvinayak
- Feb 27th, 2007
HiActually I wanted to know one-to-many mappings between person and address. But u have sent . Now I know the answer, which is as :
deepakvinayak
- Feb 27th, 2007
HiActually I wanted to know one-to-many mappings between person and address. but u have sent many-to-one. Now I know the answer which is as :Persistent base class is the base class for all persistent ...
-
J2EE Interview Questions
Sub Category
Questions
Answers
Last Updated
Ans